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