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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
