I got no answers to this post earlier, repeated below. Sam, anyone, is this facility working? In courier 0.38.2 this is supposed to be an entire SQL query, and it works. I can't get it to work in 0.46, although I can probably get equivalent flexibility by using the various MYSQL_*_FIELD settings and the MYSQL_WHERE_CLAUSE.

---------------------------------

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: <fmo...@bbadmin.com> 250 Ok. rcpt to: <fo...@bbadmin.com> 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.