[SR-Users] Deleting extra location attribute(location_attrs table) when contact is expired

[Pintu Lohar]

Hi Daniel,

It's about the contract expired and deleted from "location" but not deleted
from location_attr table when expired contact is found. My settings are
below

1. modparam("usrloc", "timer_interval", 120)
2. modparam("tm|usrloc", "xavp_contact", "ulattrs")
3. Usrloc is set to DB_ONLY Mode.
4. //// route block when the extra location attr before saving .
# Handle SIP registrations
route[REGISTRAR] {
if (!is_method("REGISTER")) return;

if(isflagset(FLT_NATS)) {
setbflag(FLB_NATB);
#!ifdef WITH_NATSIPPING
# do SIP NAT pinging
setbflag(FLB_NATSIPPING);
#!endif
}
*$xavp(ulattrs=>did)=$hdr(P-Asserted-Identity); # this adds to
location_attr table.. *
if (!save("location")) {
sl_reply_error();
}



Like if Client Registered , and went offline/crashed,(expiry i.e 3600,
proto=TLS) then contact is expired after 1 hour then it's removed from
location table but the attribute set which is added for location_attr(for
same ruid) is not deleted from db.
Thanks & Regards
Pintu


-----------

On Mon, Jul 29, 2019 at 4:32 PM Daniel-Constantin Mierla <miconda at gmail.com>
wrote:

> Hello,
>
> is the contact expired and not updated, or is about attributes set for a
> REGISTER request that should be deleted with the next REGISTER updating the
> expires for same contact?
>
> Cheers,
> Daniel
> On 29.07.19 08:44, Pintu Lohar wrote:
>
> Hi All,
>
>
> Regarding modparam("tm|usrloc", "xavp_contact", "ulattrs")
>
>
> #ref :
> https://www.kamailio.org/docs/modules/devel/modules/usrloc.html#usrloc.p.xavp_contact
> .
>
> There is some requirement where we need to save some extra location
> attributes to location_attrs
> <https://kamailio.org/docs/db-tables/kamailio-db-4.3.x.html#gen-db-location-attrs>
>  tables
> $xavp(ulattrs=>deviceIdentify)= "Some str values"  and calling
> save(“location”) , It works well and saved  location attribute table but  But
> when contact expired callback is received, udomain_contact_expired_db()
> does not it delete the extra location attribute from database but deleting
> the record from location table only ?
>
> If not, is there any recommended approach to delete the extra location
> attributes from the database? or am I missing something to set?
>
>
> Alternate I was thinking could be running timer from Kamailio config and
> check last_modified time and delete those(based on our UAC expiry setting),
> is it the right approach.
>
> Kamailio Version: 5.2.0.
>
> Thanks for your valuable suggestion in advance.
>
> Regards
>
> Pintu Lohar
>
>
>
>
>
> _______________________________________________
> Kamailio (SER) - Users Mailing Listsr-users at lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
> --
> Daniel-Constantin Mierla -- www.asipto.comwww.twitter.com/miconda -- www.linkedin.com/in/miconda
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190729/5d5bdc43/attachment.html>