Bug 534543 - (RHQ-132) allow installer to create user/database
allow installer to create user/database
Status: CLOSED NEXTRELEASE
Product: RHQ Project
Classification: Other
Component: Installer (Show other bugs)
unspecified
All All
medium Severity medium (vote)
: ---
: ---
Assigned To: John Mazzitelli
http://jira.rhq-project.org/browse/RH...
: SubTask
Depends On:
Blocks: RHQ-131
  Show dependency treegraph
 
Reported: 2008-03-17 13:50 EDT by John Mazzitelli
Modified: 2009-11-10 16:22 EST (History)
0 users

See Also:
Fixed In Version: 1.0
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed:
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description John Mazzitelli 2008-03-17 13:50:00 EDT
the installer should provide a page that let's you create a user and database in an already installed database

for example, suppose user simply installed postgres using the default postgres installer.  Given the postgres admin username/password, our installer should be able to create the rhq user and its rhq database.

Oracle users should be able to give us the sys username/password  and with that the installer should be able to create the rhq schema.
Comment 1 John Mazzitelli 2008-03-17 13:53:12 EDT
oracle DDL is:

CREATE USER rhq IDENTIFIED BY rhqpassword;
GRANT connect, resource TO rhq;
Comment 2 John Mazzitelli 2008-03-17 15:52:20 EDT
postgres DDL is:

CREATE ROLE rhq LOGIN
  ENCRYPTED PASSWORD 'rhqpassword'
  NOSUPERUSER NOINHERIT CREATEDB NOCREATEROLE;

CREATE DATABASE rhq
  WITH OWNER = rhq
       ENCODING = 'SQL_ASCII'
       TABLESPACE = pg_default;

Comment 3 Red Hat Bugzilla 2009-11-10 15:30:41 EST
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-132

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