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

[Gedalya]

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?