[Dovecot] Marathon Day 6 of First Install: MySQL Connection Problem

[Jack Fredrikson]

________________________________
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