
Hi, After deploying hosted engine using the hosted-engine-appliance I need to run the unlock_entity utility on the engine vm to unlock a disk that's stuck. So I ssh on the vm and run: sudo PGPASSWORD=xxxxxxxxx ./unlock_entity.sh -t disk -u engine -q psql: FATAL: password authentication failed for user "engine" FATAL: Cannot execute sql command: --file=./unlock_entity.sql where xxxxxxxxx is the password I supplied for everything during deployment. Does it have a different password that came with the appliance? Is this documented somewhere? Thanks, Adam Verslype

Hi, database configuration is stored in the VM/host where engine is installed in "/etc/ovirt-engine/engine.conf.d/10-setup-database.conf". If you used automatic database setup, then whole db configuration is generated automatically. And please bear in mind that db user password is different from webadmin user (admin@internal) password which you can specify during installation. Martin Perina ----- Original Message -----
From: "Adam Verslype" <verslyap@gmail.com> To: users@ovirt.org Sent: Monday, February 15, 2016 2:50:21 AM Subject: [ovirt-users] Can't fine engine postgres password
Hi,
After deploying hosted engine using the hosted-engine-appliance I need to run the unlock_entity utility on the engine vm to unlock a disk that's stuck. So I ssh on the vm and run:
sudo PGPASSWORD=xxxxxxxxx ./unlock_entity.sh -t disk -u engine -q psql: FATAL: password authentication failed for user "engine" FATAL: Cannot execute sql command: --file=./unlock_entity.sql where xxxxxxxxx is the password I supplied for everything during deployment. Does it have a different password that came with the appliance? Is this documented somewhere?
Thanks,
Adam Verslype
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

I always do: su - postgres psql -U postgres -d engine ----- Original Message -----
From: "Adam Verslype" <verslyap@gmail.com> To: users@ovirt.org Sent: Sunday, February 14, 2016 5:50:21 PM Subject: [ovirt-users] Can't fine engine postgres password
Hi,
After deploying hosted engine using the hosted-engine-appliance I need to run the unlock_entity utility on the engine vm to unlock a disk that's stuck. So I ssh on the vm and run:
sudo PGPASSWORD=xxxxxxxxx ./unlock_entity.sh -t disk -u engine -q psql: FATAL: password authentication failed for user "engine" FATAL: Cannot execute sql command: --file=./unlock_entity.sql where xxxxxxxxx is the password I supplied for everything during deployment. Does it have a different password that came with the appliance? Is this documented somewhere?
Thanks,
Adam Verslype
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (3)
-
Adam Verslype
-
Jason Brooks
-
Martin Perina