[OpenSIPS-Users] Fwd: opensips usrloc deregistration failure

Mon Oct 9 11:24:48 EDT 2017

Hi Razvan
Interesting detail is that the flushing of binding works OK
when I use real backend mysql instead of virtual_db

so when I put the following snippet in place in opensips.cfg it does work
correctly/as expected
modparam("usrloc", "db_url","mysql://opensips:opensipsrw@XXXXXXX/opensips")
### TEMP MOD
#modparam("usrloc", "db_url","virtual://pmset")

So the virtdb module does something wrong or at least delays flushing
queries in this case

Stefan

On Mon, Oct 9, 2017 at 4:23 PM, Stefan Tobé <stefan.tobe at pmfactory.nl>
wrote:

> Hi Razvan, please find both pcap and query of mysql backend (location
> table) attached.
>
> no we dont see failover, single DB backend being used.
>> regards
>> Stefan
>>
>>
>> On Mon, Oct 9, 2017 at 2:39 PM, Răzvan Crainea <razvan at opensips.org>
>> wrote:
>>
>>> 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 Developerwww.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 <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>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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>
>>
>
>
>
> --
> 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>
>

-- 
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/19c14b92/attachment-0001.html>