[Exim] SMTP AUTH (from MySQL) problem

Top Page
Delete this message
Reply to this message
Author: Troy Settle
Date:  
To: exim-users
Subject: [Exim] SMTP AUTH (from MySQL) problem
Ok, another issue just crept up on me.

I'm doing the following for SMTP AUTH:

MYSQL_AUTH_LOGIN = SELECT if(count(*), "1", "0") \
 FROM users \
 WHERE (username='${quote_mysql:$1}' \
    OR username=REPLACE('${quote_mysql:$1}','%','@')) \
   AND password='${quote_mysql:$2}'


server_condition = ${lookup mysql{MYSQL_AUTH_LOGIN}}

This is working fine for plaintext passwords, but what do I need to do
to get this to work with DES or MD5 encrypted passwords? Unfortunately,
I don't have access to everyone's plaintext password.

TIA,

--
Troy Settle
Pulaski Networks
http://www.psknet.com
540.994.4254 - 866.477.5638