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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20090520/87afb14a/attachment.bin