[SR-Users] dmq_usrloc, usrloc:db_mode 3, and PostgreSQL

[Julien Chavanton]

kamailio510=# SELECT version();

version
-------------------------------------------------------------------------------------------------
 PostgreSQL 9.5.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit
(1 row)



#
U 127.0.0.1:5061 -> 127.0.1.101:5060
REGISTER sip:flowroute.com SIP/2.0.
Via: SIP/2.0/UDP 127.0.1.1:5061;branch=z9hG4bK-29823-2-0.
Via: SIP/2.0/UDP 1.1.1.2:5061;branch=z9hG4bK-29823-2-0.
From: <sip:10001 at flowroute.com>;tag=2.
To: <sip:10001 at flowroute.com>.
Call-ID: 2-29823 at 127.0.1.1.
CSeq: 1 REGISTER.
Contact: sip:10001-1 at 1.1.1.2:5061.
Max-Forwards: 10.
Expires: 3000.
Content-Length: 0.
Path: <sip:127.0.1.1:5061;lr>.
.

#
U 127.0.1.101:5060 -> 127.0.1.103:5060
KDMQ sip:usrloc at 127.0.1.103:5060 SIP/2.0.
Via: SIP/2.0/UDP
127.0.1.101;branch=z9hG4bKdd91.f90e0903000000000000000000000000.0.
To: <sip:usrloc at 127.0.1.103:5060>.
From: <sip:usrloc at 127.0.1.101:5060
>;tag=36786f8e01b2230090da58c495caeae0-9338.
CSeq: 10 KDMQ.
Call-ID: 567aa40265453df7-29439 at 127.0.1.101.
Content-Length: 304.
User-Agent: kamailio (5.1.0 (x86_64/linux)).
Max-Forwards: 1.
Content-Type: application/json.
.
{"action":1,"aor":"10001","ruid":"uloc-5a3891cf-72ff-1","c":"
sip:10001-1 at 1.1.1.2:5061","received":"","path":"","callid":"
2-29823 at 127.0.1.1
","user_agent":"n/a","instance":"","expires":1513660874,"cseq":1,"flags":0,"cflags":0,"q":-1,"last_modified":1513657874,"methods":4294967295,"reg_id":0,"server_id":0}
#
U 127.0.1.101:5060 -> 127.0.0.1:5061
SIP/2.0 200 OK.
Via: SIP/2.0/UDP 127.0.1.1:5061;branch=z9hG4bK-29823-2-0;received=127.0.0.1.
Via: SIP/2.0/UDP 1.1.1.2:5061;branch=z9hG4bK-29823-2-0.
From: <sip:10001 at flowroute.com>;tag=2.
To: <sip:10001 at flowroute.com>;tag=3a03bde2e7478628969f6eb67250a042.25c7.
Call-ID: 2-29823 at 127.0.1.1.
CSeq: 1 REGISTER.
Contact: <sip:10001-1 at 1.1.1.2:5061>;expires=3000,
<sip:10001-2 at 1.1.1.2:5061>;expires=1917,
<sip:10001-3 at 1.1.1.2:5061>;expires=1917, <sip:10001-4 at 1.1.1.2:5061
>;expires=1917.
Server: kamailio (5.1.0 (x86_64/linux)).
Content-Length: 0.
.




On Mon, Dec 18, 2017 at 8:26 PM, Alex Balashov <abalashov at evaristesys.com>
wrote:

> Hello Julien,
>
> On Mon, Dec 18, 2017 at 08:17:54PM -0800, Julien Chavanton wrote:
>
> > Hi Alex, I have done some tests in a lab with dmq usrloc,
>
> Thank you for that!
>
> > With almost the same settings, only 2 servers using DMQ, the contacts are
> > written into postgres when replicated, I wonder what is the problem you
> are
> > facing ?
>
> I wonder that too. :-) What version of PG?
>
> > Maybe double check the DB schema, just in case ?
> > ../kamailio/utils/kamctl/postgres/usrloc-create.sql
>
> Yep, that's one of the first things I did. It's 100% conformant.
>
> Also, usrloc db_mode 3 without dmq_usrloc works just fine. This is
> something highly specific to dmq_usrloc.
>
> > Maybe you could send the trace of the SIP REGISTER to emulate it in the
> > test.
>
> I'm just testing pretty standard registrations from Bria on Android.
>
> -- Alex
>
> --
> Alex Balashov | Principal | Evariste Systems LLC
>
> Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
> Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171218/96872f26/attachment.html>