Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1045855 - [DWH-SETUP] - upgrade (from 3.2.4) failed on local db, as installer uses misconfigured user
[DWH-SETUP] - upgrade (from 3.2.4) failed on local db, as installer uses misc...
Status: CLOSED ERRATA
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh (Show other bugs)
3.3.0
Unspecified Unspecified
unspecified Severity urgent
: ---
: 3.3.0
Assigned To: Yedidyah Bar David
Barak Dagan
integration
: Triaged
Depends On:
Blocks: 1043530 1043951 1043957 rhev3.3ga
  Show dependency treegraph
 
Reported: 2013-12-22 10:26 EST by Barak Dagan
Modified: 2014-03-20 10:18 EDT (History)
10 users (show)

See Also:
Fixed In Version: IS30 - rhevm-dwh-3.3.0-27.el6ev.src.rpm
Doc Type: Bug Fix
Doc Text:
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.
Story Points: ---
Clone Of:
Environment:
Last Closed: 2014-01-21 10:05:29 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
rhevm-dwh-setup-2013_12_22_13_26_29.log (1.92 KB, application/x-compressed-tar)
2013-12-22 10:26 EST, Barak Dagan
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
oVirt gerrit 22701 None None None Never
oVirt gerrit 22840 None None None Never
Red Hat Product Errata RHBA-2014:0036 normal SHIPPED_LIVE rhevm-dwh 3.3 bug fix and enhancement update 2014-01-21 14:53:35 EST

  None (edit)
Description Barak Dagan 2013-12-22 10:26:30 EST
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 1 Yedidyah Bar David 2013-12-23 09:42:36 EST
http://gerrit.ovirt.org/22658 solves this bug, in the specific flow detailed in the description.

It might be related also to bz #1045846, didn't check that.
Comment 3 Barak Dagan 2014-01-16 12:30:05 EST
verified on is32.2:

rhevm-reports-3.3.0-28.el6ev.noarch
rhevm-dwh-3.3.0-28.el6ev.noarch
jasperreports-server-pro-5.5.0-4.el6ev.noarch
Comment 5 errata-xmlrpc 2014-01-21 10:05:29 EST
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

Note You need to log in before you can comment on or make changes to this bug.