Icingadb unable to access MySQL and/or Redis

Icinga DB
1
  • Icinga DB Web version: 1.0.0-rc2
  • Icinga Web 2 version: 2.9.5
  • Icinga 2 version: r2.13.2-1
  • Icinga DB version: v1.0.0-rc2-dev
  • PHP version used: 7.4.3
  • Icinga PHP Third Library: 0.7.0
  • Icinga PHP Third Party: 0.10.0
  • Server operating system and version: Ubuntu 20.04.3 LTS

Having followed the installation guides at Installation - Icinga DB and Installation - Icinga DB, Icinga is stating that IcingaDB doesn’t seem to be running. The health section of the Web interface states “Icinga DB is not running or not writing into the database” for Icinga DB and “Can’t connect to Icinga Redis: Trying to get property ‘heartbeat’ of non-object” for Icinga Redis.

When validating the configuration for Redis in the “icingadb” module, it states “Primary connection established but failed to verify Icinga is connected as well.” Setting up the icingadb as a resource in icingaweb showed that the credentials entered(the default ones) could connect to the database too.

Output from “systemctl status icingadb” is as follows:

● icingadb.service - Icinga DB
     Loaded: loaded (/lib/systemd/system/icingadb.service; enabled; vendor preset: enabled)
     Active: active (running) since Tue 2021-11-23 21:23:49 UTC; 46min ago
   Main PID: 2576 (icingadb)
      Tasks: 4 (limit: 2296)
     Memory: 8.6M
     CGroup: /system.slice/icingadb.service
             └─2576 /usr/sbin/icingadb --config /etc/icingadb/config.yml

Nov 23 21:23:49 vmmon-icingamaster-dev systemd[1]: Starting Icinga DB...
Nov 23 21:23:49 vmmon-icingamaster-dev icingadb[2576]: Starting Icinga DB
Nov 23 21:23:49 vmmon-icingamaster-dev systemd[1]: Started Icinga DB.
Nov 23 21:23:49 vmmon-icingamaster-dev icingadb[2576]: Connecting to database
Nov 23 21:23:49 vmmon-icingamaster-dev icingadb[2576]: Connecting to Redis
Nov 23 21:23:52 vmmon-icingamaster-dev icingadb[2576]: Waiting for current Redis schema version

Output from “systemctl status icingadb-redis” is as follows:

● icingadb-redis-server.service - Advanced key-value store
     Loaded: loaded (/lib/systemd/system/icingadb-redis-server.service; enabled; vendor preset: enabled)
     Active: active (running) since Tue 2021-11-23 21:17:22 UTC; 54min ago
       Docs: http://redis.io/documentation,
             man:icingadb-redis-server(1)
   Main PID: 2275 (icingadb-redis-)
     Status: "Ready to accept connections"
      Tasks: 5 (limit: 2296)
     Memory: 7.2M
     CGroup: /system.slice/icingadb-redis-server.service
             └─2275 /usr/bin/icingadb-redis-server 127.0.0.1:6380

Nov 23 21:17:22 vmmon-icingamaster-dev systemd[1]: Starting Advanced key-value store...
Nov 23 21:17:22 vmmon-icingamaster-dev systemd[1]: Started Advanced key-value store.

Not sure where to investigate further here unfortunately. Everything is running on the same server and the firewall for the server is turned off.

2

This tells you that Icinga DB is running fine for now, but is idling because it doesn’t feel responsible. Icinga 2 doesn’t write into Redis, which also the config form validation told you, is the reason for that.

Is the icingadb feature of Icinga 2 active? Does it connect successfully to Redis?

Edit: Since this is still not covered in the documentation, I guess the feature isn’t active. Head over here on how to enable it.

1 Like
3

That was it. Thank you!