[OpenSIPS-Users] CDRTool - MySQL Database error: Invalid SQL:

osiris123d duane.larson at gmail.com
Wed Jun 1 18:59:58 CEST 2011


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.



More information about the Users mailing list