I've got installed freeradius 3.0.3 connected to a firebird database. It is working fine for about a week, but I'm getting my logs filled with following entries: Mon May 12 10:05:38 2014 : Info: rlm_sql (sql): Opening additional connection (1116) Mon May 12 10:05:38 2014 : Info: rlm_sql (sql): Closing connection (1114): Hit idle_timeout, was idle for 577 seconds Mon May 12 10:05:38 2014 : rlm_sql (sql): You probably need to lower "min" Mon May 12 10:05:51 2014 : Info: rlm_sql (sql): Opening additional connection (1117) Mon May 12 10:07:40 2014 : Info: rlm_sql (sql): Closing connection (1116): Hit idle_timeout, was idle for 109 seconds Mon May 12 10:07:40 2014 : rlm_sql (sql): You probably need to lower "min" Mon May 12 10:07:40 2014 : Info: rlm_sql (sql): Closing connection (1115): Hit idle_timeout, was idle for 123 seconds Mon May 12 10:08:12 2014 : Info: rlm_sql (sql): Opening additional connection (1118) Mon May 12 10:08:53 2014 : Info: rlm_sql (sql): Opening additional connection (1119) Mon May 12 10:12:16 2014 : Info: rlm_sql (sql): Closing connection (1118): Hit idle_timeout, was idle for 203 seconds Mon May 12 10:12:16 2014 : rlm_sql (sql): You probably need to lower "min" Mon May 12 10:12:16 2014 : Info: rlm_sql (sql): Closing connection (1117): Hit idle_timeout, was idle for 244 seconds I'd like to know what means " You probably need to lower "min" " Thank you. -- *LUCAS DIAZ | DPTO. REDES* _______________________________________________________ Istilart 255 | Tel.: 02983 513040 C.P. B7500EGE | Tres Arroyos | Bs As | Argentina * *www.eternet.cc <http://www.eternet.cc/> | *ETERNET SISTEMAS *
Hi,
I'd like to know what means " You probably need to lower "min" "
exactly what it says... you have a minimum number of connections defined...and a maximum and a starting number.... a lot of your connections are idle and doing nothing...thus are being closed down..the server is recommending that you dont start as many connections to your DB. alan
Thank you. *LUCAS DIAZ | DPTO. REDES* _______________________________________________________ Istilart 255 | Tel.: 02983 513040 C.P. B7500EGE | Tres Arroyos | Bs As | Argentina * *www.eternet.cc <http://www.eternet.cc/> | *ETERNET SISTEMAS * On 05/12/2014 11:23 AM, A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
I'd like to know what means " You probably need to lower "min" " exactly what it says... you have a minimum number of connections defined...and a maximum and a starting number.... a lot of your connections are idle and doing nothing...thus are being closed down..the server is recommending that you dont start as many connections to your DB.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Lucas Diaz wrote:
I've got installed freeradius 3.0.3 connected to a firebird database. It is working fine for about a week, but I'm getting my logs filled with following entries:
Mon May 12 10:05:38 2014 : Info: rlm_sql (sql): Opening additional connection (1116) Mon May 12 10:05:38 2014 : Info: rlm_sql (sql): Closing connection (1114): Hit idle_timeout, was idle for 577 seconds ... I'd like to know what means " You probably need to lower "min" "
See the "pool" sub-section of the "sql" module. It has a "min" configuration setting. Alan DeKok.
participants (3)
-
A.L.M.Buxey@lboro.ac.uk -
Alan DeKok -
Lucas Diaz