Current state of icinga notifications modules

Icinga Web Modules Icinga Director
1

Hi all,
I know it’s early access, but since the packages are already being distributed via the official repositories, I wanted to take a look at the new notification modules. Unfortunately, I can’t get them to work.

  • The daemon is installed and running.
  • The database is present and registered as a resource.
  • The source is configured.

However, I run into issues with the channels. When I try to create one, I get an “undefined index: config” error, regardless of which type I select.

In the Notifications tab under Events, I get the following SQLSTATE error:
syntax error or access violation: 1305 FUNCTION notifications.json_objectagg does not exist

The installation is on RHEL 8, with the following versions:

  • icingaweb2: 2.12.2
  • icinga-notifications: 0.1.1
  • icinga-notifications-web: 0.1.0
  • icingadb: 1.2.1
  • icingadbweb: 1.1.3

Has anyone encountered similar issues or has any tips on how to resolve this? Any help or information would be greatly appreciated!

Cheers,
Marcus

2

Thanks for trying out Icinga Notifications and reporting back.

Which database server are you using and in which version?

3

We are currently running on MariaDB 10.3.39

4

Sorry, but it seems like your MariaDB version is too old. Seems like JSON_OBJECTAGG was added first in MariaDB 10.5.0, https://mariadb.com/kb/en/json_objectagg/.

5

Thanks for the hint, @apenning. This should be documented in the docs, as MariaDB 10.3 is the default version in RHEL 8 and 10.5 in RHEL 9.

The SQL errors have disappeared. However, I still cannot create a channel. On the ‘Add Channel’ screen, I get a red message saying ‘Undefined index: config’ above the Name field when I click the ‘Add Channel’ button, regardless of which type I choose

6

Thanks again for your report, I have opened up a PR fixing the required version in the docs, https://github.com/Icinga/icinga-notifications/pull/287.

Please note that with Icinga Notifications being a new project, even still being in its “beta” phase, we are targeting current operating system versions. RHEL 8’s full support has already ended last year, not being our main priority for Icinga Notifications, https://endoflife.date/rhel.

I am sorry hearing this. What did you change? Have you upgraded your SQL server? Could you please again supply all your component’s versions, including database and PHP. Are there any logs available?

7

Maintanance and extended support is still in the lifecycle :wink:
Anyway, I have updated MariaDB to 10.5.27 via RedHat module upgrade mechanism.
Packages currently installed ( plus their associated packages which I am not listing now for reasons of clarity):

  • icinga2-2.14.5
  • icinga-businessprocess-2.5.1
  • icinga-cube-1.3.3
  • icingadb-1.2.1
  • icingadb-redis-7.2.7
  • icingadb-web-1.1.3
  • icinga-notifications-0.1.0
  • icingaweb2-2.12.2
  • php-icinga2-2.12.2

php --version: 7.2.24

I couldn’t find any helpful logs

8

Since I am not so familiar with the web side, I have created an issue based on this thread in their issue tracker, https://github.com/Icinga/icinga-notifications-web/issues/307. Please feel free to add any more information you have that is not already part of this thread.

1 Like