Trouble installing "There is currently no icinga instance writing to the IDO."

I have made it to the “Monitoring IDO Resource” part of the setup. But I receive this error whenever I click “Validate Configuration”

There is currently no icinga instance writing to the IDO. Make sure that a icinga instance is configured and able to write to the IDO.
Validation Log

Connection to icingaido as idouser on localhost: successful
have_ssl: YES
protocol_version: 10
version: 8.0.17
version_compile_os: Linux
Ssl_cipher: 

From what I can tell this is a common issue and is caused by improper permissions on the features-available directory, however I have since fixed those permissions and still have the same issue.

[root@icinga features-available]# ls -lah
total 72K
drwxr-x—. 2 icinga icinga 4.0K Jul 25 15:45 .
drwxr-x—. 7 root icinga 160 Jul 25 15:35 …
-rw-rw----. 1 icinga icinga 183 May 23 06:22 api.conf
-rw-rw----. 1 icinga icinga 112 May 23 06:22 checker.conf
-rw-rw----. 1 icinga icinga 140 May 23 06:22 command.conf
-rw-rw----. 1 icinga icinga 159 May 23 06:22 compatlog.conf
-rw-rw----. 1 icinga icinga 235 May 23 06:22 debuglog.conf
-rw-rw----. 1 icinga icinga 193 May 23 06:22 elasticsearch.conf
-rw-rw----. 1 icinga icinga 206 May 23 06:22 gelf.conf
-rw-rw----. 1 icinga icinga 190 May 23 06:22 graphite.conf
-rw-rw----. 1 icinga icinga 302 Jul 25 15:44 ido-mysql.conf
-rw-rw----. 1 icinga icinga 560 May 23 06:22 influxdb.conf
-rw-rw----. 1 icinga icinga 127 May 23 06:22 livestatus.conf
-rw-rw----. 1 icinga icinga 159 May 23 06:22 mainlog.conf
-rw-rw----. 1 icinga icinga 129 May 23 06:22 notification.conf
-rw-rw----. 1 icinga icinga 190 May 23 06:22 opentsdb.conf
-rw-rw----. 1 icinga icinga 146 May 23 06:22 perfdata.conf
-rw-rw----. 1 icinga icinga 225 May 23 06:22 statusdata.conf
-rw-rw----. 1 icinga icinga 127 May 23 06:22 syslog.conf

My ido-mysql.conf:

[root@icinga features-available]# cat /etc/icinga2/features-enabled/ido-mysql.conf
/**
* The IdoMysqlConnection type implements MySQL support
* for DB IDO.
*/

object IdoMysqlConnection "ido-mysql" {
        host = "localhost"
        //port = 3306
        user = "idouser"
        password = "***"
        database = "icingaido"

        cleanup = {
                downtimehistory_age = 48h
                contactnotifications_age = 31d
        }
}

And icinga2 is running:
> systemctl status icinga2 -l

● icinga2.service - Icinga host/service/network monitoring system
   Loaded: loaded (/usr/lib/systemd/system/icinga2.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2019-07-25 15:44:36 MDT; 3 days ago
  Process: 26443 ExecStartPre=/usr/lib/icinga2/prepare-dirs /etc/sysconfig/icinga2 (code=exited, status=0/SUCCESS)
 Main PID: 26451 (icinga2)

My OS version:

centos-release-7-6.1810.2.el7.centos.x86_64

Any help would be greatly appreciated.

Look into the warning, it says something about that Icinga 2 isn’t actively writing to the IDO database backend. Since you’ve posted the features-enabled configuration already, your next step should be to verify that the connection worked. You can do so within the icinga2.log in /var/log/icinga2.

Cheers,
Michael

Thank you, looking at the logs shows its was not so much an issue with IDO - Database communication (as the error indicated) but missing nagios plugins. Some how nagios-plugins-all never got installed. installed them and it validated. Might I suggest file validation checks just to make sure all needing files are in the right places?

Wondering why missing plugins would cause the core not to write anything to the IDO database. Within the icinga2.log file you did see entries for successful connects and writes, right?

Problem is more or less, that the plugins are not necessarily run on the same host where Icinga Web 2 is running on. You might just setup web on a standalone server, not related to the core itself. That being said, the installer for web doesn’t know much about the core - except for the resources you’re defining as backend (IDO, REST API).

Cheers,
Michael

the Log file was filled with nothing but errors about the plugins. never saw anything regarding IDO

Try using grep and friends when analysing the log files. This allows to filter for specific strings and words.