Ok. Just to test I swung back over to the old CDRTool mysql database and everything works like normal (plus CDRTool is now version 9 instead of the older version I was running). Here is the global.inc config for database connectivity. <div>
<br></div><div><div>class DB_CDRTool extends DB_Sql {</div><div> var $Host = "10.178.225.*";</div><div> var $Database = "cdrtool";</div><div> var $User = "user";</div><div> var $Password = "pass";</div>
<div> var $Halt_On_Error ="yes";</div><div>}</div><div><br></div><div>class DB_Locker extends DB_Sql {</div><div> var $Host = "10.178.225.*";</div><div> var $Database = "cdrtool";</div>
<div> var $User = "locker";</div><div> var $Password = "pass";</div><div> var $Halt_On_Error ="yes";</div><div>}</div><div><br></div><div>class DB_radius extends DB_Sql {</div><div> var $Host = "10.178.225.*";</div>
<div> var $Database = "radius";</div><div> var $User = "radadmin";</div><div> var $Password = "pass";</div><div> var $Halt_On_Error ="yes";</div><div>}</div><div><br></div><div>
class DB_opensips extends DB_Sql {</div><div> var $Host = "10.178.225.*";</div><div> var $Database = "opensips";</div><div> var $User = "opensips";</div><div> var $Password = "aether1234";</div>
<div> var $Halt_On_Error ="yes";</div><div>}</div><div><br></div><div>class DB_mediaproxy extends DB_Sql {</div><div> var $Host = "10.178.225.*";</div><div> var $Database = "mediaproxy";</div>
<div> var $User = "mediaadmin";</div><div> var $Password = "pass";</div><div> var $Halt_On_Error ="yes";</div><div>}</div><div><br></div><div><br></div><div>So it works with the old mysql server but not with the new server.</div>
<div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Nov 7, 2012 at 9:18 AM, Tijmen de Mes <span dir="ltr"><<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@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 bgcolor="#FFFFFF" text="#000000">
<div>Hi,<br>
<br>
Ok, I can't see quickly where it goes wrong, in my opinion it
should just work. <br>
<br>
Tomorrow I can do some tests to see if I can track where it goes
wrong.<div class="im"><br>
<br>
Best regards,<br>
<pre cols="72">--
Tijmen de Mes
AG Projects</pre>
<br></div><div><div class="h5">
On 11/07/2012 04:02 PM, Duane Larson wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">Hey Tijmen,
<div><br>
</div>
<div>Yes</div>
<div>show processlist</div>
<div>| 386 | aethercom | <a href="http://10.179.74.213:57335" target="_blank">10.179.74.213:57335</a> |
cdrtool | Sleep | 6 | | NULL <br>
</div>
<div><br>
</div>
<div>I even changed the the mysql server name on my global.inc to
be something wrong to see if restarting cdrtool would fail and
it did fail. So its not failing when the info is correct. This
is what I have.</div>
<div><br>
</div>
<div>
<div>class DB_CDRTool extends DB_Sql {</div>
<div> var $Host = "int.serverdnsname:19994";</div>
<div> var $Database = "cdrtool";</div>
<div> var $User = "user";</div>
<div> var $Password = "password";</div>
<div> var $Halt_On_Error ="yes";</div>
<div>}</div>
<div><br>
</div>
<div>class DB_Locker extends DB_Sql {</div>
<div> var $Host = "int.serverdnsname:19994";</div>
<div> var $Database = "cdrtool";</div>
<div> var $User = "user";</div>
<div> var $Password = "password";</div>
<div> var $Halt_On_Error ="yes";</div>
<div>}</div>
<div><br>
</div>
<div>class DB_radius extends DB_Sql {</div>
<div> var $Host = "int.serverdnsname:19994";</div>
<div> var $Database = "radius";</div>
<div> var $User = "user";</div>
<div> var $Password = "password";</div>
<div> var $Halt_On_Error ="yes";</div>
<div>}</div>
<div><br>
</div>
<div>
class DB_opensips extends DB_Sql {</div>
<div> var $Host = "int.serverdnsname:19994";</div>
<div> var $Database = "opensips";</div>
<div> var $User = "user";</div>
<div> var $Password = "password";</div>
<div> var $Halt_On_Error ="yes";</div>
<div>}</div>
<div><br>
</div>
<div>class DB_mediaproxy extends DB_Sql {</div>
<div> var $Host = "int.serverdnsname:19994";</div>
<div> var $Database = "mediaproxy";</div>
<div> var $User = "user";</div>
<div> var $Password = "password";</div>
<div> var $Halt_On_Error ="yes";</div>
<div>}</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
On Wed, Nov 7, 2012 at 8:33 AM, Tijmen de Mes <span dir="ltr"><<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@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 bgcolor="#FFFFFF" text="#000000">
<div>Hi Duane,<br>
<br>
So to narrow it down, CDRTool is able to connect to the
db ( you see them in the processlist?), but then it
looks in the wrong databases?<br>
<br>
Best regards,<br>
<br>
<pre cols="72">--
Tijmen de Mes
AG Projects</pre>
<div>
<div> <br>
On 11/07/2012 05:27 AM, Duane Larson wrote:<br>
</div>
</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>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>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>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>
</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>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</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>