dovecot - Dec 2006 - Urgent - Setup DoveCot with Plesk

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 at
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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20061225/97b599df/attachment-0002.html>

On 25.12.2006, at 19.19, iSquareOne LLC wrote:
> I setup sql.conf for user query and password query. I tried  
> different ways, DoveCot always says  "Authentication failed".
If you still haven't gotten it to work, auth_debug=yes and  
auth_debug_passwords=yes would be helpful in figuring out why the  
authentication is failing. Your password_query and user_query looked ok.



-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070103/e16f46b2/attachment.bin>