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 <mdunkin@innflux.com> 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