Bug 1040029 – [DWH-SETUP] - read only user is not created during unattended installation

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1040029 - [DWH-SETUP] - read only user is not created during unattended installation

Summary:	[DWH-SETUP] - read only user is not created during unattended installation

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Enterprise Virtualization Manager
Classification:	Red Hat
Component:	ovirt-engine-dwh (Show other bugs)
Sub Component:
Version:	3.3.0
Hardware:	Unspecified Unspecified

Priority	high Severity high
Target Milestone:	---
Target Release:	3.3.0
Assigned To:	Sandro Bonazzola
QA Contact:	Barak Dagan
Docs Contact:

URL:
Whiteboard:	integration
Keywords:

Depends On:
Blocks:	3.3rc1
	Show dependency tree / graph

Reported:	2013-12-10 09:41 EST by Barak Dagan
Modified:	2014-01-21 10:05 EST (History)
CC List:	10 users (show)

See Also:
Fixed In Version:	is28 - rhevm-dwh-3.3.0-26.el6ev.noarch.rpm
Doc Type:	Bug Fix
Doc Text:	During an unattended installation, if the CREATE_READONLY_USER parameter was specified in an answer file, the readonly user was not created. Now if CREATE_READONLY_USER is set to yes or true it will be created using validated values from READONLY_SECURE, READONLY_USER, and READONLY_PASS.
Story Points:	---
Clone Of:
Environment:
Last Closed:	2014-01-21 10:05:06 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)
dwh setup logs (18.50 KB, text/plain) 2013-12-10 09:41 EST, Barak Dagan	no flags	Details
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
oVirt gerrit	22369	None	None	None	Never
oVirt gerrit	22472	None	None	None	Never
Red Hat Product Errata	RHBA-2014:0036	normal	SHIPPED_LIVE	rhevm-dwh 3.3 bug fix and enhancement update	2014-01-21 14:53:35 EST

Groups: None (edit)

Description Barak Dagan 2013-12-10 09:41:36 EST

Created attachment 834798 [details]
dwh setup logs

Description of problem:

Using unattended installation, readonly user is not created:


# grep -i read 33.local.dwh.ansfile 
CREATE_READONLY_USER=Yes
READONLY_SECURE=No
READONLY_USER=readonly
READONLY_PASS=123456


# cat /etc/ovirt-engine-dwh/engine-dwh.conf.d/10-setup-database-dwh.conf 
DWH_USER=engine_history
DWH_PASSWORD=6095BIgZ
DWH_DATABASE=ovirt_engine_history



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

How reproducible:
100%


Steps to Reproduce:
1. create dwh answer file using rhevm-dwh-setup -g ansfile
2. fix te file to create readonly user
3. run rhevm-dwh-setup -a ansfile

Actual results:
readonly user is not created

Expected results:
readonly user is created, with the credentials specified in the answerfile

Additional info:

Comment 1 Sandro Bonazzola 2013-12-12 10:48:50 EST

Alex, it seems that createReadUser is not set to True when options['CREATE_READONLY_USER'] is not None.
I'm not sure about implications in other parts of the setup. 
I'll try to fix it tomorrow.

Comment 3 Barak Dagan 2013-12-22 09:37:01 EST

Verified on is28.1:

local  
======

# su - postgres -c 'psql -c "SELECT rolname FROM pg_roles;"'
    rolname     
----------------
 postgres
 engine
 engine_history
 readonly
 engine_reports
(5 rows)

Remote 
=======

Comment 5 errata-xmlrpc 2014-01-21 10:05:06 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-0036.html

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