All "hostalive" graphs show no data (grafana with influxdb)

hash02 · February 21, 2020, 7:58pm

Hi,
All graphs are working just fine but the ones with hostalive (ping4, ping6) data show “no data” no matter the time interval.
What am I doing wrong ?

blakehartshorn · February 21, 2020, 9:12pm

For the hostalive check, make sure you’re getting metric data. Try running the following in InfluxDB itself:
select * from hostalive where time >= now() - 1m

Also, can we see your host_template config from influxdb.conf?

a1mw · February 21, 2020, 9:19pm

Hi,

are the host perf data really written to influx -> take a look on the stored measurements (query schema and data)

Did you filter on metrics (rta + pl)?
Your query statement should look like this:
SELECT mean("value") FROM "autogen"."hostalive" WHERE ("metric" = 'rta' AND "hostname" =~ /^$hostname$/) AND $timeFilter GROUP BY time($interval) fill(null)

$hostname$ is a grafana variable, values will come from influxdb with SHOW TAG VALUES FROM "hostalive" WITH KEY = "hostname" -> offers a dynamic host selection for the graph.

Cheers,
Manfred

anon66228339 · February 24, 2020, 5:08pm

I guess you are using the grafana-module for icingaweb2. If yes you have to configure a graph for the command hostalive and import the provided dashboard that comes with the module. See picture for an example.

hash02 · February 27, 2020, 2:39pm

thank you problem solved.

jpamba · September 16, 2020, 5:44am

This thread helped a lot. I wanted to clarify that what resolved the same issue I had was to create a dashboard as advised. The name field was set to ‘hostalive’, Dashboard name set to that of dashboard imported from grafana module. Below is a screenshot.