Hi,<br><br><div class="gmail_quote">2009/11/21 toqeer ali <span dir="ltr"><<a href="mailto:toqeer83@gmail.com">toqeer83@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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"><font color="#888888"><br>-- <br>Toqeer Ali Syed<br><br>Red Hat Certified Engineer<br>mob: +92 321 9059916<br> </font><br></blockquote><div>
<br>Did you create the radacct table properly?<br><br>Check out /path/to/CDRTool/setup/radius/OpenSIPS/radacct.mysql<br>It should look like that.<br><br>-Laszlo <br></div></div><br>