From: Tom Hendrikx <tom@whyscream.net> To: dovecot@dovecot.org Sent: Monday, October 24, 2011 6:00 PM Subject: Re: [Dovecot] Marathon Day 6 of First Install: MySQL Connection Problem
Adding dovecot to the postfix group would be considered a security issue by many. Don't so this unless you actually think it wil help you (it won't).
Thanks. I took it out.
Please see http://dev.mysql.com/doc/refman/5.5/en/connecting.html, especially the part that starts with "On Unix, MySQL programs treat the host name localhost specially,"
Then show proof that this command works:
mysql -udovecot -pxxx -h 127.0.0.1 postfix
My bad. I had the wrong p/w in sql.conf :-}
So now I'm connected to the database as dovecot, but I'm still getting these dad-blamed errors:
BC81A57901AD: to=<foo@bar.com>, relay=dovecot, delay=25695, delays=25695/0.02/0/0.28, dsn=4.3.0, status=deferred (temporary failure)
# 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 { group = postfix mode = 0660 user = postfix } user = root } ssl_cert = </etc/pki/tls/certs/mail.bar.com.cert ssl_cipher_list = ALL:!LOW:!SSLv2 ssl_key = </etc/pki/tls/private/mail.bar.com.key 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 = 13gems.com info_log_path = /var/log/dovecot-deliver.log log_path = /var/log/dovecot-deliver.log mail_plugins = quota postmaster_address = postmaster@bar.com sendmail_path = /usr/sbin/sendmail.postfix }
TIA, Jack