Re: RadiusNT and USR-TC

Dale E. Reed Jr. ( (no email) )
Fri, 14 Aug 1998 23:32:33 -0700

Lamar Townsend wrote:
>
> Before I sit back and stick all of the USR VSA's into my dictionary file
> has anyone out there already done this? And if so could I get a copy of
> your RADIUS dictionary?
>
> What can I say, I'm getting lazy,

I haven't done all of them, but I did as a few of the more popular ones
to Emerald 2.5. Some of the column orders have changed, so you may
need to alter these before they will work.

CREATE TABLE RadAttributes
(
RadAttributeID int NOT NULL ,
RadVendorID int NOT NULL DEFAULT 0 REFERENCES RadVendors(RadVendorID),
RadVendorType int NOT NULL DEFAULT 0 CONSTRAINT pk_RadAttributes
PRIMARY KEY (RadAttributeID, RadVendorID, RadVendorType),
Name varchar (25) NOT NULL,
Type int NOT NULL,
)
GO

/* Below are some Vendors and Vendor Specific Attributes */

INSERT RadVendors VALUES(5, 'ACC')
INSERT RadAttributes VALUES(26, 5, 5, 'Acc-Ccp-Option', 1)
INSERT RadAttributes VALUES(26, 5, 7, 'Acc-Ip-Gateway-Pri', 2)
INSERT RadAttributes VALUES(26, 5, 8, 'Acc-Ip-Gateway-Sec', 2)
INSERT RadAttributes VALUES(26, 5, 9, 'Acc-Route-Policy', 1)
INSERT RadAttributes VALUES(26, 5, 10, 'Acc-ML-MLX-Admin-State', 1)
INSERT RadAttributes VALUES(26, 5, 11, 'Acc-ML-Call-Threshold', 1)
INSERT RadAttributes VALUES(26, 5, 12, 'Acc-ML-Clear-Threshold', 1)
INSERT RadAttributes VALUES(26, 5, 13, 'Acc-ML-Damping-Factor', 1)
INSERT RadAttributes VALUES(26, 5, 14, 'Acc-Tunnel-Secret', 0)
INSERT RadAttributes VALUES(26, 5, 17, 'Acc-Service-Profile', 0)
INSERT RadAttributes VALUES(26, 5, 18, 'Acc-Request-Type', 1)
INSERT RadAttributes VALUES(26, 5, 19, 'Acc-Bridging-Support', 1)
INSERT RadAttributes VALUES(26, 5, 23, 'Acc-Dns-Server-Pri', 2)
INSERT RadAttributes VALUES(26, 5, 24, 'Acc-Dns-Server-Sec', 2)
INSERT RadAttributes VALUES(26, 5, 25, 'Acc-Nbns-Server-Pri', 2)
INSERT RadAttributes VALUES(26, 5, 26, 'Acc-Nbns-Server-Sec', 2)

INSERT RadVendors VALUES(9, 'Cisco')
INSERT RadAttributes VALUES(26, 9, 187, 'Multilink-ID', 1)
INSERT RadAttributes VALUES(26, 9, 188, 'Num-In-Multilink', 1)
INSERT RadAttributes VALUES(26, 9, 190, 'Pre-Input-Octets', 1)
INSERT RadAttributes VALUES(26, 9, 191, 'Pre-Output-Octets', 1)
INSERT RadAttributes VALUES(26, 9, 192, 'Pre-Input-Packets', 1)
INSERT RadAttributes VALUES(26, 9, 193, 'Pre-Output-Packets', 1)
INSERT RadAttributes VALUES(26, 9, 195, 'Disconnect-Cause', 1)
INSERT RadAttributes VALUES(26, 9, 197, 'Data-Rate', 1)
INSERT RadAttributes VALUES(26, 9, 198, 'PreSession-Time', 1)

/* These are 6510 specific */

INSERT RadAttributes VALUES(26, 9, 1, 'Cisco-AVPair', 0)
INSERT RadAttributes VALUES(26, 9, 250, 'Account-Info', 0)
INSERT RadAttributes VALUES(26, 9, 251, 'Service-Info', 0)
INSERT RadAttributes VALUES(26, 9, 252, 'Command-Code', 0)

INSERT RadVendors VALUES(429, '3Com/USR')
INSERT RadAttributes VALUES(26, 429, 36864, 'IP-Input-Filter', 0)
INSERT RadAttributes VALUES(26, 429, 36867, 'IP-Output-Filter', 0)

INSERT RadAttributes VALUES(26, 429, 36879, 'Primary-DNS-Server', 2)
INSERT RadAttributes VALUES(26, 429, 36880, 'Secondary-DNS-Server', 2)
INSERT RadAttributes VALUES(26, 429, 36881, 'Primary-NBNS-Server', 2)
INSERT RadAttributes VALUES(26, 429, 36882, 'Secondary-NBNS-Server', 2)

INSERT RadAttributes VALUES(26, 429, 38913, 'Speed_Of_Connection', 1)
INSERT RadAttributes VALUES(26, 429, 38914, 'Max_Channels', 1)
INSERT RadAttributes VALUES(26, 429, 38918, 'Compression_Algorithm', 1)

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com