Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-22 Thread p dont think
bump. is there any reason why MYSQL_SELECT_CLAUSE would be ignored? p dont think wrote: Lindsay Haisley fmouse-courier at fmp.com writes: This was a config error on my part. I corresponded with Sam off-list. Hrm, that's not quite what I wanted to hear. ;) Here's my post to him: From

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-22 Thread p dont think
bump. is there any reason why MYSQL_SELECT_CLAUSE would be ignored? If anyone is watching and can be of help, I just inserted a print of the MYSQL_SELECT_CLAUSE right after its value is read in authlib/authmysqllib.c on line 650, and its value is null. Er, what? I double checked that there

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-22 Thread p dont think
One problem solved, one more problem identified. Sigh... The problem here was that comment lines with a backslash on the end were being wrapped. I had such a comment line right above my MYSQL_SELECT_CLAUSE, so my real MYSQL_SELECT_CLAUSE was getting folded into a comment line. It looked

[courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-22 Thread Sam Varshavchik
p dont think writes: However, now I see in my logs that $(service) is not giving what it promised. I am using $(service) with the hopes that it can tell me the difference between users hitting imapd-ssl and those using imapd. However, *both* are showing imap in my query logs. Pop3 has the

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-22 Thread p dont think
However, now I see in my logs that $(service) is not giving what it promised. I am using $(service) with the hopes that it can tell me the difference between users hitting imapd-ssl and those using imapd. However, *both* are showing imap in my query logs. Pop3 has the same problem,

[courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-21 Thread p dont think
Lindsay Haisley fmouse-courier at fmp.com writes: This was a config error on my part. I corresponded with Sam off-list. Hrm, that's not quite what I wanted to hear. ;) Here's my post to him: From fmouse at fmp.com Wed Sep 15 18:03:04 2004 Date: Wed, 15 Sep 2004 18:03:04 -0500

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-17 Thread Lindsay Haisley
This was a config error on my part. I corresponded with Sam off-list. Here's my post to him: From [EMAIL PROTECTED] Wed Sep 15 18:03:04 2004 Date: Wed, 15 Sep 2004 18:03:04 -0500 From: Lindsay Haisley [EMAIL PROTECTED] To: Sam Varshavchik [EMAIL PROTECTED] Subject: Re: Any progress with

[courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-09-01 Thread Sam Varshavchik
Lindsay Haisley writes: OK, apparently esmtpd doesn't support DEBUG_LOGIN=2 so I put it in pop3d, which does support it, and here's the output. No, you want this environment variable set for the authentication module: just add it to authdaemonrc pgpF2ALoSmwZF.pgp Description: PGP signature

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-09-01 Thread Lindsay Haisley
No help there, either. I added it to authdaemonrc, and also as an enviroment var in the authdaemond startup line in /etc/init.d/courier, but I don't get anything informative in syslog, only the usual Sep 1 11:17:58 mail01 courieresmtpd: error,relay=:::127.0.0.1,ident=root,from=[EMAIL

[courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-09-01 Thread Sam Varshavchik
Lindsay Haisley writes: No help there, either. I added it to authdaemonrc, and also as an enviroment var in the authdaemond startup line in /etc/init.d/courier, but I don't get anything informative in syslog, only the usual Sep 1 11:17:58 mail01 courieresmtpd:

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-08-31 Thread Lindsay Haisley
Thus spake Sam Varshavchik on Mon, Aug 30, 2004 at 06:58:29PM CDT Lindsay Haisley writes: 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,

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-08-31 Thread Ben Kennedy
On 31 8 2004 at 1:21 pm -0400, Lindsay Haisley wrote: These are OK. If I comment out MYSQL_SELECT_CLAUSE and let authmysql build its own query, then everything is hunky-dory, the query works, and shows up in the mysql log, so it's not connectivity. There is something broken with authmysql as

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-08-31 Thread Lindsay Haisley
Thus spake Ben Kennedy on Tue, Aug 31, 2004 at 02:55:45PM CDT On 31 8 2004 at 1:21 pm -0400, Lindsay Haisley wrote: These are OK. If I comment out MYSQL_SELECT_CLAUSE and let authmysql build its own query, then everything is hunky-dory, the query works, and shows up in the mysql log, so

RE: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-08-31 Thread Keith Willis
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lindsay Haisley Sent: Tuesday, August 31, 2004 2:09 PM To: Courier Users Subject: Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again Thus spake Ben Kennedy on Tue, Aug 31, 2004 at 02:55:45PM CDT On 31 8 2004 at 1:21 pm -0400, Lindsay Haisley wrote

[courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-08-31 Thread Sam Varshavchik
Lindsay Haisley writes: Thus spake Sam Varshavchik on Mon, Aug 30, 2004 at 06:58:29PM CDT Lindsay Haisley writes: 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

Re: [courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-08-31 Thread Lindsay Haisley
Thus spake Sam Varshavchik on Tue, Aug 31, 2004 at 05:37:33PM CDT Lindsay Haisley writes: Thus spake Sam Varshavchik on Mon, Aug 30, 2004 at 06:58:29PM CDT Lindsay Haisley writes: I have MYSQL_SELECT_CLAUSE working nicely with a non-standard query on courier-0.38.2 and authmysql. I'm

[courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-08-30 Thread Sam Varshavchik
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

[courier-users] Re: MYSQL_SELECT_CLAUSE ?

2002-06-05 Thread Sam Varshavchik
Bac0n writes: MYSQL_SELECT_CLAUSE SELECT mail_addr, \ cryptpw,\ uid,\ gid,\ clearpw,\

[courier-users] Re: MYSQL_SELECT_CLAUSE SELECT ?

2002-06-05 Thread Sam Varshavchik
Bac0n writes: what order should i use ? readme say: username, cryptpw, uid, gid, clearpw, home, maildir, quota, fullname Look at the actual example in authmysqlrc. clearpw must follow crypt, then uid, gid, and the rest. -- Sam