[Dovecot] sendmail to postfix-dovecot

[R. Berger]

Steffen Kaiser schreef op 28-11-2013 10:08:
>
>> Here is my dovecot -n:
>> root at 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 at domain1.com user: info can login as info or 
>> info at domain1.com
>> old user: info at domain2.com user: info.ltd can login as info.ltd or 
>> info at domain2.com
>> new user: info at domain3.com can login only as info at 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 at domain1.com and info hits the 
> same entry and that the username is overwritten (field "user", IMHO) 
> to info at domain1.com. Then this user can login as info at domain1.com or 
> info with the same password, internally Dovecot handles all mail as 
> info at 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 at 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