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
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh
Version: 3.3.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 3.3.0
Assignee: Sandro Bonazzola
QA Contact: Barak Dagan
URL:
Whiteboard: integration
Depends On:
Blocks: 3.3rc1
TreeView+ depends on / blocked
 
Reported: 2013-12-10 14:41 UTC by Barak Dagan
Modified: 2014-01-21 15:05 UTC (History)
10 users (show)

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


Attachments (Terms of Use)
dwh setup logs (18.50 KB, text/plain)
2013-12-10 14:41 UTC, Barak Dagan
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2014:0036 0 normal SHIPPED_LIVE rhevm-dwh 3.3 bug fix and enhancement update 2014-01-21 19:53:35 UTC
oVirt gerrit 22369 0 None None None Never
oVirt gerrit 22472 0 None None None Never

Description Barak Dagan 2013-12-10 14:41:36 UTC
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 15:48:50 UTC
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 14:37:01 UTC
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 15:05:06 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-0036.html


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