[HowTo] Replace courier with dovecot

[aseques]

Since RC5, there is the feature of an address being at the same time a normal address and a forward, some lines have to be changed in the dovecot-sql-domain.conf to be able to autenticate with those aliases too.

from:

Code:

password_query = SELECT md5(mail_pass) AS password FROM mail_users inner join domain on mail_users.domain_id = domain.domain_id WHERE mail_acc='%n' and domain.domain_name='%d' and mail_type='normal_mail';

to:

Code:

password_query = SELECT md5(mail_pass) AS password FROM mail_users inner join domain on mail_users.domain_id = domain.domain_id WHERE mail_acc='%n' and domain.domain_name='%d' and (mail_type='normal_mail' OR mail_type='normal_mail,normal_forward');

and also from:

Code:

user_query = SELECT concat('/var/mail/virtual/', domain.domain_name, '/',mail_acc) as home, '1001' as uid, '8' as gid FROM mail_users inner join domain on mail_users.domain_id = domain.domain_id WHERE mail_acc='%n' and domain.domain_name='%d' and mail_type='normal_mail';

to:

Code:

user_query = SELECT concat('/var/mail/virtual/', domain.domain_name, '/',mail_acc) as home, '1001' as uid, '8' as gid FROM mail_users inner join domain on mail_users.domain_id = domain.domain_id WHERE mail_acc='%n' and domain.domain_name='%d' and (mail_type='normal_mail' OR mail_type='normal_mail,normal_forward');

Same changes apply to people using quota
You can look at the wiki for updated config