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.
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)
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.
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)
Will you please look at the issue and try to give me a solution to resolve this.