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.
My authmysqlrc file on the customer system contains a very simple query: MYSQL_SELECT_CLAUSE select id, crypt, clear, uid, gid, home, maildir, quota, name, '' from passwd where id = '$(local_part)' The results .... # telnet localhost 25 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 220 mail01.bbadmin.com ESMTP ehlo bbadmin.com 250-mail01.bbadmin.com Ok. 250-STARTTLS 250-XVERP=Courier 250-XEXDATA 250-XSECURITY=NONE,STARTTLS 250-PIPELINING 250-8BITMIME 250-SIZE 250 DSN mail from: <[EMAIL PROTECTED]> 250 Ok. rcpt to: <[EMAIL PROTECTED]> 450 Service temporarily unavailable. Nothing shows up in the mysql log so apparently no mysql query is being made by the mail server. If I comment out MYSQL_SELECT_CLAUSE in authmysqlrc then a proper mysql query is made on the database, which shows up in the mysql.log, and mail is delivered as expected. What's changed here? Am I missing something? There doesn't seem to be any more detailed logging, although I know that the above temp error message is generally an indication of something awry in authentication configuration. -- Lindsay Haisley | "Everything works | PGP public key FMP Computer Services | if you let it" | available at 512-259-1190 | (Travis W. Redfish) | <http://www.fmp.com/pubkeys> http://www.fmp.com | ("The Roadie") | ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
