I can login to mysql with the credentials used in sql.conf, yet not sure why it gives Mysql error. i have even restarted the server and getting same error. Eby Tue May 24 20:35:21 2016 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Tue May 24 20:35:21 2016 : Info: rlm_sql (sql): Attempting to connect to root@localhost:3306/radius Tue May 24 20:35:21 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 Tue May 24 20:35:21 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Tue May 24 20:35:21 2016 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius Tue May 24 20:35:21 2016 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so' Tue May 24 20:35:21 2016 : Error: rlm_sql (sql): Failed to connect DB handle #0 Tue May 24 20:35:21 2016 : Error: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0 Tue May 24 20:35:21 2016 : Error: Failed to load clients from SQL. Tue May 24 20:35:21 2016 : Info: rlm_sql (sql): Closing sqlsocket 4 Tue May 24 20:35:21 2016 : Info: rlm_sql (sql): Closing sqlsocket 3 Tue May 24 20:35:21 2016 : Info: rlm_sql (sql): Closing sqlsocket 2 Tue May 24 20:35:21 2016 : Info: rlm_sql (sql): Closing sqlsocket 1 Tue May 24 20:35:21 2016 : Info: rlm_sql (sql): Closing sqlsocket 0 Tue May 24 20:35:21 2016 : Error: /etc/freeradius/sql.conf[22]: Instantiation failed for module "sql" Tue May 24 20:35:21 2016 : Error: /etc/freeradius/sites-enabled/default[122]: Failed to load module "sql". Tue May 24 20:35:21 2016 : Error: /etc/freeradius/sites-enabled/default[69]: Errors parsing authorize section. Tue May 24 20:35:21 2016 : Error: Failed to load virtual server <default> Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Attempting to connect to root@localhost:3306/radius Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 Tue May 24 20:35:22 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Tue May 24 20:35:22 2016 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius Tue May 24 20:35:22 2016 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so' Tue May 24 20:35:22 2016 : Error: rlm_sql (sql): Failed to connect DB handle #0 Tue May 24 20:35:22 2016 : Error: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0 Tue May 24 20:35:22 2016 : Error: Failed to load clients from SQL. Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 4 Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 3 Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 2 Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 1 Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 0 Tue May 24 20:35:22 2016 : Error: /etc/freeradius/sql.conf[22]: Instantiation failed for module "sql" Tue May 24 20:35:22 2016 : Error: /etc/freeradius/sites-enabled/default[122]: Failed to load module "sql". Tue May 24 20:35:22 2016 : Error: /etc/freeradius/sites-enabled/default[69]: Errors parsing authorize section. Tue May 24 20:35:22 2016 : Error: Failed to load virtual server <default> Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Attempting to connect to root@localhost:3306/radius Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 Tue May 24 20:35:22 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Tue May 24 20:35:22 2016 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius Tue May 24 20:35:22 2016 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so' Tue May 24 20:35:22 2016 : Error: rlm_sql (sql): Failed to connect DB handle #0 Tue May 24 20:35:22 2016 : Error: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0 Tue May 24 20:35:22 2016 : Error: Failed to load clients from SQL. Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 4 Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 3 Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 2 Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 1 Tue May 24 20:35:22 2016 : Info: rlm_sql (sql): Closing sqlsocket 0 Tue May 24 20:35:22 2016 : Error: /etc/freeradius/sql.conf[22]: Instantiation failed for module "sql" Tue May 24 20:35:22 2016 : Error: /etc/freeradius/sites-enabled/default[122]: Failed to load module "sql". Tue May 24 20:35:22 2016 : Error: /etc/freeradius/sites-enabled/default[69]: Errors parsing authorize section. Tue May 24 20:35:22 2016 : Error: Failed to load virtual server <default> Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Attempting to connect to root@localhost:3306/radius Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 Tue May 24 20:35:23 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Tue May 24 20:35:23 2016 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius Tue May 24 20:35:23 2016 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so' Tue May 24 20:35:23 2016 : Error: rlm_sql (sql): Failed to connect DB handle #0 Tue May 24 20:35:23 2016 : Error: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0 Tue May 24 20:35:23 2016 : Error: Failed to load clients from SQL. Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Closing sqlsocket 4 Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Closing sqlsocket 3 Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Closing sqlsocket 2 Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Closing sqlsocket 1 Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Closing sqlsocket 0 Tue May 24 20:35:23 2016 : Error: /etc/freeradius/sql.conf[22]: Instantiation failed for module "sql" Tue May 24 20:35:23 2016 : Error: /etc/freeradius/sites-enabled/default[122]: Failed to load module "sql". Tue May 24 20:35:23 2016 : Error: /etc/freeradius/sites-enabled/default[69]: Errors parsing authorize section. Tue May 24 20:35:23 2016 : Error: Failed to load virtual server <default> Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Attempting to connect to root@localhost:3306/radius Tue May 24 20:35:23 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 Tue May 24 20:35:23 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Connected new DB handle, #0 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 Tue May 24 20:35:25 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Connected new DB handle, #1 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 Tue May 24 20:35:25 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Connected new DB handle, #2 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 Tue May 24 20:35:25 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Connected new DB handle, #3 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 Tue May 24 20:35:25 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4 Tue May 24 20:35:25 2016 : Info: rlm_sql (sql): Connected new DB handle, #4 Tue May 24 20:35:25 2016 : Info: Loaded virtual server <default> Tue May 24 20:35:25 2016 : Info: Loaded virtual server inner-tunnel Tue May 24 20:35:25 2016 : Info: ... adding new socket proxy address * port 40350 Tue May 24 20:35:25 2016 : Info: Ready to process requests. Tue May 24 20:38:05 2016 : Info: Signalled to terminate Tue May 24 20:38:05 2016 : Info: Exiting normally. Tue May 24 20:38:05 2016 : Info: rlm_sql (sql): Closing sqlsocket 4 Tue May 24 20:38:05 2016 : Info: rlm_sql (sql): Closing sqlsocket 3 Tue May 24 20:38:05 2016 : Info: rlm_sql (sql): Closing sqlsocket 2 Tue May 24 20:38:05 2016 : Info: rlm_sql (sql): Closing sqlsocket 1 Tue May 24 20:38:05 2016 : Info: rlm_sql (sql): Closing sqlsocket 0 -------------------------------------------- On Mon, 23/5/16, Alan DeKok <aland@deployingradius.com> wrote: If only there was some kind of debug log, where you could see what the server was doing. Alan DeKok.