[Dovecot] Failed authentication to a mysql database (bug or PEBKAC?)
Hi, dovecot has a little crazy behaviour connecting to a mysql db: if you specify "127.0.0.1" as host instead of "localhost" it seems to work, also with a password. BUT, if you assign host=localhost without a password, it works too (as Ger Visschers says)....
One more question: how I can specify more different mysql-db conteining different users? I try in the following way: passdb sql { args = /etc/dovecot/dovecot-mysql_django.conf args = /etc/dovecot/dovecot-mysql_debord.conf } and also: passdb sql { args = /etc/dovecot/dovecot-mysql_debord.conf } passdb sql { args = /etc/dovecot/dovecot-mysql_django.conf } but it always seems to remember only the last args value and it tries to connect only one db...
bye jigen
jigen jigen@metalabs.org MeTA~LAbS
On Fri, 2005-08-19 at 16:56 +0200, jigen wrote:
Hi, dovecot has a little crazy behaviour connecting to a mysql db: if you specify "127.0.0.1" as host instead of "localhost" it seems to work, also with a password. BUT, if you assign host=localhost without a password, it works too (as Ger Visschers says)....
So if you have host=localhost and a password, it doesn't work?
Dovecot just passes these values to Mysql library without doing anything to them itself. So if it happens, it's Mysql library bug.
Anyway, in my system host=localhost + password word just fine too.
One more question: how I can specify more different mysql-db conteining different users? I try in the following way: passdb sql { args = /etc/dovecot/dovecot-mysql_debord.conf } passdb sql { args = /etc/dovecot/dovecot-mysql_django.conf }
This should work. After trying to authenticate against the first one it should try the second. Although I'm not sure if I've tried two passdb sqls before, maybe Dovecot has problems with that.. Well, I'll try once I get home.
jigen wrote:
Hi, dovecot has a little crazy behaviour connecting to a mysql db: if you specify "127.0.0.1" as host instead of "localhost" it seems to work, also with a password. BUT, if you assign host=localhost without a password, it works too (as Ger Visschers says)....
Got the same problem with alpha3 and mysql-4.1.14 on FreeBSD-5.4R/i386. (both installed from ports)
Does not work in any combination with password. Does work without password.
Noticed weird client hostnames reported by the mysql server in the dovecot logs (messages from libmysqlclient). Seems like it wrongfully computes the client hostname, and the authentication fails becauese of that. Is there some kind of initialization in the libmysqlclient?
--
./lxnt
participants (3)
-
Alexander Sabourenkov
-
jigen
-
Timo Sirainen