| Summary: | [DWH-SETUP] - upgrade (from 3.2.4) failed on local db, as installer uses misconfigured user | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Barak Dagan <bdagan> | ||||
| Component: | ovirt-engine-dwh | Assignee: | Yedidyah Bar David <didi> | ||||
| Status: | CLOSED ERRATA | QA Contact: | Barak Dagan <bdagan> | ||||
| Severity: | urgent | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 3.3.0 | CC: | acathrow, didi, eedri, iheim, pstehlik, Rhev-m-bugs, scohen, srevivo, yeylon, ylavi | ||||
| Target Milestone: | --- | Keywords: | Triaged | ||||
| Target Release: | 3.3.0 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | integration | ||||||
| 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 15:05:29 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Bug Depends On: | |||||||
| Bug Blocks: | 1043530, 1043951, 1043957, 1056111 | ||||||
| Attachments: |
|
||||||
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. 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 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