11 messages in net.sourceforge.lists.courier-usersRE: [courier-users] Re: MYSQL_SELECT_...| From | Sent On | Attachments |
|---|---|---|
| Lindsay Haisley | Aug 30, 2004 9:14 am | |
| Sam Varshavchik | Aug 30, 2004 4:58 pm | |
| Lindsay Haisley | Aug 31, 2004 12:40 pm | |
| Ben Kennedy | Aug 31, 2004 1:06 pm | |
| Lindsay Haisley | Aug 31, 2004 1:15 pm | |
| Keith Willis | Aug 31, 2004 2:06 pm | |
| Sam Varshavchik | Aug 31, 2004 3:37 pm | |
| Lindsay Haisley | Aug 31, 2004 6:26 pm | |
| Sam Varshavchik | Sep 1, 2004 4:09 am | |
| Lindsay Haisley | Sep 1, 2004 9:24 am | |
| Sam Varshavchik | Sep 1, 2004 3:48 pm |
| Subject: | RE: [courier-users] Re: MYSQL_SELECT_CLAUSE again | |
|---|---|---|
| From: | Keith Willis (talo...@yahoo.com) | |
| Date: | Aug 31, 2004 2:06:54 pm | |
| List: | net.sourceforge.lists.courier-users | |
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: cour...@lists.sourceforge.net [mailto:cour...@lists.sourceforge.net] 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
cour...@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users