sipcapture / homer

HOMER - 100% Open-Source SIP, VoIP, RTC Packet Capture & Monitoring
https://sipcapture.org
GNU Affero General Public License v3.0
1.61k stars 240 forks source link

RTCP data is stored on the DB but no QoS tab is displayed #550

Closed juansalvatella closed 1 year ago

juansalvatella commented 2 years ago

Hi there,

I'm using the FreeSwitch agent for SIP, RTPEngine agent for RTCP and it's all being sent to a heplify-server. Everything is working like a charm except that I don't see any QoS reports. I've been investigating all around the wiki, the troubleshooting guide and the already opened issues but I can't find a way to get this to work.

If I connect to my postgresql and run:

homer_data=# select "raw" from hep_proto_5_default limit 5;

I can see that data is being sent and stored:

raw
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 { "sender_information":{"ntp_timestamp_sec":3867414562,"ntp_timestamp_usec":1011275819,"octets":32000,"rtp_timestamp":32000, "packets":200},"ssrc":721184726,"type":200,"report_count":1,"report_blocks":[{"source_ssrc":0,"highest_seq_no":29148,"fraction_lost":1,"ia_jitter":6,"packets_lost":1,"lsr":0,"dlsr":0}],"sdes_report_count":1,"sdes_information": [ {"sdes_chunk_ssrc":721184726,"type":1,"text":"2afc67d6"},{"sdes_chunk_ssrc":721184726,"type":7,"text":"FreeSWITCH.org -- Come to ClueCon.com"}] }
 { "ssrc":2089288832,"type":201,"report_count":1,"report_blocks":[{"source_ssrc":721184726,"highest_seq_no":20056,"fraction_lost":0,"ia_jitter":0,"packets_lost":0,"lsr":270679110,"dlsr":65536}],"sdes_report_count":1,"sdes_information": [ {"sdes_chunk_ssrc":2089288832,"type":1,"text":""}] }
 { "sender_information":{"ntp_timestamp_sec":3867414566,"ntp_timestamp_usec":1097119330,"octets":64160,"rtp_timestamp":64160, "packets":401},"ssrc":721184726,"type":200,"report_count":1,"report_blocks":[{"source_ssrc":2089288832,"highest_seq_no":29349,"fraction_lost":0,"ia_jitter":0,"packets_lost":1,"lsr":0,"dlsr":0}],"sdes_report_count":1,"sdes_information": [ {"sdes_chunk_ssrc":721184726,"type":1,"text":"2afc67d6"},{"sdes_chunk_ssrc":721184726,"type":7,"text":"FreeSWITCH.org -- Come to ClueCon.com"}] }
 { "ssrc":2089288832,"type":201,"report_count":1,"report_blocks":[{"source_ssrc":721184726,"highest_seq_no":20056,"fraction_lost":0,"ia_jitter":0,"packets_lost":0,"lsr":270942564,"dlsr":129761}],"sdes_report_count":1,"sdes_information": [ {"sdes_chunk_ssrc":2089288832,"type":1,"text":""}] }
 { "sender_information":{"ntp_timestamp_sec":3867414570,"ntp_timestamp_usec":1182958547,"octets":96320,"rtp_timestamp":96320, "packets":602},"ssrc":721184726,"type":200,"report_count":1,"report_blocks":[{"source_ssrc":2089288832,"highest_seq_no":29550,"fraction_lost":0,"ia_jitter":0,"packets_lost":1,"lsr":0,"dlsr":0}],"sdes_report_count":1,"sdes_information": [ {"sdes_chunk_ssrc":721184726,"type":1,"text":"2afc67d6"},{"sdes_chunk_ssrc":721184726,"type":7,"text":"FreeSWITCH.org -- Come to ClueCon.com"}] }
(5 rows)

What other steps should I take to troubleshoot this further?

Thanks!

tcreek commented 1 year ago

Did you get this figured out?

lmangani commented 1 year ago

@tcreek check if the timestamps match with those of the call that's sourcing them

tcreek commented 1 year ago

I installed everything via docker. I am not even sure how to even get to the database. I see the container 1ccf6600c67c postgres:11-alpine.

I have tried different methods shown, but they all fail.

lmangani commented 1 year ago

@tcreek so how do you know you even have RTCP data in the database? This sounds like a different issue.

tcreek commented 1 year ago

I did run the heplify-xrcollector and data from that run is showing in Homer.

I will open a separate issue

kYroL01 commented 1 year ago

@juansalvatella did you were able to see the data in Homer ? Did you check the timestamp ?

juansalvatella commented 1 year ago

Yeah, I just redeployed everything and it worked!