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: <[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.
This indicates a connectivity problem. Check your login parameters:
MYSQL_SERVER MYSQL_USERNAME MYSQL_PASSWORD
pgpxopxIHd9Fk.pgp
Description: PGP signature
