Bug 1006948

Summary:	Setup - When creating read only user, setup doesn't make sure preserved user names are not used.
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	Yaniv Lavi <ylavi>
Component:	ovirt-engine-dwh	Assignee:	Sandro Bonazzola <sbonazzo>
Status:	CLOSED ERRATA	QA Contact:	Barak Dagan <bdagan>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	3.3.0	CC:	acathrow, iheim, obasan, oschreib, pstehlik, Rhev-m-bugs, srevivo, yeylon
Target Milestone:	---
Target Release:	3.3.0
Hardware:	x86_64
OS:	Linux
Whiteboard:	integration
Fixed In Version:	rhevm-dwh-3.3.0-15.el6ev.noarch.rpm	Doc Type:	Bug Fix
Doc Text:	rhevm-dwh-setup now validates a provided user name before it creates a read-only user. The user provided cannot be one of the reserved users (postgres, engine, engine_history and engine_reports), it cannot be empty and it should not exist in the database.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-01-21 14:59:33 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:

Description Yaniv Lavi 2013-09-11 14:38:59 UTC

Description of problem:
When creating read only user, setup doesn't make sure preserved user names are not used. We need to decide, if to fail install on existing user, so roles can be recreated with different password, or disallowing just the preserved user names. 

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

How reproducible:
Always

Steps to Reproduce:
1. Run setup
2. Enter user 'engine' to be create as read only.

Actual results:
Setup fail on user drop

Expected results:
Should not allow existing user or selecting 'engine', 'engine_reports' and 'engine_history'.

Additional info:

Comment 1 Alex Lourie 2013-10-08 16:08:27 UTC

Merged into master; http://gerrit.ovirt.org/gitweb?p=ovirt-dwh.git;a=commit;h=04e82796593ec4c69f5107d76184aea51346295e

Comment 3 Barak Dagan 2013-11-13 13:28:30 UTC

verified on IS22:

rhevm-dwh-3.3.0-20.el6ev.noarch


This utility can configure a read only user for DB access. Would you like to do so? (yes|no): y
Provide a username for read-only user : engine
engine is a reserved username and cannot be used for creating read only user.

Comment 4 Charlie 2013-11-28 00:54:04 UTC

This bug is currently attached to errata RHEA-2013:15116. If this change is not to be documented in the text for this errata please either remove it from the errata, set the requires_doc_text flag to 
minus (-), or leave a "Doc Text" value of "--no tech note required" if you do not have permission to alter the flag.

Otherwise to aid in the development of relevant and accurate release documentation, please fill out the "Doc Text" field above with these four (4) pieces of information:

* Cause: What actions or circumstances cause this bug to present.
* Consequence: What happens when the bug presents.
* Fix: What was done to fix the bug.
* Result: What now happens when the actions or circumstances above occur. (NB: this is not the same as 'the bug doesn't present anymore')

Once filled out, please set the "Doc Type" field to the appropriate value for the type of change made and submit your edits to the bug.

For further details on the Cause, Consequence, Fix, Result format please refer to:

https://bugzilla.redhat.com/page.cgi?id=fields.html#cf_release_notes 

Thanks in advance.

Comment 7 errata-xmlrpc 2014-01-21 14:59:33 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