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