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. So this looks like to me that apr_dbd_pvselect() is trying > to re-use a connection that is closed by the mysql server side whose > wait-timeout is set to 1200 seconds. my mod_dbd setting is this > DBDMin 1 > DBDKeep 2 > DBDMax 50 > DBDExptime 60 > 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? > >
I've haven't used mod_authn_dbd yet but this sounds similar to issues I was having http://issues.apache.org/bugzilla/show_bug.cgi?id=39329 patch hasn't made its way into apr_dbd_mysql.c yet. Please add a note if the it fixes your issue. > Thanks, > Daniel > -- Matthew Kent \ SA \ bravenet.com
