[Dovecot] Marathon Day 6 of First Install: MySQL Connection Problem
Jack Fredrikson
jackfredrikson at yahoo.com
Tue Oct 25 02:17:23 EEST 2011
________________________________
From: Tom Hendrikx <tom at whyscream.net>
To: dovecot at 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 at 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 at bar.com
sendmail_path = /usr/sbin/sendmail.postfix
}
TIA,
Jack
More information about the dovecot
mailing list