- Adjust FreeRADIUS SQL config to identify devices by their Agent-Circuit-Id instead of their User-Name
Code Block language diff --- a/etc/raddb/mods-config/sql/main/mysql/queries.conf +++ b/etc/raddb/mods-config/sql/main/mysql/queries.conf @@ -35,7 +35,7 @@ # Else use hard-coded string "DEFAULT" as the user name. #sql_user_name = "%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}}" # -sql_user_name = "%{User-Name}" +sql_user_name = "%{Agent-Circuit-Id}" ####################################################################### # Default profile --- /usr/share/freeradius/dictionary.ericsson.ab +++ /usr/share/freeradius/dictionary.ericsson.ab @@ -226,7 +226,7 @@ ATTRIBUTE Reauth 94 string ATTRIBUTE Reauth-More 95 integer ATTRIBUTE Agent-Remote-Id 96 octets -ATTRIBUTE Agent-Circuit-Id 97 octets +ATTRIBUTE Agent-Circuit-Id 97 string ATTRIBUTE Platform-Type 98 integer VALUE Platform-Type SMS 1 - Restart FreeRadius
Code Block language bash systemctl restart radiusd
- Insert new test user into radcheck and radusergroup (assumption QoS with id 1 already exists, device Agent-Circuit-Id is 0x0123456789ab'olt001.nmsprime.com/0/0/1/1/1')
Code Block language sql INSERT INTO radcheck (username, attribute, op, value) VALUES ('0x0123456789abolt001.nmsprime.com/0/0/1/1/1', 'Auth-Type', ':=', 'Accept'); INSERT INTO radusergroup (username, groupname, priority) VALUES ('0x0123456789abolt001.nmsprime.com/0/0/1/1/1', 0, 1); INSERT INTO radusergroup (username, groupname, priority) VALUES ('0x0123456789abolt001.nmsprime.com/0/0/1/1/1', 1, 1);
Page Comparison
Manage space
Manage content
Integrations