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
