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