Bug 1040029

Summary: [DWH-SETUP] - read only user is not created during unattended installation
Product: Red Hat Enterprise Virtualization Manager Reporter: Barak Dagan <bdagan>
Component: ovirt-engine-dwhAssignee: Sandro Bonazzola <sbonazzo>
Status: CLOSED ERRATA QA Contact: Barak Dagan <bdagan>
Severity: high Docs Contact:
Priority: high    
Version: 3.3.0CC: aberezin, acathrow, iheim, oschreib, pstehlik, Rhev-m-bugs, sbonazzo, srevivo, yeylon, ylavi
Target Milestone: ---   
Target Release: 3.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: integration
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 15:05:06 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1049022    
Attachments:
Description Flags
dwh setup logs none

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