Appendix C. Migrating Databases and Services to a Remote Server

Procedure

1. Register your system with the Content Delivery Network, entering your Customer Portal user name and password when prompted:

   Copy to Clipboard Toggle word wrap

   # subscription-manager register

   Note

   If you are using an IPv6 network, use an IPv6 transition mechanism to access the Content Delivery Network and subscription manager.

2. Find the Red Hat Virtualization Manager subscription pool and record the pool ID:

   Copy to Clipboard Toggle word wrap

   # subscription-manager list --available

3. Use the pool ID to attach the subscription to the system:

   Copy to Clipboard Toggle word wrap

   # subscription-manager attach --pool=pool_id

   Note

   To view currently attached subscriptions:

   Copy to Clipboard Toggle word wrap

   # subscription-manager list --consumed

   To list all enabled repositories:

   Copy to Clipboard Toggle word wrap

   # dnf repolist

4. Configure the repositories:

   Copy to Clipboard Toggle word wrap

   # subscription-manager repos \
       --disable='*' \
       --enable=rhel-8-for-x86_64-baseos-eus-rpms \
       --enable=rhel-8-for-x86_64-appstream-eus-rpms \
       --enable=rhv-4.4-manager-for-rhel-8-x86_64-rpms \
       --enable=fast-datapath-for-rhel-8-x86_64-rpms \
       --enable=jb-eap-7.4-for-rhel-8-x86_64-rpms \
       --enable=openstack-16.2-cinderlib-for-rhel-8-x86_64-rpms \
       --enable=rhceph-4-tools-for-rhel-8-x86_64-rpms \
       --enable=rhel-8-for-x86_64-appstream-tus-rpms \
       --enable=rhel-8-for-x86_64-baseos-tus-rpms

5. Set the RHEL version to 8.6:

   Copy to Clipboard Toggle word wrap

   # subscription-manager release --set=8.6

6. Enable version 12 of the postgresql module.

   Copy to Clipboard Toggle word wrap

   # dnf module -y enable postgresql:12

7. Enable version 14 of the nodejs module:

   Copy to Clipboard Toggle word wrap

   # dnf module -y enable nodejs:14

8. Update the Self-Hosted Engine using the procedure Updating a Self-Hosted Engine in the Upgrade Guide.

Procedure

1. Create a backup of the Data Warehouse database and configuration files on the Manager:

   Copy to Clipboard Toggle word wrap

   # engine-backup --mode=backup --scope=grafanadb --scope=dwhdb --scope=files --file=file_name --log=log_file_name

2. Copy the backup file from the Manager to the new machine:

   Copy to Clipboard Toggle word wrap

   # scp /tmp/file_name root@new.dwh.server.com:/tmp

3. Install engine-backup on the new machine:

   Copy to Clipboard Toggle word wrap

   # dnf install ovirt-engine-tools-backup

4. Install the PostgreSQL server package:

   Copy to Clipboard Toggle word wrap

   # dnf install postgresql-server postgresql-contrib

5. Initialize the PostgreSQL database, start the postgresql service, and ensure that this service starts on boot:

   Copy to Clipboard Toggle word wrap

   # su - postgres -c 'initdb'
   # systemctl enable postgresql
   # systemctl start postgresql

6. Restore the Data Warehouse database on the new machine. file_name is the backup file copied from the Manager.

   Copy to Clipboard Toggle word wrap

   # engine-backup --mode=restore --scope=files --scope=grafanadb --scope=dwhdb --file=file_name --log=log_file_name --provision-dwh-db

   When the --provision-* option is used in restore mode, --restore-permissions is applied by default.

1. Enable the required repositories:

   1. Register your system with the Content Delivery Network, entering your Customer Portal user name and password when prompted:

      Copy to Clipboard Toggle word wrap

      # subscription-manager register

   2. Find the Red Hat Virtualization Manager subscription pool and record the pool ID:

      Copy to Clipboard Toggle word wrap

      # subscription-manager list --available

   3. Use the pool ID to attach the subscription to the system:

      Copy to Clipboard Toggle word wrap

      # subscription-manager attach --pool=pool_id

   4. Configure the repositories:

      Copy to Clipboard Toggle word wrap

      # subscription-manager repos \
          --disable='*' \
          --enable=rhel-8-for-x86_64-baseos-eus-rpms \
          --enable=rhel-8-for-x86_64-appstream-eus-rpms \
          --enable=rhv-4.4-manager-for-rhel-8-x86_64-rpms \
          --enable=fast-datapath-for-rhel-8-x86_64-rpms \
          --enable=jb-eap-7.4-for-rhel-8-x86_64-rpms
      
      # subscription-manager release --set=8.6

2. Enable the pki-deps module.

   Copy to Clipboard Toggle word wrap

   # dnf module -y enable pki-deps

3. Ensure that all packages currently installed are up to date:

   Copy to Clipboard Toggle word wrap

   # dnf upgrade --nobest

4. Install the ovirt-engine-dwh-setup package:

   Copy to Clipboard Toggle word wrap

   # dnf install ovirt-engine-dwh-setup

Procedure

1. Stop the Data Warehouse service:

   Copy to Clipboard Toggle word wrap

   # systemctl stop ovirt-engine-dwhd.service

2. If the database is hosted on a remote machine, you must manually grant access by editing the postgres.conf file. Edit the /var/lib/pgsql/data/postgresql.conf file and modify the listen_addresses line so that it matches the following:

   Copy to Clipboard Toggle word wrap

   listen_addresses = '*'

   If the line does not exist or has been commented out, add it manually.

   If the database is hosted on the Manager machine and was configured during a clean setup of the Red Hat Virtualization Manager, access is granted by default.

3. Restart the postgresql service:

   Copy to Clipboard Toggle word wrap

   # systemctl restart postgresql

1. If you are migrating both the ovirt_engine_history database and the Data Warehouse service to the same machine, run the following, otherwise proceed to the next step.

   Copy to Clipboard Toggle word wrap

   # sed -i '/^ENGINE_DB_/d' \
           /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf
   
   # sed -i \
        -e 's;^\(OVESETUP_ENGINE_CORE/enable=bool\):True;\1:False;' \
        -e '/^OVESETUP_CONFIG\/fqdn/d' \
        /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf

2. Remove the apache/grafana PKI files, so that they are regenerated by engine-setup with correct values:

   Copy to Clipboard Toggle word wrap

   # rm -f \
     /etc/pki/ovirt-engine/certs/apache.cer \
     /etc/pki/ovirt-engine/certs/apache-grafana.cer \
     /etc/pki/ovirt-engine/keys/apache.key.nopass \
     /etc/pki/ovirt-engine/keys/apache-grafana.key.nopass \
     /etc/pki/ovirt-engine/apache-ca.pem \
     /etc/pki/ovirt-engine/apache-grafana-ca.pem

3. Run the engine-setup command to begin configuration of Data Warehouse on the machine:

   Copy to Clipboard Toggle word wrap

   # engine-setup

4. Press Enter to accept the automatically detected host name, or enter an alternative host name and press Enter:

   Copy to Clipboard Toggle word wrap

   Host fully qualified DNS name of this server [autodetected host name]:

5. Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings:

   Copy to Clipboard Toggle word wrap

   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.

6. Enter the fully qualified domain name and password for the Manager. Press Enter to accept the default values in each other field:

   Copy to Clipboard Toggle word wrap

   Host fully qualified DNS name of the engine server []: engine-fqdn
   Setup needs 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]:
   ssh port on remote engine server [22]:
   root password on remote engine server engine-fqdn: password

7. Enter the FQDN and password for the Manager database machine. Press Enter to accept the default values in each other field:

   Copy to Clipboard Toggle word wrap

   Engine database host []: manager-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

8. Confirm your installation settings:

   Copy to Clipboard Toggle word wrap

   Please confirm installation settings (OK, Cancel) [OK]:

Procedure

1. On the Manager machine, restart the Manager:

   Copy to Clipboard Toggle word wrap

   # service ovirt-engine restart

2. Run the following command to modify the file /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf and set the options to False:

   Copy to Clipboard Toggle word wrap

   # sed -i \
        -e 's;^\(OVESETUP_DWH_CORE/enable=bool\):True;\1:False;' \
        -e 's;^\(OVESETUP_DWH_CONFIG/remoteEngineConfigured=bool\):True;\1:False;' \
        /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf
   
   # sed -i \
        -e 's;^\(OVESETUP_GRAFANA_CORE/enable=bool\):True;\1:False;' \
        /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf

3. Disable the Data Warehouse service:

   Copy to Clipboard Toggle word wrap

   # systemctl disable ovirt-engine-dwhd.service

4. Remove the Data Warehouse files:

   Copy to Clipboard Toggle word wrap

   # rm -f /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/*.conf /var/lib/ovirt-engine-dwh/backups/*