大网数据广告活动
服务器运维问答

Dovecot cannot connect to MySQL

· 52CE 我爱测

I'm trying to configure dovecot on my server, and whenever I'm trying to connect, I'm getting this as the response in the /var/log/mail.log file. This is the line I have in the /etc/dovecot/dovecot-sql.conf.ext file that contains…

问题原文

原帖链接 · Sri Harsha Chilakapati · CC BY-SA 4.0

I'm trying to configure dovecot on my server, and whenever I'm trying to connect, I'm getting this as the response in the /var/log/mail.log file.

This is the line I have in the /etc/dovecot/dovecot-sql.conf.ext file that contains the connect line.

connect = host=127.0.0.1 dbname=servermail user=mailadmin password='pass#12@FQ'

Even though I'm specifying to connect to mysql via 127.0.0.1, it's going to localhost in that log.

I verified, I can login to mysql via terminal myself using the command:

$ mysql -u mailadmin -h 127.0.0.1 -p

How to get this to work?

UPDATE:

This is the output of grants:

已采纳解答

原帖链接 · Sri Harsha Chilakapati · CC BY-SA 4.0

Thanks to @anx in the comments, I found the solution to this issue. Creating a new user is not necessary. The problem is that I had a special character in the configuration file.

connect = host=127.0.0.1 dbname=servermail user=mailadmin password='pass#12@FQ'

When I say like this, dovecot is trying to send the password as 'pass to the server.

The issue is because of the configuration file format. There is no escape character that I knew for this. So the parser of dovecot is reading the entire line and treating whatever that's coming after the # as the comment.

The actual solution was to change the password of the user in MySQL.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2019-07-13)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。