[Dovecot] Dovecot can't connect to mysql
Hi. I've just compiled dovecot-1.0.alpha5 with mysql support.from freebsd ports (FreeBSD 6.0-RELEASE). It looks like dovecot has problems connecting to mysql. In the log I'm getting:
dovecot: Feb 24 16:57:41 Error: auth-worker(default): mysql: Connect failed to (null) (exim): Access denied for user 'root'@'localhost' (using password: YES) - waiting for 5 seconds before retry dovecot: Feb 24 16:57:41 Error: auth-worker(default): sql(facha@facha.org.ua,127.0.0.1): Password query failed: Not connected to database dovecot: Feb 24 16:57:44 Info: pop3-login: Aborted login: user=<facha@facha.org.ua>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
This is my dovecot-mysql.conf: connect = host=localhost dbname=exim user=root password=qwer default_pass_scheme = PLAIN password_query = SELECT password FROM auth WHERE username = '%u' AND domain = '%d'
Exim is working with the same settings on the same machine. I also checked if I can use these settings with mysql console client. I don't know where to look for errors. Is anyone else having this problem?
Thanks in advance for your answers.
fa wrote:
dovecot: Feb 24 16:57:41 Error: auth-worker(default): mysql: Connect failed to (null) (exim): Access denied for user 'root'@'localhost' (using password: YES) - waiting for 5 seconds before retry
This was asked and answered so many times before, that it's in the Wiki: http://wiki.dovecot.org/MysqlProblems
Hm, this should better be fixed eventually... next week maybe.
Jakob Hirsch <jh <at> plonk.de> writes:
dovecot: Feb 24 16:57:41 Error: auth-worker(default): mysql: Connect failed to (null) (exim): Access denied for user 'root' <at> 'localhost' (using password: YES) - waiting for 5 seconds before retry
This was asked and answered so many times before, that it's in the Wiki: http://wiki.dovecot.org/MysqlProblems
Yes, but unfortunately that "work around" doesn't help all of us =((( (both PASSWORD and OLD_PASSWORD, same result here...)
Hm, this should better be fixed eventually... next week maybe.
Oh, so the problem is identified?
Lapo
fa wrote:
Exim is working with the same settings on the same machine. I also checked if I can use these settings with mysql console client. I don't know where to look for errors. Is anyone else having this problem?
Yes. What version of MySQL are you running?
participants (4)
-
Alexander BrĂ¼ning
-
fa
-
Jakob Hirsch
-
Lapo Luchini