[ovirt-users] Re: Expand the disk space of the hosting engine

2023-01-02 Thread matthew.st...@fujitsu.com
You allocated a 100G storage domain.

Within that storage domain, you allocated a 50G disk to hold the disk image.

Just like any other storage domain, you can create additional disks.  I have 
seen warnings, for going over 80% allocated within this storage domain.

When building the Self-Hosted-Engine, I specify 75GB when asked about the size 
of the disk to create, and then use LVM to add the unused storage of the disk 
to the root and swap logical volumes.

You should be able to add a second disk of about 25G to the SHE, and use LVM to 
add it to the existing volume groups and expand the existing logical volumes.

Of course, I have not tested this.



-Original Message-
From: ziyi Liu  
Sent: Thursday, December 29, 2022 9:21 PM
To: users@ovirt.org
Subject: [ovirt-users] Re: Expand the disk space of the hosting engine

Thank you very much, I know the operation steps, but there is still one point 
that I don’t quite understand, fdisk -l only shows 50G, the actual disk 
allocation has 100G, how can I display the remaining 50G.
The second question is that if the allocated 100G is also full, how should I 
expand it? I can’t expand it using wei ui 
___
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/QRKI2S4WLJ2JD7X63ECYUFSJ7Z765R5W/
___
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/SZHVTIYS6YT4REAC7VTRMP2M5ZE6XKI4/


[ovirt-users] engine-config -s UserSessionTimeOutInterval=X problem

2023-01-02 Thread marek

ovirt 4.5.4, standalone engine, centos 8 stream

[root@ovirt ~]# engine-config -g UserSessionTimeOutInterval
Picked up JAVA_TOOL_OPTIONS: -Dcom.redhat.fips=false
UserSessionTimeOutInterval: 30 version: general

[root@ovirt ~]# engine-config -s UserSessionTimeOutInterval=60
Picked up JAVA_TOOL_OPTIONS: -Dcom.redhat.fips=false
Cannot set value 60 to key UserSessionTimeOutInterval.

any ideas where is the problem?

Marek
___
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/OPH7BHGBGWMECQKRXY6GW3YGZR73JK2D/


[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Yedidyah Bar David
On Mon, Jan 2, 2023 at 2:33 PM Diego Ercolani  wrote:
>
> Finally it worked:
> After the step previous described:
> 1. put cluster in global maintenance
> 2. stop ovirt-engine and ovirt-engine-dwhd
> 3. in the table dwh_history_timekeeping @enginedb I changed the dwhUuid
> 4. launched engine-setup, the engine-setup asked to disconnect a "fantomatic" 
> DWH (I answered "YES")
> 5. engine setup reconfigure things and set back the dwhUuid to the previous 
> state
> 6. stopped ovirt-engine and ovirt-engine-dwhd because I saw that in the same 
> table I had timestamp in the future (year 2177),

This might hint at the issue. I do not know the relevant logic well,
sorry. Perhaps you had some local time issue which caused this line to
be written? Perhaps there is then logic to not update/ignore/whatever
stuff that's written "in the past".

Anyway, good catch!

> so I removed the erroneous timestamp (putting to [NULL])
> 7. in the /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log I saw:
> Setting a value for the key "lastErrorSent" has failed. Error message: null
> Setting a value for the key "lastErrorSent" has failed. Error message: null
> so I put in "consistent" value:
>
> This is my set:
> INSERT INTO public.dwh_history_timekeeping (var_name,var_value,var_datetime) 
> VALUES
>  ('dwhHostname','ovirt-engine.ovirt',NULL),
>  ('dwhUuid','53878f7e-cb3d-45cc-9edf-9e389414ce6e',NULL),
>  ('lastSampling',NULL,'2023-01-02 13:32:00.2+01'),
>  ('lastSync',NULL,'2023-01-02 13:31:00+01'),
>  ('lastErrorSent','2023-01-02 12:47:15.318 +0100','2023-01-02 
> 12:47:15.318+01'),
>  ('lastOsinfoSync','2023-01-02 12:47:15.318 +0100','2023-01-02 
> 12:47:15.318+01'),
>  ('lastFullHostCheck','2001-01-01 02:01:00.000 +0100','2023-01-02 
> 13:03:00+01'),
>  ('lastOsinfoUpdate','2023-01-02 12:47:15.318 +0100','2023-01-02 
> 12:47:15.318455+01'),
>  ('heartBeat',NULL,'2023-01-02 13:31:59.082+01'),
>  ('timesFailed','0',NULL);
> INSERT INTO public.dwh_history_timekeeping (var_name,var_value,var_datetime) 
> VALUES
>  ('DwhCurrentlyRunning','1',NULL);

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/J6A7TKJ6CQTS3EB2SGDLH5XLHKJONVFZ/


[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Yedidyah Bar David
On Mon, Jan 2, 2023 at 1:38 PM Diego Ercolani  wrote:
>
> I found the reference on that file:
> https://github.com/oVirt/ovirt-dwh/blob/master/docs/Notes-about-single-dwhd

I didn't remember I wrote it :-(.

>
> It's only to notice that I veryfied the contents of
> dwh_history_timeskeeping table @engine db and the dwhUuid it's consistent 
> with the one in the 10-setup-uuid.conf file
>
> While ovirt-engine-dwh is running the value DwhCurrentlyRunning is correctly 
> set to "1" and when I issue
> systemctl stop ovirt-engine-dwhd the parameter is set to 0, so the dwhd 
> correctly can talk with engine db... I suppose.
>
> The DisconnectDwh in the vdc_options table is correctly (?) set to its 
> default value "0"

All looks good to me. Are you there was a problem (I saw your other
mail saying you fixed it)? You get the very same log lines about the
engine not updating statistics even if there is no problem at all -
this is generally what happens on a new engine with no entities being
updated, left doing nothing.

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/V2IVVEQEHULRBTY4UR3RRSXV4ECDRUEY/


[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Diego Ercolani
Finally it worked:
After the step previous described:
1. put cluster in global maintenance
2. stop ovirt-engine and ovirt-engine-dwhd
3. in the table dwh_history_timekeeping @enginedb I changed the dwhUuid
4. launched engine-setup, the engine-setup asked to disconnect a "fantomatic" 
DWH (I answered "YES")
5. engine setup reconfigure things and set back the dwhUuid to the previous 
state
6. stopped ovirt-engine and ovirt-engine-dwhd because I saw that in the same 
table I had timestamp in the future (year 2177), so I removed the erroneous 
timestamp (putting to [NULL])
7. in the /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log I saw:
Setting a value for the key "lastErrorSent" has failed. Error message: null
Setting a value for the key "lastErrorSent" has failed. Error message: null
so I put in "consistent" value:

This is my set:
INSERT INTO public.dwh_history_timekeeping (var_name,var_value,var_datetime) 
VALUES
 ('dwhHostname','ovirt-engine.ovirt',NULL),
 ('dwhUuid','53878f7e-cb3d-45cc-9edf-9e389414ce6e',NULL),
 ('lastSampling',NULL,'2023-01-02 13:32:00.2+01'),
 ('lastSync',NULL,'2023-01-02 13:31:00+01'),
 ('lastErrorSent','2023-01-02 12:47:15.318 +0100','2023-01-02 
12:47:15.318+01'),
 ('lastOsinfoSync','2023-01-02 12:47:15.318 +0100','2023-01-02 
12:47:15.318+01'),
 ('lastFullHostCheck','2001-01-01 02:01:00.000 +0100','2023-01-02 
13:03:00+01'),
 ('lastOsinfoUpdate','2023-01-02 12:47:15.318 +0100','2023-01-02 
12:47:15.318455+01'),
 ('heartBeat',NULL,'2023-01-02 13:31:59.082+01'),
 ('timesFailed','0',NULL);
INSERT INTO public.dwh_history_timekeeping (var_name,var_value,var_datetime) 
VALUES
 ('DwhCurrentlyRunning','1',NULL);
___
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/OMXYSEDVCCHQSPMVXA5KM57ZWR3XHVJI/


[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Diego Ercolani
I found the reference on that file:
https://github.com/oVirt/ovirt-dwh/blob/master/docs/Notes-about-single-dwhd

It's only to notice that I veryfied the contents of
dwh_history_timeskeeping table @engine db and the dwhUuid it's consistent with 
the one in the 10-setup-uuid.conf file

While ovirt-engine-dwh is running the value DwhCurrentlyRunning is correctly 
set to "1" and when I issue
systemctl stop ovirt-engine-dwhd the parameter is set to 0, so the dwhd 
correctly can talk with engine db... I suppose.

The DisconnectDwh in the vdc_options table is correctly (?) set to its default 
value "0"
___
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/HW54UH75DZSBLV2JESPZWNUCI4BLM522/


[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Diego Ercolani
All the files seem to be correctly intializated.
The only doubt is in the last directory you addressed: 
/etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/
there is a file:
[root@ovirt-engine ovirt-engine-dwhd.conf.d]# ls -ltr
total 28
-rw-r--r--. 1 root  root  223 Oct  5 09:17 README
-rw---. 1 ovirt ovirt  83 Dec 30 12:51 10-setup-scale.conf
-rw---. 1 ovirt ovirt 727 Dec 30 12:52 10-setup-database.conf.20230102095726
-rw-r-. 1 root  ovirt 415 Dec 30 12:52 
10-setup-grafana-database.conf.20230102095726
-rw-r--r--. 1 root  root   46 Dec 30 12:52 10-setup-uuid.conf
-rw---. 1 ovirt ovirt 727 Jan  2 09:57 10-setup-database.conf
-rw-r-. 1 root  ovirt 415 Jan  2 09:57 10-setup-grafana-database.conf

10-setup-uuid.conf have the timestamp of dec 30... what is used for?
___
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/R6QA4HWMOTYFBFRM3U7XMO5W4TVN4KLE/


[ovirt-users] Re: Changing the Cluster Compatibility Version in hyperconverged environment

2023-01-02 Thread Lucia Jelinkova
Hi,

Can you be more specific about what is the error message you get while
trying to change the cluster compatibility version?

Thanks,

Lucia

On Mon, Jan 2, 2023 at 8:46 AM  wrote:

> Hi!
>
> I'm sorry if it is a noob question but it is very important for me.
> We are researching oVirt in our company and hope to use existing
> environment where there's no SAN/NAS solution. Just a bunch of servers. We
> were able to set up a hyperconverged installation with oVirt 4.4 a while
> ago and now I'm resuming research and trying to upgrade it to 4.5. I was
> able to upgrade HE and Hosts. What's left is to upgrade Cluster
> Compatibility Version from 4.5 to 4.7. I don't seem to find a way to do it
> as when I try to Edit cluster I get this error: "Cluster Compatibility
> Version".
>
> Upgrade Guide on https://www.ovirt.org/documentation/upgrade_guide/ does
> not have entries for hyperconverged set up. So I don't know where to look
> for information on this topic.
>
> Is it possible to achieve my goal at all? Can "frozen" Cluster
> Compatibility Version cause problems in the long run?
>
> I can rebuild the whole setup now when it is still being reviewed and
> planed. But if we start using it actively it won't be possible. I'm afraid
> that this could be a show-stopper in the long run.
>
> Thanks in advance!
> ___
> 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/DTN6GPBGR4GCBY6LBXZOSWM5GBFSGO3F/
>
___
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/KTDPGNZDEBXW3HNO4FOPLBIDXUDBPBLW/


[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Yedidyah Bar David
On Mon, Jan 2, 2023 at 12:09 PM Diego Ercolani  wrote:
>
> Thank you for your infos.
> > It's not the engine that is writing there, it's dwhd. The engine only
> > reads. Did you check /var/log/ovirt-engine-dwh/ ?
> What is confusing me are these line in  
> /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log
> lastErrorSent|2011-07-03 12:46:47.00
> etlVersion|4.5.7
> dwhAggregationDebug|false
> dwhUuid|53878f7e-cb3d-45cc-9edf-9e389414ce6e
> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
> ovirtEngineHistoryDbPassword|**
> 2022-12-30 
> 21:45:01|6kFI8I|Yi5fBA|8mXcq0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
>  not sample data, oVirt Engine is not updating the statistics. Please check 
> your oVirt Engine status.|9704
> 2022-12-30 
> 22:00:01|HuESUa|Yi5fBA|8mXcq0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
>  not sample data, oVirt Engine is not updating the statistics. Please check 
> your oVirt Engine status.|9704
> 2022-12-30 
> 22:15:01|i99aVI|Yi5fBA|8mXcq0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
>  not sample data, oVirt Engine is not updating the statistics. Please check 
> your oVirt Engine status.|9704

The process is like this:

1. The engine routinely updates its own database
2. dwhd reads the engine DB. If it notices updates, it updates its own
DB. If it does not, after some time it emits the above lines to the
log.

Perhaps the problem is that dwhd fails to look at the engine DB? Or
uses wrong creds? They are in
/etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf
, keys starting with ENGINE_DB_ (those starting with DWH_DB_ are for
its own db).

> >
> >
> > What you did might be enough, in principle, but we do not have it
> > documented/tested, IIRC.
> It should be a "nice to have feature"

We had it open for many years but never finished...

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

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

> >
> > How did you remove ovirt_engine_history? Did you remove both db and
> > user? And lines from pghba.conf?
> >
> > You might need to remove also
> > /etc/ovirt-engine/engine.conf.d/10-setup-dwh-database.conf , before
> > running engine-setup. That's the file the engine uses to get
> > credentials for the dwh db.
> I noticed that engine-setup wrote the correct credentials even if you don't 
> remove the file
> >
> > Good luck and best regards,
> I decided to restart the clean process using your info so, I'm going to trace 
> what I do during the process in the following lines:
> 1. put the cluster in global maintenance
> 2. systemctl stop ovirt-engine-dwhd, systemctl stop ovirt-engine, systemctl 
> stop grafana-server
> 3. verify what process i using the dwh db: SELECT  * FROM pg_stat_activity 
> where datname='ovirt_engine_history';
> 4. "Clean" the database: DROP DATABASE ovirt_engine_history; DROP ROLE 
> ovirt_engine_history; DROP ROLE ovirt_engine_history_grafana;
> 5. "Clean" the setup environment:
>
> --- /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf.bak 2022-12-30 
> 12:52:19.810983574 +
> +++ /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf 2023-01-02 
> 09:48:43.642373549 +
> @@ -19,10 +19,10 @@
>  OVESETUP_CONFIG/adminUserId=str:9c1af7f1-5795-432a-b971-9883e0bed76d
>  OVESETUP_OVN/ovirtProviderOvn=bool:True
>  OVESETUP_OVN/ovirtProviderOvnId=str:e6b92384-b112-40e0-8d6f-2c6e4536cd1a
> -OVESETUP_DWH_CORE/enable=bool:True
> +OVESETUP_DWH_CORE/enable=bool:False
>  OVESETUP_DWH_CONFIG/remoteEngineConfigured=bool:False
>  OVESETUP_DWH_CONFIG/scale=str:2
> -OVESETUP_GRAFANA_CORE/enable=bool:True
> +OVESETUP_GRAFANA_CORE/enable=bool:False
>  OVESETUP_GRAFANA_CORE/grafanaDbCreatedByUs=none:None
>  OVESETUP_KEYCLOAK_CONFIG/ovirtAdminUser=str:admin@ovirt
>  OVESETUP_VMCONSOLE_PROXY_CONFIG/vmconsoleProxyConfig=bool:True
>
> rm /etc/ovirt-engine/engine.conf.d/10-setup-dwh-database.conf
>
> --- /var/lib/pgsql/data/pg_hba.conf.bak 2023-01-02 09:52:34.153904851 +
> +++ /var/lib/pgsql/data/pg_hba.conf 2023-01-02 09:53:08.784158670 +
> @@ -82,14 +82,6 @@
>
>  # "local" is for Unix domain socket connections only
>  local   all all peer
> -hostovirt_engine_history ovirt_engine_history_grafana 0.0.0.0/0  
>  md5
> -hostovirt_engine_history ovirt_engine_history_grafana ::0/0  
>  md5
> -hostovirt_engine_history ovirt_engine_history 0.0.0.0/0   md5
> -hostovirt_engine_history ovirt_engine_history ::0/0   md5
>  hostengine  engine  0.0.0.0/0   md5
>  hostengine  engine  ::0/0   md5
>  # IPv4 local connections:
> @@ -99,18 +91,9 @@
>  # Allow replication connections from localhost, by a user with the
>  # replication privilege.
>  local   replication all peer
> -host

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Diego Ercolani
Thank you for your infos.
> It's not the engine that is writing there, it's dwhd. The engine only
> reads. Did you check /var/log/ovirt-engine-dwh/ ?
What is confusing me are these line in  
/var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log
lastErrorSent|2011-07-03 12:46:47.00
etlVersion|4.5.7
dwhAggregationDebug|false
dwhUuid|53878f7e-cb3d-45cc-9edf-9e389414ce6e
ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbPassword|**
2022-12-30 
21:45:01|6kFI8I|Yi5fBA|8mXcq0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
 not sample data, oVirt Engine is not updating the statistics. Please check 
your oVirt Engine status.|9704
2022-12-30 
22:00:01|HuESUa|Yi5fBA|8mXcq0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
 not sample data, oVirt Engine is not updating the statistics. Please check 
your oVirt Engine status.|9704
2022-12-30 
22:15:01|i99aVI|Yi5fBA|8mXcq0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can
 not sample data, oVirt Engine is not updating the statistics. Please check 
your oVirt Engine status.|9704
> 
> 
> What you did might be enough, in principle, but we do not have it
> documented/tested, IIRC.
It should be a "nice to have feature" 
> 
> How did you remove ovirt_engine_history? Did you remove both db and
> user? And lines from pghba.conf?
> 
> You might need to remove also
> /etc/ovirt-engine/engine.conf.d/10-setup-dwh-database.conf , before
> running engine-setup. That's the file the engine uses to get
> credentials for the dwh db.
I noticed that engine-setup wrote the correct credentials even if you don't 
remove the file
> 
> Good luck and best regards,
I decided to restart the clean process using your info so, I'm going to trace 
what I do during the process in the following lines:
1. put the cluster in global maintenance
2. systemctl stop ovirt-engine-dwhd, systemctl stop ovirt-engine, systemctl 
stop grafana-server
3. verify what process i using the dwh db: SELECT  * FROM pg_stat_activity 
where datname='ovirt_engine_history';
4. "Clean" the database: DROP DATABASE ovirt_engine_history; DROP ROLE 
ovirt_engine_history; DROP ROLE ovirt_engine_history_grafana;
5. "Clean" the setup environment: 

--- /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf.bak 2022-12-30 
12:52:19.810983574 +
+++ /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf 2023-01-02 
09:48:43.642373549 +
@@ -19,10 +19,10 @@
 OVESETUP_CONFIG/adminUserId=str:9c1af7f1-5795-432a-b971-9883e0bed76d
 OVESETUP_OVN/ovirtProviderOvn=bool:True
 OVESETUP_OVN/ovirtProviderOvnId=str:e6b92384-b112-40e0-8d6f-2c6e4536cd1a
-OVESETUP_DWH_CORE/enable=bool:True
+OVESETUP_DWH_CORE/enable=bool:False
 OVESETUP_DWH_CONFIG/remoteEngineConfigured=bool:False
 OVESETUP_DWH_CONFIG/scale=str:2
-OVESETUP_GRAFANA_CORE/enable=bool:True
+OVESETUP_GRAFANA_CORE/enable=bool:False
 OVESETUP_GRAFANA_CORE/grafanaDbCreatedByUs=none:None
 OVESETUP_KEYCLOAK_CONFIG/ovirtAdminUser=str:admin@ovirt
 OVESETUP_VMCONSOLE_PROXY_CONFIG/vmconsoleProxyConfig=bool:True

rm /etc/ovirt-engine/engine.conf.d/10-setup-dwh-database.conf

--- /var/lib/pgsql/data/pg_hba.conf.bak 2023-01-02 09:52:34.153904851 +
+++ /var/lib/pgsql/data/pg_hba.conf 2023-01-02 09:53:08.784158670 +
@@ -82,14 +82,6 @@
 
 # "local" is for Unix domain socket connections only
 local   all all peer
-hostovirt_engine_history ovirt_engine_history_grafana 0.0.0.0/0
   md5
-hostovirt_engine_history ovirt_engine_history_grafana ::0/0
   md5
-hostovirt_engine_history ovirt_engine_history 0.0.0.0/0   md5
-hostovirt_engine_history ovirt_engine_history ::0/0   md5
 hostengine  engine  0.0.0.0/0   md5
 hostengine  engine  ::0/0   md5
 # IPv4 local connections:
@@ -99,18 +91,9 @@
 # Allow replication connections from localhost, by a user with the
 # replication privilege.
 local   replication all peer
-hostovirt_engine_history ovirt_engine_history_grafana 0.0.0.0/0
   md5
-hostovirt_engine_history ovirt_engine_history_grafana ::0/0
   md5
-hostovirt_engine_history ovirt_engine_history 0.0.0.0/0   md5
-hostovirt_engine_history ovirt_engine_history ::0/0   md5
 hostengine  engine  0.0.0.0/0   md5
 hostengine  engine  ::0/0   md5
 hostreplication all 127.0.0.1/32ident
 hostreplication all ::1/128 ident
 host   all diego   192.168.9.0/24  password
 host   all axel192.168.9.0/24  trust

6. launch engine-setup --reconfigure-optional-components:
  --== CONFIGURATION PREVIEW ==--
 
  Default SAN wipe 

[ovirt-users] Re: noVNC console error : Something went wrong, connection is closed

2023-01-02 Thread Lucia Jelinkova
Hi,

You may need to import the new certificate to the browser.

Regards,

Lucia

On Wed, Dec 21, 2022 at 11:42 AM  wrote:

> Hello everyone,
>
> Context :
> oVirt 4.4.9.3-1.el8
> glusterfs 8.6
> Self-hosted engine
>
> Problem:
> Since I update my certificates (with engine-setup) because of the warning
> that my certs will expire soon, I can't open the noVNC console anymore.
>
> In the logs on engine, I have these :
> in /var/log/messages :
> ovsdb-server[510110]:
> ovs|04628|jsonrpc|WARN|ssl:[:::]:51214: receive error:
> Protocol error
> ovsdb-server[510110]:
> ovs|04629|reconnect|WARN|ssl:[:::]:51214: connection dropped
> (Protocol error)
> journal[516217]: 2022-12-21 11:31:27,800+0100 ovirt-websocket-proxy: INFO
> msg:871 handler exception: [SSL: SSLV3_ALERT_CERTIFICATE_UNKNOWN] sslv3
> alert certificate unknown (_ssl.c:897)
> ovirt-websocket-proxy.py[509812]: ovirt-websocket-proxy[516217] INFO
> msg:871 handler exception: [SSL: SSLV3_ALERT_CERTIFICATE_UNKNOWN] sslv3
> alert certificate unknown (_ssl.c:897)
> ovsdb-server[510110]: ovs|04632|stream_ssl|WARN|SSL_accept:
> error:1417C086:SSL routines:tls_process_client_certificate:certificate
> verify failed
>
> in /var/log/openvswitch/ovsdb-server-sb.log :
> 2022-12-21T10:31:22.540Z|04626|stream_ssl|WARN|SSL_accept:
> error:1417C086:SSL routines:tls_process_client_certificate:certificate
> verify failed
> 2022-12-21T10:31:22.541Z|04627|jsonrpc|WARN|Dropped 1 log messages in last
> 8 seconds (most recently, 8 seconds ago) due to excessive rate
> 2022-12-21T10:31:22.541Z|04628|jsonrpc|WARN|ssl:[:::]:51214:
> receive error: Protocol error
> 2022-12-21T10:31:22.542Z|04629|reconnect|WARN|ssl:[:::]:51214:
> connection dropped (Protocol error)
>
> I've tried these commands (found here :
> https://access.redhat.com/solutions/6877501) :
> /usr/share/ovirt-engine/bin/pki-enroll-pkcs12.sh
> --name="ovirt-provider-ovn" --password=mypass --subject=""
> --keep-key
> /usr/share/ovirt-engine/bin/pki-enroll-pkcs12.sh --name="ovn-ndb"
> --password=mypass --subject="" --keep-key
> /usr/share/ovirt-engine/bin/pki-enroll-pkcs12.sh --name="ovn-sdb"
> --password=mypass --subject="" --keep-key
> systemctl restart ovirt-provider-ovn.service
> systemctl restart ovn-northd.service
>
> Still not work, so I've seen that some certificates was still not renewed
> :
> /usr/share/ovirt-engine/bin/pki-enroll-pkcs12.sh
> --name="vmconsole-proxy-helper" --password=mypass
> --subject="" --keep-key
> /usr/share/ovirt-engine/bin/pki-enroll-pkcs12.sh
> --name="vmconsole-proxy-host" --password=mypass
> --subject="" --keep-key
> /usr/share/ovirt-engine/bin/pki-enroll-pkcs12.sh
> --name="vmconsole-proxy-user" --password=mypass
> --subject="" --keep-key
> And restart every ovirt services.
>
> But it still does not work better.
>
> I don't see any other unvalid certificates in
> /etc/pki/ovirt-engine/certs/, so I don't know which certificate is invalid
> for ovsdb.
>
> Thanks for any advice.
> Best regards,
>
> Michael
> ___
> 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/MD2TXPGRX4V5EIDNVMDXWU2NCCISN5BQ/
>
___
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/K2OQ2LSHBTHC6MIKO4AJBABBWRA5WWP7/