root@ngw40:/etc/freeradius/mods-enabled# freeradius -v radiusd: FreeRADIUS Version 3.2.3 (git #db3d1924d), for host x86_64-pc-linux-gnu FreeRADIUS Version 3.2.3 running on terminal without any issue *freeradius -X* Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address :: port 1812 bound to server default Listening on acct address :: port 1813 bound to server default Listening on proxy address * port 44685 Listening on proxy address :: port 57364 *run as as service always failed with sql connection issue* Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: # Instantiating module "sql" from file /etc/freeradius/mods-enabled/sql Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Info: rlm_sql_mysql: libmysql version: 8.0.34 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: mysql { Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: tls { Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011ca_file = "/etc/ssl/certs/my_ca.crt" Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011ca_path = "/etc/ssl/certs/" Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011certificate_file = "/etc/ssl/certs/private/client.crt" Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011private_key_file = "/etc/ssl/certs/private/client.key" Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011cipher = "DHE-RSA-AES256-SHA:AES128-SHA" Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011tls_required = yes Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011check_cert = no Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011check_cert_cn = no Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Warning: /etc/freeradius/mods-enabled/sql[94]: The item 'tls_check_cert' is defined, but is unused by the configuration Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Warning: /etc/freeradius/mods-enabled/sql[95]: The item 'tls_check_cert_cn' is defined, but is unused by the configuration Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: } Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011warnings = "auto" Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: } Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Info: rlm_sql (sql): Attempting to connect to database "radius" Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: rlm_sql (sql): Initialising connection pool Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: pool { Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011start = 5 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011min = 3 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011max = 32 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011spare = 10 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011uses = 0 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011lifetime = 0 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011cleanup_interval = 30 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011idle_timeout = 60 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011retry_delay = 30 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011max_retries = 5 Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: #011spread = no Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: } Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: rlm_sql (sql): Processing generate_sql_clients Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: rlm_sql (sql): 0 of 0 connections in use. You may need to increase "spare" Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Info: rlm_sql (sql): Opening additional connection (0), 1 of 1 pending slots used Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: rlm_sql_mysql: Starting connect to MySQL server Oct 24 14:42:43 ngw40 freeradius[168957]: WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Error: rlm_sql_mysql: Couldn't connect to MySQL server radius@localhost:radius Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Error: rlm_sql_mysql: MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Debug: rlm_sql_mysql: Socket destructor called, closing socket Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Error: rlm_sql (sql): Opening connection failed (0) Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Error: Failed to load clients from SQL Oct 24 14:42:43 ngw40 freeradius[168957]: Tue Oct 24 14:42:43 2023 : Error: /etc/freeradius/mods-enabled/sql[27]: Instantiation failed for module "sql"