9:15 a.m.
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...
[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 <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/postgresql-changi...,
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 -- 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/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/AO3JBKZZDMT...