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
Connected to localhost.
Escape character is '^]'.
220 mail01.bbadmin.com ESMTP
mail from: <fmo...@bbadmin.com>
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.