I have a fresh install of CDRTool on an Ubuntu box. Everything appears to be ok except for the fact that when I go to the CDR page and do a search I get the following error on the webpage
MySQL error: 1146 (Table 'cdrtool.radacct201106' doesn't exist) Session halted. Then when I look in syslog I see the following Jun 1 16:35:57 CDRTool01 cdrtool[5986]: Database error: Invalid SQL: select count(*) as records#012 from radacct201106 where (AcctStartTime >= ' 2011-06-01 10:25' and AcctStartTime < '2011-06-01 23:55') Jun 1 16:35:57 CDRTool01 cdrtool[5986]: 64 Yet if I log into mysql and perform the same command (minus the #12 junk that is in syslog) it returns a value without issue. Also in syslog I see other MySQL database errors Jun 1 16:35:17 CDRTool01 cdrtool[21095]: Database error: Invalid SQL: select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp#012 from radacct201106 whe re (1=1) and Normalized = '0' and AcctStopTime not like '0000-00-00 00:00:00%' order by RadAcctId asc Jun 1 16:35:17 CDRTool01 cdrtool[21095]: 64 -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-MySQL-Database-error-Invalid-SQL-tp6427865p6427865.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
