<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi, Stefan!<br>
<br>
Are you saying that the Contacts "leak" in the database (they are
never deleted), or that they are not deleted immediately after the
client is deregistering (but they are a bit later)?<br>
<br>
What is the db_mode setting[1] you are using for the usrloc
module? Also, note that the Contacts might still be present in the
database after they are deleted, but with a Deleted state. If
that's the case, this is perfectly fine.<br>
<br>
[1]
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/2.3.x/usrloc.html#idp5620912">http://www.opensips.org/html/docs/modules/2.3.x/usrloc.html#idp5620912</a><br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Răzvan Crainea
OpenSIPS Developer
<a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 10/09/2017 11:57 AM, Stefan Tobé
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAA7e_wemM+LqKRBLVA-4iKLxha8wrp0nMjLyTh+usBfAK_cPBw@mail.gmail.com">
<div dir="ltr"><br>
<div class="gmail_quote">
<div dir="ltr">
<div>
<div>
<div>
<div>Hi there,<br>
</div>
I noticed that opensips 2.2.5-1 intermittently does
NOT flush the contact when the client is
deregistering.</div>
<div>It is reproducable with multple sip clients.
opensips 2.3 also suffers from this issue.<br>
</div>
<div><br>
</div>
When I check the mysql database backend I can see that
the entry is table opensips.location is not consistently
deleted.</div>
<div>It works for several times and the subsequently it
does not flush the contact showing two bindings the next
time the client is registered.</div>
<div><br>
</div>
<div><br>
</div>
I can unfortunately not monitor the sql queries because
opensips is using tls for secure transmission.<br>
</div>
I use mysql as backend and the config is attached as well as
the local wireshark trace I took<span class="HOEnZb"><font
color="#888888"><br clear="all">
<div>
<div>
<div>
<div>
<div><br>
<br>
</div>
</div>
</div>
</div>
</div>
</font></span></div>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><span>
<div>mvg<br>
Stefan Tobé<br>
<br>
</div>
<br>
</span></div>
<div>
<div><span>PM Factory B.V.<br>
Bolderweg 2<br>
1332 AT Almere<br>
tel: 06 21 26 59 68<br>
email: <a
href="mailto:stefan.tobe@privatemobility.nl"
target="_blank" moz-do-not-send="true">stefan.tobe@pmfactory.nl</a><br>
</span></div>
<div><span>PGP public key: <a
href="https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing"
target="_blank" moz-do-not-send="true">click
here to download</a><br>
</span></div>
<div><span><br>
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</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>