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

[Tijmen de Mes]

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
> 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/d8a094c9/attachment.htm>