Tijmen,<div><br></div><div>For the new MySQL server I am not able to log into it and do any iptables redirects since it is a "managed" mysql solution. But with my old server I configured mysql to work off of port 19994 and pointed CDRTools global.inc to port 19994 on the old server and everything works fine. So something is up with the new mysql servers database. I did a backup of the old database and moved it over to the new database and I also added the radius_accounting.proc to the radius database. If you can think of why CDRTool would want to look in the opensips database let me know.</div>
<div><br></div><div>The only thing I can think to do is to blow away the database that I restored on the new mysql server and start from scratch to see if anything is missing.</div><div><br></div><div><br><br><div class="gmail_quote">
On Thu, Nov 8, 2012 at 6: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>
I am unable to reproduce it. Just as a quick test can you insert
an iptables rule on the mysql server to divert requests on port
3306 from the cdr machine to 19994? That way we can check if
CDRTool tries to use that port even though you specified an other
and rule. You can even put the config back then and see if it
works then. <br>
<br>
In my testing I changed the config to use 19994 and redirected the
port 19994 to 3306 on the mysql server. I got no errors an all was
working.<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 05:27 PM, Duane Larson wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">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><br>
<br>
Best regards,<br>
<pre cols="72">--
Tijmen de Mes
AG Projects</pre>
<br>
</div>
<div>
<div> On 11/07/2012 04:02 PM, Duane Larson
wrote:<br>
</div>
</div>
</div>
<div>
<div>
<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" 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>