<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">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.<br>
<br>
Best regards,<br>
<pre class="moz-signature" cols="72">
--
Tijmen de Mes
AG Projects</pre>
<br>
On 11/07/2012 05:27 PM, Duane Larson wrote:<br>
</div>
<blockquote
cite="mid:CAFcM1EqkZLzNDum=SNQ1kOsuP6FKczqQ1jSKFPkhXVGJi+myVw@mail.gmail.com"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:Users@lists.opensips.org"
target="_blank">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
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 class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>