| From | Sent On | Attachments |
|---|---|---|
| Lindsay Haisley | Aug 30, 2004 9:14 am | |
| Sam Varshavchik | Aug 30, 2004 4:58 pm | |
| Lindsay Haisley | Aug 31, 2004 12:40 pm | |
| Ben Kennedy | Aug 31, 2004 1:06 pm | |
| Lindsay Haisley | Aug 31, 2004 1:15 pm | |
| Keith Willis | Aug 31, 2004 2:06 pm | |
| Sam Varshavchik | Aug 31, 2004 3:37 pm | |
| Lindsay Haisley | Aug 31, 2004 6:26 pm | |
| Sam Varshavchik | Sep 1, 2004 4:09 am | |
| Lindsay Haisley | Sep 1, 2004 9:24 am | |
| Sam Varshavchik | Sep 1, 2004 3:48 pm |
| Subject: | [courier-users] MYSQL_SELECT_CLAUSE again | |
|---|---|---|
| From: | Lindsay Haisley (fmou...@fmp.com) | |
| Date: | Aug 30, 2004 9:14:41 am | |
| List: | net.sourceforge.lists.courier-users | |
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.
-- 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") |





