On Tue, 10 Oct 2006 21:37:57 -0500 "Craig Jackson" CJackson@abbott-simses.com wrote:
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
Does running this the command line mysql client (something like mysql -u user -h localhost -p exim_db) as the Dovecot user work? I'm guessing it won't and the message from the mysql client will be the same as above?
Have you tried making the logging on the DB more verbose? Often useful with MySQL I find. I see it is a production system though so that might not be possible.
Dominic
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