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@flowroute.com>;tag=2.
To: <sip:10001@flowroute.com>.
Call-ID: 2-29823@127.0.1.1.
CSeq: 1 REGISTER.
Contact: sip:10001-1@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@127.0.1.103:5060 SIP/2.0.
Via: SIP/2.0/UDP 127.0.1.101;branch=z9hG4bKdd91.f90e0903000000000000000000000000.0.
To: <sip:usrloc@127.0.1.103:5060>.
From: <sip:usrloc@127.0.1.101:5060>;tag=36786f8e01b2230090da58c495caeae0-9338.
CSeq: 10 KDMQ.
Call-ID: 567aa40265453df7-29439@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@1.1.1.2:5061","received":"","path":"","callid":"2-29823@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@flowroute.com>;tag=2.
To: <sip:10001@flowroute.com>;tag=3a03bde2e7478628969f6eb67250a042.25c7.
Call-ID: 2-29823@127.0.1.1.
CSeq: 1 REGISTER.
Contact: <sip:10001-1@1.1.1.2:5061>;expires=3000, <sip:10001-2@1.1.1.2:5061>;expires=1917, <sip:10001-3@1.1.1.2:5061>;expires=1917, <sip:10001-4@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@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@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users