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

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 &lt;miconda(a)gmail.com <mailto:miconda@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.xa… > . > > 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 List > sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org> > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>