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

[Simon Brereton]

On 24 October 2011 19:17, Jack Fredrikson <jackfredrikson at yahoo.com> wrote:
>
> ________________________________
> 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)

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 at bar.com
>   sendmail_path = /usr/sbin/sendmail.postfix
> }
>
> TIA,
> Jack