Calls not updating (SQL error)

Mauro J. Jaskelioff ( (no email) )
Fri, 19 Jun 1998 10:32:04

I=B4m using RadiusNT2.5 and SQL Server. I've created the tables using the
radiusnt.sql script that's in IEA Software FTP server.
The Calls table is not being updated.
When i Run radius -x15

I see the following error:

SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,UserName,AcctStatusType,AcctSessionId,AcctDe
layTime) VALUES (GetDate(),'200.32.15.238',3,'mauro',1,'00000089',20)

ODBC Error:23000:2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.

There is another (older) entry in the Database with the same AcctSessionId.

************************
* Mauro J. Jaskelioff *
* mauro@citynet.net.ar *
* Depto T=E9cnico *
* Citynet S.A. *
************************