<div dir="ltr"><div><div>Hi Alex, I have done some tests in a lab with dmq usrloc,<br><br><span style="font-family:monospace,monospace">------------------------------------------------------</span><br><span style="font-family:monospace,monospace">version: kamailio 5.1.0 (x86_64/linux) <br><br>commit 28011aa9fdca7012103506d9a437c8e44dc8963c<br>Author: Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>><br>Date:   Mon Dec 11 16:31:31 2017 +0100<br>------------------------------------------------------<br><br></span></div><span style="font-family:monospace,monospace">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 ?<br><br></span></div><span style="font-family:monospace,monospace">Maybe double check the DB schema, just in case ?  <br>../kamailio/utils/kamctl/postgres/usrloc-create.sql<br></span><div><span style="font-family:monospace,monospace"><br></span></div><div><span style="font-family:monospace,monospace"><br></span></div><div><span style="font-family:monospace,monospace">Maybe you could send the trace of the SIP REGISTER to emulate it in the test.<br><br><br></span></div><div><span style="font-family:monospace,monospace"><br></span></div><div><span style="font-family:monospace,monospace">The config I modified to try to test yours :<br></span></div><div><span style="font-family:monospace,monospace"><br># ----- usrloc params -----<br>modparam("usrloc", "db_url", "postgres://<a href="http://postgres:cacao@127.0.0.1:5432/kamailio510">postgres:cacao@127.0.0.1:5432/kamailio510</a>")<br>modparam("usrloc", "db_mode", 3)<br>modparam("usrloc", "db_load", 0)<br>#modparam("usrloc", "db_insert_update", 1)<br>modparam("usrloc", "use_domain", 1)<br>modparam("usrloc", "nat_bflag", 6)<br>modparam("usrloc", "matching_mode", 2)<br>modparam("usrloc", "fetch_rows", 10000)<br>modparam("usrloc", "timer_interval", 5)<br>modparam("usrloc", "timer_procs", 1)<br>modparam("usrloc", "db_timer_clean", 1)<br>modparam("usrloc", "hash_size", 19)<br># extra just for testing<br>modparam("usrloc", "nat_bflag", 1)<br>modparam("usrloc", "desc_time_order", 0)<br>modparam("usrloc", "matching_mode", 0)<br>modparam("usrloc", "cseq_delay", 10)<br>modparam("usrloc", "fetch_rows", 1000)<br>modparam("usrloc", "hash_size", 16)<br><br>#!ifdef WITH_DMQ<br>loadmodule "dmq.so"<br>loadmodule "dmq_usrloc.so"<br>modparam("dmq", "server_address", "sip:<a href="http://127.0.1.103:5060">127.0.1.103:5060</a>")<br>modparam("dmq", "notification_address", "sip:<a href="http://127.0.1.101:5060">127.0.1.101:5060</a>")<br>modparam("dmq_usrloc", "enable", 1)<br>modparam("dmq_usrloc", "batch_size", 512)<br>modparam("dmq_usrloc", "batch_msg_size", 65536)<br>modparam("dmq_usrloc", "sync", 1)<br>#!endif<br><br><br></span><div><br><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Dec 18, 2017 at 6:00 AM, 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello Charles,<br>
<span class=""><br>
On Mon, Dec 18, 2017 at 11:50:55AM +0000, Charles Chance wrote:<br>
<br>
> Can you provide your usrloc and dmq_usrloc module parameters please?<br>
<br>
</span>Well, naturally!<br>
<br>
modparam("usrloc", "nat_bflag", 1)<br>
modparam("usrloc", "use_domain", 1)<br>
modparam("usrloc", "db_url", "DB_DRIVER://DB_USER:DB_<wbr>PASSWORD@DB_HOST/DB_NAME")<br>
modparam("usrloc", "db_mode", 3)<br>
modparam("usrloc", "desc_time_order", 0)<br>
#modparam("usrloc", "timer_interval", 60)<br>
modparam("usrloc", "matching_mode", 0)<br>
modparam("usrloc", "cseq_delay", 10)<br>
modparam("usrloc", "fetch_rows", 1000)<br>
modparam("usrloc", "hash_size", 16)<br>
modparam("usrloc", "timer_procs", 1)<br>
<br>
modparam("dmq", "server_address", "sip:<elided>:5060")<br>
modparam("dmq", "notification_address", "sip:evaristesys-testbed-2:<wbr>5060")<br>
modparam("dmq_usrloc", "enable", 1)<br>
modparam("dmq_usrloc", "batch_size", 512)<br>
modparam("dmq_usrloc", "batch_msg_size", 65536)<br>
<div class="HOEnZb"><div class="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>