Bug 1045855 - [DWH-SETUP] - upgrade (from 3.2.4) failed on local db, as installer uses misconfigured user
Summary: [DWH-SETUP] - upgrade (from 3.2.4) failed on local db, as installer uses misc...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh
Version: 3.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
urgent
Target Milestone: ---
: 3.3.0
Assignee: Yedidyah Bar David
QA Contact: Barak Dagan
URL:
Whiteboard: integration
Depends On:
Blocks: 1043530 1043951 1043957 rhev3.3ga
TreeView+ depends on / blocked
 
Reported: 2013-12-22 15:26 UTC by Barak Dagan
Modified: 2014-03-20 14:18 UTC (History)
10 users (show)

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.
Clone Of:
Environment:
Last Closed: 2014-01-21 15:05:29 UTC
oVirt Team: ---
Target Upstream Version:
Embargoed:


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


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2014:0036 0 normal SHIPPED_LIVE rhevm-dwh 3.3 bug fix and enhancement update 2014-01-21 19:53:35 UTC
oVirt gerrit 22701 0 None None None Never
oVirt gerrit 22840 0 None None None Never

Description Barak Dagan 2013-12-22 15:26:30 UTC
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 14:42:36 UTC
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 17:30:05 UTC
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 15:05:29 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


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