Description of problem: Running the script /usr/share/ovirt-engine/setup/dbutils/validatedb.sh fails because it cannot find the psql binary, as it has to use the software collection. Version-Release number of selected component (if applicable): ovirt-engine-setup-plugin-ovirt-engine-4.3.9.4-11.el7.noarch How reproducible: Always Steps to Reproduce: 1. Run the script in the manager: ~~~ # . /etc/ovirt-engine/engine.conf.d/10-setup-database.conf # export PGPASSWORD=$ENGINE_DB_PASSWORD # cd /usr/share/ovirt-engine/setup/dbutils # ./validatedb.sh --user=engine --database=engine ~~~ Actual results: ~~~ ./dbfunc-base.sh: line 34: psql: command not found FATAL: Cannot execute sql command: --file=./fkvalidator_sp.sql ./dbfunc-base.sh: line 34: psql: command not found FATAL: Cannot execute sql command: --file=./fkvalidator_sp_drop.sql ~~~ Expected results: Additional info:
Running it with the correct scl works, but I'm not sure if the psql detection logic should do that automatically. # . /etc/ovirt-engine/engine.conf.d/10-setup-database.conf # scl enable rh-postgresql10 "PGPASSWORD=$ENGINE_DB_PASSWORD /usr/share/ovirt-engine/setup/dbutils/validatedb.sh --user=engine --database=engine"
script ran without any psql error verified in ovirt-engine-4.3.11.2-0.1.el7.noarch
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Red Hat Virtualization Engine security, bug fix 4.3.11), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2020:4112