we are using RadiusNT 2.5.213
SQL 6.5
below is part of SQL 6.5 trace , and I want to know why the update query
calculates current time minus 2 seconds
as the insert statement shows that AcctDelayTime = 0, where 2 (two) comes
from ?
-- 22/05/2000 11:48:12,326 SQL (ID=7, SPID=29, User=bla bla ...
INSERT INTO Calls
(CallDate,AcctStatusType,NASIdentifier,NASPort,AcctDelayTime,FramedAddress,U
serName,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' From
Servers s, ServerPorts sp WHERE sp.ServerID = s.ServerID AND
s.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