[icinga-users] Icingaweb2 wizard with postgres fails
bnacht at web.de
Mon Feb 11 19:17:38 CET 2019
Am 10.02.19 um 20:48 schrieb Florian Bachmann:
> this sounds like PostgreSQL authentication has not been properly
> 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
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  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
message: SQLSTATE  FATAL: database "icingaweb_db" does not exist"
OK, it is no problem to create the DB manuelly before start the wizard,
More information about the icinga-users