Hi David, Taken from [1], for setting the password for the engine user. su - postgres psql postgres=# create role engine with login encrypted password 'password';
You can set the password for the postgres with 'sudo passwd postgres' (Alghout the password should be postgres) For unlocking the disk, follow the example here [2] $ PGPASSWORD=xxxxxx ./unlock_entity.sh -t disk -q [1] https://www.ovirt.org/develop/Using-oVirt-Engine-with-a-PostgreSQL-container.html [2] https://www.ovirt.org/develop/developer-guide/db-issues/helperutilities.html *Regards,* *Shani Leviim* On Thu, Oct 14, 2021 at 12:45 PM David White via Users <[email protected]> wrote: > I am trying to put a host into maintenance mode, and keep getting this > error: > > Error while executing action: Cannot switch Host > cha1-storage.my-domain.com to Maintenance mode. Image transfer is in > progress for the following (3) disks: > > e0f46dc5-7f98-47cf-a586-4645177bd6a2, > 06bd3678-bfab-4793-a839-ec8cad4b96e5, > 13cef086-3878-463b-a224-cc42b44d8468 > > Reviewing documentation online, it seems I need to do this: > PGPASSWORD=pass /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh > -t disk e0f46dc5-7f98-47cf-a586-4645177bd6a2 > PGPASSWORD=pass /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh > -t disk 06bd3678-bfab-4793-a839-ec8cad4b96e5 > PGPASSWORD=pass /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh > -t disk 13cef086-3878-463b-a224-cc42b44d8468 > /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -R > > When I run those commands, it *seems* to run successfully. > However, I don't think that I have the correct password, because I cannot > get a psql interface: > > [root@ovirt-engine1 ovirt-engine]# psql -U admin -h localhost -p 5432 > psql: error: FATAL: Ident authentication failed for user "admin" > [root@ovirt-engine1 ovirt-engine]# psql -U admin -W -h localhost -p 5432 > Password: > psql: error: FATAL: Ident authentication failed for user "admin" > [root@ovirt-engine1 ovirt-engine]# psql -U engine -h localhost -p 5432 > Password for user engine: > > Checking > https://www.ovirt.org/develop/developer-guide/db-issues/postgresql-changing-db-pass.html, > I tried: > [root@ovirt-engine1 ovirt-engine]# read PASSWD > /etc/pki/ovirt-engine/encryptpasswd.sh > [root@ovirt-engine1 ovirt-engine]# cat > /etc/pki/ovirt-engine/encryptpasswd.sh $PASSWD > cat: /etc/pki/ovirt-engine/encryptpasswd.sh: No such file or directory > cat: /etc/pki/ovirt-engine/encryptpasswd.sh: No such file or directory > > I must be doing something wrong here. > > 1) How can I reset the Postgres password? What user should I be using? > 2) Once I have the correct password, will the commands I provided earlier > work to unlock the disk? > > Sent with ProtonMail <https://protonmail.com/> Secure Email. > > _______________________________________________ > Users mailing list -- [email protected] > To unsubscribe send an email to [email protected] > Privacy Statement: https://www.ovirt.org/privacy-policy.html > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/[email protected]/message/AO3JBKZZDMTNTRD7GYLUKV7VG6OMVY5G/ >
_______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/[email protected]/message/W7ULHHPWM2H6PQO6E4ZZIB3G65UUO6VA/
