Re: Dup Key in Radius
Erik Lundby ( (no email) )
Thu, 13 Mar 1997 11:42:29 -0600
> From: Dale E. Reed Jr. <firstname.lastname@example.org>
> To: email@example.com
> Subject: Re: Dup Key in Radius
> Date: Thursday, March 13, 1997 11:17 AM
> Erik Lundby wrote:
> > radrecv: Request from host ce9ce303 code=4, id=192, length=165
> > Acct-Session-Id = "02000012"
> > NAS-Identifier = 18.104.22.168
> > NAS-Port = 9
> > Acct-Status-Type = Start
> > ODBC: SQLExecDirect Error:
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY
> > constra
> > int 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
> > Sending Accounting Ack of id 192 to ce9ce303 (usr1.linkup.net)
> > Response Time: 60
> > This started happening after I reset my NAS. It was acting up. I am
> > talking with my vendor but am not sure I am being fed the correct
> > infrmation. Can someone tell me exactly how the AcctSessionID is
> > generated? Is it entirely by the NAS at the point the call is started
> > how? I assume this is the duplicate key right?
> The key is the above four fields. They must be unique for the duration
> of the
> accouting packet in the calls table.
Until I consolidate it right? I have never done this since I offer only
unlimited access accounts but still shouldn't be running into duplicates.
So Clearing My calls table should correct the problem right?
Typically the first byte is the
> "start cycle", and the last three bytes are the accounting cycles. This
> be 99 reboots of 2^24 calls (which call roll to the next start cycle
> is need be. The above looks like the third reboot, 12th accounting
So at that's what 16 million calls? Why is it repeating. The NAS
generates this number, correct?
When you say the key is the above four fields. Do you mean all four of
them have to be the same for it to be a duplicate? I apologize for my
ignorance but, It's been a really long day.
> Dale E. Reed Jr. (firstname.lastname@example.org)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.emerald.iea.com
> Emerald Mailing List email@example.com