interesting problem with SQL backend

2005-03-24 Thread alan premselaar
Today I had an interesting situation. This is more of an FYI in case anyone else has run into similar problems. (cross-posted to MIMEDefang list as well) I use SpamAssassin with MIMEDefang. I got notified by one of my users that they were unable to send mail suddenly. after checking the logs I

Re: interesting problem with SQL backend

2005-03-24 Thread Michael Parker
On Fri, Mar 25, 2005 at 01:43:49AM +0900, alan premselaar wrote: I understand that the SQL code for SA is still 'experimental'. is there any way currently to set a forced timeout to connect to the SQL server? I would certainly call it less experimental these days, as it's turned out to

Re: interesting problem with SQL backend

2005-03-24 Thread JamesDR
Check to make sure you have PTR records in your dns for the SA computer. If not, mysql has to fall down the name res. chain to get the name of the computer that's connecting. I've seen delays from 20secs to a minute while mysql tries to determine the host name during the auth stage of

Re: interesting problem with SQL backend

2005-03-24 Thread Kevin Sullivan
--On 03/25/05 01:43:49 +0900 alan premselaar wrote: I got notified by one of my users that they were unable to send mail suddenly. after checking the logs I determined that MIMEDefang was timing out and returning errors. the cause for this was very unclear (which is why i'm sharing my findings