11 messages in net.sourceforge.lists.courier-users[courier-users] Re: MYSQL_SELECT_CLAU...| 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] Re: MYSQL_SELECT_CLAUSE again | |
|---|---|---|
| From: | Sam Varshavchik (mrs...@courier-mta.com) | |
| Date: | Aug 30, 2004 4:58:44 pm | |
| List: | net.sourceforge.lists.courier-users | |
Lindsay Haisley writes:
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.
It should work.
---------------------------------
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.
This indicates a connectivity problem. Check your login parameters:
MYSQL_SERVER MYSQL_USERNAME MYSQL_PASSWORD