Search broken after 16:00 about homer-ui HOT 8 CLOSED

could you share your timezone settings for both homer server and capture agents?

from homer-ui.

preferences.php:
define('HOMER_TIMEZONE', "America/Los_Angeles");

root@homer01:/etc/kamailio# date
Mon Jan 25 17:58:20 PST 2016
root@homer01:/etc/kamailio# date +%Z
PST

from homer-ui.

Freddy also check the time on both server. Are they sync ?

Wbr,
Alexandr

On 26.01.2016 03:00, Freddy Andersen wrote:

preferences.php:
define('HOMER_TIMEZONE', "America/Los_Angeles");

root@homer01:/etc/kamailio# date
Mon Jan 25 17:58:20 PST 2016
root@homer01:/etc/kamailio# date +%Z
PST

—
Reply to this email directly or view it on GitHub
#52 (comment).

from homer-ui.

yes both servers are syncing from the same internal ntp server.
kamailio03:$ date
Tue Jan 26 06:29:34 PST 2016
homer01:$ date
Tue Jan 26 06:29:35 PST 2016

do you want to see something out of my database? looking at a captured invite thats from before 4pm and one after they look the same so I think this is a ui issue only, not capture issue.

My kamailio is using this config:

#!ifdef WITH_SIPTRACE
modparam("siptrace", "trace_on", 1)
modparam("siptrace", "trace_flag", 22)
modparam("siptrace", "trace_to_database", 0)
modparam("siptrace", "duplicate_uri", "sip:homer01.xxx.com:9060")
modparam("siptrace", "hep_mode_on", 1)
modparam("siptrace", "hep_version", 2)
#!endif

request_route {

#!ifdef WITH_SIPTRACE
sip_trace();
setflag(22);
#!endif

and capture server is using kamailio with the example config.

from homer-ui.

@heimdull from your browser console try to capture a working and non working pair of request/response to/from the Homer API and post here for troubleshooting this further

from homer-ui.

I just pulled these two packets from mysql. 3384224 works fine when I search for it in the ui, 3384319 does show in search window but has no data.

mysql> select id,date,micro_ts,method,callid from sip_capture_call_20160125 WHERE method='ACK' and date='2016-01-25 16:10:00' limit 1;
+---------+---------------------+------------------+--------+----------------------------------------------+
| id | date | micro_ts | method | callid |
+---------+---------------------+------------------+--------+----------------------------------------------+
| 3384224 | 2016-01-25 16:10:00 | 1453767000106818 | ACK | [email protected] |
+---------+---------------------+------------------+--------+----------------------------------------------+
1 row in set (0.01 sec)

mysql> select id,date,micro_ts,method,callid from sip_capture_call_20160125 WHERE method='ACK' and date='2016-01-25 16:10:01' limit 1;
+---------+---------------------+------------------+--------+----------------------------------------------+
| id | date | micro_ts | method | callid |
+---------+---------------------+------------------+--------+----------------------------------------------+
| 3384319 | 2016-01-25 16:10:01 | 1453767001032369 | ACK | [email protected] |
+---------+---------------------+------------------+--------+----------------------------------------------+
1 row in set (0.01 sec)

from homer-ui.

Upgraded capture server (kamailio to latest 4.3 from github master)
and change kamailio.cfg to :

#For old models. Not accurate insert time. System vs capture time.
#$var(a) = $var(table) + "" + $timef(%Y%m%d);
#for Kamailio >4.3 please uncomment this parameters:
$var(a) = $var(table) + "%Y%m%d";

everything is now working like expected.

from homer-ui.

case added to Wiki/FAQ

from homer-ui.