[OpenSIPS-Users] Help!! How to do failover of mysql connection

[Bogdan-Andrei Iancu]

Hi,

are you sure the mysql server on 10.14.11.2 is configured to listen on a 
network interface (and not only on local host) ? check on the 
10.14.11.2  with "netstat -tlnp | grep mysqld" and see if mysql is 
listed as TCP listener.

Regards,
Bogdan

agung nugroho wrote:
> Krunal Patel <krunal.lists at ...> writes:
>
>   
>> HiThanks for your help.I have installed mysql-proxy.I have tested it for
>> failover.It seems working.Thanks again..Krunal Patel
>>     
>
>
> Hi krunal Patel,
> I was read your post about failover of mysql. I still dont understand it.
> Actually my need is to connect opensips with mysql that in other PC.
> How can I do that?? I using opensips-1.6.1-notls.
> My configuration is opensips on 10.14.11.1 and mysql server on 10.14.11.2
> I have been try this setting:
> modparam("usrloc", "db_url", "mysql://root:******@10.14.11.2/opensips")
> or
> modparam("usrloc", "db_url", "mysql://root:******@10.14.11.2:3306/opensips")
> But I still get error :
> ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect to MySQL
> server on '10.14.11.2' (111)
>
> Is there any solution???
>
> thanks before.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro