Setting up database with icingaweb2

[ctindorf]

Hey Icinga-Community,

I am stuck with setting up the database resource with the icingaweb2 setup assistant.

In one of the first steps, it wants to setup the database resource. After I put in the required data, I get an additional step with (roughly translated):

“The defined database does not exist, cannot be created with the provided credentials or does not meet the required scheme”

I already tried:

“Importing” a database scheme with
mysql -u root -p icinga2 < /usr/share/icinga2-ido-mysql/schema/mysql.sql

Creating an “import-user” on the SQL Database and
GRANT ALL PRIVILEGES ON icinga2.* to ‘icingaimport’@‘localhost’;

Most likely I somehow missed the important stuff on the documentation. Can someone please point me to it?

[log1c]

Simply provide high enough credentials to create the icingaweb2 database (this is the database for icingaweb where it stores users and groups.)
This could simply be the root user of the mysql db.

Here is a schema overview of Icinga where the databases are listed as well:

Icinga 2 communication schemas

As I have posted them before, I’ll also post them here and hope they are useful for someone when figuring out a problem or explaining how Icinga 2 communicates on the inside. Icinga 2 + Icinga Web 2 + Icinga Director + Graphite [image] Icinga 2 + Icinga Web 2 + Icinga Director + PNP4Nagios [image] Hope both are correct. If not, please tell me and I will correct the error(s)