<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Jonathan,<br>
<br>
If you see the state transition from DIRTY to SYNC, it means the
INSERT / UPDATE into DB was successful from the OpenSIPS perspective.
<br>
<br>
What you can do :<br>
<br>
1) ngrep to traffic between OpenSIPS and DB server to see if the
query is actually pushed<br>
<br>
2) run "opensipsctl fifo ul_sync" to force re-writing the whole DB
content based on mem cache:<br>
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/2.3.x/usrloc.html#idp5721824">http://www.opensips.org/html/docs/modules/2.3.x/usrloc.html#idp5721824</a><br>
<br>
Sometimes, if for whatever reasons the original INSERT was lost
at DB level, any sequential UPDATE(s), even if successful, will
have no effect on the DB content.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
</pre>
<div class="moz-cite-prefix">On 10/16/2017 08:27 PM, Jonathan Hunter
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:DB4PR02MB03362814538B3F9B3A5317C3BD4F0@DB4PR02MB0336.eurprd02.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
<div id="divtagdefaultwrapper"
style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;"
dir="ltr">
<div><span style="font-size: 12pt;">Hi Guys,</span><br>
</div>
<div><br>
</div>
<div>I have an interesting issue and wondered if anyone else has
seen this issue.</div>
<div><br>
</div>
<div>We have a user who is registered with the platform and can
make and receive calls, however the registration is only ever
in the cache, it is not being populated in the location table.</div>
<div><br>
</div>
<div>When I check its state I can see it registered, and I see
its state go from CS_DIRTY, to CS_SYNC as it re-registers;</div>
<div><br>
</div>
<div>opensipsctl ul show <a class="moz-txt-link-abbreviated" href="mailto:02033279460@sip.provider">02033279460@sip.provider</a></div>
<div>AOR:: 02033279460</div>
<div> Contact:: <a class="moz-txt-link-freetext" href="sip:02033279460@WANIP:5060">sip:02033279460@WANIP:5060</a> Q=</div>
<div> Expires:: 266</div>
<div> Callid::
<a class="moz-txt-link-abbreviated" href="mailto:5820966e249dce1b6796222708c8d94b@sip.provider">5820966e249dce1b6796222708c8d94b@sip.provider</a></div>
<div> Cseq:: 11070</div>
<div> User-agent:: Asterisk PBX</div>
<div> State:: CS_DIRTY</div>
<div> Flags:: 0</div>
<div> Cflags::</div>
<div> Socket:: udp:91.X.X.X:5060</div>
<div> Methods:: 4294967295</div>
<div><br>
</div>
<div>opensipsctl ul show <a class="moz-txt-link-abbreviated" href="mailto:02033279460@sip.provider">02033279460@sip.provider</a></div>
<div>AOR:: 02033279460</div>
<div> Contact:: <a class="moz-txt-link-freetext" href="sip:02033279460@WANIP:5060">sip:02033279460@WANIP:5060</a> Q=</div>
<div> Expires:: 224</div>
<div> Callid::
<a class="moz-txt-link-abbreviated" href="mailto:5820966e249dce1b6796222708c8d94b@sip.provider">5820966e249dce1b6796222708c8d94b@sip.provider</a></div>
<div> Cseq:: 11070</div>
<div> User-agent:: Asterisk PBX</div>
<div> State:: CS_SYNC</div>
<div> Flags:: 0</div>
<div> Cflags::</div>
<div> Socket:: udp:91.X.X.X:5060</div>
<div> Methods:: 4294967295</div>
<div><br>
</div>
<div><br>
</div>
<div>However it isn't contained within the location table, even
though other registrations are contained in both, as we have
the following set;</div>
<div><br>
</div>
<div>modparam("usrloc", "db_url", "DBURL")</div>
<div>modparam("usrloc", "db_mode", 2)</div>
<div>modparam("usrloc", "timer_interval", 60)</div>
<div><br>
</div>
<div>I have tried to reproduce the issue but cant seem to, the
REGISTER message being sent looks like the below;</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Request-Line: REGISTER <a class="moz-txt-link-freetext" href="sip:sip.provider">sip:sip.provider</a> SIP/2.0</div>
<div> Message Header</div>
<div> Via: SIP/2.0/UDP
91.X.X.X:5060;branch=z9hG4bK-25033-1-3</div>
<div> Max-Forwards: 70</div>
<div> From: <a class="moz-txt-link-rfc2396E" href="sip:02033279460@sip.provider"><sip:02033279460@sip.provider></a>;tag=1</div>
<div> To: <a class="moz-txt-link-rfc2396E" href="sip:02033279460@sip.provider"><sip:02033279460@sip.provider></a></div>
<div> Call-ID: <a class="moz-txt-link-abbreviated" href="mailto:1-25033@91.X.X.X">1-25033@91.X.X.X</a></div>
<div> CSeq: 8 REGISTER</div>
<div> Supported: replaces, timer</div>
<div> User-Agent: Asterisk PBX</div>
<div> Authorization: Digest
username="02033279460",realm="sip.provider",uri=<a class="moz-txt-link-rfc2396E" href="sip:91.X.X.X:5060">"sip:91.X.X.X:5060"</a>,nonce="59e4d0ae000000019388ae5161ff1f5d2666a1d2adb6e77d",response="e2f9ffb2ccf33c864adb76c950c2221c",algorithm=MD5</div>
<div> Expires: 120</div>
<div> Contact: <a class="moz-txt-link-freetext" href="sip:02033279460@91.X.X.X:5060">sip:02033279460@91.X.X.X:5060</a></div>
<div> Content-Length: 0</div>
<div><br>
</div>
<div><span style="font-size: 12pt;">Note its send the Auth
header in initial REGISTER before the 401 challenge.</span></div>
<div><span style="font-size: 12pt;"><br>
</span></div>
<div><span style="font-size: 12pt;">Does anyone have any tips
please on where the issue might be or how best to
trouble-shoot on a busy live platform?</span><br>
</div>
<div><br>
</div>
<div>Many thanks!</div>
<div><br>
</div>
<div>Jon</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>