[sr-dev] db version of nat pinger

[Juha Heinanen]

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?

-- juha