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

[Alex Balashov]

Julien,

I am running PG 10. That is the only difference I can discern thus far,
but let me compare your notes to mine and see if I can spot anything.

Thank you very much for your testing and assistance!

On Mon, Dec 18, 2017 at 08:33:26PM -0800, Julien Chavanton wrote:

> 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
> >

> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


-- 
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/