This post illustrates steps to change engine database password for RHVM engine.

1. Before modification, you can run below commands to check the current ENGINE_DB_PASSWORD for RHEVM 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:

[[email protected] ~]# cat /etc/ovirt-engine/engine.conf.d/10-setup-database.conf |grep "ENGINE_DB_PASSWORD"
ENGINE_DB_PASSWORD="xxxxxxxx"  

[[email protected] ~]# cat /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf |grep "ENGINE_DB_PASSWORD"
ENGINE_DB_PASSWORD="xxxxxxxx"

[[email protected] ~]# cat /etc/ovirt-engine/aaa/internal.properties |grep dbpassword
config.datasource.dbpassword=xxxxxxxx

2. Follow below steps to change engine database password:

a. Stop the ovirt-engine process:

[[email protected] ~]# systemctl stop ovirt-engine

b. Stop oVirt Engine Data Warehouse service:

[[email protected] ~]# systemctl stop ovirt-engine-dwhd

c. Change the credentials that the engine process sends to the database by modifying ENGINE_DB_PASSWORD with the new password:

[[email protected] ~]# vi /etc/ovirt-engine/engine.conf.d/10-setup-database.conf
ENGINE_DB_PASSWORD="YourNewPassword"  

[[email protected] ~]# vi /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf
ENGINE_DB_PASSWORD="YourNewPassword"

d. Change internal domain dbpassword:

[[email protected] ~]# vi /etc/ovirt-engine/aaa/internal.properties

config.datasource.dbpassword=YourNewPassword

e. 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”:

[[email protected] ~]# 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:

[[email protected] ~]# 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

f. Start ovirt-engine and Data Warehouse service to take effect:

[[email protected] ~]# systemctl start ovirt-engine
[[email protected] ~]# systemctl start ovirt-engine-dwhd

Now you can use now use the new credentials to access the engine database.