sip_capture_call table is being populated, but packet search results contain stale data

[Jon Findley]

Hello,

I've been using HOMER for a while now and just recently started having problems with the UI not showing the new packets in the search panel. I decided to start over from scratch and reinstall HOMER5 and Captagent 6. The agents are sending the data, kamailio is capturing it and storing it in the database, but the UI is only showing a tiny, old fraction of the data that's actually there. 

My favorite thing about HOMER was setting the interval to 5 seconds and having the page automatically refresh, but that seems to be broken now =/

What can I do to help debug this?

[Alexandr Dubovikov]

Hello Jon,

first please check if you don't have Javascript errors in the browser console. Second, please check if you have any errors in the php/apache/nginx

Wbr,

Alexandr

--
You received this message because you are subscribed to the Google Groups "Homer Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to homer-dev+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jon Findley]

Hello Alexander,

Thanks for the response!

I don't see any errors in the console. I'm running Apache 2.2.15. There are some errors about undefined indexes, but the requests that are sent every <interval> seconds have 200 responses. 

I figured out that if I switch to 30 minute, refresh, then switch back to 10 minute, I'll see the most recent data. Same result in Chrome and firefox.

Example undefined index:

[Mon Jul 25 16:32:43 2016] [error] [client ] PHP Notice:  Undefined index: _1428431423814 in /var/www/sipcapture/htdocs/api/RestApi/Dashboard.php on line 143, 

[Mon Jul 25 16:32:43 2016] [error] [client ] PHP Notice:  Undefined index: _1452069187383 in /var/www/sipcapture/htdocs/api/RestApi/Dashboard.php on line 143, 

[Mon Jul 25 16:32:43 2016] [error] [client ] PHP Notice:  Undefined index: _1450278390101 in /var/www/sipcapture/htdocs/api/RestApi/Dashboard.php on line 143, 

[Mon Jul 25 16:32:43 2016] [error] [client ] PHP Notice:  Undefined index: _1430318378410 in /var/www/sipcapture/htdocs/api/RestApi/Dashboard.php on line 143, 

[Mon Jul 25 16:32:43 2016] [error] [client ] PHP Notice:  Undefined index: _1411848944046 in /var/www/sipcapture/htdocs/api/RestApi/Dashboard.php on line 143, 

Example refresh request:

[] - - [25/Jul/2016:16:33:33 -0400] "POST /api/v1/profile/store/timerange HTTP/1.1" 200 51 "http://<ip addr>/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.106 Safari/537.36"

[] - - [25/Jul/2016:16:33:33 -0400] "POST /api/v1/profile/store/timezone HTTP/1.1" 200 51 "http://<ip addr>/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.106 Safari/537.36"

[] - - [25/Jul/2016:16:33:33 -0400] "POST /api/v1/search/data HTTP/1.1" 200 186496 "http://<ip addr>/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.106 Safari/537.36"

[Alexandr Dubovikov]

but do you see anything in the API reply? This you can check in the Network tab

[Jon Findley]

Yes. I think I found the issue, though. The timestamp from and timestamp to in the request to api/v1/search/data only update if I change the time range. So each time the auto-refresh does it's thing (or I manually click search), the same time range is being sent in the request, so the same results are returned each time. When I change the time range, calls to api/v1/profile/store/timerange and timezone are made with updated times, then when calling api/v1/search/data again the timestamp from and timestamp to are updated/more recent.

[Alexandr Dubovikov]

ok. understood. Please open ticket for this.

[Jon Findley]

Thanks,

I created the ticket. Also made a temporary hack so I can watch the calls come in.

[Alexandr Dubovikov]

thanks, also for such things we use "Next 5 minutes" which does exactly same. But yes, this confuse and better change.