RE: [RadiusNT] AcctDelayTime

Graeme Slogrove ( Graeme@na.co.za )
Mon, 22 May 2000 13:53:21 +0200

It just makes sure that the record has been inserted into the calls
database.

Regards,
Graeme

---Graeme Slogrove, BSc (Eng) Elec (Wits)Director, Systems Development & Value Added ServicesNetActive InternetTel: 011-719-0333    Fax: 011-719-0444Support: 011-719-0300





-----Original Message-----From: Serkan Subasi [mailto:ssubasi@turk.net]Sent: 22 May 2000 12:36To: radiusnt@iea-software.comSubject: [RadiusNT] AcctDelayTime



Hi,

we are using RadiusNT 2.5.213SQL 6.5

below is part of SQL 6.5 trace , and I want to know why the update querycalculates current time  minus 2 secondsas the insert statement shows that AcctDelayTime = 0, where 2 (two) comesfrom ?



-- 22/05/2000 11:48:12,326 SQL (ID=7, SPID=29, User=bla bla ...INSERT INTO Calls(CallDate,AcctStatusType,NASIdentifier,NASPort,AcctDelayTime,FramedAddress,UserName,AcctInputOctets,AcctOutputOctets,AcctSessionID,AcctSessionTime)VALUES(GetDate(),2,'xxx.xxx.xxx.xxx',16636,0,'195.214.176.41','bca',419,593,'15788',176)go-- 22/05/2000 11:48:12,373 Duration 0,046, CPU 0,015, Reads 1, Writes 0

-- 22/05/2000 11:48:12,390 SQL (ID=7, SPID=29, User=bla bla ...UPDATE sp Set sp.Username='bca',sp.AcctStatusType=2, sp.CallDate=GetDate(),sp.FramedAddress='195.214.176.41', CallerID=NULL, AcctSessionID='15788' FromServers s, ServerPorts sp  WHERE sp.ServerID = s.ServerID ANDs.IPAddress='xxx.xxx.xxx.xxx' and sp.Port=16636   AND (DateAdd(Second, 0-2,GetDate()) >= CallDate OR        CallDate IS NULL)go-- 22/05/2000 11:48:12,390 Duration 0,000, CPU 0,000, Reads 0, Writes 0



thanks in advance

Serkan SUBASI



For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart