dovecot - Oct 2006 - Strange Mysql connect problem

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

> -----Original Message-----
> From: "M. Tolga ?zses" [mailto:mtozses at sabanciuniv.edu]
> Sent: Wednesday, October 11, 2006 12:52 AM
> To: Craig Jackson
> Subject: Re: [Dovecot] Strange Mysql connect problem
> 
> 
> Hi,
> 
> Is MySQL even running?
> 
>
Yes. Other applications are using it. It is a production mail server.

On Tue, 2006-10-10 at 21:37 -0500, Craig Jackson 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
I guess you mean this: http://wiki.dovecot.org/MysqlProblems

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20061011/cf7bb1e5/attachment.bin>

On Tue, 10 Oct 2006 21:37:57 -0500
"Craig Jackson" <CJackson at 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