Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1039946

Summary: [REPORTS-SETUP] - reports installation fails on remote db configuration
Product: Red Hat Enterprise Virtualization Manager Reporter: Barak Dagan <bdagan>
Component: ovirt-engine-reportsAssignee: Sandro Bonazzola <sbonazzo>
Status: CLOSED ERRATA QA Contact: Barak Dagan <bdagan>
Severity: urgent Docs Contact:
Priority: urgent    
Version: unspecifiedCC: acathrow, iheim, pstehlik, Rhev-m-bugs, sbonazzo, yeylon, ylavi
Target Milestone: ---   
Target Release: 3.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: integration
Fixed In Version: is28 - rhevm-reports-3.3.0-26.el6ev.noarch.rpm Doc Type: Bug Fix
Doc Text:
Previously, installing rhevm-reports on a remote database failed when it could not connect to the database. Now when the database connection could not be established, it raises a runtime error instead of killing the installation process.
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-01-21 14:56:40 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:
Embargoed:
Bug Depends On: 1045846    
Bug Blocks: 922854, 1021556, 1049022, 1052848    
Attachments:
Description Flags
reports setup log none

Description Barak Dagan 2013-12-10 11:58:41 UTC
Created attachment 834718 [details]
reports setup log

Description of problem:

reports installation fails on clean installation due to DB connectivity:

# rhevm-reports-setup
Welcome to ovirt-engine-reports setup utility
Remote database found.
Could not connect to the remote DB
Error encountered while installing ovirt-engine-reports, please consult the log file: /var/log/ovirt-engine/ovirt-engine-reports-setup-2013_12_09_17_56_38.log

using the command in the log:

[root@fire33-remrep yum.repos.d]# psql --dbname ovirtenginereports --host fire33-remdb.scl.lab.tlv.redhat.com --port 5432 --username reportuser -c 'select 1'
Password for user reportuser:
 ?column?
----------
        1
(1 row)


Version-Release number of selected component (if applicable):
is26

How reproducible:
Happened once out of one try

Steps to Reproduce:
1. on clean machine install remote db + engine, history & reports roles and DBs
2. on clean machine install engine + dwh + reports using remote DB created in the previous step 
3.

Actual results:
Reports installation failed

Expected results:
Sucessfull reports installation

Additional info:

Comment 1 Yaniv Lavi 2013-12-17 10:25:02 UTC
For some reason the user trying to connect is engine_reports, while bdagan uses a role called reportuser. This looks like user name assignment issue.




Yaniv

Comment 3 Barak Dagan 2014-01-16 21:41:38 UTC
verified on is32.3:

rhevm-dwh-3.3.0-28.el6ev.noarch
jasperreports-server-pro-5.5.0-4.el6ev.noarch
rhevm-reports-3.3.0-28.el6ev.noarch

Comment 5 errata-xmlrpc 2014-01-21 14:56:40 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-0035.html