Hi Arran, Hi Arron, I think that I have understood. But why do I get the message that he needed more spares? And why does he say that as 0 of 2 are used, which makes so much sense. My server is still in the test and I have connected only one client. regardes Andre ns/hans] (from client andre port 0) Wed Jul 15 14:42:57 2015 : Auth: (4) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [hans/hans] (from client andre port 0) Wed Jul 15 14:42:59 2015 : Info: rlm_sql (sql): Closing connection (0), from 1 unused connections Wed Jul 15 14:42:59 2015 : Auth: (5) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [hans/hans] (from client andre port 0) Wed Jul 15 14:43:24 2015 : Auth: (6) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [hans/hans] (from client andre port 0) Wed Jul 15 14:43:30 2015 : Info: rlm_sql (sql): Closing connection (3): Hit idle_timeout, was idle for 62 seconds Wed Jul 15 14:43:30 2015 : Warning: rlm_sql (sql): You probably need to lower "min" Wed Jul 15 14:43:30 2015 : Info: rlm_sql (sql): Closing connection (2): Hit idle_timeout, was idle for 62 seconds Wed Jul 15 14:43:30 2015 : Info: rlm_sql (sql): Closing connection (1): Hit idle_timeout, was idle for 62 seconds Wed Jul 15 14:43:30 2015 : Auth: (7) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [sb3959/andre24] (from client andre port 0) Wed Jul 15 14:43:59 2015 : Info: rlm_sql (sql): 0 of 1 connections in use. Need more spares Wed Jul 15 14:43:59 2015 : Info: rlm_sql (sql): Opening additional connection (5) Wed Jul 15 14:43:59 2015 : Auth: (8) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [sb3959/andre24] (from client andre port 0) Wed Jul 15 14:44:19 2015 : Info: rlm_sql (sql): 0 of 2 connections in use. Need more spares Wed Jul 15 14:44:19 2015 : Info: rlm_sql (sql): Opening additional connection (6) Wed Jul 15 14:44:19 2015 : Auth: (9) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [sb3959/andre24] (from client andre port 0) Wed Jul 15 14:44:21 2015 : Info: rlm_sql (sql): 0 of 3 connections in use. Need more spares Wed Jul 15 14:44:21 2015 : Info: rlm_sql (sql): Opening additional connection (7) Wed Jul 15 14:44:21 2015 : Auth: (10) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [sb3959/andre24] (from client andre port 0) Wed Jul 15 14:44:23 2015 : Auth: (11) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [sb3959/andre24] (from client andre port 0) Wed Jul 15 14:44:24 2015 : Auth: (12) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [sb3959/andre24] (from client andre port 0) Wed Jul 15 14:44:25 2015 : Auth: (13) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [sb3959/andre24] (from client andre port 0) 2015-07-15 14:41 GMT+02:00 Arran Cudbard-Bell <a.cudbardb@freeradius.org>:
On 15 Jul 2015, at 08:15, Andre Schwarzer <andreschwarzer@gmail.com> wrote:
Hello,
have installed a new freeradius 3.0, bevor i worked with the Version 1.
I see in my Test´s, in the radius.log the Messages below. I don´t know what are spare Connections, what they do and for what the radius use this. Additional i don´t know why i get this messeges with the Default Settings.
Can some one explain me the usage of the spare Connections, best by an example.
Wed Jul 15 13:34:25 2015 : Info: rlm_sql (sql): 0 of 5 connections in use. Need more spares Wed Jul 15 13:34:25 2015 : Info: rlm_sql (sql): Opening additional connection (12)
The connection pool will attempt to find the minimum number of connections required to service the current load.
It will also open a number of spare connections to absorb any sudden increases in that load.
Without spare connections the server would have to open new connections when dealing with the load spike. This could potentially cause a number of worker threads to block, and would affect the servers ability to 'ramp up' to deal with the new load level.
-Arran
Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team
FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html