This is still an issue. As part of my troubleshooting process, I manually migrated all of the VMs off of this host. When I still couldn't put it into maintenance mode, I manually ran "yum update" from the command line, and then rebooted it.
The oVirt UI detected that it was down, and marked it as "Unavailable" for a while, but once the host came back up, everything was marked green again, and the host is a useful part of the cluster. Unfortunately, I still cannot put it into maintenance mode because oVirt still thinks these disks are locked. Sent with ProtonMail Secure Email. ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Friday, October 15th, 2021 at 4:32 AM, David White via Users <[email protected]> wrote: > Thank you very much. > I was able to (re)set the `engine` user's password in Postgres. > Unfortunately, I'm still having trouble unlocking the disks. > > The following command produces no output underneath "Locked disks" when I run > this command on the hosted engine VM: > > [root@ovirt-engine1 dwhite]# PGPASSWORD=snip > /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t disk -qLocked disks > > However, in the oVirt UI, when I try to put the host into maintenance mode I > continue to get the message that there are (3) locked disks (screenshot > below). > [Screenshot from 2021-10-15 04-29-15.png] > > I've tried the following multiple times: > > PGPASSWORD=snip /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t > disk > e0f46dc5-7f98-47cf-a586-4645177bd6a2##########################################CAUTION, > this operation may lead to data corruption and should be used with care. > Please contact support prior to running this > command##########################################Are you sure you want to > proceed? [y/n]yselect > fn_db_unlock_disk('e0f46dc5-7f98-47cf-a586-4645177bd6a2');INSERT 0 1unlock > disk e0f46dc5-7f98-47cf-a586-4645177bd6a2 completed successfully. > > Any other ideas? > > Sent with ProtonMail Secure Email. > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > > On Thursday, October 14th, 2021 at 10:15 AM, Shani Leviim > <[email protected]> wrote: > > > 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 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/
publickey - [email protected] - 0x320CD582.asc
Description: application/pgp-keys
signature.asc
Description: OpenPGP digital signature
_______________________________________________ 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/4CUOM4K4EUKT5XUR2AW35ZCI3XKVU5TL/
