multi ssid use multi radcheck

Alan DeKok aland at
Thu Mar 23 13:45:41 CET 2017

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

More information about the Freeradius-Users mailing list