Question about SQL logs in fr3

classic Classic list List threaded Threaded
2 messages Options
| Threaded
Open this post in threaded view
|

Question about SQL logs in fr3

Andrés Gómez
Hi dear list.

I have been using freeradius 2.x from many years ago, buy now I am testing
v 3.0.16. Everything works great, buy I have some Logs That I didn't have
in v2.x, about MySQL:


Wed Jan  2 21:04:57 2019 : Info: rlm_sql (sql): Opening additional
connection (115), 1 of 32 pending slots used
Wed Jan  2 21:04:57 2019 : Info: rlm_sql (sql): Opening additional
connection (116), 1 of 31 pending slots used
Wed Jan  2 21:05:05 2019 : Info: rlm_sql (sql): Opening additional
connection (117), 1 of 30 pending slots used
Wed Jan  2 21:05:10 2019 : Info: rlm_sql (sql): Opening additional
connection (118), 1 of 29 pending slots used
Wed Jan  2 21:05:17 2019 : Info: rlm_sql (sql): Opening additional
connection (119), 1 of 28 pending slots used
Wed Jan  2 21:05:20 2019 : Info: rlm_sql (sql): Opening additional
connection (120), 1 of 27 pending slots used
Wed Jan  2 21:05:21 2019 : Info: rlm_sql (sql): Opening additional
connection (121), 1 of 26 pending slots used
Wed Jan  2 21:06:00 2019 : Info: rlm_sql (sql): Opening additional
connection (122), 1 of 25 pending slots used
Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (119):
Hit idle_timeout, was idle for 113 seconds
Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (115):
Hit idle_timeout, was idle for 113 seconds
Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (116):
Hit idle_timeout, was idle for 110 seconds
Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (120):
Hit idle_timeout, was idle for 109 seconds
Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (118):
Hit idle_timeout, was idle for 109 seconds
Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (121):
Hit idle_timeout, was idle for 109 seconds
Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (117):
Hit idle_timeout, was idle for 70 seconds
Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (122):
Hit idle_timeout, was idle for 70 seconds

It is the nomal behavior?

I want to migrate a fr v2.x with a lot o Autentication and Accounting
queries (arount 600 Auth queries per minute, and much more accounting
queries per minute),  What would be the  best coniguration of connections
in sql module and sites-enabled/default file?  I only use web
authenticvation (PAP), I dont use EAP, MSCHAP, DIGEST, etc

Best Regards

--
*C. Andrés Gómez R.*
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
| Threaded
Open this post in threaded view
|

Re: Question about SQL logs in fr3

Alan Buxey
hi,

this is the server opening up extra connections as per the pool config of
the sql module...and then closing them down after idle period has been
exceeded
as per the config.  if you dont want such activity then adjust the
max/min/spare settings for the extra connections and, if you dont want idle
connections
to be closed down (ie so that they are ready to use and you know no network
device in between is going to slam those connections down after a period of
time
(eg a firewall or remote SQL config) then set idle_timeout = 0



On Wed, 2 Jan 2019 at 21:21, Andrés Gómez <[hidden email]>
wrote:

> Hi dear list.
>
> I have been using freeradius 2.x from many years ago, buy now I am testing
> v 3.0.16. Everything works great, buy I have some Logs That I didn't have
> in v2.x, about MySQL:
>
>
> Wed Jan  2 21:04:57 2019 : Info: rlm_sql (sql): Opening additional
> connection (115), 1 of 32 pending slots used
> Wed Jan  2 21:04:57 2019 : Info: rlm_sql (sql): Opening additional
> connection (116), 1 of 31 pending slots used
> Wed Jan  2 21:05:05 2019 : Info: rlm_sql (sql): Opening additional
> connection (117), 1 of 30 pending slots used
> Wed Jan  2 21:05:10 2019 : Info: rlm_sql (sql): Opening additional
> connection (118), 1 of 29 pending slots used
> Wed Jan  2 21:05:17 2019 : Info: rlm_sql (sql): Opening additional
> connection (119), 1 of 28 pending slots used
> Wed Jan  2 21:05:20 2019 : Info: rlm_sql (sql): Opening additional
> connection (120), 1 of 27 pending slots used
> Wed Jan  2 21:05:21 2019 : Info: rlm_sql (sql): Opening additional
> connection (121), 1 of 26 pending slots used
> Wed Jan  2 21:06:00 2019 : Info: rlm_sql (sql): Opening additional
> connection (122), 1 of 25 pending slots used
> Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (119):
> Hit idle_timeout, was idle for 113 seconds
> Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (115):
> Hit idle_timeout, was idle for 113 seconds
> Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (116):
> Hit idle_timeout, was idle for 110 seconds
> Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (120):
> Hit idle_timeout, was idle for 109 seconds
> Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (118):
> Hit idle_timeout, was idle for 109 seconds
> Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (121):
> Hit idle_timeout, was idle for 109 seconds
> Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (117):
> Hit idle_timeout, was idle for 70 seconds
> Wed Jan  2 21:07:10 2019 : Info: rlm_sql (sql): Closing connection (122):
> Hit idle_timeout, was idle for 70 seconds
>
> It is the nomal behavior?
>
> I want to migrate a fr v2.x with a lot o Autentication and Accounting
> queries (arount 600 Auth queries per minute, and much more accounting
> queries per minute),  What would be the  best coniguration of connections
> in sql module and sites-enabled/default file?  I only use web
> authenticvation (PAP), I dont use EAP, MSCHAP, DIGEST, etc
>
> Best Regards
>
> --
> *C. Andrés Gómez R.*
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html