Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1039946 - [REPORTS-SETUP] - reports installation fails on remote db configuration
[REPORTS-SETUP] - reports installation fails on remote db configuration
Status: CLOSED ERRATA
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-reports (Show other bugs)
unspecified
Unspecified Unspecified
urgent Severity urgent
: ---
: 3.3.0
Assigned To: Sandro Bonazzola
Barak Dagan
integration
:
Depends On: 1045846
Blocks: 922854 1021556 3.3rc1 1052848
  Show dependency treegraph
 
Reported: 2013-12-10 06:58 EST by Barak Dagan
Modified: 2015-09-22 09 EDT (History)
7 users (show)

See Also:
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 09:56:40 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)
reports setup log (7.23 KB, text/plain)
2013-12-10 06:58 EST, Barak Dagan
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
oVirt gerrit 22235 None None None Never
oVirt gerrit 22550 None None None Never
oVirt gerrit 22564 None None None Never
Red Hat Product Errata RHBA-2014:0035 normal SHIPPED_LIVE rhevm-reports 3.3 bug fix and enhancement update 2014-01-21 14:53:30 EST

  None (edit)
Description Barak Dagan 2013-12-10 06:58:41 EST
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 05:25:02 EST
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 16:41:38 EST
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 09:56:40 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-0035.html

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