Yes,
remeber to include the initiation of the handler outside the function
(global for the script). i.e. :
...
my $dbh;
sub CLONE(){
$dbh = DBI->connect...
}
...
(the rest of your functions which use the $dbh handler)
--
-------------------------------------------
Apostolos Pantsiopoulos
Kinetix Tele.com R & D
email: r...@kinetix.gr
-------------------------------------------
On 7/4/2010 12:27 μμ, Nasser Heidari wrote:
-----Original Message-----
From: freeradius-users-bounces+nasser=rasana....@lists.freeradius.org
[mailto:freeradius-users-bounces+nasser=rasana....@lists.freeradius.org]
On Behalf Of Apostolos Pantsiopoulos
Sent: Wednesday, April 07, 2010 13:37
To: freeradius-users@lists.freeradius.org
Subject: Re: Permanent mysql connection in mod_perl
Have a look at the CLONE special function in rlm_perl documentation.
Initiate your db connections in that function.
Unfortunately I'm not familiar with this function, as I have searched , I think
that only change that I need is to enclose my db connection part in Perl script
into sub CLONE {} .
Is that correct?
--
-------------------------------------------
Apostolos Pantsiopoulos
Kinetix Tele.com R& D
email: r...@kinetix.gr
-------------------------------------------
On 7/4/2010 12:01 μμ, Nasser Heidari wrote:
Hi,
I'm using mod_perl in my radius configuration and using it I write some
logs to database.
Today I noticed that, there are lots of mysql connections in TIME_WAIT
state.
# netstat -epn --tcp | grep TIME_WAIT | wc -l
15015
netstat -epn --tcp | grep TIME_WAIT | tail -1
tcp 0 0 192.168.1.4:49060 192.168.1.6:3306 TIME_WAIT
I'm sure it is because of mod_perl, and I'm looking forward to force
radius to use permanent mysql connections.
Has anyone any idea?
Thanks in advance
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html