Grafana + influxdb2 does not show data for host in default template

[ledvinap]

Expected Behavior

Host performance data are visible in graph

Current Behavior

Graph for Hosts displays "No data" (and does work for services)

var-service passed to grafana is passed as check_command for hosts. Icinga2 influxdb2 writer stores empty value in service for hosts, so default query can't find any data ( WHERE ("hostname" =~ /^$hostname$/ AND "service" =~ /^$service$/) ).

Possible Solution

Maybe pass new var-servicename that will contain real service name (empty for hosts).

Your Environment

• Icinga Web 2 Grafana version : 1.4.3 (master, 7e27158)
• icingadb 1.0.1 (master)
• Icinga Web 2 Version 2.11.1
• icinga2 - The Icinga 2 network monitoring daemon (version: r2.13.5-1)
• System information:
  Platform: Debian GNU/Linux
  Platform version: 11 (bullseye)
  Kernel: Linux
  Kernel version: 5.10.0-18-amd64
  Architecture: x86_64
  Enabled features: api checker command icingadb influxdb2 mainlog notification
• Config validation (icinga2 daemon -C):
  [2022-10-16 21:58:21 +0200] information/cli: Icinga application loader (version: r2.13.5-1)
  [2022-10-16 21:58:21 +0200] information/cli: Loading configuration file(s).
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Committing config item(s).
  [2022-10-16 21:58:21 +0200] information/ApiListener: My API identity: bullseye
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 IcingaApplication.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 268 Dependencies.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 3 HostGroups.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 137 Hosts.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 FileLogger.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 Influxdb2Writer.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 CheckerComponent.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 2 Notifications.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 IcingaDB.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 3 Zones.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 IdoPgsqlConnection.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 ExternalCommandListener.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 Endpoint.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 4 ApiUsers.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 ApiListener.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 NotificationComponent.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 244 CheckCommands.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 2 UserGroups.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 3 TimePeriods.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 6 Users.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 549 Services.
  [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 2 NotificationCommands.
  [2022-10-16 21:58:21 +0200] information/ScriptGlobal: Dumping variables to file '/var/cache/icinga2/icinga2.vars'
  [2022-10-16 21:58:21 +0200] information/cli: Finished validating the configuration file(s).

[Mikesch-mp]

This version is not made for icingadb, wait for 2.0.0