Hi, Stefan!
Indeed, there is no "Deleted" state in the db, not even in opensips' memory.
Can you paste the records of two bindings that should not be there?
Since you are using db_virtual, are you experiencing any failover?
Best regards,
Răzvan Crainea
OpenSIPS Developer
www.opensips-solutions.com
On 10/09/2017 02:48 PM, Stefan Tobé wrote:
Hi Razvan,
thanks for replying
I notice that the bindings remain in the DB for a while (at least >
5min), sometimes they are deleted immediately (as I would expect),
some other times they remain in the table.
So reregistering returns 200OK (2 bindings or 3 , increasing). Re
querying the DB shows an increment of equal bindings for a client
until the limit is reached for max amount of registrations in the
config (10 by default I believe?).
If I decrease that setting lets say to modparam("registrar",
"max_contacts", 2) then I will very soon get an error reply back. Note
that this behavior (increment of bindings) is not consequently
observed (it is intermittent).
The DB setting in the config (config was attached to original email as
well as pcap) is:
#### USeR LOCation module
loadmodule "usrloc.so"
#modparam("usrloc", "nat_bflag", "NAT")
modparam("usrloc", "db_mode", 3)
modparam("usrloc", "db_url","virtual://pmset")
You mention a '/Deleted/' state, but I was unable to find that flag .
Should that be in /opensips.location/ table?
On Mon, Oct 9, 2017 at 11:21 AM, Răzvan Crainea <[email protected]
<mailto:[email protected]>> wrote:
Hi, Stefan!
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)?
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.
[1]
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>
Best regards,
Răzvan Crainea
OpenSIPS Developer
www.opensips-solutions.com <http://www.opensips-solutions.com>
On 10/09/2017 11:57 AM, Stefan Tobé wrote:
Hi there,
I noticed that opensips 2.2.5-1 intermittently does NOT flush
the contact when the client is deregistering.
It is reproducable with multple sip clients. opensips 2.3 also
suffers from this issue.
When I check the mysql database backend I can see that the entry
is table opensips.location is not consistently deleted.
It works for several times and the subsequently it does not flush
the contact showing two bindings the next time the client is
registered.
I can unfortunately not monitor the sql queries because opensips
is using tls for secure transmission.
I use mysql as backend and the config is attached as well as the
local wireshark trace I took
--
mvg
Stefan Tobé
PM Factory B.V.
Bolderweg 2
1332 AT Almere
tel: 06 21 26 59 68
email: [email protected]
<mailto:[email protected]>
PGP public key: click here to download
<https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
--
mvg
Stefan Tobé
PM Factory B.V.
Bolderweg 2
1332 AT Almere
tel: 06 21 26 59 68
email: [email protected] <mailto:[email protected]>
PGP public key: click here to download
<https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
