# Icinga DB **URL:** https://community.icinga.com/c/icinga-2/icinga-db/14.md?page=1 [Latest](https://community.icinga.com/latest.md) · [Categories](https://community.icinga.com/categories.md) · [Tags](https://community.icinga.com/tags.md) **Page:** 2 --- ## [Where is event history plugin output in the database? (e.g. CRIT: "Planned Maintenance" on status.nfon.com)](https://community.icinga.com/t/where-is-event-history-plugin-output-in-the-database-e-g-crit-planned-maintenance-on-status-nfon-com/14335)
**Author:** [@sduzevichiow](https://community.icinga.com/u/sduzevichiow)\ **Replies:** 4\ **Last updated:** [November 25, 2024, 9:55am UTC](https://community.icinga.com/t/where-is-event-history-plugin-output-in-the-database-e-g-crit-planned-maintenance-on-status-nfon-com/14335 "2024-11-25T09:55:17Z")
I’m trying to find this data (specifically, the string) in the database. Honestly, I have very little clue about how icinga is set up and integrated with our services, just trying to complete another task and finding… --- ## [Icingadb wont run](https://community.icinga.com/t/icingadb-wont-run/14237)
**Author:** [@Luke](https://community.icinga.com/u/Luke)\ **Replies:** 11\ **Last updated:** [October 29, 2024, 4:02pm UTC](https://community.icinga.com/t/icingadb-wont-run/14237 "2024-10-29T16:02:43Z")
After i installed icinga and did the web installation. I got this error code I’ve tried many things but nothing seems to work. After i started icingadb i still get an error message. --- ## [IcingaDB does not delete history data from all tables containin historical data](https://community.icinga.com/t/icingadb-does-not-delete-history-data-from-all-tables-containin-historical-data/14232)
**Author:** [@akrnaw](https://community.icinga.com/u/akrnaw)\ **Replies:** 1\ **Last updated:** [October 24, 2024, 3:25pm UTC](https://community.icinga.com/t/icingadb-does-not-delete-history-data-from-all-tables-containin-historical-data/14232 "2024-10-24T15:25:22Z")
The IcingaDB configuration mentions that history data can be deleted: Configuration - Icinga DB This works as expected, but I am wondering, why the “history” table is not cleaned by the configuration. At the moment, it … --- ## [Icingadb-redis Bug on RHEL 9](https://community.icinga.com/t/icingadb-redis-bug-on-rhel-9/14217)
**Author:** [@skrinetzki](https://community.icinga.com/u/skrinetzki)\ **Replies:** 1\ **Last updated:** [October 18, 2024, 1:37pm UTC](https://community.icinga.com/t/icingadb-redis-bug-on-rhel-9/14217 "2024-10-18T13:37:01Z")
Hello everyone, This morning we updated the icingadb-redis package on a Rocky 9 system (icingadb-redis-7.2.6-1.el9.x86\_64). After that, the Redis server no longer started. From the log: icingadb-redis-server\[2985980\]: … --- ## [Icinga DB with Grafana module throwing error](https://community.icinga.com/t/icinga-db-with-grafana-module-throwing-error/12755)
**Author:** [@lucasbotka](https://community.icinga.com/u/lucasbotka)\ **Replies:** 7\ **Last updated:** [September 27, 2024, 12:40pm UTC](https://community.icinga.com/t/icinga-db-with-grafana-module-throwing-error/12755 "2024-09-27T12:40:50Z")
Hi comunnity. On my fresh icinga installation, Grafana module throving following errors: Deprecated : Creation of dynamic property Icinga\\Module\\Grafana\\ProvidedHook\\Icingadb\\ServiceDetailExtension::$permission is depre… --- ## [Enable debug for icingadb to troubleshoot redis heartbeat issue](https://community.icinga.com/t/enable-debug-for-icingadb-to-troubleshoot-redis-heartbeat-issue/14040)
**Author:** [@moose\_drips](https://community.icinga.com/u/moose_drips)\ **Replies:** 3\ **Last updated:** [August 28, 2024, 3:28pm UTC](https://community.icinga.com/t/enable-debug-for-icingadb-to-troubleshoot-redis-heartbeat-issue/14040 "2024-08-28T15:28:59Z")
After configuring TLS for redis I am noticing that icingadb is dropping the redis heartbeat. It stays up but fails, Aug 27 18:06:37 servicename.obfuscate.org icingadb\[142343\]: Connecting to Redis at 'servicename.obfusc… --- ## [It seems that Icinga DB is not running. Make sure Icinga DB is running and writing into the database](https://community.icinga.com/t/it-seems-that-icinga-db-is-not-running-make-sure-icinga-db-is-running-and-writing-into-the-database/14026)
**Author:** [@bunghi](https://community.icinga.com/u/bunghi)\ **Replies:** 5\ **Last updated:** [August 26, 2024, 8:42am UTC](https://community.icinga.com/t/it-seems-that-icinga-db-is-not-running-make-sure-icinga-db-is-running-and-writing-into-the-database/14026 "2024-08-26T08:42:50Z")
Hi, We are trying to migrate from InoDB to IcingaDB but we get this error. Using a distributed setup: mqde01icinga02: icingaweb2 + mysqld mqde01icinga2cl01: icinga2+icingadb+icingadb-redis mqde01icinga2cl02: icinga2+… --- ## [IcingaDB failing exactly 5 minutes after start](https://community.icinga.com/t/icingadb-failing-exactly-5-minutes-after-start/13955)
**Author:** [@obol89](https://community.icinga.com/u/obol89)\ **Replies:** 3\ **Last updated:** [August 6, 2024, 4:15pm UTC](https://community.icinga.com/t/icingadb-failing-exactly-5-minutes-after-start/13955 "2024-08-06T16:15:54Z")
Hey, I’m facing some weird IcingaDB behaviour after upgrade: Icinga2 from 2.13 to 2.14 IcingaDB from v1.1.0 to v1.2.0 It is Debian 11 and to upgrade I’m using apt upgrade. Everything seems to be running fine, but af… --- ## [DB is not running](https://community.icinga.com/t/db-is-not-running/13909)
**Author:** [@Jessica](https://community.icinga.com/u/Jessica)\ **Replies:** 8\ **Last updated:** [July 30, 2024, 6:38am UTC](https://community.icinga.com/t/db-is-not-running/13909 "2024-07-30T06:38:24Z")
Hi, everything was working suddenly i notices this error message. here is the image: . I have tried “icinga2 feature enable icingadb” and “systemctl restart icinga2” but still getting this error. Please i really need… --- ## [Failed to start icingadb-redis.service after update](https://community.icinga.com/t/failed-to-start-icingadb-redis-service-after-update/13828)
**Author:** [@I-Cube](https://community.icinga.com/u/I-Cube)\ **Replies:** 1\ **Last updated:** [July 19, 2024, 7:56am UTC](https://community.icinga.com/t/failed-to-start-icingadb-redis-service-after-update/13828 "2024-07-19T07:56:42Z")
Hello everyone! Icinga2 deployed in the LXC-container, based on Debian Bookworm. After a full upgrade system and all packages (apt update && apt upgrade -y && apt-autoremove -y), I encountered a problem starting the se… --- ## [Reduce dependency logs](https://community.icinga.com/t/reduce-dependency-logs/13863)
**Author:** [@padri45](https://community.icinga.com/u/padri45)\ **Replies:** 1\ **Last updated:** [July 17, 2024, 9:35am UTC](https://community.icinga.com/t/reduce-dependency-logs/13863 "2024-07-17T09:35:14Z")
Hi, icinga2 : 2.14.2-1+debian11 icingadb : 1.2.0-1+debian11 When I activate debuglog, I notice that I’m logging Dependencies every second; for example \[2024-07-17 10:52:13 +0200\] notice/Dependency: Dependency ‘HOST!D… --- ## [Correct set-up and config for icingadb-redis - \`NOAUTH Authentication required.\`](https://community.icinga.com/t/correct-set-up-and-config-for-icingadb-redis-noauth-authentication-required/13809)
**Author:** [@itchy\_scratchy\_patch](https://community.icinga.com/u/itchy_scratchy_patch)\ **Replies:** 4\ **Last updated:** [July 12, 2024, 3:14pm UTC](https://community.icinga.com/t/correct-set-up-and-config-for-icingadb-redis-noauth-authentication-required/13809 "2024-07-12T15:14:34Z")
Having provided a password in /etc/icingadb-redis/icingadb-redis.conf and removed the # along with adding the password to /etc/icingadb/config.yml the following log entries appear. This is after running sudo systemctl r… --- ## [Icinga2 director loop](https://community.icinga.com/t/icinga2-director-loop/13780)
**Author:** [@c00lz3r0](https://community.icinga.com/u/c00lz3r0)\ **Replies:** 6\ **Last updated:** [July 1, 2024, 7:18pm UTC](https://community.icinga.com/t/icinga2-director-loop/13780 "2024-07-01T19:18:30Z")
Loop detected: nvidia → nvidia (TemplateTree.php:225) using director cannot deploy someone can help ?? icinga2 - The Icinga 2 network monitoring daemon (version: r2.14.2-1) Copyright (c) 2012-2024 Icinga GmbH (https:… --- ## [Cannot enable icingadb-redis](https://community.icinga.com/t/cannot-enable-icingadb-redis/9106)
**Author:** [@ottonaut](https://community.icinga.com/u/ottonaut)\ **Replies:** 6\ **Last updated:** [June 26, 2024, 12:44pm UTC](https://community.icinga.com/t/cannot-enable-icingadb-redis/9106 "2024-06-26T12:44:32Z")
I’ve been doing the installation of IcingaDB Web as documented but upon the lasts steps where you add the Database to the module icingadb. Documentation for reference: IcingaDB Web Installtion My first error was this: … --- ## [Create role with restricted access to hosts and services](https://community.icinga.com/t/create-role-with-restricted-access-to-hosts-and-services/13673)
**Author:** [@sziloo](https://community.icinga.com/u/sziloo)\ **Replies:** 6\ **Last updated:** [June 4, 2024, 2:44pm UTC](https://community.icinga.com/t/create-role-with-restricted-access-to-hosts-and-services/13673 "2024-06-04T14:44:23Z")
Dear Community, I am relative new at Icinga with some experience. I want to create a role which don’t have any right to some of the hosts and the services. My goal would be to create a role which has access to all devic… --- ## [IcingaDB 1.2.0 - schema upgrade fails](https://community.icinga.com/t/icingadb-1-2-0-schema-upgrade-fails/13495)
**Author:** [@janHH](https://community.icinga.com/u/janHH)\ **Replies:** 15\ **Last updated:** [April 23, 2024, 12:56pm UTC](https://community.icinga.com/t/icingadb-1-2-0-schema-upgrade-fails/13495 "2024-04-23T12:56:30Z")
Hello, after recklessly running OS update on my Icinga master running on Ubuntu 22.04.03 using “apt upgrade” I realised a minor update for Icinga was released(Releasing Icinga DB 1.2.0 and Icinga DB Web 1.1.2). It inclu… --- ## [Icingadb and redis in ha setup](https://community.icinga.com/t/icingadb-and-redis-in-ha-setup/13464)
**Author:** [@Katzentier](https://community.icinga.com/u/Katzentier)\ **Replies:** 5\ **Last updated:** [April 15, 2024, 9:06am UTC](https://community.icinga.com/t/icingadb-and-redis-in-ha-setup/13464 "2024-04-15T09:06:12Z")
Hi there, I have set up a distributed setup with 2 masters. The icinga2 setup is working fine. On each master, there is a redis server and icingadb running. Then I have a 3rd server that hosts mariadb (mysql), icingad… --- ## [Linked server tot icingadb (postgresql)](https://community.icinga.com/t/linked-server-tot-icingadb-postgresql/13456)
**Author:** [@Ganz](https://community.icinga.com/u/Ganz)\ **Replies:** 2\ **Last updated:** [April 12, 2024, 12:44pm UTC](https://community.icinga.com/t/linked-server-tot-icingadb-postgresql/13456 "2024-04-12T12:44:57Z")
the basic stuf works fine ! also select a table to SQL like : SELECT \* FROM OPENQUERY (icinga2 , ‘select \* from public.hostgroup\_member’); but this one : SELECT \* FROM OPENQUERY (icinga2 , 'select \* from public.hostg… --- ## [IcingaDB not running](https://community.icinga.com/t/icingadb-not-running/11159)
**Author:** [@B3RN0UT](https://community.icinga.com/u/B3RN0UT)\ **Replies:** 5\ **Last updated:** [April 10, 2024, 7:37am UTC](https://community.icinga.com/t/icingadb-not-running/11159 "2024-04-10T07:37:37Z")
Hi Community, does someone have some advice for me? Still getting the following message after walking through the install docs according to IcingaDB an IcingaDB-Web # /usr/sbin/icingadb --config /etc/icingadb/conf… --- ## [Unable to locate icingadb-redis packet](https://community.icinga.com/t/unable-to-locate-icingadb-redis-packet/13423)
**Author:** [@giolopezl](https://community.icinga.com/u/giolopezl)\ **Replies:** 1\ **Last updated:** [April 2, 2024, 5:16pm UTC](https://community.icinga.com/t/unable-to-locate-icingadb-redis-packet/13423 "2024-04-02T17:16:19Z")
Hi guys: I’ve trying to install icinga2 and when I try to install the redis server i got the message “Unable to locate icingadb-redis packet”. I’m installing on Ubuntu server 22.04.4 LTS --- ## [Icingadb is not running](https://community.icinga.com/t/icingadb-is-not-running/13327)
**Author:** [@Melone](https://community.icinga.com/u/Melone)\ **Replies:** 4\ **Last updated:** [March 4, 2024, 8:48pm UTC](https://community.icinga.com/t/icingadb-is-not-running/13327 "2024-03-04T20:48:19Z")
Hi guys, My Icinga says that the database is not running or that it can’t read now, I just don’t know how to check if it can read or not, but it should be on, I used the command “systemctl enable --now icingadb”. --- ## [Icingadb-redis.conf contents](https://community.icinga.com/t/icingadb-redis-conf-contents/13245)
**Author:** [@starchaserV0](https://community.icinga.com/u/starchaserV0)\ **Replies:** 2\ **Last updated:** [February 14, 2024, 10:08am UTC](https://community.icinga.com/t/icingadb-redis-conf-contents/13245 "2024-02-14T10:08:31Z")
Hi All, I accidently deleted the redis conf file - /etc/icingadb-redis/icingadb-redis.conf. Now when i am trying to reinstall redis the conf file is not automatically being generated. Also i could not find an example of… --- ## [Tabel doesn't exist](https://community.icinga.com/t/tabel-doesnt-exist/13256)
**Author:** [@Mo.Yab](https://community.icinga.com/u/Mo.Yab)\ **Replies:** 2\ **Last updated:** [February 13, 2024, 9:48am UTC](https://community.icinga.com/t/tabel-doesnt-exist/13256 "2024-02-13T09:48:11Z")
Hello everyone, I’m have the following issue and I would appreciate your help: User: “Icinga DB from icingadb is UNKNOWN. PDOException in /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php:401 with message: S… --- ## [Icingadb service don't started](https://community.icinga.com/t/icingadb-service-dont-started/13167)
**Author:** [@Techmahindro](https://community.icinga.com/u/Techmahindro)\ **Replies:** 9\ **Last updated:** [January 27, 2024, 1:14am UTC](https://community.icinga.com/t/icingadb-service-dont-started/13167 "2024-01-27T01:14:16Z")
I have a problem when trying to start the icingadvb service. Evidence this is my config.yml here my version --- ## [General IcingaDB Architecture](https://community.icinga.com/t/general-icingadb-architecture/10818)
**Author:** [@jwilliams-shadowsoft](https://community.icinga.com/u/jwilliams-shadowsoft)\ **Replies:** 3\ **Last updated:** [January 28, 2024, 5:13pm UTC](https://community.icinga.com/t/general-icingadb-architecture/10818 "2024-01-28T17:13:54Z")
So I have not had a chance to implement an IcingaDB platform yet, but I have a basic architecture question before I start installing. I love this diagram, by the way. Q: So if I wanted to break up load, this diagram … --- ## [Hidden custom attributes on icingadb-web](https://community.icinga.com/t/hidden-custom-attributes-on-icingadb-web/11650)
**Author:** [@nguyenhuukhoinw](https://community.icinga.com/u/nguyenhuukhoinw)\ **Replies:** 5\ **Last updated:** [January 25, 2024, 3:42pm UTC](https://community.icinga.com/t/hidden-custom-attributes-on-icingadb-web/11650 "2024-01-25T15:42:38Z")
Hello guys. I want to hide some sensitive information on web. I can do with icingaweb: https://icinga.com/docs/icinga-web/latest/modules/monitoring/doc/10-Restrict-Custom-Variables/ Will we have this feature with icin… --- ## [Hook vsphere monitoring integration into icingadb backend](https://community.icinga.com/t/hook-vsphere-monitoring-integration-into-icingadb-backend/13091)
**Author:** [@manny4566](https://community.icinga.com/u/manny4566)\ **Replies:** 1\ **Last updated:** [January 23, 2024, 5:08pm UTC](https://community.icinga.com/t/hook-vsphere-monitoring-integration-into-icingadb-backend/13091 "2024-01-23T17:08:02Z")
Hi, i have a question how to hook the monitoring integration from the vsphere module into a fresh icingadb installation? For example like in this live demo (minute 23:00): For example in my test installat… --- ## [Confused about migrating from Monitoring-IDO to icingadb and icingadb-redis](https://community.icinga.com/t/confused-about-migrating-from-monitoring-ido-to-icingadb-and-icingadb-redis/13132)
**Author:** [@emboehm](https://community.icinga.com/u/emboehm)\ **Replies:** 1\ **Last updated:** [January 17, 2024, 7:08am UTC](https://community.icinga.com/t/confused-about-migrating-from-monitoring-ido-to-icingadb-and-icingadb-redis/13132 "2024-01-17T07:08:52Z")
I had a previous installation of icinga2 2.9.1 and monitoring with IDO I had some difficulties migrating to icinga2 2.12.1 but I finally have that working using Monitoring and IDO. The installation of icingadb did not … --- ## [Icingadb-redis not found](https://community.icinga.com/t/icingadb-redis-not-found/13121)
**Author:** [@Melone](https://community.icinga.com/u/Melone)\ **Replies:** 1\ **Last updated:** [January 15, 2024, 9:51am UTC](https://community.icinga.com/t/icingadb-redis-not-found/13121 "2024-01-15T09:51:17Z")
Hello Guys, I try to install icingadb-redis in my Debian 12 Server with the command “apt install icingadb-redis” but it not work can everyone help me --- ## [Very high load after updating to icingadb 1.1.1](https://community.icinga.com/t/very-high-load-after-updating-to-icingadb-1-1-1/13044)
**Author:** [@Robby](https://community.icinga.com/u/Robby)\ **Replies:** 4\ **Last updated:** [December 14, 2023, 3:32pm UTC](https://community.icinga.com/t/very-high-load-after-updating-to-icingadb-1-1-1/13044 "2023-12-14T15:32:12Z")
Hi at all, since our last update of some modules and php to version 8.1 (SLES doesn’t provide 8.2 now), the load of our icinga2 master literally exploded. We updated following packages from repo: \*icingadb to 1.1.1 \*i… [Previous page](https://community.icinga.com/c/icinga-2/icinga-db/14.md) [Next page](https://community.icinga.com/c/icinga-2/icinga-db/14.md?page=2)