[Dovecot] pop/imap login logging only username part of full email address

[Justin McAleer]

Timo Sirainen wrote:
> It means dovecot-auth has stripped the domain from the username.
> Typically the problem has been with SQL queries where you have user and
> domain in separate fields:
>
> password_query = select user, password from .. where user = '%n' and
> domain = '%d'
>
> Because you're returning here "user" field, Dovecot changes the username
> to that. So either remove the user field, or change it to eg.
> "concat(user, '@', domain) as user" (to preserve the casing).
>
>   
Doh! Of course... sorry to bother you with that. Actually, I was 
wondering what I was going to do about users logging in with email 
aliases, and this solves that problem.