[Dovecot] Authenfication on 2 databases

[LeeJaY]

Lorens a écrit :

> On Fri, Sep 09, 2005 at 01:06:42PM +0200, LeeJaY wrote:
> > Hello,
> > 
> > I have 2 databases MySQL. I would like to do that:
> > 
> > If the user does not existe in the first base, it goes in the second
> > database.
> > 
> > my configuration 
> > 
> > auth default {
> >         mechanisms = plain
> >         passdb sql {
> >                 args = /etc/dovecot-sql-1.conf
> >         }
> > 
> >         passdb sql {
> >                args = /etc/dovecot-sql-2.conf
> >         }
> > 
> >         userdb sql {
> >                 args = /etc/dovecot-sql-1.conf
> >         }
> > 
> >         userdb sql {
> >                args = /etc/dovecot-sql-2.conf
> >         }
> > }
> > 
> > but it don't work
> 
> One could wish for more details . . . does the daemon start,
> is the only passdb used the first one or is it that can nobody
> log in, are there error messages in the logs . . . just for
> starters.
> 
Ok, the log

 
Sep  9 18:34:16 localhost dovecot: auth(default): client in:
AUTH^I1^IPLAIN^Iservice=POP3^Isecured^Ilip=^Irip=^Iresp=AGxlZWpheUBsaWJyZWFzc28ubmV0AGxlZWpheTU5
Sep  9 18:34:16 localhost dovecot: auth-worker(default): sql
(xxx at xxxx.net,84.xx.xxx.xxx): query: SELECT passwd AS password
FROM comptes WHERE email = 'xxx at xxxx.net' Sep  9 18:34:16
spider dovecot: auth-worker(default): sql
(xxx at xxx.net,84.98.233.181): unknown user

The users is in second database and he's not valide.

> > my version est 1.0.alpha1
> 
> On my 1.0 (logs "Dovecot v1.0-stable starting up")
> 
> auth default {
>   mechanisms = plain
>   passdb = sql /etc/dovecot/dovecot-sql.conf
>   passdb = sql /etc/dovecot/dovecot-sql-crypt.conf
>   userdb = sql /etc/dovecot/dovecot-sql.conf
> }
> 
> works as expected and desired.
> 
Why there is one userdb = and two passdb ?

> > 
> > if you not understand this message, i am sorry, my english is bad
> 
> Mais tout à fait compréhensible :-)
> 

Mon accent sonne si français que ça ou les headers du mail vous ont
aidé ?

Si vous comprennez le français, c'est plus simple pour exposer mon
problème. 

J'ai deux bases de données avec des comptes emails differents, je veux
juste faire en sorte que si il ne trouve dans la première, il va dans
voir dans la deuxième et ça se fonctionne pas sur ma configuration

Thank/Merci