________________________________
From: Tom Hendrikx <t...@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 = postmas...@mydomain.com
sendmail_path = /usr/sbin/sendmail.postfix
}
