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

20 May 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 ..