[OpenSIPS-Users] need help on connection CDRTool to opensips

[Tijmen de Mes]

Hi,

You should verify by hand that you can connect to the database by
executing a mysql -h 192.168.1.39 -u opensips -psips  opensips.

Maybe you forgot to remove the bind interfaces directive in the mysql  
config.

Best regards,

Tijmen de Mes
AG Projects

On Nov 9, 2010, at 4:11 AM, ha do wrote:

> Hi all
>
> i installed opensips and mediaproxy in server 1, ip address :  
> 192.168.1.39
> and cdrtool and freeradius in server 2, ip address : 192.168.1.42
>
> the opensips, mediaproxy, freeradius starting are fine
>
>
> i use the link below as a guide
> http://cdrtool.ag-projects.com/browser/doc/INSTALL.txt
>
> the problem i got only with cdrtool
> Nov  9 04:56:22 cdrtool cdrtool[3219]: Read 12291 PSTN destinations  
> from cache
> in 0 seconds
> Nov  9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect  
> as opensips
> to 192.168.1.39 failed
> Nov  9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:   
> (0) select *
> from domain
> Nov  9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect  
> as opensips
> to 192.168.1.39 failed
> Nov  9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:   
> (0) select *
> from trusted
> Nov  9 04:56:22 cdrtool cdrtool[3219]: PSTN destinations cache size:  
> 0.64 MB
> Nov  9 04:56:22 cdrtool cdrtool[3219]: SIP destinations cache size:  
> 0.00 MB
> Nov  9 04:56:22 cdrtool cdrtool[3219]: Cached 12291 total, 12291  
> default, 0
> gateway, 0 domain, 0 subscriber destinations
> Nov  9 04:56:22 cdrtool cdrtool[3219]: Cached 0 SIP destinations
>
>
> the cdrtool is fine with almost component except the connection to  
> opensips
> the global.inc with define opensips server
> class DB_opensips extends DB_Sql {
> var $Host     = "192.168.1.39";
> var $Database = "opensips";
> var $User     = "opensips";
> var $Password = "sips";
> var $Halt_On_Error = "no";
> }
>
> and issue the command  grant all on opensips.* to  
> opensips@'192.168.1.%'
> identified by 'sips'; in opensips server
>
> please help
>
> Ha`
>
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users