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