This post illustrates steps to change the engine database password for the OLVM engine.
1. Before modification, you can run below commands to check the current ENGINE_DB_PASSWORD for OLVM engine interacting with the engine database. By default, ENGINE_DB_PASSWORD is a random string which is auto-generated by engine-config during the setup process. The ENGINE_DB_PASSWORD is used by below files:
# cat /etc/ovirt-engine/engine.conf.d/10-setup-database.conf | grep "ENGINE_DB_PASSWORD" ENGINE_DB_PASSWORD="xxxxxxxx"
# cat /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf |grep "ENGINE_DB_PASSWORD" ENGINE_DB_PASSWORD="xxxxxxxx"
# cat /etc/ovirt-engine/aaa/internal.properties |grep dbpassword config.datasource.dbpassword=xxxxxxxx
2. Follow below steps to change engine database password:
. Stop the ovirt-engine process:
# systemctl stop ovirt-engine
. Stop oVirt Engine Data Warehouse service:
# systemctl stop ovirt-engine-dwhd
. Change the credentials that the engine process sends to the database by modifying ENGINE_DB_PASSWORD with the new password:
# vi /etc/ovirt-engine/engine.conf.d/10-setup-database.conf ENGINE_DB_PASSWORD="YourNewPassword"
# vi /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf ENGINE_DB_PASSWORD="YourNewPassword"
. Change internal domain dbpassword:
# vi /etc/ovirt-engine/aaa/internal.properties config.datasource.dbpassword=YourNewPassword
. Change the postgres database credentials:
By default, the name of the user in ENGINE_DB_USER and database in ENGINE_DB_DATABASE are both “engine“:
# cat /etc/ovirt-engine/engine.conf.d/10-setup-database.conf ENGINE_DB_HOST="localhost" ENGINE_DB_PORT="5432" ENGINE_DB_USER="engine" ENGINE_DB_DATABASE="engine"
Connect to the ‘postgres’ database to alter the engine db user and postgres passwords:
# su - postgres Last login: Thu Apr 30 15:29:48 AEST 2020 on pts/1 -bash-4.2$ scl enable rh-postgresql95 -- psql psql (9.5.14) Type "help" for help. postgres=# alter user engine with password 'YourNewPassword'; ALTER ROLE postgres-# alter user postgres with password 'YourNewPassword'; ALTER ROLE postgres=# \q -bash-4.2$ exit logout
. Start ovirt-engine and Data Warehouse service to take effect:
# systemctl start ovirt-engine # systemctl start ovirt-engine-dwhd
Now you can use now use the new credentials to access the engine database.