rhevm-dwh setup failed during upgrade, because the installer connected to the database using the engine_history user while the owner is actually postgres. Now, the database owner is set as engine_history during installation, so this error does not occur.
Created attachment 840361[details]
rhevm-dwh-setup-2013_12_22_13_26_29.log
Description of problem:
dwh setup failed while upgrading from 3.2.4, since the installer connects to the DB using "engine_history", while the owner is postgres:
log:
stderr = psql: FATAL: password authentication failed for user "engine_history"
DB:
# su - postgres -c "psql -l;"
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
----------------------+----------+----------+-------------+-------------+-----------------------
engine | engine | UTF8 | en_US.UTF8 | en_US.UTF8 |
ovirt_engine_history | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
rhevmreports | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
Version-Release number of selected component (if applicable):
is28.1
How reproducible:
100%
Steps to Reproduce:
1. install 3.2.4 / 5 including dwh & reports
2. verify that the OS was upgraded to 6.5 and install 3.3 (is28.1) engine
3. install dwh
Actual results:
installation failed
Expected results:
successful installation
Additional info:
in the log after that failure, there is a try to create engine role
Comment 1Yedidyah Bar David
2013-12-23 14:42:36 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.
http://rhn.redhat.com/errata/RHBA-2014-0036.html
Created attachment 840361 [details] rhevm-dwh-setup-2013_12_22_13_26_29.log Description of problem: dwh setup failed while upgrading from 3.2.4, since the installer connects to the DB using "engine_history", while the owner is postgres: log: stderr = psql: FATAL: password authentication failed for user "engine_history" DB: # su - postgres -c "psql -l;" List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges ----------------------+----------+----------+-------------+-------------+----------------------- engine | engine | UTF8 | en_US.UTF8 | en_US.UTF8 | ovirt_engine_history | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | rhevmreports | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | Version-Release number of selected component (if applicable): is28.1 How reproducible: 100% Steps to Reproduce: 1. install 3.2.4 / 5 including dwh & reports 2. verify that the OS was upgraded to 6.5 and install 3.3 (is28.1) engine 3. install dwh Actual results: installation failed Expected results: successful installation Additional info: in the log after that failure, there is a try to create engine role