[Dovecot] Postfix/Dovecot virtual - directory structure

[Johan Folin]

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 
mysql_virtual_mailbox_maps.cf.
Thanks for the help.

/Johan Folin