Freeradius 3.0 - SQL - spare connections?
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) Regardes
I'm also getting these. On Wed, Jul 15, 2015 at 5:45 PM, 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)
Regardes
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Randeep Mob: +919447831699[kerala] Mob: +919880050349[B'lore] http://twitter.com/Randeeppr http://in.linkedin.com/in/randeeppr [image: --] Randeep Raman [image: http://]about.me/Randeeppr <http://about.me/Randeeppr>
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
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
I think that I have understood. But why do I get the message that he needed more spares?
Re-read my answer
And why does he say that as 0 of 2 are used, which makes so much sense.
Zero out of the Two available connections are in use. You probably have spares set to 5. (2 - 0) < 5. It'll likely try and open another three connections to bring spare connections to the right level (5). -Arran
Hello There, as is the flow then exactly. a) When you start the server it will automatically open the "Start" respectively "min" connections. If the min connections to a particular set of% are full, he opens the spare connections for the next requests. Correctly or when he opens his spare connections? b) Can run multiple requests over a Connection? or c) Or he takes per client request a Connection, block the connections and when the request is complete, the next client can use the Connection? d) The spare connections have a higher idle timer? I have set for idle 60 seconds in config but see the log in part Close Connection after respectively 230 seconds? Regardes Andre 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
On Jul 16, 2015, at 2:26 AM, Andre Schwarzer <andreschwarzer@gmail.com> wrote:
a) When you start the server it will automatically open the "Start" respectively "min" connections. If the min connections to a particular set of% are full, he opens the spare connections for the next requests.
That's what the documentation says. And I have to ask, why do you care about the details of the connection pool? It's behaviour is documented. It works. Just configure it, and use it. You will not configure it any differently if you get answers to all of your questions. So, unless you're writing C modules which use the connection pool, the questions are irrelevant. Alan DeKok.
participants (4)
-
Alan DeKok -
Andre Schwarzer -
Arran Cudbard-Bell -
Randeep