IDO Icinga2 Scheme

Question

I followed the steps to configure icinga on a server with a UI v 2.0 icingaweb layout, as indicated in the documentation . I managed to get to the setup page, which requires you to enter a token, and then follow these steps. I am stuck at this place (see screenshot) right now, which requires installing an IDO database, which I have already done, as shown:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| icinga             |
| icinga2idomysql    |
| icinga_ido         |
| mysql              |
| performance_schema |
+--------------------+

However, I keep getting the error message Cannot find the IDO schema. Please verify that the given database contains the schema and that the configured user has access to it.. Can someone help me or point out what I'm doing wrong.

Answer 1

Use the credentials set when configuring icinga2. This is itself.

, , psql IDO Ubuntu :

/etc/icinga2/features-enabled/ido-pgsql.conf

:

/**
 * The db_ido_pgsql library implements IDO functionality
 * for PostgreSQL.
 */

library "db_ido_pgsql"

object IdoPgsqlConnection "ido-pgsql" {
  user = "icinga2",
  password = "<PASSWORD>",
  host = "localhost",
  database = "icinga2"
}

, icinga2 , :

tail -f /var/log/icinga2/startup.log

, :

service icinga2 restart

Answer 2

, "icinga2-ido-mysql". . ubuntu.

apt-get install mysql-server mysql-client icinga2-ido-mysql
icinga2 feature enable ido-mysql
icinga2 feature enable command
service icinga2 restart

icinga, , "icinga2" db ido scehma, icinga2-ido-mysql

Answer 3

.

Answer 4

CentOS 7:

cp /usr/share/icinga2-ido-mysql/schema/mysql.sql .
sed -i "1iuse icinga;" mysql.sql
mysql -u root -p < mysql.sql

:

https://lists.icinga.org/pipermail/icinga-users/2014-July/008424.html