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