[ovirt-users] Re: Console does not work on run once

2022-07-18 Thread José Ferradeira via Users
sorry, my mistake 


De: "José Ferradeira via Users"  
Para: "users"  
Enviadas: Segunda-feira, 18 De Julho de 2022 13:41:41 
Assunto: [ovirt-users] Console does not work on run once 

Hi, 

In run once, when open console nothing shows. 
But it works on any other VM. 

Version 4.5.1.3-1.el8 

Any idea? 

-- 

Jose Ferradeira 
http://www.logicworks.pt 

___ 
Users mailing list -- users@ovirt.org 
To unsubscribe send an email to users-le...@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/LV6GB2ILFBPKNKINX3TBSHRWBM474ECX/
 
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/VHPAPZ3KT3XHJESGDIZWPXYUB6VF7CT7/


[ovirt-users] Re: Grafana login

2022-07-18 Thread Klaas Demter

I thought that was fixed in latest version:

https://bugzilla.redhat.com/show_bug.cgi?id=1996292

https://bugzilla.redhat.com/show_bug.cgi?id=2021497

Maybe report your findings in one of the bzs.


Greetings

Klaas

On 7/18/22 08:16, markec...@gmail.com wrote:

Ok, i finally found a way to login, using username "admin" and password that I 
have created when installing hosted engine.

I thought the Grafana login was connected to Keycloak or the oVirt internal SSO 
database, but as far as I can see, Grafana account is created during the 
installation of Hosted-engine, and subsequent password changes in Keycloak or 
the internal SSO database do not affect the Grafana login credidentials, you 
have to use ones you have created during installation.
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/D6Q2JV65JM3Q3NVTRDDHU532V75652VL/

___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/F7BHAD6DJ66QYTYQCLAZ5F4DSTH6VDU3/


[ovirt-users] Console does not work on run once

2022-07-18 Thread José Ferradeira via Users
Hi, 

In run once, when open console nothing shows. 
But it works on any other VM. 

Version 4.5.1.3-1.el8 

Any idea? 

-- 

Jose Ferradeira 
http://www.logicworks.pt 
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/LV6GB2ILFBPKNKINX3TBSHRWBM474ECX/


[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

2022-07-18 Thread Yedidyah Bar David
On Fri, Jul 15, 2022 at 10:31 AM Andrei Verovski  wrote:
>
> Hi,
>
> I did this and still struck at that Grafana stage.
>
> CREATE ROLE ovirt_engine_history_grafana;
> ALTER DEFAULT PRIVILEGES FOR ROLE ovirt_engine_history IN SCHEMA public GRANT 
> SELECT ON TABLES TO ovirt_engine_history_grafana;
> ALTER ROLE ovirt_engine_history_grafana WITH PASSWORD ‘my_password’;


You are probably missing pg_hba.conf configuration, see e.g.
https://www.ovirt.org/documentation/data_warehouse_guide/#Allowing_Read_Only_Access_to_the_History_Database
.

>
>
> How to delete Grafana completely from old setup???


I don't think we have this documented anywhere.

If you only want to get rid of the setup issue, it's probably enough
to edit /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf,
changing the line 'OVESETUP_GRAFANA_CORE/enable=bool:True' to
'OVESETUP_GRAFANA_CORE/enable=bool:False'.

This will not "delete Grafana completely", only make engine-setup ignore it.

>
>
> I don’t need it.
>
> Thanks in advance.
>
>
>
> > On 14 Jul 2022, at 17:37, Moritz Baumann  wrote:
> >
> > I had a similar issue.
> >
> > for me, taking the password from
> > /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-grafana-database.conf
> >  (GRAFANA_DB_PASSWORD)
> >
> > and set that password in postgres for the
> > user ovirt_engine_history_grafana did the trick.
> >
> > Best
> > Mo
> >
> >
> > On 7/14/22 16:28, Andrei Verovski wrote:
> >> Hi,
> >> I have oVirt engine 4.4.7 running on dedicated PC (not hosted engine).
> >> After several unsuccessful upgrade attempts of 4.4.7 to 4.4.10 decided to 
> >> install clean 4.4.10 and migrate data.
> >> On old engine
> >> engine-backup --scope=all --mode=backup
> >> On new engine
> >> engine-backup --mode=restore --provision-all-databases 
> >> --no-restore-permissions --file=ovirt-engine-backup-20220713160717.backup

I am sorry to note that your issue was most likely caused by
'--no-restore-permissions', although the documentation (including
--help/manpage) does not hint about this at all. You might want to
open a doc bug to document this, or even an RFE bug, to make this a
separate option.

for a long time, it was mandatory to pass either
--no-restore-permissions or --restore-permissions:

https://bugzilla.redhat.com/show_bug.cgi?id=1220791

But I recently changed this to default to --restore-permissions:

https://bugzilla.redhat.com/1821018

With --restore-permissions, if you previously manually created extra
users and gave them access permissions, e.g. using the doc in above
link, --mode=restore could not know the passwords for these users, and
created them with random passwords, outputting "- extra user
'${extrau}' having grants on database ${database}, created with a
random password":

https://bugzilla.redhat.com/1369757

But for grafana, this isn't true - the password is saved in the
above-mentioned conf, and so --mode=restore can (and does) create the
user with the saved password:

https://bugzilla.redhat.com/show_bug.cgi?id=1837460

Bottom line:

I now think that --restore-permissions almost always makes sense,
therefore changed it to be the default.

If you have scripts/procedures that pass --no-restore-permissions, I
recommend rethinking these and considering dropping it altogether,
relying on the default, or passing --restore-permissions.

A scenario I can think of where '--no-restore-permissions' does make
sense: If you do have extra users you created for some other
applications to access the DWH DB, and would rather not have a restore
procedure replace their passwords to random ones, but prefer having
your restore procedure handle this manually - restore/setup with
--no-restore-permissions, then manually add the users+passwords you
need and give them permissions.

Best regards,
-- 
Didi
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/YMNPAFLEQ62O6BYJVA6NNMCTGUCS3EWA/


[ovirt-users] Re: oVirt over gluster: Replacing a dead host

2022-07-18 Thread Patrick Hibbs
If I'm understanding your question / setup correctly, the best way
would be to simply mount -o bind the old path to the new one. The old
path would still be used by gluster, but it would ultimately go to the
new location.

Changing the brick path on a single brick while leaving the original
path intact on others may be possible, the gluster docs are silent
either way, but I'd doubt oVirt would work correctly in that
circumstance.
Maybe Sandro can point us at someone who would know more on that
subject? :)

If it is possible to do, and standard disclaimer: I'm *NOT*
recommending anyone do it, I'd imagine you'd need to follow
instructions similar
to (https://serverfault.com/questions/631365/rename-a-glusterfs-peer)
replacing the peer name with the brick directory.

-Patrick Hibbs

On Mon, 2022-07-18 at 08:19 +0300, Gilboa Davara wrote:
> Hello,
> 
> Many thanks for your email.
> I should add that this is a test environment we set up in preparation
> for a planned CentOS 7 / oVirt 4.3 upgrade to CentOS 8 Streams /
> oVirt 4.5 upgrade in one of our old(er) oVirt clusters.
> In this case, we blew up the software RAID during the OS replacement
> (CentOS 7 -> 8) so have a host, but no storage.
> And as an added bonus, the FS locations are a bit different. (due MD
> changes we made during the blowup).
> 
> So, essentially the host is alive, but we need to create a new brick
> using a known good brick.
> A couple of questions:
> Assuming I have a known good brick to copy but the FS location is
> different and given the fact I cannot simply remove/add brick, how do
> I change the brick path?
> Old location:
> office-wx-hv1-lab-gfs:/mnt/LogGFSData/brick
> New location:
> office-wx-hv1-lab-gfs.localdomain:/gluster/brick/data/brick
> 
> Thanks again,
> Gilboa
> 
> On Mon, Jul 18, 2022 at 1:32 AM Patrick Hibbs
>  wrote:
> > What you are missing is the fact that gluster requires more than
> > one set of bricks to recover from a dead host. I.e. In your set up,
> > you'd need 6 hosts. 4x replicas and 2x arbiters with at least one
> > set (2x replicas and 1x arbiter) operational bare minimum.
> > Automated commands to fix the volume do not exist otherwise. (It's
> > a Gluster limitation.) This can be fixed manually however.
> > 
> > Standard Disclaimer: Back up your data first! Fixing this issue
> > requires manual intervention. Reader assumes all responsiblity for
> > any action resulting from the instructions below. Etc.
> > 
> > If it's just a dead brick, (i.e. the host is still functional), all
> > you really need to do is replace the underlying storage:
> > 
> > 1. Take the gluster volume offline.
> > 2. Remove the bad storage device, and attach the replacement.
> > 3. rsync / scp / etc. the data from a known good brick (be sure to
> > include hidden files / preserve file times and ownership / SELinux
> > labels / etc. ). 
> > 4. Restart the gluster volume.
> > 
> > Gluster *might* still need to heal everything after all of that,
> > but it should start the volume and get it running again.
> > 
> > If the host itself is dead, (and the underlying storage is still
> > functional), you can just move the underlying storage over to the
> > new host:
> > 
> > 1. Take the gluster volume offline.
> > 2. Attach the old storage.
> > 3. Fix up the ids on the volume file.
> > (https://serverfault.com/questions/631365/rename-a-glusterfs-peer)
> > 4. Restart the gluster volume.
> > 
> > If both the host and underlying storage are dead, you'll need to do
> > both tasks:
> > 
> > 1. Take the gluster volume offline.
> > 2. Attach the new storage.
> > 3. rsync / scp / etc. the data from a known good brick (be sure to
> > include hidden files / preserve file times and ownership / SELinux
> > labels / etc. ).
> > 4. Fix up the ids on the volume file.
> > 5. Restart the gluster volume.
> > 
> > Keep in mind one thing however: If the gluster host you are
> > replacing is used by oVirt to connect to the volume (I.e. It's the
> > host named in the volume config in the Admin portal). The new host
> > will need to retain the old hostname / IP, or you'll need to update
> > oVirt's config. Otherwise the VM hosts will wind up in Unassigned /
> > Non-functional status.
> > 
> > - Patrick Hibbs
> > 
> > On Sun, 2022-07-17 at 22:15 +0300, Gilboa Davara wrote:
> > > Hello all,
> > > 
> > > I'm attempting to replace a dead host in a replica 2 + arbiter
> > > gluster setup and replace it with a new host.
> > > I've already set up a new host (same hostname..localdomain) and
> > > got into the cluster.
> > > 
> > > $ gluster peer status
> > > Number of Peers: 2
> > > 
> > > Hostname: office-wx-hv3-lab-gfs
> > > Uuid: 4e13f796-b818-4e07-8523-d84eb0faa4f9
> > > State: Peer in Cluster (Connected)
> > > 
> > > Hostname: office-wx-hv1-lab-gfs.localdomain <-- This is a new
> > > host.
> > > Uuid: eee17c74-0d93-4f92-b81d-87f6b9c2204d
> > > State: Peer in Cluster (Connected)
> > > 
> > > $ gluster volume info GV2Data
> > >  Volume Name: GV2Data
> > > Type: 

[ovirt-users] Re: Cannot deserialize - engine doesn't start

2022-07-18 Thread Giulio Casella

Hi Benny,
here the bug link:

https://bugzilla.redhat.com/show_bug.cgi?id=2107985

Thank you,
gc


On 13/07/2022 16:48, Benny Zlotnik wrote:

Thanks, I posted a fix[1], please share the bug link after you submit
it and I'll attach the PR to it

[1] https://github.com/oVirt/ovirt-engine/pull/526

On Wed, Jul 13, 2022 at 5:26 PM Giulio Casella  wrote:


Done!
After deleting some rows present in command_entities table (those that
hadn't a job with a correlationId in job table) the engine restarted.

I'll file a bugzilla for this issue.

Thank you Benny.

Ciao,
gc


On 13/07/2022 15:29, Benny Zlotnik wrote:

I will very carefully say yes, but please backup the engine before you do that

On Wed, Jul 13, 2022 at 1:59 PM Giulio Casella  wrote:




On 13/07/2022 12:54, Benny Zlotnik wrote:

On Wed, Jul 13, 2022 at 1:48 PM Giulio Casella  wrote:


Thanks Benny,

On 13/07/2022 12:20, Benny Zlotnik wrote:

Thanks, is the operation complete? If yes, you can remove the rows
referencing command_id 6ae544f6-b608-4d8d-9f99-eabd5d5db0ad from
command_entities


How can I know if the operation is completed? I've no access to admin
portal anymore...

Right, I forgot about this...


The only things I know are:
- there are 2 command in command_entities referencing command_id
6ae544f6-b608-4d8d-9f99-eabd5d5db0ad: the
6ae544f6-b608-4d8d-9f99-eabd5d5db0ad itself and another one referencing
it as a parent
- both of them are marked as ENDED_SUCCESSFULLY in the status field
- other commands in table exists, 3 of them marked as active (none of
them references 6ae544f6-b608-4d8d-9f99-eabd5d5db0ad)


You can check in the job table,

select *
from job
where correlation_id = 'd19c0b79-76dd-40df-af41-fc18e59bb536';


No job returned from job query.
Can I proceed to remove 2 rows from command_entities referencing
6ae544f6-b608-4d8d-9f99-eabd5d5db0ad?


Thanks,
gc











smime.p7s
Description: S/MIME Cryptographic Signature
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/VZOI2RGS7PIUNQDRBDVWZTA2347KRBUL/


[ovirt-users] How to Fix: oVirt 4.4.10 Internal server error 500 after engine-setup (vdsm-jsonrpc-java )

2022-07-18 Thread Andrei Verovski
Hi,


Finally I managed to migrate 4.4.7 to fresh installation of 4.4.10.
However, after successful engine-setup I’ve got 500 - Internal Server Error

I found this:
https://bugzilla.redhat.com/show_bug.cgi?id=1918022

Bug 1918022 - oVirt Manager is not loading after engine-setup 

Article suggested to downgrade vdsm-jsonrpc-java to 1.5.x.

However, this is not possible:
dnf --showduplicates list vdsm-jsonrpc-java
dnf install vdsm-jsonrpc-java-1.5.7-1.el8

Last metadata expiration check: 0:39:52 ago on Fri 15 Jul 2022 02:32:36 PM EEST.
Error: 
Problem: problem with installed package 
ovirt-engine-backend-4.4.10.7-1.el8.noarch
 - package ovirt-engine-backend-4.4.10.7-1.el8.noarch requires 
vdsm-jsonrpc-java >= 1.6.0, but none of the providers can be installed
 - cannot install both vdsm-jsonrpc-java-1.5.7-1.el8.noarch and 
vdsm-jsonrpc-java-1.6.0-1.el8.noarch
 - cannot install both vdsm-jsonrpc-java-1.6.0-1.el8.noarch and 
vdsm-jsonrpc-java-1.5.7-1.el8.noarch


How to fix this?
Thanks in advance.


*   SERVER LOG *

2022-07-15 14:45:44,969+03 ERROR [org.jboss.as.controller.management-operation] 
(Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: 
([("deployment" => "engine.ear")]) - failure description: {"WFLYCTL0080: Failed 
services" => 
{"jboss.deployment.subunit.\"engine.ear\".\"bll.jar\".component.Backend.START" 
=> "java.lang.IllegalStateException: WFLYEE0042: Failed to construct component 
instance
   Caused by: java.lang.IllegalStateException: WFLYEE0042: Failed to construct 
component instance
   Caused by: javax.ejb.EJBException: org.jboss.weld.exceptions.WeldException: 
WELD-49: Unable to invoke protected void 
org.ovirt.engine.core.bll.TagsDirector.init() on 
org.ovirt.engine.core.bll.TagsDirector@648487d3
   Caused by: org.jboss.weld.exceptions.WeldException: WELD-49: Unable to 
invoke protected void org.ovirt.engine.core.bll.TagsDirector.init() on 
org.ovirt.engine.core.bll.TagsDirector@648487d3
   Caused by: java.lang.reflect.InvocationTargetException
   Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: 
Unable to determine the correct call signature - no 
procedure/function/signature for 'gettagsbyparent_id'"}}
2022-07-15 14:45:44,981+03 INFO  [org.jboss.as.server] (ServerService Thread 
Pool -- 25) WFLYSRV0010: Deployed "restapi.war" (runtime-name : "restapi.war")
2022-07-15 14:45:44,982+03 INFO  [org.jboss.as.server] (ServerService Thread 
Pool -- 25) WFLYSRV0010: Deployed "engine.ear" (runtime-name : "engine.ear")
2022-07-15 14:45:44,982+03 INFO  [org.jboss.as.server] (ServerService Thread 
Pool -- 25) WFLYSRV0010: Deployed "apidoc.war" (runtime-name : "apidoc.war")
2022-07-15 14:45:44,982+03 INFO  [org.jboss.as.server] (ServerService Thread 
Pool -- 25) WFLYSRV0010: Deployed "ovirt-web-ui.war" (runtime-name : 
"ovirt-web-ui.war")
2022-07-15 14:45:45,015+03 INFO  [org.jboss.as.controller] (Controller Boot 
Thread) WFLYCTL0183: Service status report
WFLYCTL0186:   Services which failed to start:  service 
jboss.deployment.subunit."engine.ear"."bll.jar".component.Backend.START: 
java.lang.IllegalStateException: WFLYEE0042: Failed to construct component 
instance
WFLYCTL0448: 2 additional services are down due to their dependencies being 
missing or failed

___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/4KT4STN5M6HXXW4WNRI2YUX7RGLZRV2T/


[ovirt-users] Re: Grafana login

2022-07-18 Thread markeczzz
Ok, i finally found a way to login, using username "admin" and password that I 
have created when installing hosted engine.

I thought the Grafana login was connected to Keycloak or the oVirt internal SSO 
database, but as far as I can see, Grafana account is created during the 
installation of Hosted-engine, and subsequent password changes in Keycloak or 
the internal SSO database do not affect the Grafana login credidentials, you 
have to use ones you have created during installation.
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/D6Q2JV65JM3Q3NVTRDDHU532V75652VL/