I have freshly Installed Icinga but getting an error on UI as “icinga is currently not up and running”
Below is /etc/icinga2/features-available/ido-mysql.conf file
/**
- The IdoMysqlConnection type implements MySQL support
- for DB IDO.
*/
object IdoMysqlConnection “ido-mysql” {
user = “icinga”
password = “XXXX”
host = “localhost”
database = “icinga”
}
Below is my /etc/icinga2/features-available/ido-pgsql.conf file
/**
- The IdoPgsqlConnection type implements PostgreSQL support
- for DB IDO.
*/
object IdoPgsqlConnection “ido-pgsql” {
user = “icinga”
password = “XXXX”
host = “localhost”
database = “icinga”
}
Here is the Output from icinga2 daemon -C
[2021-11-10 15:57:46 -0600] information/cli: Icinga application loader (version: 2.13.1-1)
[2021-11-10 15:57:46 -0600] information/cli: Loading configuration file(s).
[2021-11-10 15:57:46 -0600] warning/ConfigCompiler: Cannot compile file ‘/etc/icinga2/features-enabled/ido-mysql.conf’: Error: Function call ‘std::ifstream::open’ for file ‘/etc/icinga2/features-enabled/ido-mysql.conf’ failed with error code 13, ‘Permission denied’
Context:
(0) Compiling configuration file ‘/etc/icinga2/features-enabled/ido-mysql.conf’
[2021-11-10 15:57:46 -0600] information/ConfigItem: Committing config item(s).
[2021-11-10 15:57:46 -0600] information/ApiListener: My API identity: ip-10-51-0-28.us-east-2.compute.internal
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 NotificationComponent.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 IdoPgsqlConnection.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 CheckerComponent.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 User.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 UserGroup.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 3 ServiceGroups.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 3 TimePeriods.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 11 Services.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 3 Zones.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 ScheduledDowntime.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 2 NotificationCommands.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 2 HostGroups.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 12 Notifications.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 Downtime.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 IcingaApplication.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 Host.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 Endpoint.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 IcingaDB.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 FileLogger.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 ApiUser.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 244 CheckCommands.
[2021-11-10 15:57:46 -0600] information/ConfigItem: Instantiated 1 ApiListener.
[2021-11-10 15:57:46 -0600] information/ScriptGlobal: Dumping variables to file ‘/var/cache/icinga2/icinga2.vars’
[2021-11-10 15:57:46 -0600] information/cli: Finished validating the configuration file(s).
below error i am getting in logs
[2021-11-10 15:59:07 -0600] critical/IdoPgsqlConnection: Connection to database ‘icinga’ with user ‘icinga’ on ‘localhost:5432’ failed: "FATAL: Ident authentication failed for user “icinga”
"
Context:
(0) Reconnecting to PostgreSQL IDO database ‘ido-pgsql’
[2021-11-10 15:59:07 -0600] warning/IdoPgsqlConnection: Exception during database operation: Verify that your database is operational!
[2021-11-10 15:59:07 -0600] information/IcingaDB: Trying to connect to Redis server (async) on host ‘127.0.0.1:6380’
[2021-11-10 15:59:07 -0600] critical/IcingaDB: Cannot connect to 127.0.0.1:6380: Connection refused
[2021-11-10 15:59:12 -0600] information/IcingaDB: Trying to connect to Redis server (async) on host ‘127.0.0.1:6380’
[2021-11-10 15:59:12 -0600] critical/IcingaDB: Cannot connect to 127.0.0.1:6380: Connection refused
Kindly assist me here