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