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 > From: Lindsay Haisley <fmouse <at> fmp.com> > To: Sam Varshavchik <mrsam <at> courier-mta.com> > 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 Hrm. I don't have that defined, either, but never have, and never have had any problem as such. But for fun, I defined it and restarted the auth daemon. Watchin the SQL logs, this doesn't seem to change anything: I see zero errors, but the query being fed to MySQL is the one built out of the other fields in authmysqlrc. The comments suggest that as long as you define MYSQL_SELECT_CLAUSE that the other query-related fields will be ignored. Is this inaccurate? Do I need to comment or otherwise remove any of them? If so, which ones? Just to make sure I'm not going insane, I changed the value of some of those other fields just to make sure I'm using the right config file, and the change was immediately reflected in my MySQL logs. So there is something that is not allowing the use of MYSQL_SELECT_CLAUSE, but I don't see what it would be. Can anyone shed some light? If I have to poke in the code, I will (rather not...) -- can someone point me to the right place (files/fxns)? Thanks, Paul > 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 courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
