From: Tom Hendrikx tom@whyscream.net To: dovecot@dovecot.org Sent: Monday, October 24, 2011 3:24 PM Subject: Re: [Dovecot] Marathon Day 6 of First Install: MySQL Connection Problem
First up, thanks for the links, Simon, but they didn't help :( I still need to chmod 666 /usr/local/var/run/dovecot/auth-userdb and I'm still getting the same error: Oct 24 13:40:57 myserver dovecot: auth-worker: Error: mysql(localhost): Connect failed to database (postfix): Access denied for user 'dovecot'@'localhost' (using password: YES) - waiting for 5 seconds before retry
The "(using password: YES)" part of the error indicates that your connection to the server was established successfully. However, it seems that user 'dovecot' has no access to database 'postfix', which you did not test on the command line either.
What happens on the commandline when you enter (after logging in: use postfix; show tables;
I can log in *just fine* as dovecot and show tables, etc.
# 2.0.15: /usr/local/etc/dovecot/dovecot.conf # OS: Linux 2.6.18-028stab094.3 x86_64 CentOS release 5.7 (Final) vzfs auth_mechanisms = plain login mail_location = maildir:/var/vmail/%d/%u passdb { args = /usr/local/etc/dovecot/sql.conf driver = sql } plugin { quota = maildir:storage=10240:messages=1000 trash = /usr/local/etc/dovecot/trash.conf } protocols = imap pop3 service auth { unix_listener auth-userdb { mode = 0660 } user = root } ssl_cert =