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 val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtP nB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoO yAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nX SA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1d GgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg', 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 database. Any ideas what could be wrong? This is the latest version of CDRTool and I am running it on Ubuntu Maverick.
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
