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@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