[Dovecot] Double mysql auth problem

Sebastian Chociwski sebastian.ch at pro-activ.pl
Mon Mar 30 16:00:23 EEST 2009


Hello ,
I am forced to use 2 DBs to auth users. First one is for our CRM system 
(new user=mail from him/her) , second is for other (cannot user CRM DB :( )
Postfix have no problem to deliver mails to both DBs but I've some 
problems with reciveing mails from second (not CRM) DB.

The dovecot.conf :
protocols =  imap pop3 imaps
disable_plaintext_auth = no
mail_location = maildir:/home/vmail/%d/%n
log_path = /var/log/dovecot
ssl_disable = no
ssl_cert_file = /etc/ssl/certs/dovecot.pem
ssl_key_file = /etc/ssl/private/dovecot.pem
auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes

auth default {
 passdb sql {
   args = /etc/dovecot/dovecot-mysql.conf
 }

userdb static {
   args = uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes
 }
}
auth secondary {
 passdb sql {
   args = /etc/dovecot/dovecot-mysql2.conf
 }
userdb static {
   args = uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes
 }
}

dovecot-mysql.conf :
driver = mysql
connect = host=127.0.0.1 dbname= user= password=
default_pass_scheme = CRYPT
password_query = SELECT email as user, haslo as password FROM users WHERE
email='%u';

dovecot-mysql2.conf :
driver = mysql
connect = host=127.0.0.1 dbname= user= password=
default_pass_scheme = CRYPT
password_query = SELECT email as user, password FROM poczta WHERE
email='%u';

I could log on mail located in dovecot-mysql.conf (CRM) but when I try 
to log on  second DB I got errors :
dovecot: Mar 30 14:41:01 Info: auth(default): client in:
AUTH    1       PLAIN   service=imap    secured lip=127.0.0.1   
rip=127.0.0.1   lport=993       rport=32930     
resp=AGdyb21AZXVyaW1hZ2UucGwANzEyMA==
dovecot: Mar 30 14:41:01 Info: auth-worker(default):
sql(grom at eurimage.pl,127.0.0.1): query: SELECT email as user, haslo as
password FROM users WHERE email='grom at eurimage.pl';
dovecot: Mar 30 14:41:01 Info: auth-worker(default):
sql(grom at eurimage.pl,127.0.0.1): unknown user
dovecot: Mar 30 14:41:01 Info: auth(default): new auth connection:
pid=19560
dovecot: Mar 30 14:41:01 Info: auth(secondary): new auth connection:
pid=19560
dovecot: Mar 30 14:41:03 Info: auth(default): client out:
FAIL    1       user=grom at eurimage.pl
dovecot: Mar 30 14:41:03 Info: imap-login: Disconnected (auth failed, 1
attempts): user=<grom at eurimage.pl>, method=PLAIN, rip=127.0.0.1,
lip=127.0.0.1, TLS

I see query for auth default but got no isea why there's no query for 
auth secondary ?
Waiting for some help :)


More information about the dovecot mailing list