Hello
I have a query regarding the record-route field update in DB for SCA SUBSCRIBE.
Here are 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 ?