Re: Hibernating: Major impact on authentication!

Kenneth Marshall wrote:
> Mr. Franco,
>
> I have not looked at the DB connection code, but is there a connection
> timer on the DB connection. That is, does the connection get dropped

No

> If the latter, the problem could be that the long running connections
> are not allowing the indexes and table spaces to be maintained properly.
> This could cause bloat and performance problems over time. After a

At least on Postgres, this is NOT correct.

Open *transactions* block such activity. However the base rlm_sql
doesn't use transactions because they're un-needed, and the
rlm_sql_ippool module executes very short running transactions indeed.

I believe the OP is running Postgres, but if anyone finds themselves
running a database where maintaining long-running connections blocks
maintenance jobs, I would recommend the un-install it immediately.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html