<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I recall seeing this myself once. Then it was caused by a broken or mismatched with the server version PHP mysql client library. Upgrading it solve the issue at that time.<div><br></div><div>Adrian</div><div><br></div><div><div><div>On Nov 7, 2012, at 5:27 AM, Duane Larson wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">I have been running CDRTool for a long time (about 2 or 3 years) and today I moved the mysql database over to a new server. For some reason when I log into CDRTool I see the following at the bottom of the screen<div><br></div>
<div><span style="color:rgb(51,51,51);font-family:'Luxino Sans',Verdana,Arial,Helvetica,sans-serif;font-size:13px;line-height:14px;background-color:rgb(207,207,207)">MySQL error: 1146 (Table 'opensips.active_sessions' doesn't exist) Session halted.</span><br>
</div><div><br></div><div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px">then if I click the "search" button it says</span></font></div><div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px"><br>
</span></font></div><div><span style="color:rgb(51,51,51);font-family:'Luxino Sans',Verdana,Arial,Helvetica,sans-serif;font-size:13px;line-height:14px;background-color:rgb(207,207,207)">MySQL error: 1146 (Table 'opensips.radacct201211' doesn't exist) Session halted.</span><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px"><br>
</span></font></div><div><br></div><div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px">The only big change that I made was in the global.inc for CDRTool I set the $Host variables to point to "<a href="http://server.dns.name:19994/">server.dns.name:19994</a>". So the only real difference is that I have added a port that isn't 3306.</span></font></div>
<div><br></div><div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px">I don't see any issues with CDRTool connecting to the database but I have no clue why it now wants to try and look in the opensips database for the active_sessions and radacct201211 table.</span></font></div>
<div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px"><br></span></font></div><div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px">Like I say all I did was move over to a new mysql server so the configs for freeradius and cdrtool didn't change except for pointing to the new server.</span></font></div>
<div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px"><br></span></font></div><div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px">I went ahead and upgraded to the latest version of CDRTool and I still see the issue. So the upgrade didn't help any.</span></font></div>
<div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px"><br></span></font></div><div><font color="#333333" face="Luxino Sans, Verdana, Arial, Helvetica, sans-serif"><span style="line-height:14px"><br>
</span></font></div>
_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>http://lists.opensips.org/cgi-bin/mailman/listinfo/users<br></blockquote></div><br></div></body></html>