Re: [Dovecot] Problem with domain part in user_query in dovecot 1.1.14

On Sun, 2009-05-17 at 14:48 +0000, Konstantin wrote:

password_query = SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM main.mail_base WHERE userid = '%n' AND password = '%w' and domain='%d'

"userid AS user" drops the domain. Use rather:

select .., userid AS username, domain