Icinga install on Ubuntu 20.04 fails

Icinga 2
1

Hi,

To skip description, I am facing similar issue as here on a brand new install today: Installation instructions for Ubutnu incorrect · Issue #7934 · Icinga/icinga2 · GitHub .

However versions are different.

I am using: Ubuntu 20.04
Icinga Version: r2.13.5-1

At stage: Monitoring Backend we are offered “Backend Type” of IDO only.

I have the option to choose “MySQL”, but I still get the error:
Cannot find the IDO schema. Please verify that the given database contains the schema and that the configured user has access to it

If I skip validation, when I login to Icinga2 I get database error on the right, as mentioned on the Github issue.

How to proceed from here?

2

Hi,

skipping validation is usually not a good idea.
You might want to check your SQL and IDO environment.

Did you create a database for Icinga?
Did you import the IDO scheme for Icinga?
Did you activate the SQL feature and restart the Icinga service.

3

Did you create a database for Icinga? Yes.

Did you import the IDO scheme for Icinga? I ran this to import the database “mysql -u root -p icingadb </usr/share/icingadb/schema/mysql/schema.sql” .

Did you activate the SQL feature and restart the Icinga service. Can you elaborate on this?

4

At the beginning of the installation wizard for Icinga Web 2, make sure that the Icinga DB Module is enabled. If it doesn’t show up, please have a look at Ubuntu - Icinga DB Web

5

I chose MySQL. I only had MySQL as option.

If you want, I can re-do the install and upload a screen recording video.

6

I managed to install it. I needed to not enable the IDO module during configuration if Icinga Web (I made the mistake to have it together with Icinga Web).

Thanks for the help guys.