So if I understand this correctly, %u matches the whole username in
the sql database, but %n only matches the name before @?

One thing we discovered in migrating from courier-imap to Dovecot is
that courier-imap supported user@domain as a valid login name, where
by default using %u in the SQL query, Dovecot does not. So it would
have been useful for us to avoid a number of tech support calls for
users who have user@domain configured in their mail clients.

-- Roger J. Weeks Systems & Network Administrator Mendocino Community Network

On Apr 12, 2006, at 7:16 AM, dovecot-request@dovecot.org wrote:

Date: Wed, 12 Apr 2006 16:05:24 +0300 From: Timo Sirainen tss@iki.fi Subject: Re: [Dovecot] strip domains To: Netlink Tech tech@netlinkcom.com Cc: dovecot@dovecot.org

On Tue, 2006-04-11 at 09:36 -0500, Netlink Tech wrote: In general I don't see this as very useful feature. Why are your users logging in with @domain? Or why not change your passdbs/userdbs to
just contain the domain, and set auth_default_realm so everyone always logs in with domains?

Here you can modify your SQL command to use %n instead of %u.

...

userdb passwd { }

...

userdb sql { args = /etc/dovecot-sql.conf }

And here again you can use %n.