postgreSQL + Icinga Web 2

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.

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

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?

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.

Cheers,
Michael