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?
