# \#database **URL:** https://community.icinga.com/tag/database/162.md [Latest](https://community.icinga.com/latest.md) · [Categories](https://community.icinga.com/categories.md) · [Tags](https://community.icinga.com/tags.md) --- ## [Migration to Docker](https://community.icinga.com/t/migration-to-docker/14996)
**Author:** [@Sel](https://community.icinga.com/u/Sel)\ **Replies:** 0\ **Last updated:** [July 9, 2025, 1:22pm UTC](https://community.icinga.com/t/migration-to-docker/14996 "2025-07-09T13:22:43Z")
Hello there, I am currently moving our Icinga 2 (version 2.12.4), which runs on a virtual machine, to a new docker environment. We have the director. So I set up the docker containers, saved the configuration of the cu… --- ## [Host state differs between Icinga2 API and host\_state table in database](https://community.icinga.com/t/host-state-differs-between-icinga2-api-and-host-state-table-in-database/14660)
**Author:** [@matthew.smith](https://community.icinga.com/u/matthew.smith)\ **Replies:** 8\ **Last updated:** [March 5, 2025, 11:37pm UTC](https://community.icinga.com/t/host-state-differs-between-icinga2-api-and-host-state-table-in-database/14660 "2025-03-05T23:37:59Z")
Cluster The cluster this is happening in is 2 ha masters and 2 satellites. The masters use Icingadb, with icingadb-redis, as their backend The data is stored in a 3 node galera cluster There are about 20,000 hosts in … --- ## [Database tables icinga\_servicestatus and icinga\_hoststatus grow uncontrollably](https://community.icinga.com/t/database-tables-icinga-servicestatus-and-icinga-hoststatus-grow-uncontrollably/13224)
**Author:** [@toerkl](https://community.icinga.com/u/toerkl)\ **Replies:** 3\ **Last updated:** [February 8, 2024, 7:25am UTC](https://community.icinga.com/t/database-tables-icinga-servicestatus-and-icinga-hoststatus-grow-uncontrollably/13224 "2024-02-08T07:25:42Z")
Hi, Since yesterday we have a problem where the icinga2 master node updates the tables icinga\_servicestatus and icinga\_hoststatus continuously with an incredibly high frequency. Severel times per second. The SQL statem… --- ## [IcingaWeb: DB migration message after update to 2.12](https://community.icinga.com/t/icingaweb-db-migration-message-after-update-to-2-12/12725)
**Author:** [@mrdsam](https://community.icinga.com/u/mrdsam)\ **Replies:** 11\ **Last updated:** [December 12, 2023, 2:30pm UTC](https://community.icinga.com/t/icingaweb-db-migration-message-after-update-to-2-12/12725 "2023-12-12T14:30:21Z")
Hi, after upgrading from IcingaWeb 2.11.4 to 2.12, I get this message under “Migrations”: It seems that the currently used database user does not have the required privileges to execute the CREATE, SELECT, INSERT, UPD… --- ## [Migration ERROR: unrecognized privilege type: "CREATE" (postgresql db)](https://community.icinga.com/t/migration-error-unrecognized-privilege-type-create-postgresql-db/12809)
**Author:** [@jacomo77](https://community.icinga.com/u/jacomo77)\ **Replies:** 1\ **Last updated:** [October 25, 2023, 2:04pm UTC](https://community.icinga.com/t/migration-error-unrecognized-privilege-type-create-postgresql-db/12809 "2023-10-25T14:04:57Z")
Hello, After minor upgrade of icingaweb2 we got migration ERRORS. Looks likes it is checking CREATE privilege which is for mariaDB but we are using postgreSQL where this type of privilege does not exist. Can you please … --- ## [Configure dedicated database server](https://community.icinga.com/t/configure-dedicated-database-server/10851)
**Author:** [@sameer](https://community.icinga.com/u/sameer)\ **Replies:** 6\ **Last updated:** [October 18, 2022, 11:23am UTC](https://community.icinga.com/t/configure-dedicated-database-server/10851 "2022-10-18T11:23:55Z")
I have setup test environment with 2 Master’s writing to their local databases and had load balanced between them using HAproxy. I can see on icinga web interface that the active endpoint changes when one of the master i… --- ## [Where to add virtual ip in icinga for database](https://community.icinga.com/t/where-to-add-virtual-ip-in-icinga-for-database/10802)
**Author:** [@sameer](https://community.icinga.com/u/sameer)\ **Replies:** 9\ **Last updated:** [October 12, 2022, 2:45pm UTC](https://community.icinga.com/t/where-to-add-virtual-ip-in-icinga-for-database/10802 "2022-10-12T14:45:41Z")
“Best practice is to run the database backend on a dedicated server/cluster and only expose a virtual IP address to Icinga and the IDO feature. By default, only one endpoint will actively write to the backend then. Typic… --- ## [Installing director: not able to create first endpoint](https://community.icinga.com/t/installing-director-not-able-to-create-first-endpoint/10565)
**Author:** [@verboese](https://community.icinga.com/u/verboese)\ **Replies:** 2\ **Last updated:** [September 12, 2022, 7:34am UTC](https://community.icinga.com/t/installing-director-not-able-to-create-first-endpoint/10565 "2022-09-12T07:34:30Z")
First: Our installation is special, as we are trying to run icing from a Kubernetes in Azure. I got most of it running, but I’m currently struggling setting up director. After deploying the DB structure I have to provid… --- ## [MariaDB corrupted after power outage](https://community.icinga.com/t/mariadb-corrupted-after-power-outage/10130)
**Author:** [@why](https://community.icinga.com/u/why)\ **Replies:** 1\ **Last updated:** [July 14, 2022, 7:22am UTC](https://community.icinga.com/t/mariadb-corrupted-after-power-outage/10130 "2022-07-14T07:22:25Z")
Hey everyone, I dont know if “Icinga 2” is the right subforum for my question, i dont even know if this entire forum is the correct one for it. But since the only server affected is my icinga VM i thought id at least t… --- ## [IDO DB Usage + Pending Queries on HA Master Setup Growing + Overdue Checks](https://community.icinga.com/t/ido-db-usage-pending-queries-on-ha-master-setup-growing-overdue-checks/9816)
**Author:** [@revstar](https://community.icinga.com/u/revstar)\ **Replies:** 2\ **Last updated:** [May 24, 2022, 7:50am UTC](https://community.icinga.com/t/ido-db-usage-pending-queries-on-ha-master-setup-growing-overdue-checks/9816 "2022-05-24T07:50:02Z")
Icinga2 Version 2.13.2-1 System CentOS 7.7.1908 Icinga Web 2 Version 2.10.1 PHP Version 7.3.29 icinga/icinga-php-library 0.8.1 icinga/icinga-php-thirdparty 0.10.0 Loaded Modules: doc/map/monitoring Setup 2X Master… --- ## [Heavy Disk Usage (I/O) with MariaDB](https://community.icinga.com/t/heavy-disk-usage-i-o-with-mariadb/9061)
**Author:** [@eternalliving](https://community.icinga.com/u/eternalliving)\ **Replies:** 13\ **Last updated:** [April 7, 2022, 11:20am UTC](https://community.icinga.com/t/heavy-disk-usage-i-o-with-mariadb/9061 "2022-04-07T11:20:50Z")
This is my first post here so hopefully I include all the necessary data to help get an answer. I have Icinga 2 (2.13.2-1) running on a RPi with Buster. I have the follow enabled features: api checker command ido-mysql… --- ## [Database from PSQL to Mariadb](https://community.icinga.com/t/database-from-psql-to-mariadb/9362)
**Author:** [@Rico](https://community.icinga.com/u/Rico)\ **Replies:** 2\ **Last updated:** [March 4, 2022, 10:35am UTC](https://community.icinga.com/t/database-from-psql-to-mariadb/9362 "2022-03-04T10:35:53Z")
Hello everybody, my colleague installed a new icinga2 instance with a PSQL database after a failure. However, most additional modules (X509/Vsphere) are based on MYSQL/Mariadb. So now I have Mariadb installed but can’t … --- ## [Host is not part of a hostgroup even though it should be](https://community.icinga.com/t/host-is-not-part-of-a-hostgroup-even-though-it-should-be/7632)
**Author:** [@esma1992](https://community.icinga.com/u/esma1992)\ **Replies:** 2\ **Last updated:** [October 19, 2021, 5:00pm UTC](https://community.icinga.com/t/host-is-not-part-of-a-hostgroup-even-though-it-should-be/7632 "2021-10-19T17:00:15Z")
Occassionaly it happens that a host is not part of a hostgroup even though it should be. After detailed issue analysis it was found that the information is missing in the icinga2 database. For instance, in icingaweb2 GU… --- ## [How to change User Preference Storage Type - Icinga Web 2](https://community.icinga.com/t/how-to-change-user-preference-storage-type-icinga-web-2/8167)
**Author:** [@TsJu00](https://community.icinga.com/u/TsJu00)\ **Replies:** 1\ **Last updated:** [September 8, 2021, 6:30am UTC](https://community.icinga.com/t/how-to-change-user-preference-storage-type-icinga-web-2/8167 "2021-09-08T06:30:11Z")
Hello together, i´d like to change the User Preference Storge Type from Ini to Database, but i can´t find any Schema for the DB … Do you now where i could find this Information? Icinga Web 2 version: 2.9.3 Web browser… --- ## [Access denied for user 'admin'@'localhost' to database 'icingaweb\_users'](https://community.icinga.com/t/access-denied-for-user-admin-localhost-to-database-icingaweb-users/7015)
**Author:** [@lovalim](https://community.icinga.com/u/lovalim)\ **Replies:** 2\ **Last updated:** [March 27, 2021, 4:42pm UTC](https://community.icinga.com/t/access-denied-for-user-admin-localhost-to-database-icingaweb-users/7015 "2021-03-27T16:42:39Z")
initial administrator. 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\_Adapter\_Exception in … --- ## [Director sync database to cluster-zone](https://community.icinga.com/t/director-sync-database-to-cluster-zone/6794)
**Author:** [@famfop](https://community.icinga.com/u/famfop)\ **Replies:** 2\ **Last updated:** [March 1, 2021, 9:45am UTC](https://community.icinga.com/t/director-sync-database-to-cluster-zone/6794 "2021-03-01T09:45:00Z")
Hi, I have a master-satellite-agent setup with icinga director installed on the master and on the satellite. So far this is working. Now I am wondering: Is there a way to synchronize data from my master’s director db t… --- ## [Timezone offset incorrect when reading from database](https://community.icinga.com/t/timezone-offset-incorrect-when-reading-from-database/5288)
**Author:** [@michel\_w](https://community.icinga.com/u/michel_w)\ **Replies:** 2\ **Last updated:** [September 28, 2020, 8:18am UTC](https://community.icinga.com/t/timezone-offset-incorrect-when-reading-from-database/5288 "2020-09-28T08:18:32Z")
Hello dear community, i am currently developing a custom icingaweb2 module. For this module i used the build-in database functionality to read data about hosts. The error im facing is occuring when reading data from m… --- ## [IDO database apply retention policy to an entire database](https://community.icinga.com/t/ido-database-apply-retention-policy-to-an-entire-database/4601)
**Author:** [@phoxd](https://community.icinga.com/u/phoxd)\ **Replies:** 5\ **Last updated:** [June 10, 2020, 11:41am UTC](https://community.icinga.com/t/ido-database-apply-retention-policy-to-an-entire-database/4601 "2020-06-10T11:41:27Z")
ido-mysql feature has an attribute cleanup where you can specify table names to set retention policy. How would you apply to the entire database without writing down every table name? --- ## [Icinga2 database (postgresql) size issues](https://community.icinga.com/t/icinga2-database-postgresql-size-issues/3666)
**Author:** [@t.wagner](https://community.icinga.com/u/t.wagner)\ **Replies:** 2\ **Last updated:** [March 2, 2020, 4:04pm UTC](https://community.icinga.com/t/icinga2-database-postgresql-size-issues/3666 "2020-03-02T16:04:58Z")
Hello everyone! We are currently having a problem with the postgresql database of our icinga2 (version r2.9.1-1 running on a server with Debian GNU/Linux 7 (wheezy)). Everythings appears to work fine but apparently the …