Weird Insert sql statement in sqltrace.sql
TK Lew
tklew99 at gmail.com
Sat Dec 24 13:33:41 CET 2005
hi all ::
I have a Freeradius with Oracle 10.0 running but something weird
appeared in the sqltrace.sql.
Sample weirdness record ::
================
INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName,
Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime,
AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,
ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,
CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol,
FramedIPAddress, AcctStartDelay, AcctStopDelay) values('',
'cb5241850008c698', '200a59703fc69d6d', '60131234567', '',
'203.82.65.xxx', '', 'Virtual', NULL, TO_DATE('2005-12-23
19:24:35','yyyy-mm-dd hh24:mi:ss'), '194', '', '', '', '35440',
'80779', 'streaming.com', '60131234567', '', '', '', '10.161.211.xxx',
'0', '');
By right when accouting start packet come in and the accounting start
time should be recorded and accounting stop time should be NULL. But
in my case as shown above the accounting start time is NULL and
accounting stop time is recorded.
Anybody have encountered this kind of weirdness before ?
Thanks !
Meery Christmas and Happy New Year.
regards
More information about the Freeradius-Users
mailing list