Re: [Dovecot] help with AES_DECRYPT and password lookup - mysql password_query

On 04/28/2012 05:25 PM, Jeff Lacki wrote:

...

...

/mf/home/jeep/shell/.signature The wiki says: "The password is in %w variable" Maybe you meant

password_query = SELECT NULL AS password,
'Y' as nopassword, userid AS user
FROM users WHERE userid='%u' AND AES_DECRYPT(password, 'mykey')='%w'

Thanks, but when I do that, I get an empty value for '%w', not sure why?

Apr 28 14:23:48 mydomain dovecot: auth-worker(13349): Debug: sql(jeff,127.0.0.1): query: SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users WHERE userid='jeff' AND AES_DECRYPT(password, 'mykey')=''

/mf/home/jeep/shell/.signature

Are you using a plaintext authentication mechanism?