Lindsay Haisley writes:
Thus spake Sam Varshavchik on Mon, Aug 30, 2004 at 06:58:29PM CDTLindsay Haisley writes: >I have MYSQL_SELECT_CLAUSE working nicely with a non-standard query on >courier-0.38.2 and authmysql. I'm trying to get courier with authmysql set >up and working on a customer's mail system the same way, and it looks as if >MYSQL_SELECT_CLAUSE isn't working at all in courier-0.46. > >Nothing shows up in the mysql log so apparently no mysql query is being >made by the mail server.
This indicates a connectivity problem. Check your login parameters:
MYSQL_SERVER MYSQL_USERNAME MYSQL_PASSWORD
These are OK. If I comment out MYSQL_SELECT_CLAUSE and let authmysql build its own query, then everything is hunky-dory, the query works, and shows up in the mysql log, so it's not connectivity.
That does indicate a bug.
Set DEBUG_LOGIN=2; this generates a few debugging messages in syslog.
Also try replacing $(localpart) with a constant string, 'foo'. Perhaps there's a bug in variable substitution getting triggered.
pgpkfNrijwJQY.pgp
Description: PGP signature
