[OpenSIPS-Users] CDRTool - Database error's

Duane Larson duane.larson at gmail.com
Tue Jun 7 16:07:44 CEST 2011


When I execute
update active_sessions set
val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtPnB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg',
changed='20110606111425', count=count+1 where
sid='99eeb2a6426095d5708d0a5149196bae' and name='CDRc'

manually it is ok
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

This doesn't happen all the time.  It appears that something happens after a
while and then I start getting the
MySQL error: 1036 (Table 'active_sessions' is read only) Session halted.
errors.

I will have to look into this more.  If anyone has any ideas let me know.






On Tue, Jun 7, 2011 at 8:10 AM, Tijmen de Mes <tijmen at ag-projects.com>wrote:

> 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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110607/8ca617d6/attachment-0001.htm>


More information about the Users mailing list