Re: [Emerald] DUPLICATE RECORDS

Glen Harvy ( glen@aquarius.com.au )
Mon, 22 Mar 1999 10:13:15

At 22:55 18/03/99 -0800, you wrote:

Thanks for your usual prompt response.

I have tried all the documentation for Radius as well as the Access Server
without luck.

Where and how do I check the response times in RadiusNT?

Whilst I don't expect you to be a genius with all the different types of
Access Servers :-) , can you please tell me how I check the accounting
timeouts on the Cisco AS2500 series.

Assuming I do eventually find out this information, what am I supposed to
do with it.

BTW: The Cisco Access Sever starts it's Acct-Session-ID at 00000000 every
time it is rebooted. Is this a problem?

For completeness, here's a copy of the start record...

radrecv: Request from host cb3a1913 code=4, id=2, length=85
NAS-Identifier = 203.58.25.19
NAS-Port = 1
NAS-Port-Type = Async
User-Name = "terry"
Acct-Status-Type = Start
Acct-Authentic = RADIUS
User-Service = Framed-User
Acct-Session-Id = "00000003"
Framed-Protocol = PPP
Acct-Delay-Time = 0

SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,NASPortType,UserName,AcctStatusType,UserServ
ice,AcctSessionId,FramedProtocol,AcctDelayTime) VALUES
(GetDate(),'203.58.25.19',1,0,'terry',1,2,'00000003',1,0)

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

Sending Accounting Ack of id 2 to cb3a1913 (Comserv1)

Resp Time: 30 Auth: 78/8 -> 86 Acct: 158/0/17 -> 175

>Glen Harvy wrote:
>>
>> I keep getting the following errors:
>>
>> 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'.
>>
>> Sending Accounting Ack of id 9 to cb3a1913 (203.58.25.19)
>>
>> How do I fix this?
>
>This just means that RadiusNT already has that accounting record.
>Check the response times of RadiusNT and the accounting timeouts
>of your NAS.
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
>
>
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet needs
voice(02)9977-3788 fax(02)9977-3844
http://www.aquarius.com.au mailto:sales@aquarius.com.au

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

Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet needs
voice(02)9977-3788 fax(02)9977-3844
http://www.aquarius.com.au mailto:sales@aquarius.com.au

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