Thus spake Sam Varshavchik on Mon, Aug 30, 2004 at 06:58:29PM CDT
Lindsay 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:
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.