Hello everyone!
I’m very new to Icinga so first and foremost I would like to apologize if I placed this question in the wrong section or repeated a question in the community message board.
I’m running into the following error when configuring Icinga Web 2:
Unable to create user group “Administrators”. An error occured:
ERROR: Zend_Db_Statement_Exception in /usr/share/icingaweb2/library/vendor/Zend/Db/Statement/Pdo.php:225 with message: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘icinga_users.icingaweb_group’ doesn’t exist, query was: SELECT COUNT(*) AS cnt FROM icingaweb_group AS g WHERE (g.name = ‘Administrators’)
I have two nodes. On one node I installed Icinga 2 and Icinga Web 2 and on another node is simply the database. During the configuration, I was able to connect to the database but I ran into the following issues:
For Authentication I selected Database and I entered the required information and clicked on Validate Configuration which states
" The configuration has been successfully validated."
BUT when I click on “Next” it tells me
" * It seems that either the database you defined earlier does not yet exist and cannot be created using the provided access credentials, the database does not have the required schema to be operated by Icinga Web 2 or the provided access credentials do not have the sufficient permissions to access the database. Please provide appropriate access credentials to solve this."
This is after using the correct username and password for the database which I granted full access to the needed database.
I would assume that it’s not a good idea to “Skip Validation” but if I did everything is fine until I get to the Monitoring Backend set up backend type being IDO. I set up the database information (After I enabled the Ido-mysql feature and imported the database from /usr/share/icinga2-ido-mysql/schema/mysql.sql)
For Monitoring IDO Resource I filled in the database information I got the following:
- 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 icinga_ido as icinga on hostname:3306 successful
have_ssl: DISABLED
protocol_version: 10
version: 5.5.60-MariaDB
version_compile_os: Linux
I can skip it but I’m sure that’s not recommended and once I confirm the settings I get the error message I posted above. Also, on the node that has Icinga2 and Icinga 2 Web I did configure /etc/icinga2/features-enabled/ido-mysql.conf with the required information but not sure what else to do.
Again, sorry if this is answered somewhere else I didn’t really find it myself and thank you in advance for any and all help even if it’s just someone pointing to the proper documentation to figure this out. Thank you and have a great day/goodnight!