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

[Bogdan-Andrei Iancu]

agung nugroho wrote:
> Bogdan-Andrei Iancu <bogdan at ...> writes:
>
>   
>> 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
>>
>>     
>
> Pardon me,Bogdan. It was my fault. I forget to setting mysql server.
> I have another problem. When I got finish the mysql problem, I got this error on
> my opensips server:
>
>  WARNING:usrloc:dbrow2info: non-local socket<udp:XXXX:5060>...ignoring
>
> Is that make something goes wrong?? Can I just walk away??
>   
That means you had (at startup time) some registration in DB with an IP 
that is not local to opensips - this may happen if (1) the DB is shared 
between multiple opensips or (2) you changed the IP of opensips.

Whatever cause is, you can ignore the warnings.

Regards,
Bogdan

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