Re: [Dovecot] Postgresql and Dovecot

I have another question. I am authenticating against an existing database. Postfix drops mail in /var/spool/mail/%u . The existing database only has login (the username) and password. My user_query is:

user_query = SELECT '/var/spool/mail'||login as mail, 89 AS uid, 89 AS gid FROM user_common WHERE login='%u';

I think you want a slash after /var/spool/mail, and select the mail directory field as "home", not "mail":

user_query = SELECT '/var/spool/mail/'||login AS home, 89 AS uid, 89 AS gid FROM user_common WHERE login='%u';

-- Alex Howansky Wankwood Associates http://www.wankwood.com/