<div dir="ltr"><div><br>kamailio510=# SELECT version();<br> version <br>-------------------------------------------------------------------------------------------------<br> PostgreSQL 9.5.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit<br>(1 row)<br><br></div><br><br><span style="font-family:monospace,monospace">#<br>U <a href="http://127.0.0.1:5061">127.0.0.1:5061</a> -> <a href="http://127.0.1.101:5060">127.0.1.101:5060</a><br>REGISTER sip:<a href="http://flowroute.com">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">sip:10001@flowroute.com</a>>;tag=2.<br>To: <<a href="mailto:sip%3A10001@flowroute.com">sip:10001@flowroute.com</a>>.<br>Call-ID: <a href="mailto:2-29823@127.0.1.1">2-29823@127.0.1.1</a>.<br>CSeq: 1 REGISTER.<br>Contact: <a href="http://sip:10001-1@1.1.1.2:5061">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></span><br><span style="font-family:monospace,monospace">#<br>U <a href="http://127.0.1.101:5060">127.0.1.101:5060</a> -> <a href="http://127.0.1.103:5060">127.0.1.103:5060</a><br>KDMQ <a href="http://sip:usrloc@127.0.1.103:5060">sip:usrloc@127.0.1.103:5060</a> SIP/2.0.<br>Via: SIP/2.0/UDP 127.0.1.101;branch=z9hG4bKdd91.f90e0903000000000000000000000000.0.<br>To: <<a href="http://sip:usrloc@127.0.1.103:5060">sip:usrloc@127.0.1.103:5060</a>>.<br>From: <<a href="http://sip:usrloc@127.0.1.101:5060">sip:usrloc@127.0.1.101:5060</a>>;tag=36786f8e01b2230090da58c495caeae0-9338.<br>CSeq: 10 KDMQ.<br>Call-ID: <a href="mailto:567aa40265453df7-29439@127.0.1.101">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":"<a href="http://sip:10001-1@1.1.1.2:5061">sip:10001-1@1.1.1.2:5061</a>","received":"","path":"","callid":"<a href="mailto:2-29823@127.0.1.1">2-29823@127.0.1.1</a>","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">127.0.1.101:5060</a> -> <a href="http://127.0.0.1:5061">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">sip:10001@flowroute.com</a>>;tag=2.<br>To: <<a href="mailto:sip%3A10001@flowroute.com">sip:10001@flowroute.com</a>>;tag=3a03bde2e7478628969f6eb67250a042.25c7.<br>Call-ID: <a href="mailto:2-29823@127.0.1.1">2-29823@127.0.1.1</a>.<br>CSeq: 1 REGISTER.<br>Contact: <<a href="http://sip:10001-1@1.1.1.2:5061">sip:10001-1@1.1.1.2:5061</a>>;expires=3000, <<a href="http://sip:10001-2@1.1.1.2:5061">sip:10001-2@1.1.1.2:5061</a>>;expires=1917, <<a href="http://sip:10001-3@1.1.1.2:5061">sip:10001-3@1.1.1.2:5061</a>>;expires=1917, <<a href="http://sip:10001-4@1.1.1.2:5061">sip:10001-4@1.1.1.2:5061</a>>;expires=1917.<br>Server: kamailio (5.1.0 (x86_64/linux)).<br>Content-Length: 0.<br>.<br></span><br><br><div><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Dec 18, 2017 at 8:26 PM, Alex Balashov <span dir="ltr"><<a href="mailto:abalashov@evaristesys.com" target="_blank">abalashov@evaristesys.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello Julien,<br>
<span class="gmail-"><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>
</span>Thank you for that!<br>
<span class="gmail-"><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 are<br>
> facing ?<br>
<br>
</span>I wonder that too. :-) What version of PG?<br>
<span class="gmail-"><br>
> Maybe double check the DB schema, just in case ?<br>
> ../kamailio/utils/kamctl/<wbr>postgres/usrloc-create.sql<br>
<br>
</span>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>
<span class="gmail-"><br>
> Maybe you could send the trace of the SIP REGISTER to emulate it in the<br>
> test.<br>
<br>
</span>I'm just testing pretty standard registrations from Bria on Android.<br>
<div class="gmail-HOEnZb"><div class="gmail-h5"><br>
-- Alex<br>
<br>
--<br>
Alex Balashov | Principal | Evariste Systems LLC<br>
<br>
Tel: <a href="tel:%2B1-706-510-6800" value="+17065106800">+1-706-510-6800</a> / <a href="tel:%2B1-800-250-5920" value="+18002505920">+1-800-250-5920</a> (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>
______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org">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/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a><br>
</div></div></blockquote></div><br></div></div></div>