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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
