3:32 a.m.
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 <sleviim(a)redhat.com>
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-contai...
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
<users(a)ovirt.org> 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/postgres...,
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 -- users(a)ovirt.org
>
> To unsubscribe send an email to users-leave(a)ovirt.org
>
> Privacy Statement: https://www.ovirt.org/privacy-policy.html
>
> oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
>
