[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-27 Thread David White via Users
Still banging my head against the wall on this. The point I'm trying to make here is that when the password is wrong, or when I don't enter the password, I get a clear message saying that the access was denied. curl -u 'admin@internal'@'PASS' -X POST

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-23 Thread Strahil Nikolov via Users
That's why I put the user and the pass in single quotes... Like this: 'user@domain'@'pass' Best Regards,Strahil Nikolov On Thu, Oct 21, 2021 at 23:47, David White via Users wrote: ___ Users mailing list -- users@ovirt.org To unsubscribe send an

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-21 Thread David White via Users
When I tried with admin@internal@password, I got prompted for a password. So then, I tried admin@internal without the password, and I got prompted for the password. $ curl -u admin@internal@password -X POST

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-20 Thread Strahil Nikolov via Users
Try with curl -u 'admin@internal'@'pass' ... Best Regards,Strahil Nikolov On Thu, Oct 21, 2021 at 2:17, David White via Users wrote: ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-20 Thread David White via Users
Ok, I was able to login to ovirt-engine/api/imagetransfers, and I see the 3 image transfers in here. Thanks for the help on that. Based on the example that I'm pasting below, and based on your last email, I tried to run the following curl command: $ curl -u admin@password -X POST

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-20 Thread Eyal Shenitzky
On Wed, 20 Oct 2021 at 12:36, David White wrote: > Hah. Wow. > Thanks for your patience on this. lol. > > There they are! > I just cross-checked these disk_id's, and can confirm these are the 3 that > continue to show up in the oVirt UI. > > *engine=# SELECT command_id, disk_id, last_updated,

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-20 Thread David White via Users
Hah. Wow.  Thanks for your patience on this. lol. There they are!  I just cross-checked these disk_id's, and can confirm these are the 3 that continue to show up in the oVirt UI. engine=# SELECT command_id, disk_id, last_updated, message, timeout_policy, type, active FROM image_transfers;  

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-20 Thread Eyal Shenitzky
On Tue, 19 Oct 2021 at 23:49, David White via Users wrote: > I missed this email. > > You can check by getting > > https://myengine/ovirt-engine/api/imagetransfers > > If there are no image transfers, check the relevant disks status: > > https://myengine/ovirt-engine/api/disks/{id} > > >

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-20 Thread Eyal Shenitzky
Hi David, Since you tried first to execute the query without semicolon the second attempt to run the query with the semicolon failed. It considers both lines as one query. Try only - SELECT * FROM image_transfers; On Tue, 19 Oct 2021 at 23:32, David White wrote: > I tried that, but whenever

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-19 Thread David White via Users
I missed this email.  > You can check by getting > >    https://myengine/ovirt-engine/api/imagetransfers >   > If there are no image transfers, check the relevant disks status: > >    https://myengine/ovirt-engine/api/disks/{id} Apparently, I don't have credentials to the API. My "admin"

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-19 Thread David White via Users
I tried that, but whenever I use semicolons, I get a syntax error. Here's my full stdout with and without the semicolon:  postgres=# \c engine You are now connected to database "engine" as user "postgres". engine=# SELECT * FROM image_transfers engine-# SELECT * FROM image_transfers; ERROR: 

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-19 Thread Eyal Shenitzky
You are missing ';' at the end of the query. That's why you see no output. On Tue, 19 Oct 2021 at 13:24, David White wrote: > Thank you. > However, that was one of the queries I already tried. > > All of the queries I listed in my previous email returned empty results, > which is why I was

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-19 Thread David White via Users
Thank you. However, that was one of the queries I already tried. All of the queries I listed in my previous email returned empty results, which is why I was confused. Given the name of some of these tables, I expect to see some data in them. I just tried re-running that query, making sure to

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-19 Thread Eyal Shenitzky
Please try the following query and share the output - SELECT * FROM image_transfers; On Tue, 19 Oct 2021 at 03:48, David White wrote: > Would this be found in the "image_transfers" table? > > \dt shows me that there are 156 tables in the engine database. > And I see an image_transfers table.

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-18 Thread David White via Users
Would this be found in the "image_transfers" table? \dt shows me that there are 156 tables in the engine database. And I see an image_transfers table. But it looks empty, like a lot of other tables.  This seems strange to me. All of these tables are empty, unless I'm doing something wrong (I'm

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-18 Thread Eyal Shenitzky
The host cannot be set to maintenance if there are image transfer with status different then PAUSED (by user or system - 4/5 in the DB) or FINISHED (success or failure - 9/10 in the DB). If there are image transfer session in the DB with status that is different then those that I mentioned, you

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-17 Thread David White via Users
Thank you. Unfortunately, this is still an issue.  I have indeed tried running the taskcleaner.sh script, but I just tried it again. [root@ovirt-engine1 dwhite]# PGPASSWORD=password /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -Rt This will remove all async_tasks table content!!!

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-17 Thread Nir Soffer
On Fri, Oct 15, 2021 at 11:38 AM David White via Users 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 >

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-17 Thread Shani Leviim
Hi David, Have you tried running the taskcleaner script with the updated password? $ PGPASSWORD=xx /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -R You can also verify if the SPM itself has some locked tasks by running on it: vdsm-client Host getAllTasksStatuses Then clear those

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-17 Thread Strahil Nikolov via Users
Try unlock_entitiy.sh with '-t all -r' Best Regards,Strahil Nikolov On Sat, Oct 16, 2021 at 13:43, David White via Users wrote: ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement:

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-16 Thread David White via Users
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

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-15 Thread David White via Users
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]#

[ovirt-users] Re: Unable to put host in maintenance mode & unable to login to Postgres

2021-10-14 Thread Shani Leviim
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