[OpenSIPS-Users] Fwd: opensips usrloc deregistration failure

[Stefan Tobé]

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 <razvan at opensips.org> 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
>
> Best regards,
>
> Răzvan Crainea
> OpenSIPS Developerwww.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: stefan.tobe at pmfactory.nl <stefan.tobe at privatemobility.nl>
> PGP public key: click here to download
> <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
>
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> 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: stefan.tobe at pmfactory.nl <stefan.tobe at privatemobility.nl>
PGP public key: click here to download
<https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>

<http://www.privatemobility.nl>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20171009/e7ffb2cd/attachment.html>