Monitoring IDO Resource

Icinga 2
1

icinga2 - The Icinga 2 network monitoring daemon (version: r2.15.0-1)
Description: Ubuntu 24.04.3 LTS
Release: 24.04
psql (PostgreSQL) 16.10 (Ubuntu 16.10-0ubuntu0.24.04.1)
icinga2
icingacli
icingadb
icingadb-redis
icingadb-web
icingaweb2
icinga-director
monitoring-plugins

Icinga application loader (version: r2.15.0-1)
single server single instance

when I try to validate it says it can connect to the database but cannot find the IDO schema

image
image1183Ă—804 38.6 KB

I have ran the schema for postgresql. in fact I tried running again. below is a snippet of the output saying stuff already exists

please help me understand what it is looking for. not much on google for
“Cannot find the IDO schema” “Monitoring IDO Resource”

COMMENT
COMMENT
ERROR: relation “notification_usergroup” already exists
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: relation “idx_notification_usergroup_usergroup_id” already exists
ERROR: relation “idx_notification_usergroup_notification_id” already exists
COMMENT
COMMENT
COMMENT
COMMENT
ERROR: relation “notification_recipient” already exists
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: relation “idx_notification_recipient_user_id” already exists
ERROR: relation “idx_notification_recipient_notification_id_user” already exists
ERROR: relation “idx_notification_recipient_usergroup_id” already exists
ERROR: relation “idx_notification_recipient_notification_id_usergroup” already exists
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
ERROR: relation “notification_customvar” already exists
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: relation “idx_notification_customvar_notification_id” already exists
ERROR: relation “idx_notification_customvar_customvar_id” already exists
COMMENT
COMMENT
COMMENT
COMMENT
ERROR: relation “icon_image” already exists
ALTER TABLE
ALTER TABLE
ERROR: relation “idx_icon_image” already exists

2

you are trying to use the icingadb database for the old deprecated ido (icinga data out) feature.

there are two modules storing data in icinga2

  1. ido → (deprecated) using the the module monitoring which is shipped with icingaweb

  2. icingadb → which is in the docs part of the installation guide (with the REDIS part)
    Ubuntu - Icinga 2

from your previouse poss I can assume that you configured icingadb correctly

In the setup just go back an disable or not enable the module monitoring

I think you can also do this on the shell

icingacli module disable monitoring

alternatively you can also install ido correctly, here is the docs for that:

don’t use the same database for anything use individual databases for (icingadb, ido, icingaweb2, and so on)

3

funny you should say “correctly” when that is the exact link I used
I will work on using different databases
the whole point of me building this out is for monitoring so would I disable it
if something is deprecated why is it required during setup??

4

monitoring is the name of the old deprecated Icingaweb2 module that uses the old IDO DB backend.
The new module and the new backend are called icingadb and it also displays the monitoring information.

2 Likes
5

I was able to tweak this and get it to work
/etc/icinga2/features-enabled/ido-pgsql.conf
thanks for your help and time

6

configuring monitoring is only required if you do not have icingadb-web installed.
icingadb-web is an extra package, while monitoring is built in to the icingaweb2 package.