<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">Mark and Devs</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">Service witnessd is writing sip_stats on different format after upgrade to CE mr7.5.1 </div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">I've got active calls data using this query on Grafana:<br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">q:"SELECT "dialog_active_dialogs" FROM "autogen"."kamailio" WHERE ("node_active" = '1') AND time >= now() - 24h"<br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">Active data are written on different tag than Grafana is looking for.</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small">Maybe we get a hotfix sometime in future.</div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div style="font-family:verdana,sans-serif">Atenciosamente,</div><br>Luciano Moreira<br>_____________________<br>Logic Telecom<br><br></div></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em ter, 8 de out de 2019 às 11:54, Mark van Herpen <<a href="mailto:mark@cambrium.nl" target="_blank">mark@cambrium.nl</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
I'm debugging a bit more. I have one active call, and a query on <br>
influxdb gives me this result:<br>
<br>
> select host, kam_dialog_active from kamailio where "node_active" = <br>
'1' and time > now() - 20s group by host;<br>
name: kamailio<br>
tags: host=tran-out01<br>
time host kam_dialog_active<br>
---- ---- -----------------<br>
1570546033000000000 tran-out01 0<br>
1570546043000000000 tran-out01 0<br>
<br>
The kam_dialog_active is 0<br>
<br>
On another host this is '1'. What sets the kam_dialog_active value?<br>
<br>
Grtz,<br>
<br>
Mark<br>
<br>
Op 01-10-19 om 12:13 schreef Mark van Herpen:<br>
> Hello,<br>
> <br>
> Same issue here on CE mr7.5.1, applied al fixes with 'apt-get upgrade' <br>
> and ngcpcfg apply and a reboot.<br>
> <br>
> I have one active call, also ngcp-status shows 1 active call.<br>
> <br>
> The grafana sip-statistics dashboard shows 0 active calls.<br>
> The 'active calls'-panel (one row lower), shows 'No data points.<br>
> <br>
> From the json-export of the active panel I saw the influx query used:<br>
> <br>
> root@tran-out01:/etc/ngcp-config# influx<br>
> Connected to /run/influxdb/influxdb.sock version 1.6.4<br>
> InfluxDB shell version: 1.6.4<br>
> > use ngcp<br>
> Using database ngcp<br>
> > SELECT SUM(mean) from (SELECT mean(kam_dialog_active) from kamailio <br>
> where "node_active" = '1' AND time > now() - 20s group by host)<br>
> name: kamailio<br>
> time sum<br>
> ---- ---<br>
> 0 0<br>
> <br>
> Also a 'select * from kam_dialog_active' gives no result.<br>
> <br>
> Can I do something more for debugging?<br>
> <br>
> Grtz,<br>
> <br>
> Mark<br>
> <br>
> <br>
> <br>
> Op 23-09-19 om 15:06 schreef Luciano Moreira:<br>
>> Hi Folks,<br>
>><br>
>> I installed SIPWISE CE 7.4.1. Everything was perfect.<br>
>> Then I upgraded to mr7.5.1. After that, I lost Grafana's Active Calls <br>
>> panel.<br>
>> Applied all hotfixes, but Active calls panel stills empty.<br>
>> I have no clue how to debug this issue. Anyone could help me? Where <br>
>> should I start look in for?<br>
>><br>
>> +---------------------------------------------- 2019-09-23 09:56:55 -+<br>
>> | NGCP: CE mr7.5.1 nodes setup [ ] |<br>
>> | NGCP: subscribers:21 locations:6 calls:2 |<br>
>> | OS: buster (10.1) 4.19.0-6-amd64 SMP (ext4) |<br>
>> | CPU: 2 = 1 x Virtual CPU 82d9ed4018dd (HT) |<br>
>> | HW: Standard PC (i440FX + PIIX, 1996) by QEMU |<br>
>> | BIOS: rel-1.12.0-0-ga698c8... (04/01/2014) by SeaBIOS |<br>
>> | RAM: 3.9Gi (used 78%/cache 6%) mysqld[39.7%] kamailio[12.7%] |<br>
>> | LA: system load OK: 0.25 0.48 0.51 |<br>
>> | DISK: /dev/sr0 [CDROM] /dev/vda [HDD] |<br>
>> | DISK: space used /[26%] |<br>
>> | DISK: inodes in use /[3%] |<br>
>> | SWAP: used 685824 kB: mysqld[59%] perl-fcgi-pm [N[59%] <br>
>> perl-fcgi[47%] |<br>
>> | MODs: License OFF, DUMMY ON, |<br>
>> +----- ---------------------------------------7.5.1.1+0~mr7.5.1.1---+<br>
>><br>
>> Luciano Moreira<br>
>> Logic<br>
>><br>
> <br>
<br>
-- <br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" rel="noreferrer" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>
</blockquote></div>