Re: new connection problem

Alan DeKok via Freeradius-Users <[email protected]> Thu, 15 Jan 2026 07:53:59 -0500

Newsgroups	gmane.comp.freeradius.user
Message-ID	<[email protected]>

On Jan 15, 2026, at 7:43 AM, Can Paçacı <[email protected]> wrote:
> Thanks Alan, What value should I change max value to? I increased it from 40 to 200, is that enough?

  It depends on your system.  There is no perfect answer which works for all systems.

> The following logs were received during the burst and for a certain period afterward:
> 
> Jan 15 03:54:15 srv-1 radiusd[581372]: rlm_sql (sql): Cannot open new connection, already at max
> Jan 15 03:54:35 srv-1 radiusd[581372]: rlm_sql (sql): No connections available and at max connection limit
> Jan 15 03:54:38 srv-1 radiusd[581372]: rlm_sql (sql): No connections available and at max connection limit
> Jan 15 03:54:40 srv-1 radiusd[581372]: rlm_sql (sql): No connections available and at max connection limit

  Yes, that's a sign that the database is overloaded.

  Adding more connections won't make the database faster.  It just means that more packets will be waiting for the database.

  Instead, you should configure the server so that if the SQL module fails, the accounting data is written to the detail file.  Then, use radrelay *after* the traffic peak is over to insert the records into the database.

  Or, double-check your database to see if you can make it faster.  This is a database issue, and changing FreeRADIUS won't make the database faster.

  Alan DeKok.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

signature.asc (application/pgp-signature, 833 B)