Hard-Coded InfluxDB/HostAlive in icinga2-default.json

[aaron-goulet-bfg]

There's a raw query that appears to point to a particular host for hostalive stats in the json file:
https://github.com/Mikesch-mp/icingaweb2-module-grafana/blob/master/dashboards/graphite/icinga2-default.json#L77-L97

It appears this will break hostalive graphs without manual adjustment, at least during my testing. All other graphs are working fantastic for me at present.

It might not be the above, however; could also be the target for the graph itself in the Icingaweb2 module. By default, it links to:
https://<grafana host>/dashboard/db/icinga2-default?var-hostname=icinga01_dev_bigfishgames_com&var-service=hostalive&from=now-30m&to=now

I'm surprised this hasn't been reported previously... Which also leads me to wonder if I need to change a setting. Anyway, I hope this helps.

Expected Behavior

All normal, included graphs render using default configuration in instructions.

Current Behavior

hostalive graphs don't render (no datapoints). Host data is correctly populating in Graphite at icinga2.<hostname>.host.hostalive.perfdata.*

Possible Solution

Review and re-test implementation of hostalive graphs. Remove any hard-coded hosts that might have been left over from testing.

Steps to Reproduce (for bugs)

1. Install newest version of Icinga2 + Icingaweb2.
2. Install and configure Graphite module for Icinga2, and Grafana module for Icingaweb2.
3. Import dashboard into Grafana using included icinga2-default.json
4. All metrics should populate to Graphite at this point, and all graphs should properly render EXCEPT for hostalive.

Context

This metric allows us to measure basic host connectivity, and could be useful for troubleshooting. It might benefit the project as well if this metric worked out-of-the-box for people using a Graphite data source.

Your Environment

• Icinga Web 2 Grafana version (System - About): 1.1.7
• Icinga Web 2 version and modules (System - About): 2.1.0
• Version used (icinga2 --version): r2.4.1-1
• Operating System and version: Ubuntu Xenial LTS (16.04), Kernel version: 4.4.0-59
• Enabled features (icinga2 feature list):
  Disabled features: api compatlog debuglog gelf opentsdb
  Enabled features: checker command graphite icingastatus ido-mysql livestatus mainlog notification
  perfdata statusdata syslog
• Config validation (icinga2 daemon -C):

information/ConfigCompiler: Compiling config file: /etc/icinga2/icinga2.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/constants.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/zones.conf
information/ConfigCompiler: Compiling config file: /usr/share/icinga2/include/itl
information/ConfigCompiler: Compiling config file: /usr/share/icinga2/include/command.conf
information/Utility: Loading library 'libmethods.so'
information/ConfigCompiler: Compiling config file: /usr/share/icinga2/include/command-icinga.conf
information/ConfigCompiler: Compiling config file: /usr/share/icinga2/include/timeperiod.conf
information/ConfigCompiler: Compiling config file: /usr/share/icinga2/include/plugins
information/ConfigCompiler: Compiling config file: /usr/share/icinga2/include/command-plugins.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/checker.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/command.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/graphite.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/icingastatus.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/ido-mysql.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/livestatus.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/mainlog.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/notification.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/perfdata.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/statusdata.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/features-enabled/syslog.conf
information/Utility: Loading library 'libchecker.so'
information/Utility: Loading library 'libcompat.so'
information/Utility: Loading library 'libperfdata.so'
information/Utility: Loading library 'libdb_ido_mysql.so'
information/Utility: Loading library 'liblivestatus.so'
information/Utility: Loading library 'libnotification.so'
information/Utility: Loading library 'libperfdata.so'
information/Utility: Loading library 'libcompat.so'
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/app.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/apt.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/commands.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/downtimes.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/groups.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/hosts.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/notifications.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/satellite.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/services.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/templates.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/timeperiods.conf
information/ConfigCompiler: Compiling config file: /etc/icinga2/conf.d/users.conf
information/ConfigCompiler: Compiling config file: /var/lib/icinga2/api/packages/_api/include.conf
information/ConfigCompiler: Compiling config file: /var/lib/icinga2/api/packages/_api/icinga01.dev.bigfishgames.com-1497457702-1/include.conf
information/ConfigCompiler: Compiling config file: /var/lib/icinga2/api/packages/_api/icinga01.dev.bigfishgames.com-1497457702-1/../active.conf
information/ConfigCompiler: Compiling config file: /var/lib/icinga2/api/packages/_api/icinga01.dev.bigfishgames.com-1497457702-1/conf.d/downtimes/icinga01.dev.bigfishgames.com!load!icinga01.dev.bigfishgames.com-1497776451-7.conf
information/ConfigItem: Committing config items
information/ConfigItem: Instantiated 1 FileLogger.
information/ConfigItem: Instantiated 1 SyslogLogger.
information/ConfigItem: Instantiated 1 Zone.
information/ConfigItem: Instantiated 1 Endpoint.
information/ConfigItem: Instantiated 1 IdoMysqlConnection.
information/ConfigItem: Instantiated 54 CheckCommands.
information/ConfigItem: Instantiated 2 NotificationCommands.
information/ConfigItem: Instantiated 12 Notifications.
information/ConfigItem: Instantiated 1 IcingaApplication.
information/ConfigItem: Instantiated 1 IcingaStatusWriter.
information/ConfigItem: Instantiated 1 Host.
information/ConfigItem: Instantiated 2 HostGroups.
information/ConfigItem: Instantiated 1 User.
information/ConfigItem: Instantiated 1 UserGroup.
information/ConfigItem: Instantiated 1 Downtime.
information/ConfigItem: Instantiated 11 Services.
information/ConfigItem: Instantiated 3 TimePeriods.
information/ConfigItem: Instantiated 3 ServiceGroups.
information/ConfigItem: Instantiated 1 ScheduledDowntime.
information/ConfigItem: Instantiated 1 CheckerComponent.
information/ConfigItem: Instantiated 1 StatusDataWriter.
information/ConfigItem: Instantiated 1 ExternalCommandListener.
information/ConfigItem: Instantiated 1 PerfdataWriter.
information/ConfigItem: Instantiated 1 GraphiteWriter.
information/ConfigItem: Instantiated 1 LivestatusListener.
information/ConfigItem: Instantiated 1 NotificationComponent.
information/ScriptGlobal: Dumping variables to file '/var/cache/icinga2/icinga2.vars'
information/cli: Finished validating the configuration file(s).```

[Mikesch-mp]

Looks like Grafana deletes not all the old infos from a dashboard. I created a new one from scratch and the entries are not there anymore.
But for hostalive it will not work, you stil have to create a seperate graph in grafana and configure the graph in the icinga web 2 module.