[sr-dev] db version of nat pinger

[Klaus Darilion]

On 15.09.2012 20:53, Juha Heinanen wrote:
> Juha Heinanen writes:
>
>> so it does not help that nathelper has "natping_socket" module param
>> defined, because nathelper does not get a chance to override the
>> socket.
>
> this was not true.  the warning
>
> Sep 15 21:44:18 siika /usr/sbin/sip-proxy[14911]: WARNING: usrloc [dlist.c:232]: non-local socket <udp:192.98.103.2:5070>...ignoring
>
> is not correct.  the entry is NOT ignored and nathelper module starts to
> ping the contact fine:
>
> U 2012/09/15 21:45:58.441183 192.98.103.10:5060 -> 192.98.103.3:5050
>
> should i just go ahead and remove the above warning?  after that it
> appears that dispatcher can be used to do nat pinging.
>
> one more thing.  the all contacts query that usrloc makes looks like
> this:
>
> 120915 21:48:04	 1397 Query	select received, contact, socket, cflags, path, ruid from location where expires > '2012-09-15 21:48:04' and cflags & 0 = 0 and id % 20 = 0
>
> there is currently no index for expires and cflags.  should i add one or
> both of them?

I wonder why "expires" is checked at all? Expired contacts will be 
deleted automatically so the chance to ping expired contacts should be 
very small.

regards
Klaus