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

[Charles Chance]

Julian - thanks for testing, I had very little time yesterday!

Alex - the only thing I can suggest is to check the table name on your
receiving node as by default the replicated contacts will use “location”.
If the table name is different then you’ll need to set the domain parameter
of dmq_usrloc. Either way, when dmq writes a replicated contact it uses the
usrloc API and is entirely independent of the underlying storage method. So
if there is an issue I suspect it’s somewhere else.

Cheers,

Charles

On Tue, 19 Dec 2017 at 05:00, Alex Balashov <abalashov at evaristesys.com>
wrote:

> 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/
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-- 
*Charles Chance*
Managing Director

t. 0330 120 1200    m. 07932 063 891

-- 
Sipcentric Ltd. Company registered in England & Wales no. 7365592. Registered 
office: Faraday Wharf, Innovation Birmingham Campus, Holt Street, 
Birmingham Science Park, Birmingham B7 4BB.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171219/e3305af4/attachment.html>