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

[Simon Brereton]

On 24 October 2011 16:43, Jack Fredrikson <jackfredrikson at yahoo.com> wrote:
>
> ________________________________
> 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


Who owns /var/vmail?


> 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
> }