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