Hi, 2009/11/21 toqeer ali <[email protected]>
> Hi all, > > > 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... > > Please help > Bellow is the error i got... > > "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')" > > -- > Toqeer Ali Syed > > Red Hat Certified Engineer > mob: +92 321 9059916 > > Did you create the radacct table properly? Check out /path/to/CDRTool/setup/radius/OpenSIPS/radacct.mysql It should look like that. -Laszlo
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
