rate linit connections to DB

[Alan DeKok]

On Jul 15, 2023, at 2:39 AM, Anatoliy <cphlpd at gmail.com> wrote:
> 
> Hi Alan, team.
> I saw in logs messages like this
> Thu Jul 13 02:23:40 2023 : Warning: rlm_sql (mysql): Cannot open a new
> connection due to rate limit after failure
> 
> Why we limiting connections and how we can control this ?
> Unable to find anything on doc

  The SQLconnection  configuration is in the "pool" section of mods-available/sql

  If the MySQL server is down, then FreeRADIUS tries to connect again.  If the connection fails, it does *not* repeatedly try to open new connections for every packet.

  The short answer here is that if FreeRADIUS is producing an error message... it doesn't mean you have to fix FreeRADIUS.  In this case, it means you have to fix the MySQL server.

  I'm not clear why an error of "cannot connection to MySQL" means that people try to poke FreeRADIUS.  It is not a FreeRADIUS problem.  No amount of poking FreeRADIUS will make the MySQL server start up again.

 Alan DeKok.