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 = </etc/pki/tls/certs/mail.mydomain.com.cert ssl_cipher_list = ALL:!LOW:!SSLv2 ssl_key = </etc/pki/tls/private/mail.mydomaincom.key ssl_key_password = Jw93Mx2 userdb { args = /usr/local/etc/dovecot/sql.conf driver = sql } protocol imap { mail_plugins = quota imap_quota } protocol pop3 { mail_plugins = quota pop3_client_workarounds = outlook-no-nuls oe-ns-eoh } protocol lda { hostname = mydomain.com info_log_path = /var/log/dovecot-deliver.log log_path = /var/log/dovecot-deliver.log mail_plugins = quota postmaster_address = postmaster@mydomain.com sendmail_path = /usr/sbin/sendmail.postfix }