[OpenSIPS-Users] CDRTool web application issue

[JayaPrakash]

Hi All,

I installed Opensips 1.4.4 with Mysql Authentication. Freeradius 1.3 is
installed. Both are functioning.
FreeRadius is able to retrieve data like called party, calling party, call
starttime, call stop time.

CDRTool 6.7.2 is installed. It is giving web application too. When I try to
search for CDRs it is giving the following database error.
*
Database error: Invalid SQL: select count(*) as records from radacct where
(AcctStartTime >= '2009-03-01 09:07' and AcctStartTime < '2009-03-01 23:55')
MySQL error: 1146 (Table 'opensips.radacct' doesn't exist) 59Session halted.
*

I renamed the table of radacct to opensips.radacct and searched for CDRs in
web application of CDRTool. Then it is able to retrieve the number of
records in the particular time period. But still giving the following
database error.

* 4 records found. *

*Database error: Invalid SQL: select *, UNIX_TIMESTAMP(AcctStartTime) as
timestamp from radacct where (AcctStartTime >= '2009-02-28 10:01' and
AcctStartTime < '2009-03-01 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: 1146 (Table 'cdrtool.radacct' doesn't exist) 58Session
halted.*

Will you please look at the issue and try to give me a solution to resolve
this.

Thanks & Regards,
JP
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090301/ee6501e0/attachment.htm