mod_authn_dbd - internal server error after certain idle time

2007-10-08 Thread Don Harden
Hello, Just a short note concerning mod_dbd and mod_authn_dbd in Apache 2.2.6 and authentication against MySQL (5.0.45-0). A fresh compile of Apache 2.2.6 resulted in the Internal Errors as described in thread 940 in July 2007 with Apache 2.2.4. Recompiling 2.2.6 with the following updat

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-09 Thread Tom Donovan
Danie Qian wrote: Thank you for the kind words. I am a little overwhelmed by the complexity of mod_dbd.c, especially its use of dbd_group_t. I couldnt find any notes for it so I wish someone here could shed some light on it for me and anyone interested. There do not seem to any group-related

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-09 Thread Danie Qian
- Original Message - From: "Tom Donovan" <[EMAIL PROTECTED]> To: Sent: Monday, July 09, 2007 11:29 AM Subject: Re: mod_authn_dbd - internal server error after certain idle time Danie Qian wrote: With this patch, setting DBDTimout lower than the MySQL

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-09 Thread Tom Donovan
Danie Qian wrote: > > > It is working a little better now after I set both DBDKeep and DBDMin to > zero. But I am still getting the internal server error from time to > time. Users usually can get pass the error by reloading the same page. > Here is the error messages in the log: > > [Sat Jul

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-07 Thread Danie Qian
- Original Message - From: "Nick Kew" <[EMAIL PROTECTED]> To: Sent: Saturday, July 07, 2007 4:38 AM Subject: Re: mod_authn_dbd - internal server error after certain idle time On Fri, 06 Jul 2007 18:37:07 -0700 Matthew Kent <[EMAIL PROTECTED]> wrote: After

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-07 Thread Nick Kew
On Sat, 7 Jul 2007 12:50:05 +0200 "Ben Noordhuis" <[EMAIL PROTECTED]> wrote: > On 7/7/07, Ben Noordhuis <[EMAIL PROTECTED]> wrote: > > I'm not aware of a reliable workaround for earlier versions of > > MySQL, unfortunately. > > Allow me to reply to myself. If you can live with a slight performanc

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-07 Thread Ben Noordhuis
On 7/7/07, Ben Noordhuis <[EMAIL PROTECTED]> wrote: I'm not aware of a reliable workaround for earlier versions of MySQL, unfortunately. Allow me to reply to myself. If you can live with a slight performance impact, the code snippet below should help you to reconnect in a controlled fashion. Ho

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-07 Thread Ben Noordhuis
On 7/7/07, Nick Kew <[EMAIL PROTECTED]> wrote: Any other suggestions for a workaround to check the connection now? With MySQL 5.0.3 and later, mysql_ping() doesn't automatically reconnect but returns CR_SERVER_GONE_ERROR instead, so you'll want to reinitialize the prepared statements when that

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-07 Thread Nick Kew
On Sat, 07 Jul 2007 05:44:27 -0400 Tom Donovan <[EMAIL PROTECTED]> wrote: > Nick Kew wrote: > > On Fri, 06 Jul 2007 18:37:07 -0700 > > Matthew Kent <[EMAIL PROTECTED]> wrote: > > > >> think its the mysql_ping reconnection clobbering the prepared > >> statement > >> used in mod_authn_dbd. > > >

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-07 Thread Tom Donovan
Nick Kew wrote: On Fri, 06 Jul 2007 18:37:07 -0700 Matthew Kent <[EMAIL PROTECTED]> wrote: >> think its the mysql_ping reconnection clobbering the prepared statement used in mod_authn_dbd. Buggrit. I can't see a satisfactory workaround for that. I guess the kludge suggested by Tom Donovan

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-07 Thread Nick Kew
On Fri, 06 Jul 2007 18:37:07 -0700 Matthew Kent <[EMAIL PROTECTED]> wrote: > After some testing I think I better understand the issue, updated it > here > > http://issues.apache.org/bugzilla/show_bug.cgi?id=39329#c11 Thanks. I saw that already (notification email reached me ahead of this one).

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Danie Qian
- Original Message - From: "Matthew Kent" <[EMAIL PROTECTED]> To: Sent: Friday, July 06, 2007 9:37 PM Subject: Re: mod_authn_dbd - internal server error after certain idle time On Fri, 2007-06-07 at 23:04 +0100, Nick Kew wrote: On Fri, 06 Jul 2007 13:13:03 -0

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Danie Qian
- Original Message - From: "Matthew Kent" <[EMAIL PROTECTED]> To: Sent: Friday, July 06, 2007 9:37 PM Subject: Re: mod_authn_dbd - internal server error after certain idle time On Fri, 2007-06-07 at 23:04 +0100, Nick Kew wrote: On Fri, 06 Jul 2007 13:13:03 -0

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Matthew Kent
On Fri, 2007-06-07 at 23:04 +0100, Nick Kew wrote: > On Fri, 06 Jul 2007 13:13:03 -0700 > Matthew Kent <[EMAIL PROTECTED]> wrote: > > > > > >> My question is why the keepalive setting for 60sec doesnt work > > > >> for me? How > > > >> do I fix this without changing the timeout setting on the mys

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Mark Constable
On Saturday 07 July 2007 07:49:13 Danie Qian wrote: > Apparently it hasnt been fixed as I AM using the mod_dbd.c file from trunk > and still having this problem. but it did fix some problems in dbd_acquire() > I had before I replaced the mod_dbd.c that comes with apache-2.2.4. I am > surprised t

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Danie Qian
- Original Message - From: "Nick Kew" <[EMAIL PROTECTED]> To: Sent: Friday, July 06, 2007 6:04 PM Subject: Re: mod_authn_dbd - internal server error after certain idle time On Fri, 06 Jul 2007 13:13:03 -0700 Matthew Kent <[EMAIL PROTECTED]> wrote: >

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Nick Kew
On Fri, 06 Jul 2007 13:13:03 -0700 Matthew Kent <[EMAIL PROTECTED]> wrote: > > >> My question is why the keepalive setting for 60sec doesnt work > > >> for me? How > > >> do I fix this without changing the timeout setting on the mysql > > >> server? For future reference, this should really have

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Danie Qian
- Original Message - From: "Matthew Kent" <[EMAIL PROTECTED]> To: Sent: Friday, July 06, 2007 5:21 PM Subject: Re: mod_authn_dbd - internal server error after certain idle time On Fri, 2007-06-07 at 16:52 -0400, Danie Qian wrote: - Original Message - Fro

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Matthew Kent
On Fri, 2007-06-07 at 16:52 -0400, Danie Qian wrote: > - Original Message - > From: "Matthew Kent" <[EMAIL PROTECTED]> > To: > Sent: Friday, July 06, 2007 4:13 PM > Subject: Re: mod_authn_dbd - internal server error after certain idle time > >

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Danie Qian
- Original Message - From: "Matthew Kent" <[EMAIL PROTECTED]> To: Sent: Friday, July 06, 2007 4:13 PM Subject: Re: mod_authn_dbd - internal server error after certain idle time On Fri, 2007-06-07 at 15:54 -0400, Danie Qian wrote: - Original Message - Fro

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Matthew Kent
On Fri, 2007-06-07 at 15:54 -0400, Danie Qian wrote: > - Original Message - > From: "Matthew Kent" <[EMAIL PROTECTED]> > To: > Sent: Friday, July 06, 2007 3:18 PM > Subject: Re: mod_authn_dbd - internal server error after certain idle time > >

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Tom Donovan
Danie Qian wrote: I am using mod_authn_dbd and mod_dbd to do authentication again a mysql database. Basically it works but after sometime I will get a internal server error. I checked the log this happens at apr_dbd_pvselect() line in mod_authn_dbd.c. So this looks like to me that apr_dbd_pvsel

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Danie Qian
- Original Message - From: "Matthew Kent" <[EMAIL PROTECTED]> To: Sent: Friday, July 06, 2007 3:18 PM Subject: Re: mod_authn_dbd - internal server error after certain idle time On Fri, 2007-06-07 at 15:07 -0400, Danie Qian wrote: I am using mod_authn_dbd a

Re: mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Matthew Kent
On Fri, 2007-06-07 at 15:07 -0400, Danie Qian wrote: > I am using mod_authn_dbd and mod_dbd to do authentication again a mysql > database. Basically it works but after sometime I will get a internal server > error. I checked the log this happens at apr_dbd_pvselect() line in > mod_authn_dbd.c. S

mod_authn_dbd - internal server error after certain idle time

2007-07-06 Thread Danie Qian
I am using mod_authn_dbd and mod_dbd to do authentication again a mysql database. Basically it works but after sometime I will get a internal server error. I checked the log this happens at apr_dbd_pvselect() line in mod_authn_dbd.c. So this looks like to me that apr_dbd_pvselect() is trying to