Message-ID: <003501c048ee$61c683b0$0100a8c0@romtech.com.au> From: "David Moore" <moored@romtech.com.au> Subject: [RadiusNT] Duplicate Start / Stop records written to Calls Table. Date: Wed, 8 Nov 2000 06:10:23 +1100
I have recently moved my SQL server from one server to another faster server
I imported the whole database structure using Transfer objects and data
between SQL 7.0 databases. I then installed Emerald/Radius on the same
server (latest download from ftp.iea-software.com, Radius ver 2.5.217
Emerald ver 2.5.337).
Since then I am getting Duplicate stop records written to the calls table,
as show below from my radius.exe -x15 debug. Is there some trigger that
could be doing this. I decide early on not to have a an unique index on the
calls table because the Cisco 4500 I have seems to duplicate the session ID
when powered off and it is important for me to retain the Acct-Input-Octets
= , Acct-Output-Octets = information.
Regards David Moore
radrecv: Request from host a000006 code=4, id=31, length=104
NAS-Identifier = 10.0.0.6
NAS-Port = 10000
NAS-Port-Type = Sync
User-Name = ""
Acct-Status-Type = Stop
User-Service = Framed-User
Acct-Session-Id = "0000000E"
Framed-Protocol = PPP
Acct-Input-Octets = 67417922
Acct-Output-Octets = 43462730
Acct-Input-Packets = 218523
Acct-Output-Packets = 216661
Acct-Session-Time = 33556
Acct-Delay-Time = 5
SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,NASPortType,Us
ername,AcctStatusType,AcctSessionID,AcctInputOctets,AcctOutputOctets,AcctSes
sion
Time,AcctDelayTime) VALUES
(GetDate(),'10.0.0.6',10000,1,'',2,'0000000E',6741792
2,43462730,33556,5)
Sending Accounting Ack of id 31 to a000006 (Cisco1720)
Resp Time: 62 Auth: 120/0 -> 120 Acct: 575/0/0 -> 575
radrecv: Request from host a000006 code=4, id=31, length=104
NAS-Identifier = 10.0.0.6
NAS-Port = 10000
NAS-Port-Type = Sync
User-Name = ""
Acct-Status-Type = Stop
User-Service = Framed-User
Acct-Session-Id = "0000000E"
Framed-Protocol = PPP
Acct-Input-Octets = 67417922
Acct-Output-Octets = 43462730
Acct-Input-Packets = 218523
Acct-Output-Packets = 216661
Acct-Session-Time = 33556
Acct-Delay-Time = 5
SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,NASPortType,Us
ername,AcctStatusType,AcctSessionID,AcctInputOctets,AcctOutputOctets,AcctSes
sion
Time,AcctDelayTime) VALUES
(GetDate(),'10.0.0.6',10000,1,'',2,'0000000E',6741792
2,43462730,33556,5)
Sending Accounting Ack of id 31 to a000006 (Cisco1720)
Resp Time: 63 Auth: 120/0 -> 120 Acct: 576/0/0 -> 576
.