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

[Tom Hendrikx]

On 24-10-11 23:47, Jack Fredrikson wrote:
> 
> ________________________________
> From: Simon Brereton <simon.brereton at buongiorno.com>
> To: dovecot at dovecot.org
> Sent: Monday, October 24, 2011 5:04 PM
> Subject: Re: [Dovecot] Marathon Day 6 of First Install: MySQL Connection Problem
> 
>> Who owns /var/vmail?
> 
> ls -al /var/vmail/
> total 8
> drwxrwx---  2 vmail mail 4096 Oct 19 18:45 .
> drwxr-xr-x 26 root  root 4096 Oct 23 08:35 ..
> /usr/sbin/usermod -a -G mail,postfix dovecot

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).

> 
> And I'm still getting the same error:
> dovecot: auth-worker: Error: mysql(localhost): Connect failed to database (postfix): Access denied for user 'dovecot'@'localhost' (using password: YES)
> 

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

And see what happens if you set the hostname in dovecot config also to
127.0.0.1. Note that testing as root will likely give you access to the
mysql socket, but dovecot might not have the same privileges. The above
will test tcp connectivity for both.

--
Tom