Steffen Kaiser schreef op 28-11-2013 10:08:
Here is my dovecot -n:
root@mail:/usr/local/etc/dovecot/conf.d # dovecot -n
# 2.2.6: /usr/local/etc/dovecot/dovecot.conf
mail_location = maildir:~/
you should not use the home directory as base for mail storage, use
~/Maildir
passdb {
args = /usr/local/etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
userdb {
driver = prefetch
}
userdb {
args = /usr/local/etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
I've been thinking about this and I want to put all system users in
the database using the provided tools from postfixadmin and then sync
the mail using imapsync.
OK, then all user data are in the SQL database.
In that case domain admins can handle their own mailboxes using
postfixadmin.
In that case I have all users as virtual users, but they have to be
able to login with only their username.
That means new users should login by using their complete
emailaddress and old users as username or emailaddress.
so:
old user: i...@domain1.com user: info can login as info or
i...@domain1.com
old user: i...@domain2.com user: info.ltd can login as info.ltd or
i...@domain2.com
new user: i...@domain3.com can login only as i...@domain3.com
if the new user tries to login as info he gets a password failure
Is this possible an correct ?
configure your SQL query so, that i...@domain1.com and info hits the
same entry and that the username is overwritten (field "user", IMHO)
to i...@domain1.com. Then this user can login as i...@domain1.com or
info with the same password, internally Dovecot handles all mail as
i...@domain1.com only.
Do the same for all other users as appropriate.
One can craft the database like so:
+ one table with the user data of i...@domain1.com, username, password
a.s.o.
+ one table with alias names and foreign key of user data table
+ the select for passdb joins both tables
Search the list and wiki for such setup, e.g.
http://wiki2.dovecot.org/PasswordDatabase?highlight=%28username%29
- -- Steffen Kaiser
Hmm.. I am googling around for about 4 hours now, but not getting
anywhere. Can you point me in the right direction?
Thanks,
Roger
