29 Jul
2019
29 Jul
'19
11:16 a.m.
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(a)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
Listsr-users@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