[OpenSIPS-Users] CDRTool - Database error's

Duane Larson duane.larson at gmail.com
Mon Jun 6 18:37:06 CEST 2011

I am having some database errors with a new install of CDRTool.  One error I
keep seeing in my syslog is

Database error: Invalid SQL: select *, UNIX_TIMESTAMP(AcctStartTime) as
timestamp#012        from radacct201105 where  (1=1)  and  Normalized = '0'
and AcctStopTime not like '0000-00-00 00:00:00%'  order by RadAcctId asc

I don't see any issues with this log, but I don't know why it is trying to
look for radacct201105.  It was never created and the database doesn't exist
since this month is 201106.

Then I see another issue and this does cause issues with the CDRTool
application.  With this I am not able to log into the CDRTool and see the
following error at the bottom of the login page

MySQL error: 1036 (Table 'active_sessions' is read only) Session halted.

When I look in the syslog I see the following error

Database error: Invalid SQL: update active_sessions set
changed='20110606111425', count=count+1 where sid=
'99eeb2a6426095d5708d0a5149196bae' and name='CDRc'

If I stop cdrtool and try to restart it I am not able to restart CDRTool and
see the following error in syslog
Database error: Invalid SQL: delete from memcache where `key` =
'destinations_sip' or `key` = 'destinations'

In order to get CDRTool to start up again I have to stop and restart MySQL

Any ideas what could be wrong?  This is the latest version of CDRTool and I
am running it on Ubuntu Maverick.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110606/3769868a/attachment.htm>

More information about the Users mailing list