[Dovecot] Marathon Day 6 of First Install: MySQL Connection Problem

[Jack Fredrikson]

________________________________
From: Tom Hendrikx <tom at whyscream.net>
To: dovecot at 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 at mydomain.com
  sendmail_path = /usr/sbin/sendmail.postfix
}