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

[Heiko Schlittermann]

Jack Fredrikson <jackfredrikson at yahoo.com> (Mon Oct 24 21:00:54 2011):
> Hi;
> This is my 6th day installing my first Postfix/Dovecot installation. The Postfix mailing list indicates I've got the MTA under control so now I'm seeking your help with the MDA. I get these errors with legitimate email addresses:
> Oct 24 11:47:38 myserver dovecot: auth-worker: Error: mysql(localhost): Connect failed to database (postfix): Access denied for user 'dovecot'@'localhost' (using password: YES) - waiting for 25 seconds before retry
> 
> Now I've logged in myself:
> mysql -u dovecot -p
> Enter password: xxx
> and succeeded. What am I doing wrong?

You should test:

    mysql -udovecot -pxxx -hlocalhost postfix

to simulate the dovecot attemts.

> I've noticed that every time I restart dovecot I get this error in the dovecot-deliver.log:
> 
> Oct 24 11:31:11 lda: Error: userdb lookup: connect(/usr/local/var/run/dovecot/auth-userdb) failed: Permission denied (euid=512(vmail) egid=512(vmail) missing +r perm: /usr/local/var/run/dovecot/auth-userdb, dir owned by 0:0 mode=0755)
> Oct 24 11:31:11 lda: Fatal: Internal error occurred. Refer to server log for more information.
> 
> 
> Every time I go to chmod 666 on that file, restarting dovecot wipes those permissions. How fix?
> Even when I fix that, I still get the "temporary failure".
> Please advise.

This file is not a file, it is a socket and gets recreated every time
you restart dovecot. There is, if I remember well, some config option
"mode" near the name of the name of the socket.

-- 
Heiko :: dresden : linux : SCHLITTERMANN.de
GPG Key 48D0359B : 3061 CFBF 2D88 F034 E8D2 7E92 EE4E AC98 48D0 359B
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://dovecot.org/pipermail/dovecot/attachments/20111024/e4d7027d/attachment-0001.bin>