IcingaDB / Icinga-Redis / DB cant talk to each other?!

Hey,

I tried to setup a new fresh test-icinga2-environment on my computer in a debian 11 virtual-machine.

Followed this guide (22.09.2022): Debian - Icinga 2
Installed all modules and packages without any changes in some configurations.

I also used the credentials from the instructions (just to test, local network…, dont worry).

Now after the website wizard to setup icinga2, I get this message:

I entered the correct details everytime in the wizard and pressed every time “validate settings” before I click on “next” in the wizard.

Log Files:

icingadb-redis-server.log:

9519:C 22 Sep 2022 17:02:36.339 * Supervised by systemd. Please make sure you set appropriate values for TimeoutStartSec and TimeoutStopSec in your service unit.
9519:C 22 Sep 2022 17:02:36.340 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
9519:C 22 Sep 2022 17:02:36.340 # Redis version=7.0.2, bits=64, commit=e3d5cdc5, modified=0, pid=9519, just started
9519:C 22 Sep 2022 17:02:36.340 # Configuration loaded
9519:M 22 Sep 2022 17:02:36.340 * monotonic clock: POSIX clock_gettime
9519:M 22 Sep 2022 17:02:36.340 * Running mode=standalone, port=6380.
9519:M 22 Sep 2022 17:02:36.340 # Server initialized
9519:M 22 Sep 2022 17:02:36.341 * Ready to accept connections
9519:signal-handler (1663858976) Received SIGTERM scheduling shutdown...
9519:M 22 Sep 2022 17:02:56.213 # User requested shutdown...
9519:M 22 Sep 2022 17:02:56.213 * Saving the final RDB snapshot before exiting.
9519:M 22 Sep 2022 17:02:56.214 * DB saved on disk
9519:M 22 Sep 2022 17:02:56.214 * Removing the pid file.
9519:M 22 Sep 2022 17:02:56.214 # Redis is now ready to exit, bye bye...
9626:C 22 Sep 2022 17:02:56.253 * Supervised by systemd. Please make sure you set appropriate values for TimeoutStartSec and TimeoutStopSec in your service unit.
9626:C 22 Sep 2022 17:02:56.253 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
9626:C 22 Sep 2022 17:02:56.253 # Redis version=7.0.2, bits=64, commit=e3d5cdc5, modified=0, pid=9626, just started
9626:C 22 Sep 2022 17:02:56.253 # Configuration loaded
9626:M 22 Sep 2022 17:02:56.254 * monotonic clock: POSIX clock_gettime
9626:M 22 Sep 2022 17:02:56.254 * Running mode=standalone, port=6380.
9626:M 22 Sep 2022 17:02:56.254 # Server initialized
9626:M 22 Sep 2022 17:02:56.255 * Loading RDB produced by version 7.0.2
9626:M 22 Sep 2022 17:02:56.255 * RDB age 0 seconds
9626:M 22 Sep 2022 17:02:56.255 * RDB memory usage when created 0.84 Mb
9626:M 22 Sep 2022 17:02:56.255 * Done loading RDB, keys loaded: 0, keys expired: 0.
9626:M 22 Sep 2022 17:02:56.255 * DB loaded from disk: 0.000 seconds
9626:M 22 Sep 2022 17:02:56.255 * Ready to accept connections
9626:M 22 Sep 2022 17:03:57.001 * 10000 changes in 60 seconds. Saving...
9626:M 22 Sep 2022 17:03:57.002 * Background saving started by pid 9970
9970:C 22 Sep 2022 17:03:57.021 * DB saved on disk
9970:C 22 Sep 2022 17:03:57.022 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
9626:M 22 Sep 2022 17:03:57.103 * Background saving terminated with success
9626:M 22 Sep 2022 17:08:58.079 * 100 changes in 300 seconds. Saving...
9626:M 22 Sep 2022 17:08:58.080 * Background saving started by pid 17366
17366:C 22 Sep 2022 17:08:58.102 * DB saved on disk
17366:C 22 Sep 2022 17:08:58.103 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
9626:M 22 Sep 2022 17:08:58.181 * Background saving terminated with success
9626:signal-handler (1663859588) Received SIGTERM scheduling shutdown...
9626:M 22 Sep 2022 17:13:08.468 # User requested shutdown...
9626:M 22 Sep 2022 17:13:08.469 * Saving the final RDB snapshot before exiting.
9626:M 22 Sep 2022 17:13:08.495 * DB saved on disk
9626:M 22 Sep 2022 17:13:08.495 * Removing the pid file.
9626:M 22 Sep 2022 17:13:08.495 # Redis is now ready to exit, bye bye...
452:C 22 Sep 2022 17:13:24.385 * Supervised by systemd. Please make sure you set appropriate values for TimeoutStartSec and TimeoutStopSec in your service unit.
452:C 22 Sep 2022 17:13:24.385 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
452:C 22 Sep 2022 17:13:24.385 # Redis version=7.0.2, bits=64, commit=e3d5cdc5, modified=0, pid=452, just started
452:C 22 Sep 2022 17:13:24.385 # Configuration loaded
452:M 22 Sep 2022 17:13:24.386 * monotonic clock: POSIX clock_gettime
452:M 22 Sep 2022 17:13:24.387 * Running mode=standalone, port=6380.
452:M 22 Sep 2022 17:13:24.387 # Server initialized
452:M 22 Sep 2022 17:13:24.388 * Loading RDB produced by version 7.0.2
452:M 22 Sep 2022 17:13:24.388 * RDB age 16 seconds
452:M 22 Sep 2022 17:13:24.388 * RDB memory usage when created 3.33 Mb
452:M 22 Sep 2022 17:13:24.403 * Done loading RDB, keys loaded: 54, keys expired: 0.
452:M 22 Sep 2022 17:13:24.403 * DB loaded from disk: 0.016 seconds
452:M 22 Sep 2022 17:13:24.403 * Ready to accept connections
452:M 22 Sep 2022 17:14:25.055 * 10000 changes in 60 seconds. Saving...
452:M 22 Sep 2022 17:14:25.056 * Background saving started by pid 1006
1006:C 22 Sep 2022 17:14:25.079 * DB saved on disk
1006:C 22 Sep 2022 17:14:25.080 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
452:M 22 Sep 2022 17:14:25.156 * Background saving terminated with success
452:M 22 Sep 2022 17:19:26.051 * 100 changes in 300 seconds. Saving...
452:M 22 Sep 2022 17:19:26.051 * Background saving started by pid 1390
1390:C 22 Sep 2022 17:19:26.071 * DB saved on disk
1390:C 22 Sep 2022 17:19:26.072 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
452:M 22 Sep 2022 17:19:26.153 * Background saving terminated with success
452:M 22 Sep 2022 17:24:27.011 * 100 changes in 300 seconds. Saving...
452:M 22 Sep 2022 17:24:27.012 * Background saving started by pid 1535
1535:C 22 Sep 2022 17:24:27.029 * DB saved on disk
1535:C 22 Sep 2022 17:24:27.030 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
452:M 22 Sep 2022 17:24:27.114 * Background saving terminated with success
452:M 22 Sep 2022 17:29:28.017 * 100 changes in 300 seconds. Saving...
452:M 22 Sep 2022 17:29:28.018 * Background saving started by pid 1657
1657:C 22 Sep 2022 17:29:28.038 * DB saved on disk
1657:C 22 Sep 2022 17:29:28.039 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
452:M 22 Sep 2022 17:29:28.119 * Background saving terminated with success
452:M 22 Sep 2022 17:34:29.029 * 100 changes in 300 seconds. Saving...
452:M 22 Sep 2022 17:34:29.029 * Background saving started by pid 1778
1778:C 22 Sep 2022 17:34:29.047 * DB saved on disk
1778:C 22 Sep 2022 17:34:29.048 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
452:M 22 Sep 2022 17:34:29.130 * Background saving terminated with success
452:M 22 Sep 2022 17:39:30.033 * 100 changes in 300 seconds. Saving...
452:M 22 Sep 2022 17:39:30.034 * Background saving started by pid 1954
1954:C 22 Sep 2022 17:39:30.051 * DB saved on disk
1954:C 22 Sep 2022 17:39:30.052 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
452:M 22 Sep 2022 17:39:30.135 * Background saving terminated with success

[2022-09-22 16:59:52 +0200] information/FileLogger: 'main-log' started.
[2022-09-22 16:59:52 +0200] information/NotificationComponent: 'notification' started.
[2022-09-22 16:59:52 +0200] information/CheckerComponent: 'checker' started.
[2022-09-22 16:59:52 +0200] information/ConfigItem: Activated all objects.
[2022-09-22 17:00:52 +0200] information/ConfigObjectUtility: Created and activated object 'server01.vm.lab!load!b1a1a2ca-e3bb-4769-86e4-e7b45fe2f43e' of type 'Downtime'.
[2022-09-22 17:00:52 +0200] information/Downtime: Added downtime 'server01.vm.lab!load!b1a1a2ca-e3bb-4769-86e4-e7b45fe2f43e' between '2022-09-23 02:00:00' and '2022-09-23 03:00:00', author: 'icingaadmin', fixed
[2022-09-22 17:01:44 +0200] information/Application: Received request to shut down.
[2022-09-22 17:01:44 +0200] information/Application: Shutting down...
[2022-09-22 17:01:44 +0200] information/CheckerComponent: 'checker' stopped.
[2022-09-22 17:01:44 +0200] information/NotificationComponent: 'notification' stopped.
[2022-09-22 17:01:45 +0200] information/FileLogger: 'main-log' started.
[2022-09-22 17:01:45 +0200] information/ApiListener: 'api' started.
[2022-09-22 17:01:45 +0200] information/ApiListener: Started new listener on '[0.0.0.0]:5665'
[2022-09-22 17:01:45 +0200] information/NotificationComponent: 'notification' started.
[2022-09-22 17:01:45 +0200] information/CheckerComponent: 'checker' started.
[2022-09-22 17:01:45 +0200] information/ConfigItem: Activated all objects.
[2022-09-22 17:01:55 +0200] information/WorkQueue: #5 (ApiListener, RelayQueue) items: 0, rate: 0.233333/s (14/min 14/5min 14/15min);
[2022-09-22 17:01:55 +0200] information/WorkQueue: #6 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);
[2022-09-22 17:02:31 +0200] information/Checkable: Checkable 'server01.vm.lab!http' has 1 notification(s). Checking filters for type 'Problem', sends will be logged.
[2022-09-22 17:02:31 +0200] information/Notification: Sending 'Problem' notification 'server01.vm.lab!http!mail-icingaadmin' for user 'icingaadmin'
[2022-09-22 17:02:31 +0200] information/Notification: Completed sending 'Problem' notification 'server01.vm.lab!http!mail-icingaadmin' for checkable 'server01.vm.lab!http' and user 'icingaadmin' using command 'mail-service-notification'.
[2022-09-22 17:02:31 +0200] warning/PluginNotificationTask: Notification command for object 'server01.vm.lab!http' (PID: 9289, arguments: '/etc/icinga2/scripts/mail-service-notification.sh' '-4' '127.0.0.1' '-6' '::1' '-b' '' '-c' '' '-d' '2022-09-22 17:02:31 +0200' '-e' 'http' '-l' 'server01.vm.lab' '-n' 'server01.vm.lab' '-o' 'connect to address 127.0.0.1 and port 80: Verbindungsaufbau abgelehnt
HTTP CRITICAL - Konnte TCP socket nicht öffnen' '-r' 'root@localhost' '-s' 'CRITICAL' '-t' 'PROBLEM' '-u' 'http' '-v' 'false') terminated with exit code 1, output: mail not found in $PATH. Consider installing it.

[2022-09-22 17:03:33 +0200] information/Application: Received request to shut down.
[2022-09-22 17:03:33 +0200] information/Application: Shutting down...
[2022-09-22 17:03:33 +0200] information/CheckerComponent: 'checker' stopped.
[2022-09-22 17:03:33 +0200] information/NotificationComponent: 'notification' stopped.
[2022-09-22 17:03:33 +0200] information/ApiListener: 'api' stopped.
[2022-09-22 17:03:33 +0200] information/FileLogger: 'main-log' started.
[2022-09-22 17:03:33 +0200] information/IcingaDB: 'icingadb' started.
[2022-09-22 17:03:33 +0200] information/IcingaDB: Trying to connect to Redis server (async) on host '127.0.0.1:6380'
[2022-09-22 17:03:33 +0200] information/IcingaDB: Connected to Redis server
[2022-09-22 17:03:33 +0200] information/ApiListener: 'api' started.
[2022-09-22 17:03:33 +0200] information/ApiListener: Started new listener on '[0.0.0.0]:5665'
[2022-09-22 17:03:33 +0200] information/NotificationComponent: 'notification' started.
[2022-09-22 17:03:33 +0200] information/CheckerComponent: 'checker' started.
[2022-09-22 17:03:33 +0200] information/ConfigItem: Activated all objects.
[2022-09-22 17:03:43 +0200] information/WorkQueue: #5 (IcingaDB) items: 0, rate: 0.0166667/s (1/min 1/5min 1/15min);
[2022-09-22 17:03:43 +0200] information/WorkQueue: #7 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);
[2022-09-22 17:03:43 +0200] information/WorkQueue: #6 (ApiListener, RelayQueue) items: 0, rate: 0.233333/s (14/min 14/5min 14/15min);
[2022-09-22 17:03:48 +0200] information/IcingaDB: Initial config/status dump finished in 0.072571 seconds.
[2022-09-22 17:04:53 +0200] information/Checkable: Checkable 'server01.vm.lab!apt' has 1 notification(s). Checking filters for type 'Problem', sends will be logged.
[2022-09-22 17:04:53 +0200] information/Notification: Sending 'Problem' notification 'server01.vm.lab!apt!mail-icingaadmin' for user 'icingaadmin'
[2022-09-22 17:04:53 +0200] information/Notification: Completed sending 'Problem' notification 'server01.vm.lab!apt!mail-icingaadmin' for checkable 'server01.vm.lab!apt' and user 'icingaadmin' using command 'mail-service-notification'.
[2022-09-22 17:04:53 +0200] warning/PluginNotificationTask: Notification command for object 'server01.vm.lab!apt' (PID: 13377, arguments: '/etc/icinga2/scripts/mail-service-notification.sh' '-4' '127.0.0.1' '-6' '::1' '-b' '' '-c' '' '-d' '2022-09-22 17:04:53 +0200' '-e' 'apt' '-l' 'server01.vm.lab' '-n' 'server01.vm.lab' '-o' 'APT WARNING: 1 packages available for upgrade (0 critical updates). ' '-r' 'root@localhost' '-s' 'WARNING' '-t' 'PROBLEM' '-u' 'apt' '-v' 'false') terminated with exit code 1, output: mail not found in $PATH. Consider installing it.

[2022-09-22 17:08:33 +0200] information/ConfigObject: Dumping program state to file '/var/lib/icinga2/icinga2.state'
[2022-09-22 17:08:43 +0200] information/WorkQueue: #5 (IcingaDB) items: 0, rate: 0.0666667/s (4/min 20/5min 21/15min);
[2022-09-22 17:08:43 +0200] information/WorkQueue: #6 (ApiListener, RelayQueue) items: 0, rate: 0.866667/s (52/min 272/5min 286/15min);
[2022-09-22 17:08:43 +0200] information/WorkQueue: #7 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);
[2022-09-22 17:10:04 +0200] information/Checkable: Checkable 'server01.vm.lab!http' has 1 notification(s). Checking filters for type 'Recovery', sends will be logged.
[2022-09-22 17:10:04 +0200] information/Notification: Sending 'Recovery' notification 'server01.vm.lab!http!mail-icingaadmin' for user 'icingaadmin'
[2022-09-22 17:10:04 +0200] information/Notification: Completed sending 'Recovery' notification 'server01.vm.lab!http!mail-icingaadmin' for checkable 'server01.vm.lab!http' and user 'icingaadmin' using command 'mail-service-notification'.
[2022-09-22 17:10:04 +0200] warning/PluginNotificationTask: Notification command for object 'server01.vm.lab!http' (PID: 32761, arguments: '/etc/icinga2/scripts/mail-service-notification.sh' '-4' '127.0.0.1' '-6' '::1' '-b' '' '-c' '' '-d' '2022-09-22 17:10:04 +0200' '-e' 'http' '-l' 'server01.vm.lab' '-n' 'server01.vm.lab' '-o' 'HTTP OK: HTTP/1.1 200 OK - 10975 bytes in 0.001 second response time ' '-r' 'root@localhost' '-s' 'OK' '-t' 'RECOVERY' '-u' 'http' '-v' 'false') terminated with exit code 1, output: mail not found in $PATH. Consider installing it.

[2022-09-22 17:11:34 +0200] information/ApiListener: New client connection from [127.0.0.1]:42334 (no client certificate)
[2022-09-22 17:11:34 +0200] information/HttpServerConnection: Request: GET /v1/ (from [127.0.0.1]:42334), user: root, agent: GuzzleHttp/6.5.5 curl/7.74.0 PHP/7.4.30, status: OK).
[2022-09-22 17:11:34 +0200] information/HttpServerConnection: HTTP client disconnected (from [127.0.0.1]:42334)
[2022-09-22 17:11:35 +0200] information/ApiListener: New client connection from [127.0.0.1]:42336 (no client certificate)
[2022-09-22 17:11:35 +0200] information/HttpServerConnection: Request: GET /v1/ (from [127.0.0.1]:42336), user: root, agent: GuzzleHttp/6.5.5 curl/7.74.0 PHP/7.4.30, status: OK).
[2022-09-22 17:11:35 +0200] information/HttpServerConnection: HTTP client disconnected (from [127.0.0.1]:42336)
[2022-09-22 17:13:08 +0200] information/Application: Received request to shut down.
[2022-09-22 17:13:08 +0200] information/Application: Shutting down...
[2022-09-22 17:13:08 +0200] information/CheckerComponent: 'checker' stopped.
[2022-09-22 17:13:08 +0200] information/NotificationComponent: 'notification' stopped.
[2022-09-22 17:13:08 +0200] information/ApiListener: 'api' stopped.
[2022-09-22 17:13:08 +0200] information/IcingaDB: 'icingadb' stopped.
[2022-09-22 17:13:25 +0200] information/FileLogger: 'main-log' started.
[2022-09-22 17:13:25 +0200] information/IcingaDB: 'icingadb' started.
[2022-09-22 17:13:25 +0200] information/IcingaDB: Trying to connect to Redis server (async) on host '127.0.0.1:6380'
[2022-09-22 17:13:25 +0200] information/IcingaDB: Connected to Redis server
[2022-09-22 17:13:25 +0200] information/ApiListener: 'api' started.
[2022-09-22 17:13:25 +0200] information/ApiListener: Started new listener on '[0.0.0.0]:5665'
[2022-09-22 17:13:25 +0200] information/NotificationComponent: 'notification' started.
[2022-09-22 17:13:25 +0200] information/CheckerComponent: 'checker' started.
[2022-09-22 17:13:25 +0200] information/ConfigItem: Activated all objects.
[2022-09-22 17:13:35 +0200] information/WorkQueue: #5 (IcingaDB) items: 0, rate: 0.0166667/s (1/min 1/5min 1/15min);
[2022-09-22 17:13:35 +0200] information/WorkQueue: #6 (ApiListener, RelayQueue) items: 0, rate: 0.233333/s (14/min 14/5min 14/15min);
[2022-09-22 17:13:35 +0200] information/WorkQueue: #7 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);
[2022-09-22 17:13:40 +0200] information/IcingaDB: Initial config/status dump finished in 0.0638959 seconds.
[2022-09-22 17:18:25 +0200] information/ConfigObject: Dumping program state to file '/var/lib/icinga2/icinga2.state'
[2022-09-22 17:18:35 +0200] information/WorkQueue: #5 (IcingaDB) items: 0, rate: 0.0666667/s (4/min 20/5min 21/15min);
[2022-09-22 17:18:35 +0200] information/WorkQueue: #6 (ApiListener, RelayQueue) items: 0, rate: 0.933333/s (56/min 272/5min 286/15min);
[2022-09-22 17:18:35 +0200] information/WorkQueue: #7 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);
[2022-09-22 17:23:25 +0200] information/ConfigObject: Dumping program state to file '/var/lib/icinga2/icinga2.state'
[2022-09-22 17:23:35 +0200] information/WorkQueue: #5 (IcingaDB) items: 0, rate: 0.0666667/s (4/min 20/5min 41/15min);
[2022-09-22 17:23:35 +0200] information/WorkQueue: #6 (ApiListener, RelayQueue) items: 0, rate: 0.866667/s (52/min 264/5min 550/15min);
[2022-09-22 17:23:35 +0200] information/WorkQueue: #7 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);
[2022-09-22 17:28:25 +0200] information/ConfigObject: Dumping program state to file '/var/lib/icinga2/icinga2.state'
[2022-09-22 17:28:35 +0200] information/WorkQueue: #5 (IcingaDB) items: 0, rate: 0.0666667/s (4/min 20/5min 60/15min);
[2022-09-22 17:28:35 +0200] information/WorkQueue: #6 (ApiListener, RelayQueue) items: 0, rate: 0.866667/s (52/min 262/5min 798/15min);
[2022-09-22 17:28:35 +0200] information/WorkQueue: #7 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);
[2022-09-22 17:33:25 +0200] information/ConfigObject: Dumping program state to file '/var/lib/icinga2/icinga2.state'
[2022-09-22 17:33:35 +0200] information/WorkQueue: #5 (IcingaDB) items: 0, rate: 0.0666667/s (4/min 20/5min 60/15min);
[2022-09-22 17:33:35 +0200] information/WorkQueue: #6 (ApiListener, RelayQueue) items: 0, rate: 0.866667/s (52/min 262/5min 788/15min);
[2022-09-22 17:33:35 +0200] information/WorkQueue: #7 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);
[2022-09-22 17:34:55 +0200] information/Notification: Sending reminder 'Problem' notification 'server01.vm.lab!apt!mail-icingaadmin' for user 'icingaadmin'
[2022-09-22 17:34:55 +0200] information/Notification: Completed sending 'Problem' notification 'server01.vm.lab!apt!mail-icingaadmin' for checkable 'server01.vm.lab!apt' and user 'icingaadmin' using command 'mail-service-notification'.
[2022-09-22 17:34:55 +0200] warning/PluginNotificationTask: Notification command for object 'server01.vm.lab!apt' (PID: 1793, arguments: '/etc/icinga2/scripts/mail-service-notification.sh' '-4' '127.0.0.1' '-6' '::1' '-b' '' '-c' '' '-d' '2022-09-22 17:34:55 +0200' '-e' 'apt' '-l' 'server01.vm.lab' '-n' 'server01.vm.lab' '-o' 'APT WARNING: 1 packages available for upgrade (0 critical updates). ' '-r' 'root@localhost' '-s' 'WARNING' '-t' 'PROBLEM' '-u' 'apt' '-v' 'false') terminated with exit code 1, output: mail not found in $PATH. Consider installing it.

[2022-09-22 17:38:25 +0200] information/ConfigObject: Dumping program state to file '/var/lib/icinga2/icinga2.state'
[2022-09-22 17:38:35 +0200] information/WorkQueue: #5 (IcingaDB) items: 0, rate: 0.0666667/s (4/min 20/5min 60/15min);
[2022-09-22 17:38:35 +0200] information/WorkQueue: #6 (ApiListener, RelayQueue) items: 0, rate: 0.833333/s (50/min 264/5min 788/15min);
[2022-09-22 17:38:35 +0200] information/WorkQueue: #7 (ApiListener, SyncQueue) items: 0, rate:  0/s (0/min 0/5min 0/15min);


Can anyone help? :frowning:

Output of “systemctl status mariadb”:

Sep 22 18:57:41 server01 mariadbd[531]: 2022-09-22 18:57:41 4 [Warning] Aborted connection 4 to db: 'icingadb' user: 'icingadb' host: 'localhost' (Got an error reading communication packets)

Got it fixed by using this steps at the installation (fresh installation):

nano /etc/ssh/sshd_config
nano /etc/apt/sources.list
timedatectl set-timezone Europe/Berlin
apt update && apt upgrade -y
reboot
apt-get install apt-transport-https wget gnupg git -y
wget -O - https://packages.icinga.com/icinga.key | apt-key add -
DIST=$(awk -F"[)(]+" '/VERSION=/ {print $2}' /etc/os-release);  echo "deb https://packages.icinga.com/debian icinga-${DIST} main" >  /etc/apt/sources.list.d/${DIST}-icinga.list
echo "deb-src https://packages.icinga.com/debian icinga-${DIST} main" >>  /etc/apt/sources.list.d/${DIST}-icinga.list
apt-get update
apt-get install icinga2 -y
icinga2 daemon -C
apt-get install monitoring-plugins -y
icinga2 api setup
systemctl restart icinga2
apt-get install icingadb-redis -y
systemctl enable --now icingadb-redis
systemctl restart icingadb-redis
icinga2 feature enable icingadb
systemctl restart icinga2
apt-get install icingadb -y
apt install mariadb-server -y
mysql -u root -p
CREATE DATABASE icingadb;
CREATE DATABASE icingaweb2;
CREATE DATABASE directordb CHARACTER SET 'utf8';
CREATE USER 'icingaweb2'@'localhost' IDENTIFIED BY 'xxx';
CREATE USER 'icingadb'@'localhost' IDENTIFIED BY 'xxx';
CREATE USER directordb@localhost IDENTIFIED BY 'xxx';
GRANT ALL ON icingadb.* TO 'icingadb'@'localhost';
GRANT ALL ON icingaweb2.* TO 'icingaweb2'@'localhost';
GRANT ALL ON directordb.* TO directordb@localhost;
mysql -u root -p icingadb </usr/share/icingadb/schema/mysql/schema.sql
systemctl enable --now icingadb
apt-get install icingadb-web -y
cat /etc/icinga2/conf.d/api-users.conf 
icingacli setup token create

So, you just did everything new, but you don’t know what the issue was in the end?

Simple: Just do a full restart of your system where Icinga is installed or restart the icingadb service. :slight_smile:
I prefere to do a full restart.

1 Like