<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
It looks like there is something wrong with your database. What
happens if you execute the active sessions query manually?<br>
<br>
Do you have an empty database, or are there valid destinations in
ther (from the sample data)?<br>
<br>
Best regards,<br>
<br>
--<br>
Tijmen de Mes<br>
AG Projects<br>
<br>
Op 6/6/11 6:37 PM, Duane Larson schreef:
<blockquote
cite="mid:BANLkTi=3nV+t5+T_2mhO7OHDfHrT-vNr7g@mail.gmail.com"
type="cite">
<div>I am having some database errors with a new install of
CDRTool. One error I keep seeing in my syslog is</div>
<div> </div>
<div>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</div>
<div> </div>
<div> </div>
<div>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.</div>
<div> </div>
<div> </div>
<div>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</div>
<div> </div>
<div> </div>
<div>MySQL error: 1036 (Table 'active_sessions' is read only)
Session halted. </div>
<div> </div>
<div>When I look in the syslog I see the following error</div>
<div> </div>
<div>Database error: Invalid SQL: update active_sessions set
val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtP<br>
nB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoO<br>
yAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nX<br>
SA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1d<br>
GgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg',
changed='20110606111425', count=count+1 where sid=<br>
'99eeb2a6426095d5708d0a5149196bae' and name='CDRc'</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div>If I stop cdrtool and try to restart it I am not able to
restart CDRTool and see the following error in syslog</div>
<div>Database error: Invalid SQL: delete from memcache where `key`
= 'destinations_sip' or `key` = 'destinations'</div>
<div> </div>
<div>In order to get CDRTool to start up again I have to stop and
restart MySQL database.</div>
<div> </div>
<div>Any ideas what could be wrong? This is the latest version of
CDRTool and I am running it on Ubuntu Maverick.</div>
<div> </div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>