23 Mar
2017
23 Mar
'17
8:45 a.m.
On Mar 23, 2017, at 1:34 AM, gh.li@microshield.com.cn wrote:
the problem is:how can I map the user to the correct record?
a) include the SSID in the table and in the queries, b) have two different SQL tables.
I have extented radcheck tables with field user_ssid,so the records like:
and change the authorize_check_query statement to: "SELECT id, username, attribute, value, op FROM ${authcheck_table} WHERE username = '%{SQL-User-Name}' and ssid='%{Aruba_Essid_Name}' ORDER BY id"
but I donot get the correct sql statement: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'emp' and ssid='' ORDER BY id
As always, read the debug log to see why. Does the packet include the Aruba_Essid_Name attribute? Alan DeKok.