[Kamailio-Users] openser - asterisk - methods field location table

[Matteo Piazza]

Hello,

The issue is when I restart openser, it reads the data into the database
and this is the result of the openserctl ul show:

Contact:: sip:s at 172.25.18.168 Q=
			Expires:: 20
			Callid:: 1bcc8b3150934e9d49cc88254ec31d44 at 172.25.18.168
			Cseq:: 489
			User-agent:: Asterisk PBX 1.4 Test
			State:: CS_SYNC
			Flags:: 0
			Cflag:: 0
			Socket:: udp:172.25.18.163:5060
			Methods:: 0

As you can see the Methods is 0 and not 4294967295. So when I do a
lookup(location) the function return as $retcode -2

When the asterisk register himself the methods come back to 4294967295.

This my cfg for the db_mode

# ----- usrloc params -----
modparam("usrloc", "db_mode",   2)
modparam("usrloc", "db_url",
"postgres://openser:openserrw@localhost/openser")

This happened if I use like client asterisk, if I use x-lite, for
example, I didn't notice this problem.

Until now the solution is keep the registration time very low.

Regards
Matteo

Il giorno gio, 13/11/2008 alle 14.21 +0100, Henning Westerholt ha
scritto:
> On Thursday 13 November 2008, Matteo Piazza wrote:
> > I'm using openser 1.3.3. And I found an issue between asterisk and
> > openser.
> >
> > When an asterisk register himself to openser this is my opeserctl ul
> > show:
> > Contact:: sip:s at 172.25.18.168 Q=
> > [..]
> > 			Methods:: 4294967295
> >
> > In to the postgres database into location table I have
> >
> > 2;"50001";"ttnnet.it";"sip:s at 172.25.18.168";"";"";"2008-11-13
> > 10:56:24";-1;"76e873601b776e8a430237091a76a483 at 172.25.18.168";108;"2008-11-
> >13 10:54:24";0;0;"Asterisk PBX 1.4 Test";"udp:172.25.18.163:5060";
> >
> > As you can see the methods field into the database is null!
> >
> > This causes an issue when you restart openser, the asterisk pbx is
> > unreachable until the next registration because the lookup function
> > doesn't match the methods field.
> >
> > The number 4294967295 is the max int (without sign), maybe there is a
> > issue in the function that calculate this value and post the query.
> 
> Hi Matteo,
> 
> the value of 4294967295 is the default, when no allow header is set. This is 
> represented in the DB as NULL. So this is probably not the source of your 
> problem. What db_mode do you use? Normally openser should reload the contacts 
> during startup.
> 
> Cheers,
> 
> Henning