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: info@domain1.com user: info can login as info or info@domain1.com old user: info@domain2.com user: info.ltd can login as info.ltd or info@domain2.com new user: info@domain3.com can login only as info@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 info@domain1.com and info hits the same entry and that the username is overwritten (field "user", IMHO) to info@domain1.com. Then this user can login as info@domain1.com or info with the same password, internally Dovecot handles all mail as info@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 info@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