Bug 1079355
| Summary: | [rhevm-reports-setup] Enable specifying a different DB server than the engine DB server | |||
|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Jiri Belka <jbelka> | |
| Component: | ovirt-engine-reports | Assignee: | Yedidyah Bar David <didi> | |
| Status: | CLOSED ERRATA | QA Contact: | Pavel Novotny <pnovotny> | |
| Severity: | medium | Docs Contact: | ||
| Priority: | medium | |||
| Version: | 3.3.0 | CC: | dfediuck, gklein, iheim, rbalakri, Rhev-m-bugs, sherold, sradco, talayan, yeylon, ylavi | |
| Target Milestone: | --- | |||
| Target Release: | 3.5.0 | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | integration | |||
| Fixed In Version: | oVirt Beta2 | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1167313 (view as bug list) | Environment: | ||
| Last Closed: | 2015-02-11 18:17:03 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: | 1142923, 1156165, 1167313 | |||
Will be considered for 3.5.0. Yaniv should be in the code of first release. Please test once it's out. Yaniv Verified in rhevm-3.5.0-0.19.beta.el6ev.noarch (vt9).
Verification steps:
1. Do a clean install of RHEVM (no DWH or Reports), use remote engine DB during installation.
2. Install rhevm-dwh, run rhevm-setup and use the same remote DB host for DWH as was used in step 1.
3. Install rhevm-reports, run rhevm-setup and also specify remote DB for Reports.
Result:
Install script asks for remote DB host for Reports, snippet from installation process:
-~-
--== DATABASE CONFIGURATION ==--
Where is the Reports database located? (Local, Remote) [Local]: remote
ATTENTION
Manual action required.
Please create database for ovirt-engine use. Use the following commands as an example:
create role ovirt_engine_reports with login encrypted password 'ovirt_engine_reports';
create database ovirt_engine_reports owner ovirt_engine_reports
template template0
encoding 'UTF8' lc_collate 'en_US.UTF-8'
lc_ctype 'en_US.UTF-8';
Make sure that database can be accessed remotely.
Reports database host [localhost]: remotedb.example.com
Reports database port [5432]:
Reports database secured connection (Yes, No) [No]:
Reports database name [ovirt_engine_reports]: reportsdb
Reports database user [ovirt_engine_reports]: reports
Reports database password: *****
The detected DWH database size is 21 MB.
Setup can backup the existing database.
...
Would you like to backup the existing database before upgrading it? (Yes, No) [Yes]:
...
...
-~-
Yaniv - do we needs docs for this (in the bug or in docs)? This already worked in 3.4, not sure about the status of official support etc. (In reply to Yedidyah Bar David from comment #6) > Yaniv - do we needs docs for this (in the bug or in docs)? > > This already worked in 3.4, not sure about the status of official support > etc. If it's not already included, then it need to be added to docs. 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. https://rhn.redhat.com/errata/RHEA-2015-0176.html |
Description of problem: remote DB server cannot be define, it is inherited from remote engine DB server. I want to define different DB server :) # rhevm-reports-setup Welcome to rhevm-reports setup utility In order to proceed the installer must stop the ovirt-engine service Would you like to stop the ovirt-engine service (yes|no): yes Stopping ovirt-engine... [ DONE ] Remote database not found. Remote installation selected. Make sure that DBA creates a user and the database in the following fashion: ^^^^^ - no freedom to define remote DB server! create role <role> with login encrypted password '<password>'; create database rhevmreports template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8' owner <role>; Database user: remote_reports Database password: Editing XML files... [ DONE ] Setting DB connectivity... [ DONE ] Please choose a password for the reports admin user(s) (rhevm-admin and superuser): Warning: Weak Password. Re-type password: ... Version-Release number of selected component (if applicable): rhevm-reports-3.3.2-3.el6ev.noarch How reproducible: 100% Steps to Reproduce: 1. install engine with remote DB and dwh 2. rhevm-reports-setup 3. Actual results: no question about setting remote DB server Expected results: give me back the freedom to define remote DB server Additional info: