Ugh. Looked harder at what you said Adrian and the version of MySQL on the Managed service is 5.1.42 and my old MySQL server was 5.5.23-2. Not much I can do with upgrading the Managed MySQL since I have no control. I tried to do ahead and install mysql-server on the CDRTool server itself but since it is Ubuntu 10.10 it comes with version 5.1. So let me try and get mysql verson 5.5 on the CDRTool server and see if all my issues go away like you say.<div>
<br></div><div><br><br><div class="gmail_quote">On Thu, Nov 8, 2012 at 3:50 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">Just a wild guess. An incompatibility between the php mysql client library and the mysql server could cause this. <div><div class="h5"><div><br></div><div><div><div><div>On Nov 8, 2012, at 10:34 PM, Duane Larson wrote:</div>
<br><blockquote type="cite">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><font color="#888888"><div>
<br></div><div>Adrian</div><div><br></div></font></span><div><div><div><div><div>On Nov 7, 2012, at 5:27 AM, Duane Larson wrote:</div><br></div></div><blockquote type="cite"><div><div>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>
_______________________________________________<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" 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>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>
</div>
_______________________________________________<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>
</blockquote></div><br></div></div></div></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>