Answering my own question:
In dovecot-sql.conf:
user_query = SELECT '/var/vmail/' as home, maildir as mail,
postfix_uid as uid, postfix_gid as gid FROM mailbox WHERE username = '%u'
And in dovecot.conf userdb/passwdb sections:
args = home=maildir:~/Maildir/
it's not as clean as I'd
I am almost done migrating to a new server using Dovecot + Postfix +
Postfixadmin/MySQL. I am a bit confused about how to mix the system
(pam) and virtual (SQL) users though.
I see that in dovecot.conf, there is a default_mail_env variable but
that seems to apply to both cases. I really need