How would we run a SQL query statement to insert that list? When I just
whack it into query analyser it complains about a conflict with a column
foreign key constraint.
Cheers
David Leigh
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Tuesday, October 19, 1999 1:01 AM
Subject: Re: [RadiusNT] Unknown vendor attributes
>Charlie Cocuzza wrote:
>>
>> While running radius (2.5.175) in debug mode, I noticed I am getting the
>> following error:
>>
>> Received unknown attribute 44, vendor 1584
>>
>> Attribute 44 is defined in the radattributes table as Acct-Session-ID. I
am
>> using Bay Networks equipment. This is only one of several unknown
>> attributes coming across. The others are 33,34,45,46,60,65,66,67 and 68.
>> They have all been defined in radattributes. Does anyone have any ideas?
>
>Acct-Session-ID #44 is for Vendor 0, or the standard RADIUS attributes.
>That attribute is for vendor 1584 (not vendor 0).
>
>You can define VSA attributes (which is RadAttributeID #26)
>by specifying the VendorID and VendorType (1584 and 44 for your
>example) in the RadAttributes table.
>
>Here are all the Annex attributes that I have collected:
>
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>28, 'Annex-Filter', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>29, 'Annex-CLI-Command', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>30, 'Annex-CLI-Filter', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>31, 'Annex-Host-Restrict', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>32, 'Annex-Host-Allow', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>33, 'Annex-Product-Name', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>34, 'Annex-SW-Version', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>35, 'Annex-Local-IP-Address', 2)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>36, 'Annex-Callback-Portlist', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>37, 'Annex-Sec-Profile-Index', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>38, 'Annex-Tunnel-Authen-Type', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>39, 'Annex-Tunnel-Authen-Mode', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>40, 'Annex-Authen-Servers', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>41, 'Annex-Acct-Servers', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>42, 'Annex-User-Server-Location', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>43, 'Annex-Local-Username', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>44, 'Annex-System-Disc-Reason', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>45, 'Annex-Modem-Disc-Reason', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>46, 'Annex-Disconnect-Reason', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>47, 'Annex-Addr-Resolution-Protocol', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>48, 'Annex-Addr-Resolution-Servers', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>49, 'Annex-Domain-Name', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>50, 'Annex-Transmit-Speed', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>51, 'Annex-Receive-Speed', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>52, 'Annex-Input-Filter', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>53, 'Annex-Output-Filter', 0)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>54, 'Annex-Primary-DNS-Server', 2)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>55, 'Annex-Secondary-DNS-Server', 2)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>56, 'Annex-Primary-NBNS-Server', 2)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>57, 'Annex-Secondary-NBNS-Server', 2)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>59, 'Annex-Keypress-Timeout', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>60, 'Annex-Unauthenticated-Time', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>61, 'Annex-Re-CHAP-Timeout', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>62, 'Annex-MRRU', 1)
>INSERT RadAttributes
>(RadAttributeID,RadVendorID,RadVendorType,Name,Type) VALUES(26, 1584,
>63, 'Annex-EDO', 0)
>
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart