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

[Julien Chavanton]

Hi Alex, I have done some tests in a lab with dmq usrloc,

------------------------------------------------------
version: kamailio 5.1.0 (x86_64/linux)

commit 28011aa9fdca7012103506d9a437c8e44dc8963c
Author: Daniel-Constantin Mierla <miconda at gmail.com>
Date:   Mon Dec 11 16:31:31 2017 +0100
------------------------------------------------------

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 ?

Maybe double check the DB schema, just in case ?
../kamailio/utils/kamctl/postgres/usrloc-create.sql


Maybe you could send the trace of the SIP REGISTER to emulate it in the
test.



The config I modified to try to test yours :

# ----- usrloc params -----
modparam("usrloc", "db_url", "postgres://
postgres:cacao at 127.0.0.1:5432/kamailio510")
modparam("usrloc", "db_mode", 3)
modparam("usrloc", "db_load", 0)
#modparam("usrloc", "db_insert_update", 1)
modparam("usrloc", "use_domain", 1)
modparam("usrloc", "nat_bflag", 6)
modparam("usrloc", "matching_mode", 2)
modparam("usrloc", "fetch_rows", 10000)
modparam("usrloc", "timer_interval", 5)
modparam("usrloc", "timer_procs", 1)
modparam("usrloc", "db_timer_clean", 1)
modparam("usrloc", "hash_size", 19)
# extra just for testing
modparam("usrloc", "nat_bflag", 1)
modparam("usrloc", "desc_time_order", 0)
modparam("usrloc", "matching_mode", 0)
modparam("usrloc", "cseq_delay", 10)
modparam("usrloc", "fetch_rows", 1000)
modparam("usrloc", "hash_size", 16)

#!ifdef WITH_DMQ
loadmodule "dmq.so"
loadmodule "dmq_usrloc.so"
modparam("dmq", "server_address", "sip:127.0.1.103:5060")
modparam("dmq", "notification_address", "sip:127.0.1.101:5060")
modparam("dmq_usrloc", "enable", 1)
modparam("dmq_usrloc", "batch_size", 512)
modparam("dmq_usrloc", "batch_msg_size", 65536)
modparam("dmq_usrloc", "sync", 1)
#!endif





On Mon, Dec 18, 2017 at 6:00 AM, Alex Balashov <abalashov at evaristesys.com>
wrote:

> Hello Charles,
>
> On Mon, Dec 18, 2017 at 11:50:55AM +0000, Charles Chance wrote:
>
> > Can you provide your usrloc and dmq_usrloc module parameters please?
>
> Well, naturally!
>
> modparam("usrloc", "nat_bflag", 1)
> modparam("usrloc", "use_domain", 1)
> modparam("usrloc", "db_url", "DB_DRIVER://DB_USER:DB_PASSWORD@DB_HOST
> /DB_NAME")
> modparam("usrloc", "db_mode", 3)
> modparam("usrloc", "desc_time_order", 0)
> #modparam("usrloc", "timer_interval", 60)
> modparam("usrloc", "matching_mode", 0)
> modparam("usrloc", "cseq_delay", 10)
> modparam("usrloc", "fetch_rows", 1000)
> modparam("usrloc", "hash_size", 16)
> modparam("usrloc", "timer_procs", 1)
>
> modparam("dmq", "server_address", "sip:<elided>:5060")
> modparam("dmq", "notification_address", "sip:evaristesys-testbed-2:5060")
> modparam("dmq_usrloc", "enable", 1)
> modparam("dmq_usrloc", "batch_size", 512)
> modparam("dmq_usrloc", "batch_msg_size", 65536)
>
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171218/6bae33df/attachment.html>