Hi Use sub CLONE to create for each thread separate SQL connection. for more information see rlm_perl on wiki.freeradius.org
On Tuesday 08 August 2006 19:34, Matt Dunkin wrote: > I tried opening a mysql connection outside the functions in my perl > script then using that handle through out the perl script. I am getting > the following error... > > Error: rlm_perl: perl_embed:: module = > /usr/local/etc/raddb/modules/billing.pl , func = accounting exit status= > DBD::mysql::db prepare failed: handle 2 is owned by thread 9b19fc8 not > current thread 9cfdac8 (handles can't be shared between threads and your > driver may need a CLONE method added) at > /usr/local/etc/raddb/modules/billing.pl line 214. > > Alan DeKok wrote: > >Matt Dunkin <[EMAIL PROTECTED]> wrote: > >>After some recent changes to my rlm_perl perl script I am getting the > >>following messages all the time... > >> > >>Tue Aug 8 08:08:50 2006 : Error: WARNING: Unresponsive child (id > >>2966633392) for request 28 > > > > Something's blocking the thread. > > > >>Each function in the perl script opens a mysql connection then closes it > >>before finishing the function. Could this be the problem? Should I > >>create an initial connection and use it throughout the script? > > > > Yes. That would probably help a lot. > > > > The "unresponsive child" message comes out after about 20 seconds of > >problems, which is a pretty serious problem. > > > > Alan DeKok. > >-- > > http://deployingradius.com - The web site of the book > > http://deployingradius.com/blog/ - The blog > >- > >List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html -- Best Regards, Boian Jordanov SNE Orbitel - Next Generation Telecom tel. +359 2 4004 723 tel. +359 2 4004 002 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
