[Dovecot] Postfix Query

[Timo Sirainen]

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