<br><br><div class="gmail_quote">2010/4/22 Chris Maciejewski <span dir="ltr"><<a href="mailto:chris@wima.co.uk">chris@wima.co.uk</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div><div></div><div class="h5">On 22 April 2010 17:47, Laszlo <<a href="mailto:laszlo@voipfreak.net">laszlo@voipfreak.net</a>> wrote:<br>
> 2010/4/22 Chris Maciejewski <<a href="mailto:chris@wima.co.uk">chris@wima.co.uk</a>><br>
>> On 22 April 2010 17:30, Laszlo <<a href="mailto:laszlo@voipfreak.net">laszlo@voipfreak.net</a>> wrote:<br>
>> > 2010/4/22 Chris Maciejewski <<a href="mailto:chris@wima.co.uk">chris@wima.co.uk</a>><br>
>> >> Hi,<br>
>> >><br>
>> >> I'm trying to run two opensips instances accessing one MySQL database<br>
>> >> using the usrloc db-only mode.<br>
>> >><br>
>> >> This results in the following warning in my log files:<br>
>> >><br>
>> >> "WARNING:usrloc:get_all_db_ucontacts: non-local socket<br>
>> >> <udp:xxx.xxx.xxx.xxx:5060>...ignoring"<br>
>> >><br>
>> >> The only discussion/solution I found was in some old openser mailing<br>
>> >> list thread:<br>
>> >> <a href="http://www.mail-archive.com/users@openser.org/msg05974.html" target="_blank">http://www.mail-archive.com/users@openser.org/msg05974.html</a><br>
>> >><br>
>> >> What is the "right" way of handling the above scenario: 2x opensips +<br>
>> >> 1x<br>
>> >> MySQL ?<br>
>> >> Is mhomed=1 the correct solution?<br>
>> >><br>
>> >> Thanks and best regards,<br>
>> >> Chris<br>
>> >><br>
>> ><br>
>> > Try to set mhomed=1<br>
>> ><br>
>> > -Laszlo<br>
>> ><br>
>><br>
>> Hi, thanks for suggestion, but when I added mhomed=1 I am getting the<br>
>> following error:<br>
>><br>
>> WARNING:usrloc:get_all_db_ucontacts: non-local socket<br>
>> <udp:xxx.xxx.xxx.xxx:5060>...ignoring<br>
>> ERROR:core:get_out_socket: no socket found<br>
>> ERROR:nathelper:nh_timer: can't get sending socket<br>
>><br>
>> Any ideas?<br>
>><br>
><br>
</div></div><div class="im">> usrloc is in "db only" mode?<br>
><br>
> -Laszlo<br>
<br>
</div>Yes, it is: modparam("usrloc", "db_mode", 3)<br>
<br>
Just to clarify. I am running two instances of opensips on two<br>
different servers (so obviously both are bound do different public IP<br>
addresses) using the same 'location' table on central MySQL server.<br>
<br>
Therefore in my 'location' table some entries in 'socket' column are:<br>
aaa.bbb.ccc.ddd:5060<br>
and others are: ppp.ttt.qqq.zzz:5060<br>
<div><div></div><div class="h5"><br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></div></div></blockquote><div><br>ahh, then it's a problem, with NAT, there will be a conflict with the stored sockets.<br>
Let's say proxy1 inserts a record with socket "proxy1", and then proxy2 will read it and will try to use socket "proxy1', that will fail (not local).<br><br>-Laszlo<br></div></div><br><div style="visibility: hidden; display: inline;" id="avg_ls_inline_popup">
</div><style type="text/css">#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 13px;}</style>