Question about SQL logs in fr3

Andrés Gómez andres.gomez.ruiz at gmail.com
Wed Jan 2 22:20:13 CET 2019


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.*


More information about the Freeradius-Users mailing list