new connection problem

[Alan DeKok]

On Jan 15, 2026, at 7:43 AM, Can Paçacı <pacaci at servisnet.com.tr> 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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20260115/40855ec0/attachment.sig>