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 <andres.gomez.ruiz at gmail.com>
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