User login restrictions based on SSID

[Eby Mani]

Hi Alan,

If the SQL can't connect, how authentication work as user details are stored in db?. I was able to login thru Radius and i have not enabled Radius  caching of anysort on my WLAN controller.

Anyway, i've stopped and started the services (mysql & freeradius) several times. 
Following is today's radius.log, there isn't much info, is there a command to log more info regarding this ?.

Eby

Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Attempting to connect to root at localhost:3306/radius
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
Wed May 25 12:13:00 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Connected new DB handle, #0
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
Wed May 25 12:13:00 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Connected new DB handle, #1
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
Wed May 25 12:13:00 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Connected new DB handle, #2
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
Wed May 25 12:13:00 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Connected new DB handle, #3
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
Wed May 25 12:13:00 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
Wed May 25 12:13:00 2016 : Info: rlm_sql (sql): Connected new DB handle, #4
Wed May 25 12:13:00 2016 : Info: Loaded virtual server <default>
Wed May 25 12:13:00 2016 : Info: Loaded virtual server inner-tunnel
Wed May 25 12:13:00 2016 : Info:  ... adding new socket proxy address * port 34635
Wed May 25 12:13:00 2016 : Info: Ready to process requests.
Wed May 25 12:13:51 2016 : Info: Signalled to terminate
Wed May 25 12:13:51 2016 : Info: Exiting normally.
Wed May 25 12:13:51 2016 : Info: rlm_sql (sql): Closing sqlsocket 4
Wed May 25 12:13:51 2016 : Info: rlm_sql (sql): Closing sqlsocket 3
Wed May 25 12:13:51 2016 : Info: rlm_sql (sql): Closing sqlsocket 2
Wed May 25 12:13:51 2016 : Info: rlm_sql (sql): Closing sqlsocket 1
Wed May 25 12:13:51 2016 : Info: rlm_sql (sql): Closing sqlsocket 0
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Attempting to connect to root at localhost:3306/radius
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
Wed May 25 12:30:53 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Connected new DB handle, #0
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
Wed May 25 12:30:53 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Connected new DB handle, #1
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
Wed May 25 12:30:53 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Connected new DB handle, #2
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
Wed May 25 12:30:53 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Connected new DB handle, #3
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
Wed May 25 12:30:53 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
Wed May 25 12:30:53 2016 : Info: rlm_sql (sql): Connected new DB handle, #4
Wed May 25 12:30:53 2016 : Info: Loaded virtual server <default>
Wed May 25 12:30:53 2016 : Info: Loaded virtual server inner-tunnel
Wed May 25 12:30:53 2016 : Info:  ... adding new socket proxy address * port 45005
Wed May 25 12:30:53 2016 : Info: Ready to process requests.
Wed May 25 12:32:18 2016 : Info: Signalled to terminate
Wed May 25 12:32:18 2016 : Info: Exiting normally.
Wed May 25 12:32:18 2016 : Info: rlm_sql (sql): Closing sqlsocket 4
Wed May 25 12:32:18 2016 : Info: rlm_sql (sql): Closing sqlsocket 3
Wed May 25 12:32:18 2016 : Info: rlm_sql (sql): Closing sqlsocket 2
Wed May 25 12:32:18 2016 : Info: rlm_sql (sql): Closing sqlsocket 1
Wed May 25 12:32:18 2016 : Info: rlm_sql (sql): Closing sqlsocket 0
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Attempting to connect to root at localhost:3306/radius
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
Wed May 25 12:41:28 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Connected new DB handle, #0
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
Wed May 25 12:41:28 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Connected new DB handle, #1
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
Wed May 25 12:41:28 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Connected new DB handle, #2
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
Wed May 25 12:41:28 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Connected new DB handle, #3
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
Wed May 25 12:41:28 2016 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
Wed May 25 12:41:28 2016 : Info: rlm_sql (sql): Connected new DB handle, #4
Wed May 25 12:41:28 2016 : Info: Loaded virtual server <default>
Wed May 25 12:41:28 2016 : Info: Loaded virtual server inner-tunnel
Wed May 25 12:41:28 2016 : Info:  ... adding new socket proxy address * port 34551
Wed May 25 12:41:28 2016 : Info: Ready to process requests.
Wed May 25 14:54:09 2016 : Auth: Login incorrect: [sales/<via Auth-Type = EAP>] (from client aruba port 0 via TLS tunnel)
Wed May 25 14:54:09 2016 : Auth: Login incorrect: [sales/<via Auth-Type = EAP>] (from client aruba port 0 cli 38192fb2eb02)
Wed May 25 14:54:14 2016 : Auth: Login incorrect: [sales/<via Auth-Type = EAP>] (from client aruba port 0 via TLS tunnel)
Wed May 25 14:54:14 2016 : Auth: Login incorrect: [sales/<via Auth-Type = EAP>] (from client aruba port 0 cli 38192fb2eb02)
Wed May 25 14:54:56 2016 : Auth: Login incorrect: [support/<via Auth-Type = EAP>] (from client aruba port 0 via TLS tunnel)
Wed May 25 14:54:56 2016 : Auth: Login incorrect: [support/<via Auth-Type = EAP>] (from client aruba port 0 cli 38192fb2eb02)
Wed May 25 14:55:00 2016 : Auth: Login incorrect: [support/<via Auth-Type = EAP>] (from client aruba port 0 via TLS tunnel)
Wed May 25 14:55:00 2016 : Auth: Login incorrect: [support/<via Auth-Type = EAP>] (from client aruba port 0 cli 38192fb2eb02)
Wed May 25 16:00:08 2016 : Auth: Login OK: [eby] (from client aruba port 0 via TLS tunnel)
Wed May 25 16:00:08 2016 : Auth: Login OK: [eby] (from client aruba port 0 cli e02a82e1afbf)
Wed May 25 16:01:27 2016 : Auth: Login OK: [eby] (from client aruba port 0 via TLS tunnel)
Wed May 25 16:01:27 2016 : Auth: Login OK: [eby] (from client aruba port 0 cli e02a82e1afbf)
Wed May 25 16:03:27 2016 : Auth: Login OK: [eby] (from client aruba port 0 via TLS tunnel)
Wed May 25 16:03:27 2016 : Auth: Login OK: [eby] (from client aruba port 0 cli e02a82e1afbf)
Wed May 25 16:05:19 2016 : Auth: Login OK: [eby] (from client aruba port 0 via TLS tunnel)
Wed May 25 16:05:19 2016 : Auth: Login OK: [eby] (from client aruba port 0 cli e02a82e1afbf)

--------------------------------------------
On Tue, 24/5/16, A.L.M.Buxey at lboro.ac.uk <A.L.M.Buxey at lboro.ac.uk> wrote:

 Subject: Re: User login restrictions based on SSID
 To: "Eby Mani" <eby_km at yahoo.com>, "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
 Date: Tuesday, 24 May, 2016, 7:25 PM
 
 Hi,
 
 
 > 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.
 
 not sure?
 
 > 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
 
 the
 error message says why......  
 
 alan