Freeradius 3.0 - SQL - spare connections?

[Andre Schwarzer]

 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 at freeradius.org>:
>
>> On 15 Jul 2015, at 08:15, Andre Schwarzer <andreschwarzer at 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 at 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