CDRTool web application issue

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

CDRTool web application issue

JayaPrakash-2
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

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users