<html>
<head>
<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>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>Hi Bogdan,</p>
<p><br>
</p>
<p>Thanks for the response!</p>
<p><br>
</p>
<p>I grabbed the update and you are correct, its trying to update an entry that doesnt exist within the location table.</p>
<p><br>
</p>
<p>We will dig into the database side!</p>
<p><br>
</p>
<p>Thanks!</p>
<p><br>
</p>
<p>Jon</p>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Bogdan-Andrei Iancu <bogdan@opensips.org><br>
<b>Sent:</b> 17 October 2017 08:11<br>
<b>To:</b> OpenSIPS users mailling list; Jonathan Hunter<br>
<b>Subject:</b> Re: [OpenSIPS-Users] opensips version 2.2 -Cache and location table out of sync for particular registrations.</font>
<div> </div>
</div>
<div><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" id="LPlnk707270" previewremoved="true">
http://www.opensips.org/html/docs/modules/2.3.x/usrloc.html#idp5721824</a>
<div id="LPBorder_GT_15082546249560.6578486139914865" style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;">
<table id="LPContainer_15082546249530.6762173870496468" role="presentation" cellspacing="0" style="width: 90%; background-color: rgb(255, 255, 255); position: relative; overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, 200);">
<tbody>
<tr valign="top" style="border-spacing: 0px;">
<td id="TextCell_15082546249540.6867553262094672" colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;">
<div id="LPRemovePreviewContainer_15082546249540.6388781809668136"></div>
<div id="LPTitle_15082546249540.5091367240880602" style="top: 0px; color: rgb(0, 120, 215); font-weight: normal; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe UI Light", "Segoe WP Light", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; line-height: 21px;">
<a id="LPUrlAnchor_15082546249540.8087039064144033" href="http://www.opensips.org/html/docs/modules/2.3.x/usrloc.html#idp5721824" target="_blank" style="text-decoration: none;">usrloc Module - OpenSIPS</a></div>
<div id="LPMetadata_15082546249550.42265979879822124" style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 14px;">
www.opensips.org</div>
<div id="LPDescription_15082546249550.44796375287616175" style="display: block; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;">
How the contacts are matched (for same AOR - Address of Record) is an important aspect of the usrloc modules, especialy in the context of NAT traversal - this raise ...</div>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<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" id="LPlnk227610" previewremoved="true">http://www.opensips-solutions.com</a>
</pre>
<div id="LPBorder_GT_15082546240280.18569594161113678" style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;">
<table id="LPContainer_15082546240250.5691041165295441" role="presentation" cellspacing="0" style="width: 90%; background-color: rgb(255, 255, 255); position: relative; overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, 200);">
<tbody>
<tr valign="top" style="border-spacing: 0px;">
<td id="TextCell_15082546240260.8354213963956938" colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;">
<div id="LPRemovePreviewContainer_15082546240260.4533440411148819"></div>
<div id="LPTitle_15082546240260.14361364936189625" style="top: 0px; color: rgb(0, 120, 215); font-weight: normal; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe UI Light", "Segoe WP Light", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; line-height: 21px;">
<a id="LPUrlAnchor_15082546240270.381924354620536" href="http://www.opensips-solutions.com/" target="_blank" style="text-decoration: none;">Home — OpenSIPS Solutions</a></div>
<div id="LPMetadata_15082546240270.5310026167566841" style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 14px;">
www.opensips-solutions.com</div>
<div id="LPDescription_15082546240280.06450536249849637" style="display: block; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;">
OpenSIPS is a mature Open Source implementation of a SIP server. OpenSIPS is more than a SIP proxy/router as it includes application-level functionalities.</div>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<div class="moz-cite-prefix">On 10/16/2017 08:27 PM, Jonathan Hunter wrote:<br>
</div>
<blockquote type="cite">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<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>_______________________________________________
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>
</div>
</div>
</div>
</body>
</html>