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 pr

[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 sa

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 simil

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 is

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 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 fmp.com Wed Se

[courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-21 Thread p dont think
Lindsay Haisley 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 fmp.com Wed Sep 15 18:03:04 2004 > Date: Wed, 15 Sep 2004 18:03:04 -0500 > From: Lindsay Ha

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 MYSQ

[courier-users] Re: MYSQL_SELECT_CLAUSE again

2004-12-17 Thread p dont think
All, Wondering if this has been looked at lately. I get slightly different side effects, wherein the select clause seems to simply be ignored, but nevertheless, it might be the same problem. I suppose I can take a look at the code, not that I have the time, but if someone wants to point me to

[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: error,relay=:::127.0.0.1,id

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: 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-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 authmys

[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 Keith Willis
om: [EMAIL 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

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,

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 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

[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 variou