postgreSQL + Icinga Web 2

Icinga Web
1

I installed Icinga Web2 about this documentation: https://icinga.com/docs/icingaweb2/latest/doc/02-Installation/

Then I arrive the WebWizard without any issues. Even in the wizard all messages are green or blue. No problems are visible. But at the end I get an error message:

Unable to create user group “Administrators”. An error occured:
ERROR: Zend_Db_Adapter_Exception in /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php:145 with message: SQLSTATE[08006] [7] FATAL: Ident authentication failed for user “icingaweb2”

Where I have to look for the error? I assume that the group Adminstrators should be a DB user group no linux group. If I try to connect to the DB as DB user icingaweb2 this is possible without problem. But I do not found a DB group Administrators (OK, the error msg. say that it was unable to create …)

I have add the DB rights to create roles and databases to the DB user icingaweb2, but this does not resolve the issue.

2

Hi,

can you share the configuration from your pg_hba.conf? It seems that the local icingaweb2 pgsql user is not allowed to communicate with the database itself.

Which system are you on, and which Icinga Web 2 version is involved?

Cheers,
Michael

3

Fu**,

I forgot to assign rights for this user to the localhost :-/

Thank you for the hint!

BTW: This is Icinga Web 2, Version 2.6.2 @ openSUSE LEAP15.1 @ aarch64

PS: Maybe someone want to remove the hint ‘Skip validation is secure’ when configure the DB resource if the configured user can NOT reach the DB :wink:

PPS: It is neccessary that the user icingaweb2 can create roles and databases?

4

Please open a feature request on GitHub - or you’ll chime into the source code and create a patch yourself :slight_smile:

I don’t think so. The setup wizard applies the GRANT on the database itself.
https://github.com/Icinga/icingaweb2/blob/master/modules/setup/library/Setup/Utils/DbTool.php#L627

Cheers,
Michael