Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Adjust FreeRADIUS SQL config to identify devices by their Agent-Circuit-Id instead of their User-Name
    Code Block
    languagediff
    --- 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
    --- a/usretc/share/freeradiusraddb/dictionary.ericsson.ab
    +++ b/usretc/shareraddb/freeradius/dictionary.ericsson.ab
    @@ -22647,73 +22647,7 @@
     ATTRIBUTE	Reauth					94#ATTRIBUTE	My-Local-String		3000	string
     ATTRIBUTE#ATTRIBUTE	ReauthMy-Local-MoreIPAddr		3001		95	integeripaddr
     ATTRIBUTE#ATTRIBUTE	AgentMy-Remote-Id				96	octets
    -ATTRIBUTE	Agent-Circuit-Id			97	octetsLocal-Integer	3002	integer
    +VENDOR		Ericsson-AB			2352
    +BEGIN-VENDOR	Ericsson-AB
    +ATTRIBUTE	Agent-Circuit-Id			97	string
     ATTRIBUTE	Platform-Type				98	integer
     
     VALUE	Platform-Type			SMS			1+END-VENDOR	Ericsson-AB
    
  2. Restart FreeRadiusĀ 
    Code Block
    languagebash
    systemctl restart radiusd
  3. Insert new test user into radcheck and radusergroup (assumption QoS with id 1 already exists, device Agent-Circuit-Id is 'olt001.nmsprime.com/0/0/1/1/1')
    Code Block
    languagesql
    INSERT INTO radcheck (username, attribute, op, value) VALUES ('olt001.nmsprime.com/0/0/1/1/1', 'Auth-Type', ':=', 'Accept');
    INSERT INTO radusergroup (username, groupname, priority) VALUES ('olt001.nmsprime.com/0/0/1/1/1', 0, 1);
    INSERT INTO radusergroup (username, groupname, priority) VALUES ('olt001.nmsprime.com/0/0/1/1/1', 1, 1);