[OpenSIPS-Users] CDRTool - Database error's

Tijmen de Mes tijmen at ag-projects.com
Tue Jun 7 15:10:15 CEST 2011


Hi,

It looks like there is something wrong with your database. What happens 
if you execute the active sessions query manually?

Do you have an empty database, or are there valid destinations in ther 
(from the sample data)?

Best regards,

--
Tijmen de Mes
AG Projects

Op 6/6/11 6:37 PM, Duane Larson schreef:
> 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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110607/239793fd/attachment.htm>


More information about the Users mailing list