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>