[Dovecot] %d does not expand to domain
Timo Sirainen
tss at iki.fi
Wed May 20 20:21:41 EEST 2009
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
More information about the dovecot
mailing list