On 24-10-11 23:47, Jack Fredrikson wrote:
From: Simon Brereton simon.brereton@buongiorno.com To: dovecot@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 postfixAnd 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