<div><div dir="auto">Julian - thanks for testing, I had very little time yesterday!</div><div dir="auto"><br></div><div dir="auto">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.</div><div dir="auto"><br></div><div dir="auto">Cheers,</div><div dir="auto"><br></div><div dir="auto">Charles</div><br><div class="gmail_quote"><div>On Tue, 19 Dec 2017 at 05:00, Alex Balashov <<a href="mailto:abalashov@evaristesys.com">abalashov@evaristesys.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Julien,<br>
<br>
I am running PG 10. That is the only difference I can discern thus far,<br>
but let me compare your notes to mine and see if I can spot anything.<br>
<br>
Thank you very much for your testing and assistance!<br>
<br>
On Mon, Dec 18, 2017 at 08:33:26PM -0800, Julien Chavanton wrote:<br>
<br>
> kamailio510=# SELECT version();<br>
><br>
> version<br>
> -------------------------------------------------------------------------------------------------<br>
> PostgreSQL 9.5.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu<br>
> 4.8.2-19ubuntu1) 4.8.2, 64-bit<br>
> (1 row)<br>
><br>
><br>
><br>
> #<br>
> U <a href="http://127.0.0.1:5061" rel="noreferrer" target="_blank">127.0.0.1:5061</a> -> <a href="http://127.0.1.101:5060" rel="noreferrer" target="_blank">127.0.1.101:5060</a><br>
> REGISTER sip:<a href="http://flowroute.com" rel="noreferrer" target="_blank">flowroute.com</a> SIP/2.0.<br>
> Via: SIP/2.0/UDP 127.0.1.1:5061;branch=z9hG4bK-29823-2-0.<br>
> Via: SIP/2.0/UDP 1.1.1.2:5061;branch=z9hG4bK-29823-2-0.<br>
> From: <<a href="mailto:sip%3A10001@flowroute.com" target="_blank">sip:10001@flowroute.com</a>>;tag=2.<br>
> To: <<a href="mailto:sip%3A10001@flowroute.com" target="_blank">sip:10001@flowroute.com</a>>.<br>
> Call-ID: <a href="mailto:2-29823@127.0.1.1" target="_blank">2-29823@127.0.1.1</a>.<br>
> CSeq: 1 REGISTER.<br>
> Contact: <a href="http://sip:10001-1@1.1.1.2:5061" rel="noreferrer" target="_blank">sip:10001-1@1.1.1.2:5061</a>.<br>
> Max-Forwards: 10.<br>
> Expires: 3000.<br>
> Content-Length: 0.<br>
> Path: <sip:127.0.1.1:5061;lr>.<br>
> .<br>
><br>
> #<br>
> U <a href="http://127.0.1.101:5060" rel="noreferrer" target="_blank">127.0.1.101:5060</a> -> <a href="http://127.0.1.103:5060" rel="noreferrer" target="_blank">127.0.1.103:5060</a><br>
> KDMQ <a href="http://sip:usrloc@127.0.1.103:5060" rel="noreferrer" target="_blank">sip:usrloc@127.0.1.103:5060</a> SIP/2.0.<br>
> Via: SIP/2.0/UDP<br>
> 127.0.1.101;branch=z9hG4bKdd91.f90e0903000000000000000000000000.0.<br>
> To: <<a href="http://sip:usrloc@127.0.1.103:5060" rel="noreferrer" target="_blank">sip:usrloc@127.0.1.103:5060</a>>.<br>
> From: <<a href="http://sip:usrloc@127.0.1.101:5060" rel="noreferrer" target="_blank">sip:usrloc@127.0.1.101:5060</a><br>
> >;tag=36786f8e01b2230090da58c495caeae0-9338.<br>
> CSeq: 10 KDMQ.<br>
> Call-ID: <a href="mailto:567aa40265453df7-29439@127.0.1.101" target="_blank">567aa40265453df7-29439@127.0.1.101</a>.<br>
> Content-Length: 304.<br>
> User-Agent: kamailio (5.1.0 (x86_64/linux)).<br>
> Max-Forwards: 1.<br>
> Content-Type: application/json.<br>
> .<br>
> {"action":1,"aor":"10001","ruid":"uloc-5a3891cf-72ff-1","c":"<br>
> <a href="http://sip:10001-1@1.1.1.2:5061" rel="noreferrer" target="_blank">sip:10001-1@1.1.1.2:5061</a>","received":"","path":"","callid":"<br>
> <a href="mailto:2-29823@127.0.1.1" target="_blank">2-29823@127.0.1.1</a><br>
> ","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}<br>
> #<br>
> U <a href="http://127.0.1.101:5060" rel="noreferrer" target="_blank">127.0.1.101:5060</a> -> <a href="http://127.0.0.1:5061" rel="noreferrer" target="_blank">127.0.0.1:5061</a><br>
> SIP/2.0 200 OK.<br>
> Via: SIP/2.0/UDP 127.0.1.1:5061;branch=z9hG4bK-29823-2-0;received=127.0.0.1.<br>
> Via: SIP/2.0/UDP 1.1.1.2:5061;branch=z9hG4bK-29823-2-0.<br>
> From: <<a href="mailto:sip%3A10001@flowroute.com" target="_blank">sip:10001@flowroute.com</a>>;tag=2.<br>
> To: <<a href="mailto:sip%3A10001@flowroute.com" target="_blank">sip:10001@flowroute.com</a>>;tag=3a03bde2e7478628969f6eb67250a042.25c7.<br>
> Call-ID: <a href="mailto:2-29823@127.0.1.1" target="_blank">2-29823@127.0.1.1</a>.<br>
> CSeq: 1 REGISTER.<br>
> Contact: <<a href="http://sip:10001-1@1.1.1.2:5061" rel="noreferrer" target="_blank">sip:10001-1@1.1.1.2:5061</a>>;expires=3000,<br>
> <<a href="http://sip:10001-2@1.1.1.2:5061" rel="noreferrer" target="_blank">sip:10001-2@1.1.1.2:5061</a>>;expires=1917,<br>
> <<a href="http://sip:10001-3@1.1.1.2:5061" rel="noreferrer" target="_blank">sip:10001-3@1.1.1.2:5061</a>>;expires=1917, <<a href="http://sip:10001-4@1.1.1.2:5061" rel="noreferrer" target="_blank">sip:10001-4@1.1.1.2:5061</a><br>
> >;expires=1917.<br>
> Server: kamailio (5.1.0 (x86_64/linux)).<br>
> Content-Length: 0.<br>
> .<br>
><br>
><br>
><br>
><br>
> On Mon, Dec 18, 2017 at 8:26 PM, Alex Balashov <<a href="mailto:abalashov@evaristesys.com" target="_blank">abalashov@evaristesys.com</a>><br>
> wrote:<br>
><br>
> > Hello Julien,<br>
> ><br>
> > On Mon, Dec 18, 2017 at 08:17:54PM -0800, Julien Chavanton wrote:<br>
> ><br>
> > > Hi Alex, I have done some tests in a lab with dmq usrloc,<br>
> ><br>
> > Thank you for that!<br>
> ><br>
> > > With almost the same settings, only 2 servers using DMQ, the contacts are<br>
> > > written into postgres when replicated, I wonder what is the problem you<br>
> > are<br>
> > > facing ?<br>
> ><br>
> > I wonder that too. :-) What version of PG?<br>
> ><br>
> > > Maybe double check the DB schema, just in case ?<br>
> > > ../kamailio/utils/kamctl/postgres/usrloc-create.sql<br>
> ><br>
> > Yep, that's one of the first things I did. It's 100% conformant.<br>
> ><br>
> > Also, usrloc db_mode 3 without dmq_usrloc works just fine. This is<br>
> > something highly specific to dmq_usrloc.<br>
> ><br>
> > > Maybe you could send the trace of the SIP REGISTER to emulate it in the<br>
> > > test.<br>
> ><br>
> > I'm just testing pretty standard registrations from Bria on Android.<br>
> ><br>
> > -- Alex<br>
> ><br>
> > --<br>
> > Alex Balashov | Principal | Evariste Systems LLC<br>
> ><br>
> > Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)<br>
> > Web: <a href="http://www.evaristesys.com/" rel="noreferrer" target="_blank">http://www.evaristesys.com/</a>, <a href="http://www.csrpswitch.com/" rel="noreferrer" target="_blank">http://www.csrpswitch.com/</a><br>
> ><br>
> > _______________________________________________<br>
> > Kamailio (SER) - Users Mailing List<br>
> > <a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
> > <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
> ><br>
<br>
> _______________________________________________<br>
> Kamailio (SER) - Users Mailing List<br>
> <a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
> <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br>
<br>
--<br>
Alex Balashov | Principal | Evariste Systems LLC<br>
<br>
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)<br>
Web: <a href="http://www.evaristesys.com/" rel="noreferrer" target="_blank">http://www.evaristesys.com/</a>, <a href="http://www.csrpswitch.com/" rel="noreferrer" target="_blank">http://www.csrpswitch.com/</a><br>
<br>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div></div><div dir="ltr">-- <br></div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><font face="arial, helvetica, sans-serif"><b><font size="2">Charles Chance</font></b><br><font size="2">Managing Director</font></font><br><div><font face="arial, helvetica, sans-serif"><font size="2"><br></font></font></div><div><font face="arial, helvetica, sans-serif"><font size="2">t. 0330 120 1200 m. 07932 063 891</font></font></div></div></div></div></div>
<br>
<div><font color="gray" style="font-size:10pt;font-family:Helvetica,Arial,sans-serif">Sipcentric Ltd.
Company registered in England & Wales no. 7365592.</font><span style="font-size:10pt;font-family:Helvetica,Arial,sans-serif"> </span><font color="gray" style="font-size:10pt;font-family:Helvetica,Arial,sans-serif">Registered
office: Faraday Wharf, Innovation Birmingham Campus, Holt Street, Birmingham Science Park, Birmingham B7 4BB.</font></div>