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

On Sun, 17 May 2009 14:09:30 -0400 Timo Sirainen <tss@iki.fi> wrote:

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

Thanks, Timo! It works!

Konstantin <kostas@mgupb.net>