Re: [Dovecot] Postfix Query

On Fri, 2012-05-11 at 19:07 +0100, Tim wrote:

user_query = SELECT maildir, mailuser as uid, mailgroup as gid,concat('*:bytes=',quota) as quota_rule FROM virtual_mailbox WHERE username = '%u'

and maildir should return example.com/subdomain/tim for this particular user

Returning a "maildir" doesn't do anything with Dovecot. I guess you want something like:

select concat('/var/mail/', maildir) as home, ...

and in dovecot.conf:

mail_location = maildir:~/Maildir