Re: [Dovecot] %d does not expand to domain

[Timo Sirainen]

On Wed, 2009-05-20 at 10:17 -0700, RoyK wrote:
> 
> Timo Sirainen wrote:
> > 
> > On Wed, 2009-05-20 at 08:55 -0700, RoyK wrote:
> >> I see the same happen on Ubuntu Linux 8.04LTS, Dovecot 1.0.5. Config is
> >> given below. %u is expanded on the password_query, but not with the
> >> user_query, according to the mysql query log.
> > 
> > Show your password_query.
> > 
> 
> These are the two queries being executed
> 
> 181 Query       SELECT username as user, password, domain FROM users WHERE
> username = 'test' and domain = 'mydomain.com'

Use:

SELECT concat(username, '@', domain) AS user, password FROM users WHERE ..

signature.asc
Description: This is a digitally signed message part