Hey Tijmen,<div><br></div><div>Yes</div><div>show processlist</div><div>| 386 | aethercom | <a href="http://10.179.74.213:57335">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 class="h5">
<br>
On 11/07/2012 05:27 AM, Duane Larson wrote:<br>
</div></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>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>
<pre cols="72"></pre>
</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>