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

[Jeff Lacki]

> >
> > /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