exim + md5 operator

Hello there,

Im looking up a mysql database for virtual users / domains.

I would like to encrypt the password in the database (in md5) instead of plain text.

does anyone here know how to use the md5 operator in exim?

this is how i am currently authenticating the user:

Code: 
plain_login:
        driver = plaintext
        public_name = PLAIN
        server_condition = ${lookup mysql{SELECT '1' FROM users WHERE email_address = '${quote_mysql:$2}' AND password = '${quote_mysql:$3}'} {yes}{no}}
        server_set_id = $2

fixed_login:
        driver = plaintext
        public_name = LOGIN
        server_prompts = "Username:: : Password::"
        server_condition = ${lookup mysql{SELECT '1' FROM users WHERE email_address = '${quote_mysql:$1}' AND password = '${quote_mysql:$2}'} {yes}{no}}
        server_set_id = $1
does anyone know how to modify those queries to use the md5 operator so i can store the passwords in the database in md5 instead of plain text?

thanx

 

 

 

 

Top