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 like but seems to do the trick.The only other thing that got me really confused was passwd schemes. I am migrating vpopmail password database and I had to specify MD5 in dovecot-sql.conf.
Thanks,
Tim
Tim Tsai wrote:
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 a default for each type of authentication.
My virtual users are in /var/vmail/domain/user and my system users are in /home/user/Maildir
any ideas? I can get one or the other to work but not both at this point.
Thanks,
Tim