Bug 1039946 - [REPORTS-SETUP] - reports installation fails on remote db configuration
Summary: [REPORTS-SETUP] - reports installation fails on remote db configuration
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-reports
Version: unspecified
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 3.3.0
Assignee: Sandro Bonazzola
QA Contact: Barak Dagan
URL:
Whiteboard: integration
Depends On: 1045846
Blocks: 922854 1021556 3.3rc1 1052848
TreeView+ depends on / blocked
 
Reported: 2013-12-10 11:58 UTC by Barak Dagan
Modified: 2015-09-22 13:10 UTC (History)
7 users (show)

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

Attachments (Terms of Use)
reports setup log (7.23 KB, text/plain)
2013-12-10 11:58 UTC, Barak Dagan 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2014:0035 0 normal SHIPPED_LIVE rhevm-reports 3.3 bug fix and enhancement update 2014-01-21 19:53:30 UTC
oVirt gerrit 22235 0 None None None Never
oVirt gerrit 22550 0 None None None Never
oVirt gerrit 22564 0 None None None Never

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
Note You need to log in before you can comment on or make changes to this bug.