Hi all,<br><br><br>I successfully configured Freeradius and CDRtool but when i accesses the CDRs in CDRtool webinterface i got this error ... it can't get Normalized field in radacct table of Freeradius...<br><br>Please help <br>
Bellow is the error i got...<br><br>"Database error: Invalid SQL: select count(*) as c from radacct where
(AcctStartTime >= '2009-11-21 07:06' and AcctStartTime <
'2009-11-21 23:55') and Normalized = '0' and AcctStopTime !=
'0000-00-00 00:00:00' and (ConnectInfo_stop is not NULL or MediaInfo is
NULL or MediaInfo != '' or (UNIX_TIMESTAMP(NOW()) -
UNIX_TIMESTAMP(AcctStopTime) > 20)) MySQL error: 1054 (Unknown
column 'Normalized' in 'where clause')"<br clear="all"><br>-- <br>Toqeer Ali Syed<br><br>Red Hat Certified Engineer<br>mob: +92 321 9059916<br>