Bug 1431811 - CloudForms database not properly setup
Summary: CloudForms database not properly setup
Keywords:
Status: NEW
Alias: None
Product: Red Hat Quickstart Cloud Installer
Classification: Red Hat
Component: Installation - CloudForms
Version: 1.1
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
: ---
Assignee: John Matthews
QA Contact: Sudhir Mallamprabhakara
Dan Macpherson
URL:
Whiteboard:
Depends On:
Blocks: 1724792
TreeView+ depends on / blocked
 
Reported: 2017-03-13 19:31 UTC by Thom Carlin
Modified: 2022-02-12 08:28 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1385697 0 medium CLOSED [RFE] appliance_console_cli missing options 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 1387672 0 high CLOSED postgres upgrade fails to run if not usig a separate mount point/disk for the db 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 1431794 0 unspecified CLOSED miq_postgres_script fails to upgrade postgres if the database is mounted on the same local disk 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 1431815 0 medium CLOSED appliance_console_cli allows configuration that is not supported 2021-02-22 00:41:40 UTC

Internal Links: 1385697 1387672 1431794 1431815

Description Thom Carlin 2017-03-13 19:31:34 UTC
Description of problem:

While investigating other issues, discovered /dev/vdb was not actually used by CloudForms setup by QCI

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

1.1

How reproducible:

100%

Steps to Reproduce:
1. Install/configure QCI
2. Deploy provider with CloudForms
3. ssh cloudforms_system
4. appliance_console
5. Examine Local Database Server line (and below)

Actual results:

Local Database Server:   not initialized
CFME Server:             running
CFME Database:           localhost
Database/Region:         vmdb_production / 1

Expected results:

Initialized database

Additional info:

Also checked /dev/vdb.  It was partitioned but not used (all nulls).

Probably also affects 1.0

Proposed solution: Pass "--dbdisk" parameter to appliance_console_cli

CloudForms appears to be operational but not correctly configured.

Comment 1 Kedar Kulkarni 2017-03-14 16:37:40 UTC
I recently installed CFME on top of OSP. 

I ran the following command: 
 od -c /dev/vdb

Output: 
od: /dev/vdb: No such file or directory

Comment 2 Thom Carlin 2017-03-14 16:44:23 UTC
My initial configuration was for RHV.  Please note that the database *was* configured -- the issue was not there.  The corrected steps 4/5 should be:
4. od -c /dev/vdb
5. df /var/opt/rh/rh-postgresql94/lib/pgsql/data [for 1.1]

Expected results:

4. Non-null data
5. /dev/mapper/vg_data-lv-pg [...] /var/opt/rh/rh-postgres94/lib/pgsql/data

Actual results:

4. Non-null data
5. /dev/mapper/VG--CFME-lv-var [...] /var 

Comment 1 reflects this -- QCI may need to add a second disk so both OpenStack and RHV are setup similarly.


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