multi ssid use multi radcheck

[Alan DeKok]

On Mar 23, 2017, at 1:34 AM, gh.li at 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.