[OpenSIPS-Users] CDRtool freeradius mysql error
toqeer ali
toqeer83 at gmail.com
Sat Nov 21 08:27:56 CET 2009
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091121/98b25721/attachment.htm
More information about the Users
mailing list