Re: [exim] MySQL Auth with SHA1 passwords?

Am 21.05.2013 10:53, schrieb Fabien Wang:

just change the match from direct match to a indirect one:

   server_condition = "${if and { \
                       {!eq{$1}{}} \
                       {!eq{$2}{}} \
                       {eq{1}{${lookup mysql{SELECT '1' FROM mailboxes 
WHERE  (domain =\
                       '${domain:$1}' \
                       AND password = sha1('$2') AND username = 
'${local_part:$1}')}{$value}fail}} }} {yes}{no}}"

use the mysql function you like : md5() sha256() whatever or just
encrypt() .. whatever you used in your database .

Marius