I’m trying to get incinga2 to work. But when I open IcingaDB as a menu item I get the following error:
Base table or view not found: 1146 Table ‘icinga_ido_db.host’ doesn’t exist
In the schema I imported, the table names have the prefix inginca_* (icinga_hosts). Something is wrong with the table schema that I imported.
mysql -u root -p icingadb </usr/share/icingadb/schema/mysql/schema.sql
icinga2 --version:
icinga2 - The Icinga 2 network monitoring daemon (version: r2.14.0-1)
Copyright (c) 2012-2023 Icinga GmbH (https://icinga.com/)
License GPLv2+: GNU GPL version 2 or later
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
System information:
Platform: Ubuntu
Platform version: 22.04.3 LTS (Jammy Jellyfish)
Kernel: Linux
Kernel version: 5.15.0-76-generic
Architecture: x86_64
Build information:
Compiler: GNU 11.3.0
Build host: runner-hh8q3bz2-project-575-concurrent-0
OpenSSL version: OpenSSL 3.0.2 15 Mar 2022
- Enabled features (
icinga2 feature list)
Enabled features: api checker icingadb ido-mysql mainlog notification - Icinga Web 2 version and modules (System - About)
2.12.1 - Config validation (
icinga2 daemon -C)
[2023-11-27 15:22:34 +0100] information/cli: Icinga application loader (version: r2.14.0-1)
[2023-11-27 15:22:34 +0100] information/cli: Loading configuration file(s).
[2023-11-27 15:22:34 +0100] information/ConfigItem: Committing config item(s).
[2023-11-27 15:22:34 +0100] information/ApiListener: My API identity: srvcoremon.srv.med.uni-muenchen.de
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 IcingaApplication.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 IcingaDB.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 IdoMysqlConnection.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 FileLogger.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 3 Zones.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 CheckerComponent.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 Endpoint.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 ApiUser.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 NotificationComponent.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 1 ApiListener.
[2023-11-27 15:22:34 +0100] information/ConfigItem: Instantiated 246 CheckCommands.
[2023-11-27 15:22:34 +0100] information/ScriptGlobal: Dumping variables to file ‘/var/cache/icinga2/icinga2.vars’
[2023-11-27 15:22:34 +0100] information/cli: Finished validating the configuration file(s).