[Dovecot] Postfix/Dovecot virtual - directory structure
johan.folin at lsn.se
Sat Dec 23 10:58:39 UTC 2006
Luigi Rosa wrote:
> Johan Folin said the following On 23/12/2006 0:14:
>> Hi, perhaps I should post this in a Postfix forum but I'll give it a
>> shot: I want my accounts sorted under /home/vmail/[domain]/[username]
>> (and I managed to get Dovecot to look for mail there with %d and %n
>> ), but how do I tell Postfix to sort the mail?
> In Postfix I use this query:
> SELECT maildir FROM users WHERE email='%s' AND attivo='Y'
> In Dovecot the querys are:
> password_query = SELECT email AS user, password FROM users WHERE
> email='%u' AND attivo='Y'
> user_query = SELECT uid,gid,homedir AS home,
> CONCAT('/var/spool/mail/',maildir) AS mail FROM users WHERE email='%u'
> AND attivo='Y'
> Maildir are in /var/spool/mail/[domain]/[user]/
That was it! I had to adjust the select query in
Thanks for the help.
More information about the dovecot