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

[Duane Larson]

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.

class DB_CDRTool extends DB_Sql {
  var $Host     = "10.178.225.*";
  var $Database = "cdrtool";
  var $User     = "user";
  var $Password = "pass";
  var $Halt_On_Error ="yes";
}

class DB_Locker extends DB_Sql {
  var $Host     = "10.178.225.*";
  var $Database = "cdrtool";
  var $User     = "locker";
  var $Password = "pass";
  var $Halt_On_Error ="yes";
}

class DB_radius extends DB_Sql {
  var $Host     = "10.178.225.*";
  var $Database = "radius";
  var $User     = "radadmin";
  var $Password = "pass";
  var $Halt_On_Error ="yes";
}

class DB_opensips extends DB_Sql {
  var $Host     = "10.178.225.*";
  var $Database = "opensips";
  var $User     = "opensips";
  var $Password = "aether1234";
  var $Halt_On_Error ="yes";
}

class DB_mediaproxy extends DB_Sql {
  var $Host     = "10.178.225.*";
  var $Database = "mediaproxy";
  var $User     = "mediaadmin";
  var $Password = "pass";
  var $Halt_On_Error ="yes";
}


So it works with the old mysql server but not with the new server.



On Wed, Nov 7, 2012 at 9:18 AM, Tijmen de Mes <tijmen at ag-projects.com>wrote:

>  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 | 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>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".  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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
>  --
> --
> *--*--*--*--*--*
> Duane
> *--*--*--*--*--*
> --
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121107/a11ed502/attachment-0001.htm>