dovecot 2.4.4 community edition, bug in variables

I'm using this passdb sql to a postgres db

passdb sql {
   query = SELECT NULL AS password, 'Y' as nopassword, userid AS user \
     FROM users \
     WHERE addr = '%{user}' AND password = '%{password}'
}

This succeed and the addr passed in as user is [email protected] as expected

I use this userdb sql

userdb sql {
   query = SELECT home, uid, gid \
     FROM users \
     WHERE addr = '%{user}'
   # For using doveadm -A:
   # iterate_query = SELECT userid AS username, domain FROM users
}

This fails because postgres receives  just "foo" not "[email protected]" 
as user.

maybe there is a bug in my stuff but I cannot see it. I can see the 
query in the postgres log where it clearly says:

WHERE addr = 'foo'

It also logs the passdb query:

WHERE addr = '[email protected]' AND  password='secret'


thanks

Terry



_______________________________________________
dovecot mailing list -- [email protected]
To unsubscribe send an email to [email protected]