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 MYSQL_SELECT_CLAUSE ?? Organization: FMP Computer Services It was my error. The box I'm working on doesn't have a domain name yet (I'm after the owners to give it one!) and I didn't have DEFAULT_DOMAIN set in authmysqlrc. This was causing MYSQL_SELECT_CLAUSE to fail because defdomain wasn't defined in parse_select_clause(). If I didn't use MYSQL_SELECT_CLAUSE I could successfully run courier with authmysql using the IP address for the box. Sorry for the fire drill!! Thus spake Sam Varshavchik on Wed, Sep 15, 2004 at 05:33:40PM CDT > Lindsay Haisley writes: > > >I'm back to working on the customer system I mentioned previously using > >courier 0.46. Has any progress been made in the development version on > >the MYSQL_SELECT_CLAUSE problem I inquired about a couple of weeks ago? > > > >I'm going to work on debugging it, but don't want to reinvent the wheel > >if it's already been solved. > > Sorry, haven't get around to it just yet. I'll let you know as soon as I > have something. Although, someone on the mailing list did confirm that > MYSQL_SELECT_CLAUSE works for them, so??? Thus spake p dont think on Fri, Dec 17, 2004 at 03:31:59PM CST > 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 the right place in the code maybe I'll make the time... > > Thanks, > > Paul > > Original Message: > ========================= > > From: Sam Varshavchik <mrsam <at> courier-mta.com> > Subject: Re: MYSQL_SELECT_CLAUSE again > Newsgroups: gmane.mail.imap.courier.general > Date: Wed, 01 Sep 2004 18:48:04 -0400 > > 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=::ffff:127.0.0.1,ident=root,from=<fmouse <at> > > bbadmin.com>,to=<foo <at> bbadmin.com>: > > 450 Service temporarily unavailable. > > > > I suppose I'm going to have to hack some debugging code into > > authmysqllib.c in and around parse_select_clause() and calls to > > it. I don't really have time to mess with it right now, but > > maybe next week.... > > Presuming that the environment variable is properly set, the lack of any > debugging output does narrow the culprit somewhat. > > My time is also a bit tight, but I also intend to investigate it. Let's > see who finds this bug first. > > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://productguide.itmanagersjournal.com/ > _______________________________________________ > courier-users mailing list > [EMAIL PROTECTED] > Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users -- Lindsay Haisley | "Fighting against human | PGP public key FMP Computer Services | creativity is like | available at 512-259-1190 | trying to eradicate | <http://pubkeys.fmp.com> http://www.fmp.com | dandelions" | | (Pamela Jones) | ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
