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

On Wed, 2007-01-24 at 13:51 -0500, Justin McAleer wrote:

I have my login log format set like so:

login_log_format_elements = user=<%u> method=%m rip=%r lip=%l %c

When I log in using a full email address, though, I only get the username part of the address:

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).