User login restrictions based on SSID

[Eby Mani]

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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at deployingradius.com> wrote:

   If only there was some kind of debug log,
 where you could see what the server was doing.
 
   Alan DeKok.