<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 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 class="moz-signature" cols="72">--
Tijmen de Mes
AG Projects</pre>
<br>
On 11/07/2012 05:27 AM, Duane Larson wrote:<br>
</div>
<blockquote
cite="mid:CAFcM1Eo7y7xOUn0x2QMEr5JFvtRVwBZXX7oucumJ0wLdD9ZwFg@mail.gmail.com"
type="cite">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
moz-do-not-send="true" href="http://server.dns.name:19994">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 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>
<br>
<br>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>