I'm at a loss. I upgraded everything on the server, php and all, and that didn't really help. I no longer get the "MySQL error: 1146 (Table 'opensips.active_sessions' doesn't exist) Session halted" error when I log in but if I do a search I still get "MySQL error: 1146 (Table 'opensips.radacct201211' doesn't exist) Session halted". It doesn't make any sense because if I use the old MySQL server I don't have this issue at all. What else could there be that tells CDRTool to look in the opensips database because the global.inc is set to look in the radius database??<div>
<br></div><div><br><br><div class="gmail_quote">On Thu, Nov 8, 2012 at 12:18 PM, Adrian Georgescu <span dir="ltr"><<a href="mailto:ag@ag-projects.com" target="_blank">ag@ag-projects.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">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.<span class="HOEnZb"><font color="#888888"><div>
<br></div><div>Adrian</div><div><br></div></font></span><div><div><div><div class="h5"><div>On Nov 7, 2012, at 5:27 AM, Duane Larson wrote:</div><br></div></div><blockquote type="cite"><div><div class="h5">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/" target="_blank">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></div></div><div class="im">
_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></blockquote></div><br></div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>
</div>