Icinga is currently not up and running

All validation are completed but still in web page shows icinga is currelty not up and running and when I checked the status the icinga2.service it shows, below and try to figure out the issue from all online solutions but no luck, anyone help me:

[2020-09-01 16:47:55 +0530] information/cli: Icinga application loader (version: 2.12.0-1)
[2020-09-01 16:47:55 +0530] information/cli: Loading configuration file(s).
[2020-09-01 16:47:55 +0530] critical/config: Error: Value computed is not used.
Location: in /etc/icinga2/features-enabled/ido-mysql.conf: 1:0-1:1
/etc/icinga2/features-enabled/ido-mysql.conf(1): ii/**
^^
/etc/icinga2/features-enabled/ido-mysql.conf(2): * The IdoMysqlConnection type implements MySQL support
/etc/icinga2/features-enabled/ido-mysql.conf(3): * for DB IDO.

[2020-09-01 16:47:55 +0530] critical/cli: Config validation failed. Re-run with ‘icinga2 daemon -C’ after fixing the config.

Active: failed (Result: exit-code) since Tue 2020-09-01 16:15:29 IST; 19min ago
Process: 3661 ExecStart=/usr/sbin/icinga2 daemon --close-stdio -e ${ICINGA2_ERROR_LOG} (code=exited, status=1/FAILURE)
Process: 3654 ExecStartPre=/usr/lib/icinga2/prepare-dirs /etc/sysconfig/icinga2 (code=exited, status=0/SUCCESS)
Main PID: 3661 (code=exited, status=1/FAILURE)

Sep 01 16:15:29 icinga icinga2[3661]: [2020-09-01 16:15:29 +0530] critical/config: Error: Value computed is not used.
Sep 01 16:15:29 icinga icinga2[3661]: Location: in /etc/icinga2/features-enabled/ido-mysql.conf: 1:0-1:1
Sep 01 16:15:29 icinga icinga2[3661]: /etc/icinga2/features-enabled/ido-mysql.conf(1): ii/**
Sep 01 16:15:29 icinga icinga2[3661]: ^^
Sep 01 16:15:29 icinga icinga2[3661]: /etc/icinga2/features-enabled/ido-mysql.conf(2): * The IdoMysqlConnection type implements MySQL support
Sep 01 16:15:29 icinga icinga2[3661]: /etc/icinga2/features-enabled/ido-mysql.conf(3): * for DB IDO.
Sep 01 16:15:29 icinga icinga2[3661]: [2020-09-01 16:15:29 +0530] critical/cli: Config validation failed. Re-run with ‘icinga2 daemon -C’ after fixing the config.
Sep 01 16:15:29 icinga systemd[1]: icinga2.service: Main process exited, code=exited, status=1/FAILURE
Sep 01 16:15:29 icinga systemd[1]: icinga2.service: Failed with result ‘exit-code’.
Sep 01 16:15:29 icinga systemd[1]: Failed to start Icinga host/service/network monitoring system.

Hi & welcome to the icinga community,

It looks like your /etc/icinga2/features-available/ido-mysql.conf is wrong. Could you share it?

BTW: For better readability please format your posts as described here.

Thanks Mr. Roland !

Below is my ido-mysql.conf

( library “db_ido_mysql”

object IdoMysqlConnection “icinga_ido” {
user = “root”
password = “xxxxxxxxx”
host = “localhost”
database = “icingaweb2” )

And I believe it is readable format if it is not please do let me know.

No, it’s not very readable. I’m sorry.

library “db_ido_mysql”

object IdoMysqlConnection “icinga_ido” {
   user = “root”
   password = “xxxxxxxxx”
   host = “localhost”
   database = “icingaweb2”
}

I’d assume you added “(” and “)” here to make it better readable and they are not in your conf file, right?

However, “}” is missing at the end. To verify a configuration (which is recommended before trying a reload) use the command icinga2 daemon -C.

You’ve configured icingaweb2 as database for ido which brings me to a guess you’ve mixed up the databases. You need to have two databases at least: One for icinga2 core (which is usually named icinga2) and one for icingaweb2 (which is usually named icingaweb2).

[root@icinga ~]# icinga2 daemon -C
[2020-09-02 11:46:17 +0530] information/cli: Icinga application loader (version: 2.12.0-1)
[2020-09-02 11:46:17 +0530] information/cli: Loading configuration file(s).
[2020-09-02 11:46:17 +0530] critical/config: Error: Value computed is not used.
Location: in /etc/icinga2/features-enabled/ido-mysql.conf: 1:0-1:1
/etc/icinga2/features-enabled/ido-mysql.conf(1): ii/**
^^
/etc/icinga2/features-enabled/ido-mysql.conf(2): * The IdoMysqlConnection type implements MySQL support
/etc/icinga2/features-enabled/ido-mysql.conf(3): * for DB IDO.

[2020-09-02 11:46:17 +0530] critical/cli: Config validation failed. Re-run with ‘icinga2 daemon -C’ after fixing the config.

Hi RSX, I am not expert in Linux as I am a windows person but still wanted to implement this that is the reason I am lacking with the commands and you might be correct that I am mixing it.

library “db_ido_mysql”

object IdoMysqlConnection “icinga_ido” {
user = “root”
password = "xxxxxxxxxicinga not up and running_02092020 "
host = “localhost”
database = “icingaweb2”

Please guide me.

I’m sorry, I’m not able to help you since you do not post correctly. The error message clearly shows that you conf files starts with two i and in your (still unformatted) post they are missing.

Sorry, please manage for sometime as I am very much new for these conversation.

I have changed my ido-mysql as per recommended as per below and restarted the cinga2 service but now it is some different issue:

/**

  • The db_ido_mysql library implements IDO functionality
  • for MySQL.
    */
    library “db_ido_mysql”
    object IdoMysqlConnection “ido-mysql” {
    user = “root”
    password = “xxxxxxxxx”
    host = “localhost”
    database = “icingaweb2”