Hey, all, I am trying to setup DoveCot with Plesk. But I could not go through the last step.
Setup: MySQL 5.0.22 Qmail Plesk 7.5 DoveCot v1.0 RC15
The problem: I setup sql.conf for user query and password query. I tried different ways, DoveCot always says "Authentication failed".
Here are my two SQLs. user_query = SELECT concat('/var/qmail/mailnames/', d.name, '/', m.mail_name) as home, concat('/var/qmail/mailnames/', d.name, '/', m.mail_name) as mail, 101 AS uid, 12 AS gid, 'dirsize:storage=1000000' AS quota FROM accounts a, mail m, domains d WHERE a.id = m.account_id AND d.id=m.dom_id AND m.mail_name='%n' AND d.name='%d'
I manully fill in %n=admin and %d=test.com to test it and it worked fine The result is: home,mail,uid,gid,quota "/var/qmail/mailnames/test.com/admin","/var/qmail/mailnames/test.com/admin","101","12","dirsize:storage=1000000"
password_query = SELECT concat(m.mail_name, '@',d.name) as user, a.password as password, concat('/var/qmail/mailnames/', d.name, '/', m.mail_name) as userdb_home, concat('maildir:/var/qmail/mailnames/', d.name, '/', m.mail_name) as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM accounts a, mail m, domains d WHERE a.id = m.account_id AND d.id=m.dom_id AND m.mail_name='%n' AND d.name='%d' The result is: user,password,userdb_home,userdb_mail,userdb_uid,userdb_gid "admin@test.com","password","/var/qmail/mailnames/test.com/admin","maildir:/var/qmail/mailnames/test.com/admin","101","12"
I don't know what DoveCot is expecting to get from the SQL result. Please let me know if I missed anything. Thank you very much!
Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com