[OpenSIPS-Users] Shared 'location' table?

[Chris Maciejewski]

On 24 April 2010 00:14, Iñaki Baz Castillo <ibc at aliax.net> wrote:
> 2010/4/23 RAJNIKANT VANZA <rajnivanza at gmail.com>:
>> Hi Chris,
>>
>> You want to try for 2 opensips + 1 MySQL database.
>>
>> As per my knowledge u can write listen = "0.0.0.0" ipaddress in both
>> opensip.crf file and try it.
>>
>> I have configured for 2 kamailio + 1 MySQL database scenaris and its work
>> successful.
>
> This will not solve the problem, as OpenSIPS-1 still will write its
> *own* address (different than OpenSIPS-2's address) in "socket"
> column.
>

Actually I want both OpenSIPs1/2 to write its own address in "socket"
column, but also what I want is OpenSIPs1 to ignore all records but
it's *own", and OpenSIPs2 to ignore all records but it's *own*.

It seems to me at the moment userloc module runs the following query
to fetch contacts:

"select received, contact, socket, cflags, path from location where
expires > '2010-04-24 11:04:15' and cflags & 0 = 0 and id % 30 = 4"

and what would solve my problem is to append ' WHERE socket IN
('udp:my_addres1:5060','udp:my_address2:5060')

so the query would look like:

"select received, contact, socket, cflags, path from location where
expires > '2010-04-24 11:04:15' and cflags & 0 = 0 and id % 30 = 4 and
socket IN ('udp:my_addres1:5060','udp:my_address2:5060')"

It this possible at all?