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/WZRDGSC5LUWT5ULFQXYZZESQJM5F4ZJB/
