On 24 October 2011 16:43, Jack Fredrikson <jackfredrik...@yahoo.com> wrote:
>
> ________________________________
> 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
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 = postmas...@mydomain.com
> sendmail_path = /usr/sbin/sendmail.postfix
> }
