[RadiusNT] "User-Name" showing up twice in certain radius acct records

Josh Hillman ( (no email) )
Fri, 24 Mar 2000 18:55:07 -0500

Dale,

Any idea what would cause some oddball things to come up in radius
accounting packets just after a VSA attribute is received? I'm thinking
that it might be related to a VSA in some way, but I'm not sure (all data is
further below). Because "User-Name" is appearing twice (different data in
each), it's preventing the info from being stored in the Calls table.
We're using RadiusNT 2.5.212 and Emerald 2.5.323 (SQL 7 SP1).

The data that's sent to us has the following hex info that corresponds to
"YVILL" and beyond. I have the complete packet transmission from AT&T in a
color-coded Word document if you want to see it (24,064 bytes).

....1A1C 0000004A 05075956 494C4C03 03040206
00007080 010638DB E7710000

1A corresponds to attribute 26 (Vendor-Specific)
1C (??)
000000 (??)
4A corresponds to VendorID 74 (AT&T)
05 corresponds to subattribute 5 (AGNS-Account-ID)
07 (??)
5956494C4C = YVILL
03 corresponds to attribute 3 (Challenge-Response)
03 (??)
04 ("/004" ??)
02 corresponds to attribute 2 (Password)
Beyond that, I'm lost.

RadVendorID RadVendorType Type Name
----------- ------------- ---- ---------------
74 5 0 AGNS-Account-ID

Here's what we see (start, then stop):

radrecv: Request from host cc92ace2 code=4, id=8, length=170

Acct-Session-Id = "2000032416084900"
User-Name = "sometestaccount@yourvillage.com"
NAS-Identifier = 204.146.172.226
NAS-Identifier2 = "230BL01010100:041"
NAS-Port = 41
Acct-Status-Type = Start
Acct-Authentic = RADIUS
NAS-Port-DNIS = "18149411309"
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 32.101.34.161
AGNS-Account-ID = "YVILL"
Challenge-Response = "\004"
Password = ""
User-Name = "8\333\347q"

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionID,UserName,NASIdentifier,NASPort,AcctStatusType,NASPor
tDNIS,NASPortType,FramedProtocol,FramedAddress,UserName) VALUES
(GetDate(),'2000032416084900','attppp','204.146.172.226',41,1,'18149411309',
0,1,'32.101.34.161','8q')

ODBC Error:37000:264:
[Microsoft][ODBC SQL Server Driver][SQL Server]Column name 'UserName'
appears more than once in the result column list.

Resp Time: 47 Auth: 6/3 -> 8 Acct: 5/1/0 -> 7

radrecv: Request from host cc92ace2 code=4, id=9, length=194

Acct-Session-Id = "2000032416084900"
User-Name = "attppp@yourvillage.com"
NAS-Identifier = 204.146.172.226
NAS-Identifier2 = "230BL01010100:041"
NAS-Port = 41
Acct-Status-Type = Stop
Acct-Session-Time = 482
Acct-Authentic = RADIUS
NAS-Port-DNIS = "18149411309"
Acct-Output-Octets = 84
Acct-Output-Packets = 3
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 32.101.34.161
Acct-Terminate-Cause = User-Request
AGNS-Account-ID = "YVILL"
Challenge-Response = "\004"
Password = ""
User-Name = "8\333\351\024"

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionID,UserName,NASIdentifier,NASPort,AcctStatusType,AcctSe
ssionTime,NASPortDNIS,AcctOutputOctets,AcctOutputPackets,NASPortType,FramedP
rotocol,FramedAddress,AcctTerminateCause,UserName) VALUES
(GetDate(),'2000032416084900','attppp','204.146.172.226',41,2,482,'181494113
09',84,3,0,1,'32.101.34.161',1,'8')

ODBC Error:37000:264:
[Microsoft][ODBC SQL Server Driver][SQL Server]Column name 'UserName'
appears more than once in the result column list.

Resp Time: 32 Auth: 32/5 -> 34 Acct: 42/3/0 -> 48

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