Unable to create user group "Administrators": ERROR: Zend_Db_Adapter_Exception

Events and Community
,
1

icinga error -4
icinga error -4839×453 145 KB

Hello All,
Created VM on Esxi-6
IP:192.168.26.50
Icinga2 installation from below link on Centos7 - mariadb - php73

/etc/icingaweb2/authentication.ini
[icingaweb2]
backend = “db”
resource = “icingaweb_db”

/etc/icingaweb2/resources.ini
[icingaweb_db]
type = “db”
db = “mysql”
host = “localhost”
dbname = “icingaweb”
username = “icingaweb”
password = “icinga”
use_ssl = “0”

[icinga_ido]
type = “db”
db = “mysql”
host = “localhost”
dbname = “icinga”
username = “icinga”
password = “icinga”
use_ssl = “0”

/etc/icingaweb2/groups.ini
[icingaweb2]
backend = “db”
resource = “icingaweb_db”

I am new in Icinga, please help!!!

Thanks in Advance
junoon

2

Looks like your icingaweb database is missing the correct schema.
In the web-based setup, after you have defined the settings for the ‘icingaweb’ database, the setup asks for an account with root/administrative privileges, if the database is not present/missing the schema.
Provide the root user for the MySQL databse there and the setup should do the rest.

3

Hello Log1c,

thanks for your reply but I am new in icinga and mysql, could you let me know the through the command line of setting up schema. Web base setup doesn’t have an option for root privileges or may be i am missing something.
Thanks again

4

Tbh I have no idea where the icingaweb2 schema file is stored :open_mouth:

If you followed the howto you posted the database should set itself up correctly in Step 19.5.

In case the web-based setup wasn’t able to do that in this step you should normally get another window where you are asked to provide administrative credentials with which the setup will then do the setup.

Check again if you have done the following steps:
Create the database for Icinga Web 2:

CREATE DATABASE icingaweb;

Now, configure permissions:

GRANT ALL PRIVILEGES ON icingaweb.* TO 'icingaweb'@'localhost' IDENTIFIED BY 'icingaweb';

Deploy privileges:

FLUSH PRIVILEGES;

5

Already created “icingaweb” database with permission. But on the web-based setup I am not getting another window where it asked for administrative credentials to complete the step

Below the link I followed for my installation and configuration

Thanks