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@172.25.18.168 Q= Expires:: 20 Callid:: 1bcc8b3150934e9d49cc88254ec31d44@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@172.25.18.168 Q= [..] Methods:: 4294967295
In to the postgres database into location table I have
2;"50001";"ttnnet.it";"sip:s@172.25.18.168";"";"";"2008-11-13 10:56:24";-1;"76e873601b776e8a430237091a76a483@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