Re: [RadiusNT] SQL Error (Violation of PRIMARY KEY)

Dale E. Reed Jr. ( (no email) )
Tue, 15 Dec 1998 02:22:58 -0800

"Kenneth D. Lenox" wrote:
>
> I think this error message may have been explained before, but I'm not sure
> when. Can someone tell me how to fix this
>
> Resp Time: 813 Auth: 2/0 -> 2 Acct: 0/5/0 -> 5
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
> const
> nt 'pk_Calls': Attempt to insert duplicate key in object 'Calls'. [INSERT

This means that RadiusNT has already seen this accounting record. If
the
problem continues, look at your accounting timeouts on your NAs and make
sure it atleast 5. Otherwise, double-check your secrets and see if your
NAS has a log as to why its not receiving the ack.

Is the machine you are running RadiusNT on multi-homed? 

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

For more information about this list, including removal, pleasesee this URL: http://www.iea-software.com/maillist.html