[Dovecot] Mixing system and virtual users

[Tim Tsai]

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