[OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist

[Tijmen de Mes]

Hi,

Ok, I can't see quickly where it goes wrong, in my opinion it should 
just work.

Tomorrow I can do some tests to see if I can track where it goes wrong.

Best regards,

-- 
Tijmen de Mes
AG Projects


On 11/07/2012 04:02 PM, Duane Larson wrote:
> Hey Tijmen,
>
> Yes
> show processlist
> | 386 | aethercom | 10.179.74.213:57335 <http://10.179.74.213:57335> | 
> cdrtool  | Sleep   |    6 |       | NULL
>
> 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.
>
> class DB_CDRTool extends DB_Sql {
>   var $Host     = "int.serverdnsname:19994";
>   var $Database = "cdrtool";
>   var $User     = "user";
>   var $Password = "password";
>   var $Halt_On_Error ="yes";
> }
>
> class DB_Locker extends DB_Sql {
>   var $Host     = "int.serverdnsname:19994";
>   var $Database = "cdrtool";
>   var $User     = "user";
>   var $Password = "password";
>   var $Halt_On_Error ="yes";
> }
>
> class DB_radius extends DB_Sql {
>   var $Host     = "int.serverdnsname:19994";
>   var $Database = "radius";
>   var $User     = "user";
>   var $Password = "password";
>   var $Halt_On_Error ="yes";
> }
>
> class DB_opensips extends DB_Sql {
>   var $Host     = "int.serverdnsname:19994";
>   var $Database = "opensips";
>   var $User     = "user";
>   var $Password = "password";
>   var $Halt_On_Error ="yes";
> }
>
> class DB_mediaproxy extends DB_Sql {
>   var $Host     = "int.serverdnsname:19994";
>   var $Database = "mediaproxy";
>   var $User     = "user";
>   var $Password = "password";
>   var $Halt_On_Error ="yes";
> }
>
>
> On Wed, Nov 7, 2012 at 8:33 AM, Tijmen de Mes <tijmen at ag-projects.com 
> <mailto:tijmen at ag-projects.com>> wrote:
>
>     Hi Duane,
>
>     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?
>
>     Best regards,
>
>     -- 
>     Tijmen de Mes
>     AG Projects
>
>
>     On 11/07/2012 05:27 AM, Duane Larson wrote:
>>     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
>>
>>     MySQL error: 1146 (Table 'opensips.active_sessions' doesn't
>>     exist) Session halted.
>>
>>     then if I click the "search" button it says
>>
>>     MySQL error: 1146 (Table 'opensips.radacct201211' doesn't exist)
>>     Session halted.
>>
>>     The only big change that I made was in the global.inc for CDRTool
>>     I set the $Host variables to point to "server.dns.name:19994
>>     <http://server.dns.name:19994>".  So the only real difference is
>>     that I have added a port that isn't 3306.
>>
>>     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.
>>
>>     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.
>>
>>     I went ahead and upgraded to the latest version of CDRTool and I
>>     still see the issue.  So the upgrade didn't help any.
>>
>>
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> -- 
> --
> *--*--*--*--*--*
> Duane
> *--*--*--*--*--*
> --
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121107/a683727b/attachment-0001.htm>