[RadiusNT] radius bug?

Josh Hillman ( (no email) )
Wed, 5 Apr 2000 12:37:28 -0400

I added another column to our Calls table called "NASID" to correspond with
an entry in the RadAttributes table: RadAttributeID=32, Name='NAS-ID',
Type=0, RadVendorID=0, RadVendorType=0. This is actually supposed to be
"NAS-Identifier", but it can't be named that because Emerald and RadiusNT
need that name associated with attribute 4, which is supposed to be
"NAS-IP-Address".

Anyway, the problem is that RadiusNT can see the new column and displays
info for it when running radius -x15, however it does not make an attempt to
insert that data into the Calls table, eventhough everything matches and
RadiusNT has been restarted. The column name doesn't even appear in the SQL
statement. I've tried varying names for this both in RadAttributes and
Calls, but it doesn't seem to make a difference--it just never tries to
insert the data into the Calls table for that one field. Other Calls
column-additions have never done this before.

The NASID column in Calls is varchar(17), nullable

Does RadiusNT have some kind of problem dealing with attribute 32 when it
comes to the SQL statement?

Here's my -x15 output:

RadiusNT 2.5.213 Copyright (c) 1995-2000 IEA Software, Inc.
All Rights Reserved, Worldwide

0) Mode: 1
1) IgnoreCase: 0
2) TrimName: 3
4) ReqAcctAuth: 1
5) AllowMalformed: 3
7) Proxy: 0
8) Options: 225
9) Debug: 0
11) AcctLogFile:
12) ODBCDatasource: Radius
23) IPAddress: All
24) SNMP: 3
25) TestDatabaseSecs:

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS SQL Server Mode Enabled
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS SQL Server Mode Enabled
Licensed MBRs: 2000

SQL Statement: Select Name, RadAttributeID, Type, RadVendorID,
RadVendorType From RadAttributes Order By RadVendorID, RadAttributeID DESC

SQL Statement: Select ra.Name, rv.Name, rv.Value, rv.RadVendorID,
rv.RadVendorType From RadValues rv, RadAttributes ra Where
rv.RadAttributeID = ra.RadAttributeID and rv.RadVendorID = ra.RadVendorID
and rv.RadVendorType = ra.RadVendorType Order By rv.RadVendorID,
rv.RadAttributeID DESC

Dictionary: Vendors: 7 Attributes:382 Values: 198

SQL Statement: Select Server, IPAddress, Secret From Servers

35 Clients Loaded
37 Accounting Columns Loaded

Enterprise features enabled.

RadiusNT 2.5.213 (Emerald Standard) Initialized...

(other records)

radrecv: Request from host cc92db01 code=4, id=74, length=206
Acct-Session-Id = "2000040510432400"
User-Name = "testppp@mycompany.com"
NAS-Identifier = 204.146.219.1
NAS-ID = "953AL01020100:015"
NAS-Port = 15
Acct-Status-Type = Stop
Acct-Session-Time = 10
Acct-Authentic = RADIUS
NAS-Port-DNIS = "18501231234"
Caller-Id = "8505551212"
Acct-Output-Octets = 1236
Acct-Output-Packets = 15
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 166.72.196.78
Acct-Terminate-Cause = User-Request
AGNS-Account-ID = "abcde"
AGNS-LineType = 67241472
Ascend-Xmit-Rate = 44000
AGNS-Connect-Time = 954949414

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionID,UserName,NASIdentifier,NASPort,AcctStatusType,
AcctSessionTime,NASPortDNIS,CallerID,AcctOutputOctets,AcctOutputPackets,
NASPortType,FramedProtocol,FramedAddress,AcctTerminateCause,AscendXmitRate)
VALUES (GetDate),'2000040510432400','testppp','204.146.219.1',15,2,10,
'18501231234','8505551212',1236,15,0,1,'166.72.196.78',1,44000)

Sending Accounting Ack of id 74 to cc92db01 (AT&T)
Resp Time: 391 Auth: 1/0 -> 1 Acct: 4/0/0 -> 4

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart