[Dovecot] Failed authentication to a mysql database (bug or PEBKAC?)

[Timo Sirainen]

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.