Comments on How to Install Icinga 2 Monitoring Tool on Debian 9.2

mysql -u root icingadb -p < /usr/share/icinga2-ido-mysql/schema/mysql.sql

appears to hang and never return.....

another error in your docs, setting

"/var/log/icingaweb2/icingaweb2.log"

see's

"file path is not writable"

"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."

another error message.......

 

"

Finally, log in to server’s command line again and execute the following commands in order to make sure that Icinga Web 2 logs will be created.

mkdir -p /var/log/icingaweb2/

chgrp -R icingaweb2 /var/log/icingaweb2/

chmod -R 775 /var/log/icingaweb2/

This needs to be moved up the article to fix the first problem I had.  However the dashbaord is empty and not as shown so there article needs some work still

So icinga will not run, I suspect its because the mysql database is not formed correctly so your document needs work in this area.

=======

root@ininga-001:~# systemctl status icinga2 ? icinga2.service - Icinga host/service/network monitoring system   Loaded: loaded (/lib/systemd/system/icinga2.service; enabled; vendor preset: enabled)   Active: failed (Result: exit-code) since Wed 2017-11-29 10:43:31 NZDT; 34s ago  Process: 969 ExecStart=/usr/sbin/icinga2 daemon -e ${ICINGA2_ERROR_LOG} (code=exited, status=1/FAILURE)  Process: 909 ExecStartPre=/usr/lib/icinga2/prepare-dirs /usr/lib/icinga2/icinga2 (code=exited, status=0/SUCCESS) Main PID: 969 (code=exited, status=1/FAILURE)Nov 29 10:43:31 ininga-001 icinga2[969]: [2017-11-29 10:43:31 +1300] information/ConfigObject: Restored 249 objects. Loaded 0 new objects without state.Nov 29 10:43:31 ininga-001 icinga2[969]: [2017-11-29 10:43:31 +1300] information/ConfigItem: Triggering Start signal for config itemsNov 29 10:43:31 ininga-001 icinga2[969]: [2017-11-29 10:43:31 +1300] information/ConfigItem: Activated all objects.Nov 29 10:43:31 ininga-001 icinga2[969]: [2017-11-29 10:43:31 +1300] information/DbConnection: Resuming IDO connection: ido-mysqlNov 29 10:43:31 ininga-001 icinga2[969]: [2017-11-29 10:43:31 +1300] critical/IdoMysqlConnection: Schema does not provide any valid version! Verify your schema installation.Nov 29 10:43:31 ininga-001 icinga2[969]: Context:Nov 29 10:43:31 ininga-001 icinga2[969]:         (0) Reconnecting to MySQL IDO database 'ido-mysql'Nov 29 10:43:31 ininga-001 systemd[1]: icinga2.service: Main process exited, code=exited, status=1/FAILURENov 29 10:43:31 ininga-001 systemd[1]: icinga2.service: Unit entered failed state.Nov 29 10:43:31 ininga-001 systemd[1]: icinga2.service: Failed with result 'exit-code'.root@ininga-001:~# ======

 

Hello

i followed step by step and at the end i got a 

Sorry! Failed to set up Icinga Web 2 successfully. User Group Backend configuration has been successfully written to: /etc/icingaweb2/groups.ini 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 'icingadb.icingaweb_group' doesn't exist, query was: SELECT COUNT(*) AS cnt FROM icingaweb_group AS g WHERE (g.name = 'Administrators')

I had the same error, but after running the command

$ icinga2 feature enable command

 

the installation worked for me.

thanks a lot! and a lot!

icinga is currently not up and running

And this ?

icinga2 feature enable ido-mysql 

before configure IDO