Here's what I'd like to do for virtual accounts. The setup is easy, getting
courier to work with it is where I have questions.
I want to create virtual mail accounts so that the id for each account is
unique, tied to the domain name under which the virtual account will be
used. I'm using authmysql and authpam, the former being checked first.
I can set up a virtual mailbox account so that the id field in the mysql
passwd table contains user@domain, so POP logins will be unique, and the
'home' field will be set to something like /home/virtmail/domain/user, which
uniquely defines the mailbox. This works fine for POP access, but won't
work for esmtp, which gives me a "User unknown" in response to rcpt to:
<user@domain>. If I set the ID field to "user" instead of "user@domain"
there's no problem with esmtp, and mail is delivered to the right mailbox,
but my user namespace no longer has any association with the domain, so I
couldn't have virtual mailboxes for "bob@domain1" and "bob@domain2" at the
same time. I can alias "user" to something else like "user_domain" with a
.courier file, which is what I'm doing with qmail, but for various reasons
I'd like to avoid this.
Could I, for instance, include a domain_name field in the mysql passwd table
and set up MYSQL_SELECT_CLAUSE to be something like
select id,crypt,uid,gid,clear,home,maildir,quota,name from passwd where
id="$(local_part)" and domain_name="$(domain)"
Would this work for both for esmtp's rcpt to: <user@domain> to uniquely
establish the existence and identity of a mailbox and also for POP service
logging in with "user user@domain"? Would sqwebmail be happy with this?
I guess I just need to try it, but I though Sam or someone else might have
gone down this road and could give me some tips which would save some time.