On 24 October 2011 19:17, Jack Fredrikson <jackfredrikson@yahoo.com> wrote:
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)
Turn up the logging in postfix (add -vv to the smtpd line in master.cf or google for log-level) - but I'm pretty sure that this means postfix wants to give it dovecot, but dovecot says I can't do anything with it. Either cos it doesn't know where to put it. Or doesn't have permission to put it there. You could turn up your dovecot logging too if the postfix logs aren't helpful.
My directory permissions (in no way security recommended - but working) for /var/vmail/ are:
drwxrwxS mailsystem mailsystem
Simon
# 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