[icinga-users] Icingaweb2 wizard with postgres fails

Bernd Nachtigall bnacht at web.de
Tue Feb 12 10:44:49 CET 2019



Am 11.02.19 um 19:17 schrieb Bernd Nachtigall:
> Am 10.02.19 um 20:48 schrieb Florian Bachmann:
>> Hi,
>>
>> this sounds like PostgreSQL authentication has not been properly
>> configured.
>>
>> While Andreas apparently tries to connect using password authentication
>> (not enabled with the default RHEL/CentOS postgresql configuration if I
>> remember correctly, and you will need to create the database roles
>> beforehand with the "postgres" administrator account), you seem to be
>> trying to authenticate with "ident", which basically means "if the db
>> user name matches the name of the user running the PostgreSQL client (as
>> reported by the operating system) that is good enough and we don't need
>> no stinking passwords!". Unless your web server runs under the
>> "icingaweb" account, that isn't going to work out.
>>
>> Basically both of you should study the PostgreSQL documentation for the
>> pg_hba.conf file, modify that file to fit your requirements, then
>> recycle the PostgreSQL daemon (systemctl restart postgresql, reload
>> isn't good enough) and try again.
>
> Indeed I am not a postgres specialist and I do not use/create a DB-User
> for icingsweb2. But I does not found this is neccessary during the wizard.
>
> Why have a wizard if I have to do such basics w/o a hint during the
> wizard runs? (No answer neccessary ;-)
>
> OK, now I have configured the access to the pgsql. In the Wizard I get
> the messages:
>
> "Database Resource
>
> Now please configure the database resource where to store users and user
> groups. Note that the database itself does not need to exist at this
> time as it is going to be created once the wizard is about to be finished."
>
> Ah, perfect. I can go forward without create the table itself.
>
> I fill out the fields and get the message(s):
>
> "Unable to check the server's version. This is usually not a critical
> error as there is probably only access to the database permitted which
> does not exist yet. If you are absolutely sure you are running
> PostgreSQL in a version equal to or newer than 9.1, you can skip the
> validation and safely proceed to the next step. The error was:
> SQLSTATE[08006] [7] FATAL: database "icingaweb_db" does not exist"
>
> I am sure that my PGSQL Version ist equal or newser than 9.1 (it is
> 10.x) and the message above means that there is no problem if the DB is
> missing because the wizard will create them.
>
> But after the the wizard comes to the end I get:
>
> "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:  database "icingaweb_db" does not exist"
>
> OK, it is no problem to create the DB manuelly before start the wizard,
> but ...
>
... if I create a DB for icingaweb2 the result is: 'Unable to create
user group "Administrators". ... Undefined table ...'

This is correct. I have created the DB (and added the neccessary rights)
but I do not import a schema or create the tables. Do you remember, the
wizard wrote: "Note that the database itself does not need to exist at
this time as it is going to be created once the wizard is about to be
finished."

Is there a DB schema or a description to install the tables manually? Or
is there a documentation to install icingaweb w/o the wizard? It seems
that the wizard does not play with me ...

Bernd


More information about the icinga-users mailing list