Bug 1727550

Summary:	Install DWH on separate machine failed - problem with execute stage 'Misc configuration'
Product:	[oVirt] ovirt-engine-dwh	Reporter:	David Vaanunu <dvaanunu>
Component:	Setup	Assignee:	Shirly Radco <sradco>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Guilherme Santos <gdeolive>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	4.3.4	CC:	bugs, lleistne, mperina
Target Milestone:	ovirt-4.3.6	Keywords:	ZStream
Target Release:	4.3.6	Flags:	pm-rhel: ovirt-4.3+
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	ovirt-engine-dwh-4.3.6	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-09-26 19:42:47 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Metrics	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1745988

Description David Vaanunu 2019-07-07 09:11:36 UTC

Description of problem:
Installation of DWH on separate machine fails with error
Failed to execute stage 'Misc configuration': could not open extension control file "/opt/rh/rh-postgresql10/root/usr/share/pgsql/extension/uuid-ossp.control": No such file or directory


Version-Release number of selected component (if applicable):
ovirt-engine-dwh-setup-4.3.0-1.el7ev.noarch



How reproducible:


Steps to Reproduce:
1. Install 4.3 engine with DWH
2. On new DWH machine (separate) - yum install ovirt-engine-dwh-setup
3. Running 'engine-setup'
4. Enter setup values


Actual results:
[ ERROR ] Failed to execute stage 'Misc configuration': could not open extension control file "/opt/rh/rh-postgresql10/root/usr/share/pgsql/extension/uuid-ossp.control": No such file or directory


Expected results:
The setup will be passed successfully.


Additional info:

Doc - https://www.ovirt.org/documentation/data-warehouse/Data_Warehouse_and_Reports_Configuration_Notes.html

Comment 1 Martin Perina 2019-07-11 08:57:42 UTC

Currently DWH depends only on postgresql-server package, but that's not enough for standalone installation. DWH needs to depend also on postgresql-contrib, because of uuid-ossp extension, which is required for generating UUID keys.

Comment 2 Guilherme Santos 2019-09-03 08:13:05 UTC

Verified in the engine machine (on ovirt-engine-4.3.6.4-0.1.el7.noarch) configuring to access the DWH remotely;
And verified in the second machine containing the DWH (postgresql10) manually and automatically configured according with engine-setup (ovirt-engine-dwh-setup-4.3.6-1.el7ev.noarch)

Comment 3 Sandro Bonazzola 2019-09-26 19:42:47 UTC

This bugzilla is included in oVirt 4.3.6 release, published on September 26th 2019.

Since the problem described in this bug report should be
resolved in oVirt 4.3.6 release, it has been closed with a resolution of CURRENT RELEASE.

If the solution does not work for you, please open a new bug report.