I see now, it does not re-use any existing connections, each new user creates new spare, even if they are the only one authing, this keeps happening until max spares is reached, then it seems to re-use the connections, very strange indeed, since you recommend to silence previous "errors" we use no idle timeout which I presume would fix the new spares problem, and seems disconnecting again adds new spares, I suppose thats for accounting though. On Sat, Apr 16, 2016 at 11:00 AM, Laura Steynes <laura.steynes72@gmail.com> wrote:
On Fri, Apr 15, 2016 at 10:01 PM, Alan DeKok <aland@deployingradius.com> wrote:
On Apr 14, 2016, at 10:41 PM, Laura Steynes <laura.steynes72@gmail.com> wrote:
Mon Apr 11 02:41:33 2016 : Info: rlm_sql (sql): Closing connection
(131):
Hit idle_timeout, was idle for 3600 seconds
The rest of those messages are all a result of the bad setting for idle_timeout.
Why not change idle_timeout?
Are my radiusd,c.onf settings overkill and this is why the logs fill up with these errors?
Because you set idle_timeout incorrectly. Juts set it to zero.
OK, I have changed it to zero, however, since the default is set to 60, where as I used 90, does that not make teh default configuration " incorrect" as you put it?
Thats solved that error thanks!, now i see -
Sat Apr 16 10:59:00 2016 : Info: rlm_sql (sql): 0 of 5 connections in use. Need more spares Sat Apr 16 10:59:00 2016 : Info: rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots used
is this normal, or based on my earlier post with settings something there need changing too?
Thanks for your help!