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@eurimage.pl,127.0.0.1): query: SELECT email as user, haslo as password FROM users WHERE email='grom@eurimage.pl'; dovecot: Mar 30 14:41:01 Info: auth-worker(default): sql(grom@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@eurimage.pl dovecot: Mar 30 14:41:03 Info: imap-login: Disconnected (auth failed, 1 attempts): user=<grom@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 :)