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.