Procedure 5.1. Installing and Configuring the History Database

1. Install the rhevm-dwh package. This package must be installed on the system on which the Red Hat Enterprise Virtualization Manager is installed.

   # yum install rhevm-dwh

2. Once the required packages have been downloaded, they are listed for review. You will be prompted to confirm continuing with the installation. Upon confirmation, the packages are installed. However, some further configuration is required before the reports functionality can be used.
3. Configure the history database. Use the rhevm-dwh-setup command to configure the Extract, Transform, Load (ETL) process and database scripts used to create and maintain a working history database.
   1. Run the rhevm-dwh-setup command on the system hosting the Red Hat Enterprise Virtualization Manager:

      # rhevm-dwh-setup

   2. For the history database installation to take effect, the ovirt-engine service must be restarted. The rhevm-dwh-setup command prompts you:

      In order to proceed the installer must stop the ovirt-engine service
      Would you like to stop the ovirt-engine service? (yes|no):

      Type yes and then press Enter to proceed.
   3. The rhevm-dwh-setup utility can optionally create a read-only user to allow remote access to the history database.

      This utility can configure a read only user for DB access. Would you like to do so? (yes|no):
      Provide a username for read-only user:
      Provide a password for read-only user:

      If you choose to create a read-only user, the rhevm-dwh-setup utility automatically opens the required firewall ports and configures the database to listen on externally facing network interface devices.

      Note

      The rhevm-dwh-setup utility can configure read-only access to local databases only. If you chose to use a remote database during engine-setup, you have to manually configure read-only access to the history database. See Connecting to the History Database in the Red Hat Enterprise Virtualization Administration Guide.
   4. The rhevm-dwh-setup utility can optionally configure the history database to use secure connections

      Should postgresql be setup with secure connection? (yes|no):

      The command then creates and configures the ovirt_engine_history database and starts the ovirt-engine service.