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