Re: Failure on Accounting packets

Dale E. Reed Jr. ( (no email) )
Fri, 18 Sep 1998 15:55:38 -0700

Michael Whisenant wrote:
>
> This is like Morton's Salt... "When it Rains it Pours"
>
> I have a USR TotalControl HiPer ARC chassis that is sending accounting
> packets to RadiusNT, but from some reason it thinks they are duplicate and
> refused to add them to calls. Here is an example... Please note that it
> did actually accept 1 and then the next 93 and now the next 140 are all
> rejected? What is wrong?!!!!

Looks lik a NAS is sending a LOT of duplicates requests to
RadiusNT. That is what the third number in the Acct: statistics
is. I would check the timeout on accounting packets, as it looks
like it set to low causing a large number of re-transmissions.

> Resp Time: 750 Auth: 0/0 -> 0 Acct: 1/0/92 -> 93
> radrecv: Request from host c068705 code=4, id=203, length=279
> User-Name = "kbeasley"
> NAS-Identifier = xx.xx.xx.xx
> Acct-Status-Type = Start
> Acct-Session-Id = "51472"
> Acct-Delay-Time = 0
> Acct-Authentic = RADIUS
> User-Service = Framed-User
> NAS-Port-Type = Async
> NAS-Port = 1
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Caller-Id = "2567340557"
> NAS-Port-DNIS = "256734xxxx"
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Framed-Protocol = PPP
> Framed-Address = 12.6.135.129
> Vendor-Specific = ""
> Received unknown attribute 51
> Received unknown attribute 50
>
> SQL Statement: INSERT INTO Calls
> (CallDate,UserName,NASIdentifier,AcctStatusTyp
> e,AcctSessionId,AcctDelayTime,UserService,NASPortType,NASPort,CallerId,NASPo
> rtDN
> IS,FramedProtocol,FramedAddress) VALUES
> (GetDate(),'kbeasley','12.6.xx.xx',1,'51
> 472',0,2,0,1,'2567340557','256734xxxx',1,'12.6.135.129')
>
> ODBC Error:23000:2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
> constra
> int 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
>
> Sending Accounting Ack of id 203 to c068705 (Cullman 2)
> Michael J. Whisenant
> Vice-President, Operations
> AIRnet Internet Services, Inc.
> ph: (256) 704-4692 fax: (256) 704-2329

-- 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