5.3. Data Warehouse and Reports Installation Options

Data Warehouse and Reports installation requires between one and three machines, and can be configured in one of the following ways:
  1. Install and configure both Data Warehouse and Reports on the machine on which the Manager is installed.

    This configuration hosts the Data Warehouse and Reports services on your Manager machine. This requires only a single registered machine, and is the simplest to configure; however, it also requires that the services share CPU and memory, and increases the demand on the host machine. Users who require access to the Data Warehouse service or the Reports service will require access to the Manager machine itself.

  2. Install and configure both Data Warehouse and Reports on one separate machine.

    This configuration hosts Data Warehouse and Reports on a single, separate machine. This requires two registered machines; however, it reduces the load on the Manager machine, and avoids potential CPU and memory-sharing conflicts on that machine. Administrators can also allow user access to the Data Warehouse-Reports machine, without the need to grant access to the Manager machine. Note that the Data Warehouse and Reports services will still compete for resources on their single host.

  3. Install and configure Data Warehouse on a separate machine, then install and configure Reports on a separate machine.

    This configuration separates each service onto its own dedicated host. This requires three registered machines; however, it reduces the load on each individual machine, and allows each service to avoid potential conflicts caused by sharing CPU and memory with other processes. Administrators can also allow user access to one particular machine, without the need to grant access to either of the two other machines.

  4. Install and configure Data Warehouse on the Manager machine, then install and configure Reports on a separate machine.

    This configuration hosts Data Warehouse on the Manager machine, and Reports on a separate host. This requires two registered machines; however, it reduces the load on the Manager machine, and avoids some memory-sharing conflicts. Administrators can allow user access to the Reports machine, without the need to grant access to the Manager machine.

  5. Install and configure Data Warehouse on a separate machine, then install and configure Reports on the Manager machine.

    This configuration hosts Data Warehouse on a separate machine, and Reports on the Manager machine. This requires two registered machines; however, it reduces the load on the Manager machine, and avoids some memory-sharing conflicts. Administrators can allow user access to the Data Warehouse machine, without the need to grant access to the Manager machine.

If you choose to host the Data Warehouse database on a machine that is separate from the machine on which the Data Warehouse service is installed, you will require an additional machine for that purpose. The same is true if you choose to host the Reports database remotely.

Note

Detailed user, administration, and installation guides for JasperReports are available in /usr/share/jasperreports-server-pro/docs/

5.3.1. Installing and Configuring Data Warehouse and Reports on the Red Hat Enterprise Virtualization Manager

Overview

Install and configure Data Warehouse and Red Hat Enterprise Virtualization Manager Reports on the same machine as the Red Hat Enterprise Virtualization Manager.

Prerequisites

Ensure that you have completed the following prerequisites:

  1. You must have installed and configured the Manager on this machine.
  2. If you choose to use a remote Data Warehouse database or Reports database, you must set up each database before installing the Data Warehouse and Reports services. You must have the following information about each database host:
    • The fully qualified domain name of the host
    • The port through which the database can be reached (5432 by default)
    • The database name
    • The database user
    • The database password
  3. If you are using the self-hosted engine, you must move it to maintenance mode: 
    # hosted-engine --set-maintenance --mode=global

Procedure 5.1. Installing and Configuring Data Warehouse and Reports on the Red Hat Enterprise Virtualization Manager

  1. Install the rhevm-dwh package and the rhevm-reports package on the system where the Red Hat Enterprise Virtualization Manager is installed: 
    # yum install rhevm-dwh rhevm-reports
  2. Run the engine-setup command to begin configuration of Data Warehouse and Reports on the machine: 
    # engine-setup
  3. Follow the prompts to configure Data Warehouse and Reports: 
    Configure Data Warehouse on this host (Yes, No) [Yes]: 
Configure Reports on this host (Yes, No) [Yes]:
  4. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings: 
    Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:
    If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.
  5. Answer the following questions about the Data Warehouse database and the Reports database: 
    Where is the DWH database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the DWH to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create DWH database, or prefer to perform that manually? (Automatic, Manual) [Automatic]: 
Where is the Reports database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the Reports to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create Reports database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
    Press Enter to choose the highlighted defaults, or type your alternative preference and then press Enter. If you select Remote, you are prompted to provide details about each remote database host.
  6. Set a password for the Reports administrative users (admin and superuser). Note that the reports system maintains its own set of credentials that are separate to those used for the Manager: 
    Reports power users password:
    You are prompted to enter the password a second time to confirm it.
  7. For the configuration to take effect, the ovirt-engine service must be restarted. The engine-setup command prompts you: 
    During execution engine service will be stopped (OK, Cancel) [OK]:
    Press Enter to proceed. The ovirt-engine service restarts automatically later in the command.
  8. Confirm your installation settings: 
    Please confirm installation settings (OK, Cancel) [OK]:
Next Steps

Access the Reports Portal at http://demo.redhat.com/ovirt-engine-reports, replacing demo.redhat.com with the fully qualified domain name of the Manager. If during the Manager installation you selected a non-default HTTP port then append :port to the URL, replacing :port with the port that you chose.

Log in using the user name admin and the password you set during reports installation. Note that the first time you log in to Red Hat Enterprise Virtualization Manager Reports, a number of web pages are generated and, as a result, your initial attempt to log in may take some time to complete.

5.3.2. Installing and Configuring Data Warehouse and Reports Together on a Separate Machine

Overview

Install and configure Data Warehouse and Red Hat Enterprise Virtualization Manager Reports together on a separate host from that on which the Red Hat Enterprise Virtualization Manager is installed. Hosting the Data Warehouse service and the Reports service on a separate machine helps to reduce the load on the Manager machine. Note that hosting Data Warehouse and Reports on the same machine means that these processes will share CPU and memory.

Prerequisites

Ensure that you have completed the following prerequisites:

  1. You must have installed and configured the Manager on a separate machine.
  2. To set up the Data Warehouse and Reports machine, you must have the following:
    • A virtual or physical machine with Red Hat Enterprise Linux 6.6 or later versions of Red Hat Enterprise Linux 6 installed.
    • A subscription to the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization subscription pools.
    • The password from the Manager's /etc/ovirt-engine/engine.conf.d/10-setup-database.conf file.
    • Allowed access from the Data Warehouse-Reports machine to the Manager database machine's TCP port 5432.
  3. If you choose to use a remote Data Warehouse database or Reports database, you must set up each database before installing the Data Warehouse and Reports services. You must have the following information about each database host:
    • The fully qualified domain name of the host
    • The port through which the database can be reached (5432 by default)
    • The database name
    • The database user
    • The database password

Procedure 5.2. Installing and Configuring Data Warehouse and Reports Together on a Separate Machine

  1. Register your system with the Content Delivery Network, entering your Customer Portal user name and password when prompted: 
    # subscription-manager register
  2. Find the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization subscription pools and note down the pool IDs. 
    # subscription-manager list --available
  3. Use the pool IDs located in the previous step to attach the entitlements to the system: 
    # subscription-manager attach --pool=pool_id
  4. Disable all existing repositories: 
    # subscription-manager repos --disable=*
  5. Enable the required repositories: 
    # subscription-manager repos --enable=rhel-6-server-rpms
# subscription-manager repos --enable=rhel-6-server-supplementary-rpms
# subscription-manager repos --enable=rhel-6-server-rhevm-3.6-rpms
# subscription-manager repos --enable=jb-eap-6-for-rhel-6-server-rpms
  6. Ensure that all packages currently installed are up to date: 
    # yum update
  7. Install the rhevm-dwh-setup and rhevm-reports-setup packages: 
    # yum install rhevm-dwh-setup rhevm-reports-setup
  8. Run the engine-setup command to begin configuration of Data Warehouse and Reports on the machine: 
    # engine-setup
  9. Follow the prompts to configure Data Warehouse and Reports: 
    Configure Data Warehouse on this host (Yes, No) [Yes]: 
Configure Reports on this host (Yes, No) [Yes]:
  10. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings: 
    Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:
    If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.
  11. Press Enter to accept the automatically detected hostname, or enter an alternative hostname and press Enter: 
    Host fully qualified DNS name of this server [autodetected hostname]:
  12. Enter the fully qualified domain name of the Manager machine, and then press Enter: 
    Host fully qualified DNS name of the engine server []:
  13. Answer the following questions about the Data Warehouse database and the Reports database: 
    Where is the DWH database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the DWH to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create DWH database, or prefer to perform that manually? (Automatic, Manual) [Automatic]: 
Where is the Reports database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the Reports to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create Reports database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
    Press Enter to choose the highlighted defaults, or type your alternative preference and then press Enter. If you select Remote, you are prompted to provide details about each remote database host.
  14. Enter the fully qualified domain name and password for the Manager database machine. Press Enter to accept the default values in each other field: 
    Engine database host []: engine-db-fqdn
Engine database port [5432]: 
Engine database secured connection (Yes, No) [No]: 
Engine database name [engine]: 
Engine database user [engine]: 
Engine database password: password
  15. Press Enter to allow setup to sign the Reports certificate and Apache certificate on the Manager via SSH: 
    Setup will need to do some actions on the remote engine server. Either automatically, using ssh as root to access it, or you will be prompted to manually perform each such action.
Please choose one of the following:
1 - Access remote engine server using ssh as root
2 - Perform each action manually, use files to copy content around
(1, 2) [1]:
  16. Press Enter to accept the default SSH port, or enter an alternative port number and then press Enter: 
    ssh port on remote engine server [22]:
  17. Enter the root password for the Manager machine: 
    root password on remote engine server manager-fqdn.com:
  18. Press Enter to allow automatic configuration of SSL on Apache: 
    Setup can configure apache to use SSL using a certificate issued from the internal CA.
Do you wish Setup to configure that, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
  19. Set a password for the Reports administrative users (admin and superuser). Note that the reports system maintains its own set of credentials that are separate to those used for the Manager: 
    Reports power users password:
    You are prompted to enter the password a second time to confirm it.
  20. Confirm your installation settings: 
    Please confirm installation settings (OK, Cancel) [OK]:
Next Steps

Access the Reports Portal at http://demo.redhat.com/ovirt-engine-reports, replacing demo.redhat.com with the fully qualified domain name of the Manager. If during the Manager installation you selected a non-default HTTP port then append :port to the URL, replacing :port with the port that you chose.

Log in using the user name admin and the password you set during reports installation. Note that the first time you log in to Red Hat Enterprise Virtualization Manager Reports, a number of web pages are generated and, as a result, your initial attempt to log in may take some time to complete.

5.3.3. Installing and Configuring Data Warehouse and Reports on Separate Machines

Overview

Install and configure Data Warehouse on a separate host from that on which the Red Hat Enterprise Virtualization Manager is installed, then install and configure Red Hat Enterprise Virtualization Manager Reports on a third machine. Hosting the Data Warehouse and Reports services on separate machines helps to reduce the load on the Manager machine. Separating Data Warehouse and Reports onto individual machines further reduces the demand each service places on its host machine, and avoids any conflicts caused by sharing CPU and memory with other processes.

Installing this scenario involves two key steps:
  1. Install and configure Data Warehouse on a separate machine.
  2. Install and configure Reports on a separate machine.
Prerequisites

Ensure that you have completed the following prerequisites:

  1. You must have installed and configured the Manager on a separate machine.
  2. To set up the Data Warehouse machine, you must have the following:
    • A virtual or physical machine with Red Hat Enterprise Linux 6.6 or later versions of Red Hat Enterprise Linux 6 installed.
    • A subscription to the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization subscription pools.
    • The password from the Manager's /etc/ovirt-engine/engine.conf.d/10-setup-database.conf file.
    • Allowed access from the Data Warehouse machine to the Manager database machine's TCP port 5432.
  3. To set up the Reports machine, you must have the following:
    • A virtual or physical machine with Red Hat Enterprise Linux 6.6 or later versions of Red Hat Enterprise Linux 6 installed.
    • A subscription to the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization subscription pools.
    • The password from the Data Warehouse machine's /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf file.
    • Allowed access from the Reports machine to the Manager database machine's TCP port 5432.
  4. If you choose to use a remote Data Warehouse database or Reports database, you must set up each database before installing the Data Warehouse and Reports services. You must have the following information about each database host:
    • The fully qualified domain name of the host
    • The port through which the database can be reached (5432 by default)
    • The database name
    • The database user
    • The database password

Procedure 5.3. Step 1: Installing and Configuring Data Warehouse on a Separate Machine

  1. Register your system with the Content Delivery Network, entering your Customer Portal user name and password when prompted: 
    # subscription-manager register
  2. Find the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization subscription pools and note down the pool IDs. 
    # subscription-manager list --available
  3. Use the pool IDs located in the previous step to attach the entitlements to the system: 
    # subscription-manager attach --pool=pool_id
  4. Disable all existing repositories: 
    # subscription-manager repos --disable=*
  5. Enable the required repositories: 
    # subscription-manager repos --enable=rhel-6-server-rpms
# subscription-manager repos --enable=rhel-6-server-supplementary-rpms
# subscription-manager repos --enable=rhel-6-server-rhevm-3.6-rpms
# subscription-manager repos --enable=jb-eap-6-for-rhel-6-server-rpms
  6. Ensure that all packages currently installed are up to date: 
    # yum update
  7. Install the rhevm-dwh-setup package: 
    # yum install rhevm-dwh-setup
  8. Run the engine-setup command to begin configuration of Data Warehouse on the machine: 
    # engine-setup
  9. Press Enter to configure Data Warehouse: 
    Configure Data Warehouse on this host (Yes, No) [Yes]:
  10. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings: 
    Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:
    If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.
  11. Press Enter to accept the automatically detected hostname, or enter an alternative hostname and press Enter: 
    Host fully qualified DNS name of this server [autodetected host name]:
  12. Answer the following questions about the Data Warehouse database: 
    Where is the DWH database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the DWH to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create DWH database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
    Press Enter to choose the highlighted defaults, or type your alternative preference and then press Enter. If you select Remote, you are prompted to provide details about the remote database host.
  13. Enter the fully qualified domain name and password for the Manager database machine. Press Enter to accept the default values in each other field: 
    Engine database host []: engine-db-fqdn
Engine database port [5432]: 
Engine database secured connection (Yes, No) [No]: 
Engine database name [engine]: 
Engine database user [engine]: 
Engine database password: password
  14. Confirm your installation settings: 
    Please confirm installation settings (OK, Cancel) [OK]:

Procedure 5.4. Step 2: Installing and Configuring Reports on a Separate Machine

  1. Register your system with the Content Delivery Network, entering your Customer Portal user name and password when prompted: 
    # subscription-manager register
  2. Find subscription pools containing the repositories required to install Reports: 
    # subscription-manager list --available | grep -A8 "Red Hat Enterprise Linux Server"
# subscription-manager list --available | grep -A8 "Red Hat Enterprise Virtualization"
  3. Use the pool identifiers located in the previous step to attach the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization entitlements to the system: 
    # subscription-manager attach --pool=pool_id
  4. Disable all existing repositories: 
    # subscription-manager repos --disable=*
  5. Enable the required repositories: 
    # subscription-manager repos --enable=rhel-6-server-rpms
# subscription-manager repos --enable=rhel-6-server-supplementary-rpms
# subscription-manager repos --enable=rhel-6-server-rhevm-3.6-rpms
# subscription-manager repos --enable=jb-eap-6-for-rhel-6-server-rpms
  6. Ensure that all packages currently installed are up to date: 
    # yum update
  7. Install the rhevm-reports-setup package: 
    # yum install rhevm-reports-setup
  8. Run the engine-setup command to begin configuration of Reports on the machine: 
    # engine-setup
  9. Press Enter to configure Reports: 
    Configure Reports on this host (Yes, No) [Yes]:
  10. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings: 
    Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:
    If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.
  11. Press Enter to accept the automatically detected hostname, or enter an alternative hostname and press Enter: 
    Host fully qualified DNS name of this server [autodetected host name]:
  12. Enter the fully qualified domain name of the Manager machine, and then press Enter: 
    Host fully qualified DNS name of the engine server []:
  13. Answer the following questions about the Reports database: 
    Where is the Reports database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the Reports to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create Reports database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
    Press Enter to choose the highlighted defaults, or type your alternative preference and then press Enter. If you select Remote, you are prompted to provide details about the remote database host.
  14. Enter the fully qualified domain name and password for your Data Warehouse database host. Press Enter to accept the default values in each other field: 
    DWH database host []: dwh-db-fqdn
DWH database port [5432]: 
DWH database secured connection (Yes, No) [No]: 
DWH database name [ovirt_engine_history]: 
DWH database user [ovirt_engine_history]: 
DWH database password: password
  15. Press Enter to allow setup to sign the Reports certificate and Apache certificate on the Manager via SSH: 
    Setup will need to do some actions on the remote engine server. Either automatically, using ssh as root to access it, or you will be prompted to manually perform each such action.
Please choose one of the following:
1 - Access remote engine server using ssh as root
2 - Perform each action manually, use files to copy content around
(1, 2) [1]:
  16. Press Enter to accept the default SSH port, or enter an alternative port number and then press Enter: 
    ssh port on remote engine server [22]:
  17. Enter the root password for the Manager machine: 
    root password on remote engine server manager-fqdn.com:
  18. Press Enter to allow automatic configuration of SSL on Apache: 
    Setup can configure apache to use SSL using a certificate issued from the internal CA.
Do you wish Setup to configure that, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
  19. Set a password for the Reports administrative users (admin and superuser). Note that the reports system maintains its own set of credentials that are separate to those used for the Manager: 
    Reports power users password:
    You are prompted to enter the password a second time to confirm it.
  20. Confirm your installation settings: 
    Please confirm installation settings (OK, Cancel) [OK]:
Next Steps

Access the Reports Portal at http://demo.redhat.com/ovirt-engine-reports, replacing demo.redhat.com with the fully qualified domain name of the Manager. If during the Manager installation you selected a non-default HTTP port then append :port to the URL, replacing :port with the port that you chose.

Log in using the user name admin and the password you set during reports installation. Note that the first time you log in to Red Hat Enterprise Virtualization Manager Reports, a number of web pages are generated and, as a result, your initial attempt to log in may take some time to complete.

5.3.4. Installing and Configuring Data Warehouse on the Red Hat Enterprise Virtualization Manager and Reports on a Separate Machine

Overview

Install and configure Data Warehouse on the same system as the Red Hat Enterprise Virtualization Manager, then install and configure Red Hat Enterprise Virtualization Manager Reports on a separate machine. Hosting the Reports service on a separate machine helps to reduce the load on the Manager machine.

Installing this scenario involves two key steps:
  1. Install and configure Data Warehouse on the Manager machine.
  2. Install and configure Reports on a separate machine.
Prerequisites

Ensure that you have completed the following prerequisites:

  1. You must have installed and configured the Manager on one machine. This is the machine on which you are installing Data Warehouse.
  2. To set up the Reports machine, you must have the following:
    • A virtual or physical machine with Red Hat Enterprise Linux 6.6 or later versions of Red Hat Enterprise Linux 6 installed.
    • A subscription to the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization entitlement pools.
    • The password from the Data Warehouse machine's /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf file.
    • Allowed access from the Reports machine to the Manager database machine's TCP port 5432.
  3. If you choose to use a remote Data Warehouse database or Reports database, you must set up each database before installing the Data Warehouse and Reports services. You must have the following information about each database host:
    • The fully qualified domain name of the host
    • The port through which the database can be reached (5432 by default)
    • The database name
    • The database user
    • The database password
  4. If you are using the self-hosted engine, you must move it to maintenance mode: 
    # hosted-engine --set-maintenance --mode=global

Procedure 5.5. Step 1: Installing and Configuring Data Warehouse on the Manager Machine

  1. Install the rhevm-dwh package: 
    # yum install rhevm-dwh
  2. Run the engine-setup command to begin configuration of Data Warehouse on the machine: 
    # engine-setup
  3. Press Enter to configure Data Warehouse: 
    Configure Data Warehouse on this host (Yes, No) [Yes]:
  4. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings: 
    Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:
    If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.
  5. Answer the following questions about the Data Warehouse database: 
    Where is the DWH database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the DWH to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create DWH database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
    Press Enter to choose the highlighted defaults, or type your alternative preference and then press Enter. If you select Remote, you are prompted to provide details about the remote database host.
  6. For the configuration to take effect, the ovirt-engine service must be restarted. The engine-setup command prompts you: 
    During execution engine service will be stopped (OK, Cancel) [OK]:
    Press Enter to proceed. The ovirt-engine service restarts automatically later in the command.
  7. Confirm your installation settings: 
    Please confirm installation settings (OK, Cancel) [OK]:

Procedure 5.6. Step 2: Installing and Configuring Reports on a Separate Machine

  1. Register your system with the Content Delivery Network, entering your Customer Portal user name and password when prompted: 
    # subscription-manager register
  2. Find the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization subscription pools and note down the pool IDs. 
    # subscription-manager list --available
  3. Use the pool IDs located in the previous step to attach the entitlements to the system: 
    # subscription-manager attach --pool=pool_id
  4. Disable all existing repositories: 
    # subscription-manager repos --disable=*
  5. Enable the required channels: 
    # subscription-manager repos --enable=rhel-6-server-rpms
# subscription-manager repos --enable=rhel-6-server-supplementary-rpms
# subscription-manager repos --enable=rhel-6-server-rhevm-3.6-rpms
# subscription-manager repos --enable=jb-eap-6-for-rhel-6-server-rpms
  6. Ensure that all packages currently installed are up to date: 
    # yum update
  7. Install the rhevm-reports-setup package: 
    # yum install rhevm-reports-setup
  8. Run the engine-setup command to begin configuration of Reports on the machine: 
    # engine-setup
  9. Press Enter to configure Reports: 
    Configure Reports on this host (Yes, No) [Yes]:
  10. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings: 
    Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:
    If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.
  11. Press Enter to accept the automatically detected hostname, or enter an alternative hostname and press Enter: 
    Host fully qualified DNS name of this server [autodetected host name]:
  12. Enter the fully qualified domain name of the Manager machine, and then press Enter: 
    Host fully qualified DNS name of the engine server []:
  13. Answer the following questions about the Reports database: 
    Where is the Reports database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the Reports to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create Reports database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
    Press Enter to choose the highlighted defaults, or type your alternative preference and then press Enter. If you select Remote, you are prompted to provide details about the remote database host.
  14. Enter the fully qualified domain name and password for your Data Warehouse database host. Press Enter to accept the default values in each other field: 
    DWH database host []: dwh-db-fqdn
DWH database port [5432]: 
DWH database secured connection (Yes, No) [No]: 
DWH database name [ovirt_engine_history]: 
DWH database user [ovirt_engine_history]: 
DWH database password: password
  15. Press Enter to allow setup to sign the Reports certificate and Apache certificate on the Manager via SSH: 
    Setup will need to do some actions on the remote engine server. Either automatically, using ssh as root to access it, or you will be prompted to manually perform each such action.
Please choose one of the following:
1 - Access remote engine server using ssh as root
2 - Perform each action manually, use files to copy content around
(1, 2) [1]:
  16. Press Enter to accept the default SSH port, or enter an alternative port number and then press Enter: 
    ssh port on remote engine server [22]:
  17. Enter the root password for the Manager machine: 
    root password on remote engine server manager-fqdn.com:
  18. Press Enter to allow automatic configuration of SSL on Apache: 
    Setup can configure apache to use SSL using a certificate issued from the internal CA.
Do you wish Setup to configure that, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
  19. Set a password for the Reports administrative users (admin and superuser). Note that the reports system maintains its own set of credentials that are separate to those used for the Manager: 
    Reports power users password:
    You are prompted to enter the password a second time to confirm it.
  20. Confirm your installation settings: 
    Please confirm installation settings (OK, Cancel) [OK]:
Next Steps

Access the Reports Portal at http://demo.redhat.com/ovirt-engine-reports, replacing demo.redhat.com with the fully qualified domain name of the Manager. If during the Manager installation you selected a non-default HTTP port then append :port to the URL, replacing :port with the port that you chose.

Log in using the user name admin and the password you set during reports installation. Note that the first time you log in to Red Hat Enterprise Virtualization Manager Reports, a number of web pages are generated and, as a result, your initial attempt to log in may take some time to complete.

5.3.5. Installing and Configuring Data Warehouse on a Separate Machine and Reports on the Red Hat Enterprise Virtualization Manager

Overview

Install and configure Data Warehouse on a separate host from that on which the Red Hat Enterprise Virtualization Manager is installed, then install and configure Red Hat Enterprise Virtualization Manager Reports on the Manager machine. Hosting the Data Warehouse service on a separate machine helps to reduce the load on the Manager machine. Note that hosting the Manager and Reports on the same machine means that these processes will share CPU and memory.

Installing this scenario involves two key steps:
  1. Install and configure Data Warehouse on a separate machine.
  2. Install and configure Reports on the Manager machine.
Prerequisites

Ensure that you have completed the following prerequisites:

  1. You must have installed and configured the Manager on a separate machine.
  2. To set up the Data Warehouse machine, you must have the following:
    • A virtual or physical machine with Red Hat Enterprise Linux 6.6 or later versions of Red Hat Enterprise Linux 6 installed.
    • A subscription to the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization entitlement pools.
    • The password from the Manager's /etc/ovirt-engine/engine.conf.d/10-setup-database.conf file.
    • Allowed access from the Data Warehouse machine to the Manager database machine's TCP port 5432.
  3. To set up the Reports machine, you must have the following:
    • The password from the Data Warehouse machine's /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf file.
  4. If you choose to use a remote Data Warehouse database or Reports database, you must set up each database before installing the Data Warehouse and Reports services. You must have the following information about each database host:
    • The fully qualified domain name of the host
    • The port through which the database can be reached (5432 by default)
    • The database name
    • The database user
    • The database password
  5. If you are using the self-hosted engine, you must move it to maintenance mode: 
    # hosted-engine --set-maintenance --mode=global

Procedure 5.7. Step 1: Installing and Configuring Data Warehouse on a Separate Machine

  1. Register your system with the Content Delivery Network, entering your Customer Portal user name and password when prompted: 
    # subscription-manager register
  2. Find the Red Hat Enterprise Linux Server and Red Hat Enterprise Virtualization subscription pools and note down the pool IDs. 
    # subscription-manager list --available
  3. Use the pool IDs located in the previous step to attach the entitlements to the system: 
    # subscription-manager attach --pool=pool_id
  4. Disable all existing repositories: 
    # subscription-manager repos --disable=*
  5. Enable the required channels: 
    # subscription-manager repos --enable=rhel-6-server-rpms
# subscription-manager repos --enable=rhel-6-server-supplementary-rpms
# subscription-manager repos --enable=rhel-6-server-rhevm-3.6-rpms
# subscription-manager repos --enable=jb-eap-6-for-rhel-6-server-rpms
  6. Ensure that all packages currently installed are up to date: 
    # yum update
  7. Install the rhevm-dwh-setup package: 
    # yum install rhevm-dwh-setup
  8. Run the engine-setup command to begin configuration of Data Warehouse on the machine: 
    # engine-setup
  9. Press Enter to configure Data Warehouse: 
    Configure Data Warehouse on this host (Yes, No) [Yes]:
  10. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings: 
    Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:
    If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.
  11. Press Enter to accept the automatically detected hostname, or enter an alternative hostname and press Enter: 
    Host fully qualified DNS name of this server [autodetected host name]:
  12. Answer the following questions about the Data Warehouse database: 
    Where is the DWH database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the DWH to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create DWH database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
    Press Enter to choose the highlighted defaults, or type your alternative preference and then press Enter. If you select Remote, you are prompted to provide details about the remote database host.
  13. Enter the fully qualified domain name and password for the Manager database machine. Press Enter to accept the default values in each other field: 
    Engine database host []: engine-db-fqdn
Engine database port [5432]: 
Engine database secured connection (Yes, No) [No]: 
Engine database name [engine]: 
Engine database user [engine]: 
Engine database password: password
  14. Confirm your installation settings: 
    Please confirm installation settings (OK, Cancel) [OK]:

Procedure 5.8. Step 2: Installing and Configuring Reports on the Manager Machine

  1. Install the rhevm-reports package: 
    # yum install rhevm-reports
  2. Run the engine-setup command to begin configuration of Reports on the machine: 
    # engine-setup
  3. Press Enter to configure Reports: 
    Configure Reports on this host (Yes, No) [Yes]:
  4. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings: 
    Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:
    If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.
  5. Answer the following questions about the Reports database: 
    Where is the Reports database located? (Local, Remote) [Local]: 
Setup can configure the local postgresql server automatically for the Reports to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create Reports database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
    Press Enter to choose the highlighted defaults, or type your alternative preference and then press Enter. If you select Remote, you are prompted to provide details about the remote database host.
  6. Enter the fully qualified domain name and password for your Data Warehouse database host. Press Enter to accept the default values in each other field: 
    DWH database host []: dwh-db-fqdn
DWH database port [5432]: 
DWH database secured connection (Yes, No) [No]: 
DWH database name [ovirt_engine_history]: 
DWH database user [ovirt_engine_history]: 
DWH database password: password
  7. Set a password for the Reports administrative users (admin and superuser). Note that the reports system maintains its own set of credentials that are separate to those used for the Manager: 
    Reports power users password:
    You are prompted to enter the password a second time to confirm it.
  8. For the configuration to take effect, the ovirt-engine service must be restarted. The engine-setup command prompts you: 
    During execution engine service will be stopped (OK, Cancel) [OK]:
    Press Enter to proceed. The ovirt-engine service restarts automatically later in the command.
  9. Confirm your installation settings: 
    Please confirm installation settings (OK, Cancel) [OK]:
Next Steps

Access the Reports Portal at http://demo.redhat.com/ovirt-engine-reports, replacing demo.redhat.com with the fully qualified domain name of the Manager. If during the Manager installation you selected a non-default HTTP port then append :port to the URL, replacing :port with the port that you chose.

Log in using the user name admin and the password you set during reports installation. Note that the first time you log in to Red Hat Enterprise Virtualization Manager Reports, a number of web pages are generated and, as a result, your initial attempt to log in may take some time to complete.