[Dovecot] Strange Mysql connect problem

Craig Jackson CJackson at abbott-simses.com
Wed Oct 11 03:37:57 UTC 2006


Hi, I compiled Dovecot and Mysql on two different servers each with the same options. Dovecot connects successfully on Server B. Server A has this error in Dovecot trying to connect to Mysql:

dovecot: auth-worker(default): mysql: Connect failed to /tmp/mysql.sock (exim_db): Access denied for user 'user'@'localhost' (using password: YES) - waiting for 5 seconds before

Passwords are plain text.

Server A (64 bit amd with Ubuntu Hoary) info:
./mysql -V
mysql  Ver 14.7 Distrib 4.1.11, for unknown-linux-gnu (x86_64)
ldd dovecot
        libmysqlclient.so.14 => /usr/local/mysql/lib/mysql/libmysqlclient.so.14 (0x0000002a9566c000)
        libc.so.6 => /lib/libc.so.6 (0x0000002a95881000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x0000002a95ac0000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x0000002a95bf3000)
        libm.so.6 => /lib/libm.so.6 (0x0000002a95d09000)
        libz.so.0 => /usr/local/mysql/lib/mysql/libz.so.0 (0x0000002a95e90000)
        /lib64/ld-linux-x86-64.so.2 => /lib64/ld-linux-x86-64.so.2 (0x0000002a95556000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x0000002a95fa4000)
./dovecot --version
1.0.rc7
More info -- The Mysql user name on A and B are the same and are correct. Other applications are connecting on A using the same credentials.

Server B info (Debian PIII):
mysql  Ver 14.7 Distrib 4.1.21, for pc-linux-gnu (i686) using  EditLine wrapper
ldd dovecot
        linux-gate.so.1 =>  (0xffffe000)
        libc.so.6 => /lib/tls/libc.so.6 (0x40020000)
        /lib/ld-linux.so.2 (0x40000000)
./dovecot --version
1.0.rc7

I have Googled and see lots of people having the same problem. I would rather not downgrade Mysql.

Why doesn't Dovecot connect on A?

Thanks.
Craig


More information about the dovecot mailing list