Hi Henning
Thanks for your response.

But i have some query regarding record-route field update in DB forSCA SUBSCRIBE.
Here's my test cases 

Initial SCA subscription, We got the below SUBSCRIBE packet in kamailio

SUBSCRIBE sip:1234.xyz.com:5060 SIP/2.0
Via: SIP/2.0/UDP kam-ip:5060;branch=z9hG4bK2sansay1081381rdb66
Record-Route: <sip:sansay1081381rdb66spid17urcvjtr139807186744464nat0@kam-ip:5060;lr;transport=udp>
To: <sip:372427@1234.xyz.com:6060>
From: "708" <sip:372427@1234.xyz.com:6060>;tag=CFFBAF19-19A68CBC
Call-ID: bd4b50d9384523c14ea05c532d895bf2
CSeq: 2 SUBSCRIBE
Contact: <sip:372427@192.168.1.3>
Expires: 3600
Allow: INVITE,ACK,BYE,CANCEL,OPTIONS,INFO,MESSAGE,SUBSCRIBE,NOTIFY,PRACK,UPDATE,REFER
Event: call-info
User-Agent: PolycomVVX
Accept-Language: en
Max-Forwards: 69
Content-Length: 0

also  in the sca_subscriptions table record-route header is updated as per Initial SUBSCRIBE record-route.
record_route: <sip:sansay1081381rdb66spid17urcvjtr139807186744464nat0@kam-ip:5060;lr;transport=udp>

But After rebooting the device, we got a new record-route in SUBSCRIBE Packet but in DB Record-route Field not updated after getting an updated  record-route in Trace.

Kamailio Trace
SUBSCRIBE sip:1234.xyz.com:5060 SIP/2.0
Via: SIP/2.0/UDP kam-ip:5060;branch=z9hG4bK2sansay1081415rdb48
Record-Route: <sip:sansay1081415rdb48spid17urcvjtr139807186744464nat0@kam-ip:5060;lr;transport=udp>
To: <sip:372427@1234.xyz.com:6060>
From: "708" <sip:372427@1234.xyz.com:6060>;tag=35852031-CF749E20
Call-ID: 41fa031d79e35fae4a61c61984895bf2
CSeq: 2 SUBSCRIBE
Contact: <sip:372427@192.168.1.3>
Expires: 3600
Allow: INVITE,ACK,BYE,CANCEL,OPTIONS,INFO,MESSAGE,SUBSCRIBE,NOTIFY,PRACK,UPDATE,REFER
Event: call-info
User-Agent: PolycomVVX
Accept-Language: en
Max-Forwards: 69
Content-Length: 0

as per logic it should update the record-route field in sca_subscriptions table . but it didn't update it :
record_route: <sip:sansay1081381rdb66spid17urcvjtr139807186744464nat0@kam-ip:5060;lr;transport=udp>

So can you suggest to us how we can update the record-route field as per SUBSCRIBE's packet new record-route ? 

On Sat, Feb 11, 2023 at 8:47 PM Henning Westerholt <hw@gilawa.com> wrote:

Hello,

 

any errors in the log related to the module? Maybe you can also checkout the sca module code, there might be an issue related to this.

Why do you get a new record-route header after rebooting the device? I’d think that the record-route header is inserted from the Kamailio.

 

Cheers,

 

Henning

 

--

Henning Westerholt – https://skalatan.de/blog/

Kamailio services – https://gilawa.com

 

From: Vinayak Makwana <vinayak.makwana@ecosmob.com>
Sent: Friday, February 10, 2023 2:10 PM
To: sr-users@lists.kamailio.org
Subject: [SR-Users] Re: SCA Presence : Record-Route Filed Not Update in sca_subscriptions Table

 

Hello 
           Is there any update here SCA Presence : Record-Route Filed Not Update in sca_subscriptions Table ?  Appreciate your response.
 

 

On Tue, Feb 7, 2023 at 4:34 PM Vinayak Makwana <vinayak.makwana@ecosmob.com> wrote:

Hello all,
         I am using the sca module in kamailio script.so when i subscribe with my ip phone for SCA Presence i get all the information in a sca_subscriptions table for the first time. When I reboot the device I get a new record-route header in trace but It does not update record-route Filed in sca_subscriptions table.

 Can anyone help me out with this issue ?

Here's modparam configuration 

modparam("sca", "db_update_interval", 10 )
modparam("sca", "db_url", DBURL_LOCAL)
modparam( "sca", "line_seize_max_expires", 30)
modparam( "sca", "purge_expired_interval", 1800)

--

 

 

Disclaimer

In addition to generic Disclaimer which you have agreed on our website, any views or opinions presented in this email are solely those of the originator and do not necessarily represent those of the Company or its sister concerns. Any liability (in negligence, contract or otherwise) arising from any third party taking any action, or refraining from taking any action on the basis of any of the information contained in this email is hereby excluded.

 

Confidentiality

This communication (including any attachment/s) is intended only for the use of the addressee(s) and contains information that is PRIVILEGED AND CONFIDENTIAL. Unauthorized reading, dissemination, distribution, or copying of this communication is prohibited. Please inform originator if you have received it in error.

 

Caution for viruses, malware etc.

This communication, including any attachments, may not be free of viruses, trojans, similar or new contaminants/malware, interceptions or interference, and may not be compatible with your systems. You shall carry out virus/malware scanning on your own before opening any attachment to this e-mail. The sender of this e-mail and Company including its sister concerns shall not be liable for any damage that may incur to you as a result of viruses, incompleteness of this message, a delay in receipt of this message or any other computer problems. 

--

Regards,
Vinayak Makwana

Ecosmob Technologies Pvt. Ltd. 
https://www.ecosmob.com

VoIP | Web | Mobile | IoT | Big Data