[OpenSIPS-Users] CDRtool freeradius mysql error

[Laszlo]

Hi,

2009/11/21 toqeer ali <toqeer83 at gmail.com>

> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091123/6161ea71/attachment.htm