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@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@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
Kamailio (SER) - Users Mailing List sr-users@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users