[Dovecot] Postgresql and Dovecot

[Alex Howansky]

> 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/