Make sure there are no spaces trailing any of the field names. I have had extra spaces trip up my courier install many times.....use vi and go to the end of the line and get rid of all extras with 'x'.
Simple, but even after a dozen installs, I still forget this one from time to time :-) ----------------------------- Keith Willis, President Talon Computer Consulting, Inc. http://www.taloncc.com *Developers of phpCourier: http://phpcourier.sourceforge.net Open-Source (free) Fully functional account administration system for courier-MTA -----Original Message----- From: [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 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 far as I can tell, though I'm > not sure what it is. Q.v. my postings of about a month ago, relating to > similar problems, on which I never received feedback: My problem is similar, but authmysql fails even when the user is an existing user, and I get the "Service Temporarily Unavailable" response. Watching the mysql logs indicates than no query is made. This is not so much a problem with my customer's new courier installation, since the authentication there is fairly simple and probably for only one domain name, but this problem effectively prevents me from upgrading courier on my on server since I use a fairly complex MYSQL_SELECT_CLAUSE for authentication and I'd have several dozen people coming after me with ropes if I broke their company email feeds! -- Lindsay Haisley | "Everything works | PGP public key FMP Computer Services | if you let it" | available at 512-259-1190 | (Travis W. Redfish) | <http://www.fmp.com/pubkeys> http://www.fmp.com | ("The Roadie") | ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_idP47&alloc_id808&op=click _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users