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