[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Aviv Litman]

Hi Tommy,
There was a bug in the way we calculate hosts CPU: we didn't consider
the count_threads_as_cores option in the calculation.
The count_threads_as_cores column is available only from ovirt-engine
4.4.6.7 version, and ovirt-dwh 4.4.7. Patches: ovirt-engine
<https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/> ovirt-dwh
<https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/> So you have to update
the version to 4.4.7.
I will also add a note in the Blog.

You can try to implement the patches I shared manually by changing the
relevant files in engine and dwh and run engine-setup.
*Important note: do not change the minimal version part in dwh
ovirt-engine-dwh.spec.in file.

Feel free to contact me if you have more questions.

Best,
Aviv

On Fri, Sep 17, 2021 at 7:08 AM Tommy Sway  wrote:

> So, 4.3 cannot resolve it ?
>
> Thanks.
>
>
>
> -Original Message-
> From: users-boun...@ovirt.org  On Behalf Of
> Kiran Rajendra
> Sent: Thursday, September 16, 2021 4:54 PM
> To: users@ovirt.org
> Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana
>
> Hi Tommy,
>
> In OLVM/oVirt 4.3, Column count_threads_as_cores is not present in table
> cluster_configuration
>
> ovirt_engine_history=# \d cluster_configuration
> Table
> "public.cluster_configuration"
>   Column  |   Type   | Collation |
> Nullable |Default
>
> --+--+---+--+
>  history_id   | integer  |   |
> not null | nextval('configuration_seq'::regclass)
>  cluster_id   | uuid |   |
> not null |
>  cluster_name | character varying(40)|   |
> not null |
>  cluster_description  | character varying(4000)  |
>  |  |
>  datacenter_id| uuid |
>  |  |
>  cpu_name | character varying(255)   |
>  |  |
>  compatibility_version| character varying(40)|   |
> not null | '2.2'::character varying
>  datacenter_configuration_version | integer  |
>  |  |
>  create_date  | timestamp with time zone |
>  |  |
>  update_date  | timestamp with time zone |
>  |  |
>  delete_date  | timestamp with time zone |
>  |  |
> Indexes:
> "cluster_configuration_pkey" PRIMARY KEY, btree (history_id)
> "cluster_configuration_cluster_id_idx" btree (cluster_id)
> "cluster_configuration_datacenter_id_idx" btree (datacenter_id)
>
>
> It is added in oVirt 4.4 release.
> https://gerrit.ovirt.org/c/ovirt-dwh/+/114568
>
> https://gerrit.ovirt.org/c/ovirt-dwh/+/114568/11/packaging/dbscripts/create_views_4_4.sql
>
> Thank you
> ___
> 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/JOYM3DBPSHJIQUCBFV5STKSPLG47X4CY/
> ___
> 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/FYNIMRZX2FY3ZTLX2JADQAWE4XWL3QJZ/
>
___
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/TMSEKS2QDELZN5HTZGKO33HMOQZXRF4T/

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Tommy Sway]

So, 4.3 cannot resolve it ?

Thanks.



-Original Message-
From: users-boun...@ovirt.org  On Behalf Of Kiran 
Rajendra
Sent: Thursday, September 16, 2021 4:54 PM
To: users@ovirt.org
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

Hi Tommy,

In OLVM/oVirt 4.3, Column count_threads_as_cores is not present in table 
cluster_configuration

ovirt_engine_history=# \d cluster_configuration
Table "public.cluster_configuration"
  Column  |   Type   | Collation | 
Nullable |Default
--+--+---+--+
 history_id   | integer  |   | not 
null | nextval('configuration_seq'::regclass)
 cluster_id   | uuid |   | not 
null |
 cluster_name | character varying(40)|   | not 
null |
 cluster_description  | character varying(4000)  |   |  
|
 datacenter_id| uuid |   |  
|
 cpu_name | character varying(255)   |   |  
|
 compatibility_version| character varying(40)|   | not 
null | '2.2'::character varying
 datacenter_configuration_version | integer  |   |  
|
 create_date  | timestamp with time zone |   |  
|
 update_date  | timestamp with time zone |   |  
|
 delete_date  | timestamp with time zone |   |  
|
Indexes:
"cluster_configuration_pkey" PRIMARY KEY, btree (history_id)
"cluster_configuration_cluster_id_idx" btree (cluster_id)
"cluster_configuration_datacenter_id_idx" btree (datacenter_id)


It is added in oVirt 4.4 release.
https://gerrit.ovirt.org/c/ovirt-dwh/+/114568
https://gerrit.ovirt.org/c/ovirt-dwh/+/114568/11/packaging/dbscripts/create_views_4_4.sql
 

Thank you
___
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/JOYM3DBPSHJIQUCBFV5STKSPLG47X4CY/
___
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/FYNIMRZX2FY3ZTLX2JADQAWE4XWL3QJZ/

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Kiran Rajendra]

Hi Tommy,

In OLVM/oVirt 4.3, Column count_threads_as_cores is not present in table 
cluster_configuration

ovirt_engine_history=# \d cluster_configuration
Table "public.cluster_configuration"
  Column  |   Type   | Collation | 
Nullable |Default
--+--+---+--+
 history_id   | integer  |   | not 
null | nextval('configuration_seq'::regclass)
 cluster_id   | uuid |   | not 
null |
 cluster_name | character varying(40)|   | not 
null |
 cluster_description  | character varying(4000)  |   |  
|
 datacenter_id| uuid |   |  
|
 cpu_name | character varying(255)   |   |  
|
 compatibility_version| character varying(40)|   | not 
null | '2.2'::character varying
 datacenter_configuration_version | integer  |   |  
|
 create_date  | timestamp with time zone |   |  
|
 update_date  | timestamp with time zone |   |  
|
 delete_date  | timestamp with time zone |   |  
|
Indexes:
"cluster_configuration_pkey" PRIMARY KEY, btree (history_id)
"cluster_configuration_cluster_id_idx" btree (cluster_id)
"cluster_configuration_datacenter_id_idx" btree (datacenter_id)


It is added in oVirt 4.4 release.
https://gerrit.ovirt.org/c/ovirt-dwh/+/114568
https://gerrit.ovirt.org/c/ovirt-dwh/+/114568/11/packaging/dbscripts/create_views_4_4.sql
 

Thank you
___
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/JOYM3DBPSHJIQUCBFV5STKSPLG47X4CY/

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[matthew.st...@fujitsu.com]

Saw those also.  Haven’t gotten around to investigating those.

From: Tommy Sway 
Sent: Wednesday, September 15, 2021 11:14 PM
To: Stier, Matthew ; 'Michal Gutowski' 
; 'Vrgotic, Marko' 
Cc: users@ovirt.org
Subject: RE: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

Thank you!

I tried it, and I can import the json after replace the 4.4 with 4.3, but still 
have some errors like this:

pq: column "count_threads_as_cores" does not exist
Object
status:400
statusText:"Bad Request"
data:Object
results:Object
message:"pq: column "count_threads_as_cores" does not exist"
message:"pq: column "count_threads_as_cores" does not exist"

Many of the other reports worked fine, with only a few similar errors.
Is this caused by version incompatibility?
After all, 4.4 in the original document was replaced with 4.3 before the import.




From: matthew.st...@fujitsu.com<mailto:matthew.st...@fujitsu.com> 
mailto:matthew.st...@fujitsu.com>>
Sent: Wednesday, September 15, 2021 3:28 AM
To: Tommy Sway mailto:sz_cui...@163.com>>; 'Michal Gutowski' 
mailto:michal.gutow...@oracle.com>>; 'Vrgotic, 
Marko' mailto:m.vrgo...@activevideo.com>>
Cc: users@ovirt.org<mailto:users@ovirt.org>
Subject: RE: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

The instructions to modify the json files are missing. (Using find and sed to 
change all instances of v4_4_ to v4_3_ before importing them into Grafana)

This is from an Oracle Blog on the doing this with OLVM 4.3 (which is basically 
a repackaged oVirt 4.3)

Build Grafana Dashboard for Oracle Linux Virtualization Manager 
4.3<https://blogs.oracle.com/scoter/post/build-grafana-dashboard-for-oracle-linux-virtualization-manager-43>

From: Tommy Sway mailto:sz_cui...@163.com>>
Sent: Tuesday, September 14, 2021 3:01 AM
To: 'Michal Gutowski' 
mailto:michal.gutow...@oracle.com>>; 'Vrgotic, 
Marko' mailto:m.vrgo...@activevideo.com>>
Cc: users@ovirt.org<mailto:users@ovirt.org>
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

The oVirt version I'm using is 4.3, and I get an error when I import JSON.
pq: relation"v4_4_latest_configuration_datacenters" does not exist.



From: users-boun...@ovirt.org<mailto:users-boun...@ovirt.org> 
mailto:users-boun...@ovirt.org>> On Behalf Of Michal 
Gutowski
Sent: Wednesday, November 25, 2020 12:26 AM
To: Vrgotic, Marko mailto:m.vrgo...@activevideo.com>>
Cc: users@ovirt.org<mailto:users@ovirt.org>
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

Hi Marko,

I've tested this myself as I like playing with various Grafana use-cases and 
following steps allow you to set up Grafana Monitoring for your oVirt 4.3 
environment and re-use all Grafana Dashboards from latest oVirt 4.4 on a 
previous release.

1. Allowing Grafana to connect to oVirt DWH database (Data Warehouse)

Login to the oVirt engine 4.3 and create a user "grafana" with password 
"grafana" that will get a read-only access to the ovirt_engine_history database 
and will be able to use public schema

# su - postgres -c 'scl enable rh-postgresql10 bash'
# psql -U postgres -c "CREATE ROLE grafana WITH LOGIN ENCRYPTED PASSWORD 
'grafana';" -d ovirt_engine_history
# psql -U postgres -c "GRANT CONNECT ON DATABASE ovirt_engine_history TO 
grafana;"
# psql -U postgres -c "GRANT USAGE ON SCHEMA public TO grafana;" 
ovirt_engine_history

Generate the rest of the permissions that will be granted to the newly created 
user and save them to a file:

# psql -U postgres -c "SELECT 'GRANT SELECT ON ' || relname || ' TO grafana;' 
FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace 
WHERE nspname = 'public' AND relkind IN ('r', 'v');" --pset=tuples_only=on  
ovirt_engine_history > grant.sql

Use the file you created in the previous step to grant permissions to the newly 
created user:
# psql -U postgres -f grant.sql ovirt_engine_history

Remove the file you used to grant permissions:
# rm grant.sql

Exit the postgres user shell by pressing Ctrl+d

Add the following lines for the newly created user to 
/var/opt/rh/rh-postgresql10/lib/pgsql/data/pg_hba.conf preceding the line 
beginning local all all

hostovirt_engine_history grafana 0.0.0.0/0   md5
hostovirt_engine_history grafana ::0/0   md5

Reload postgres service
# systemctl reload rh-postgresql10-postgresql

2. Installing Grafana

You can install Grafana directly on the oVirt Engine machine (this is how it's 
done in oVirt 4.4) or on a separate machine. Following steps shows how you can 
install Grafana on a Oracle Linux 7 server. Note: Oracle provides Grafana in 
the OLCNE yum repository - you only need to install the repository definition 
package to pickup Grafana and it's dependencies.

# yum install oraclelinux-release-el7
# yum install oracle-olcne-release-el7
# yum-c

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Tommy Sway]

Thank you!

 

I tried it, and I can import the json after replace the 4.4 with 4.3, but still 
have some errors like this:



pq: column "count_threads_as_cores" does not exist

Object

status:400

statusText:"Bad Request"

data:Object

results:Object

message:"pq: column "count_threads_as_cores" does not exist"

message:"pq: column "count_threads_as_cores" does not exist"

 

Many of the other reports worked fine, with only a few similar errors.

Is this caused by version incompatibility?

After all, 4.4 in the original document was replaced with 4.3 before the import.

 

 

 

 

From: matthew.st...@fujitsu.com  
Sent: Wednesday, September 15, 2021 3:28 AM
To: Tommy Sway ; 'Michal Gutowski' 
; 'Vrgotic, Marko' 
Cc: users@ovirt.org
Subject: RE: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

 

The instructions to modify the json files are missing. (Using find and sed to 
change all instances of v4_4_ to v4_3_ before importing them into Grafana)

 

This is from an Oracle Blog on the doing this with OLVM 4.3 (which is basically 
a repackaged oVirt 4.3)

 

Build Grafana Dashboard for Oracle Linux Virtualization Manager 4.3 
<https://blogs.oracle.com/scoter/post/build-grafana-dashboard-for-oracle-linux-virtualization-manager-43>
 

 

From: Tommy Sway mailto:sz_cui...@163.com> > 
Sent: Tuesday, September 14, 2021 3:01 AM
To: 'Michal Gutowski' mailto:michal.gutow...@oracle.com> >; 'Vrgotic, Marko' 
mailto:m.vrgo...@activevideo.com> >
Cc: users@ovirt.org <mailto:users@ovirt.org> 
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

 

The oVirt version I'm using is 4.3, and I get an error when I import JSON.

pq: relation"v4_4_latest_configuration_datacenters" does not exist.

 

 

 

From: users-boun...@ovirt.org <mailto:users-boun...@ovirt.org>  
mailto:users-boun...@ovirt.org> > On Behalf Of Michal 
Gutowski
Sent: Wednesday, November 25, 2020 12:26 AM
To: Vrgotic, Marko mailto:m.vrgo...@activevideo.com> >
Cc: users@ovirt.org <mailto:users@ovirt.org> 
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

 

Hi Marko,

 

I've tested this myself as I like playing with various Grafana use-cases and 
following steps allow you to set up Grafana Monitoring for your oVirt 4.3 
environment and re-use all Grafana Dashboards from latest oVirt 4.4 on a 
previous release.

 

1. Allowing Grafana to connect to oVirt DWH database (Data Warehouse)

 

Login to the oVirt engine 4.3 and create a user "grafana" with password 
"grafana" that will get a read-only access to the ovirt_engine_history database 
and will be able to use public schema

 

# su - postgres -c 'scl enable rh-postgresql10 bash'

# psql -U postgres -c "CREATE ROLE grafana WITH LOGIN ENCRYPTED PASSWORD 
'grafana';" -d ovirt_engine_history

# psql -U postgres -c "GRANT CONNECT ON DATABASE ovirt_engine_history TO 
grafana;"

# psql -U postgres -c "GRANT USAGE ON SCHEMA public TO grafana;" 
ovirt_engine_history

 

Generate the rest of the permissions that will be granted to the newly created 
user and save them to a file:

 

# psql -U postgres -c "SELECT 'GRANT SELECT ON ' || relname || ' TO grafana;' 
FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace 
WHERE nspname = 'public' AND relkind IN ('r', 'v');" --pset=tuples_only=on  
ovirt_engine_history > grant.sql

 

Use the file you created in the previous step to grant permissions to the newly 
created user:

# psql -U postgres -f grant.sql ovirt_engine_history

 

Remove the file you used to grant permissions:

# rm grant.sql

 

Exit the postgres user shell by pressing Ctrl+d

 

Add the following lines for the newly created user to 
/var/opt/rh/rh-postgresql10/lib/pgsql/data/pg_hba.conf preceding the line 
beginning local all all

 

hostovirt_engine_history grafana 0.0.0.0/0   md5

hostovirt_engine_history grafana ::0/0   md5

 

Reload postgres service

# systemctl reload rh-postgresql10-postgresql

 

2. Installing Grafana

 

You can install Grafana directly on the oVirt Engine machine (this is how it's 
done in oVirt 4.4) or on a separate machine. Following steps shows how you can 
install Grafana on a Oracle Linux 7 server. Note: Oracle provides Grafana in 
the OLCNE yum repository - you only need to install the repository definition 
package to pickup Grafana and it's dependencies.

 

# yum install oraclelinux-release-el7

# yum install oracle-olcne-release-el7

# yum-config-manager --enable ol7_optional_latest ol7_olcne11

# yum install grafana

# systemctl enable --now grafana-server

 

3. Adding oVirt DWH database as Data Source in Grafana

 

Login to Grafana (default port 3000) and navigate to Configuration -> 
DataSources and click on Add Data Source button.

 

Select PostgreSQL source and use the following settings (adj

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[matthew.st...@fujitsu.com]

The instructions to modify the json files are missing. (Using find and sed to 
change all instances of v4_4_ to v4_3_ before importing them into Grafana)

This is from an Oracle Blog on the doing this with OLVM 4.3 (which is basically 
a repackaged oVirt 4.3)

Build Grafana Dashboard for Oracle Linux Virtualization Manager 
4.3<https://blogs.oracle.com/scoter/post/build-grafana-dashboard-for-oracle-linux-virtualization-manager-43>

From: Tommy Sway 
Sent: Tuesday, September 14, 2021 3:01 AM
To: 'Michal Gutowski' ; 'Vrgotic, Marko' 

Cc: users@ovirt.org
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

The oVirt version I'm using is 4.3, and I get an error when I import JSON.
pq: relation"v4_4_latest_configuration_datacenters" does not exist.



From: users-boun...@ovirt.org<mailto:users-boun...@ovirt.org> 
mailto:users-boun...@ovirt.org>> On Behalf Of Michal 
Gutowski
Sent: Wednesday, November 25, 2020 12:26 AM
To: Vrgotic, Marko mailto:m.vrgo...@activevideo.com>>
Cc: users@ovirt.org<mailto:users@ovirt.org>
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

Hi Marko,

I've tested this myself as I like playing with various Grafana use-cases and 
following steps allow you to set up Grafana Monitoring for your oVirt 4.3 
environment and re-use all Grafana Dashboards from latest oVirt 4.4 on a 
previous release.

1. Allowing Grafana to connect to oVirt DWH database (Data Warehouse)

Login to the oVirt engine 4.3 and create a user "grafana" with password 
"grafana" that will get a read-only access to the ovirt_engine_history database 
and will be able to use public schema

# su - postgres -c 'scl enable rh-postgresql10 bash'
# psql -U postgres -c "CREATE ROLE grafana WITH LOGIN ENCRYPTED PASSWORD 
'grafana';" -d ovirt_engine_history
# psql -U postgres -c "GRANT CONNECT ON DATABASE ovirt_engine_history TO 
grafana;"
# psql -U postgres -c "GRANT USAGE ON SCHEMA public TO grafana;" 
ovirt_engine_history

Generate the rest of the permissions that will be granted to the newly created 
user and save them to a file:

# psql -U postgres -c "SELECT 'GRANT SELECT ON ' || relname || ' TO grafana;' 
FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace 
WHERE nspname = 'public' AND relkind IN ('r', 'v');" --pset=tuples_only=on  
ovirt_engine_history > grant.sql

Use the file you created in the previous step to grant permissions to the newly 
created user:
# psql -U postgres -f grant.sql ovirt_engine_history

Remove the file you used to grant permissions:
# rm grant.sql

Exit the postgres user shell by pressing Ctrl+d

Add the following lines for the newly created user to 
/var/opt/rh/rh-postgresql10/lib/pgsql/data/pg_hba.conf preceding the line 
beginning local all all

hostovirt_engine_history grafana 0.0.0.0/0   md5
hostovirt_engine_history grafana ::0/0   md5

Reload postgres service
# systemctl reload rh-postgresql10-postgresql

2. Installing Grafana

You can install Grafana directly on the oVirt Engine machine (this is how it's 
done in oVirt 4.4) or on a separate machine. Following steps shows how you can 
install Grafana on a Oracle Linux 7 server. Note: Oracle provides Grafana in 
the OLCNE yum repository - you only need to install the repository definition 
package to pickup Grafana and it's dependencies.

# yum install oraclelinux-release-el7
# yum install oracle-olcne-release-el7
# yum-config-manager --enable ol7_optional_latest ol7_olcne11
# yum install grafana
# systemctl enable --now grafana-server

3. Adding oVirt DWH database as Data Source in Grafana

Login to Grafana (default port 3000) and navigate to Configuration -> 
DataSources and click on Add Data Source button.

Select PostgreSQL source and use the following settings (adjust the Host IP 
address to match your oVirt Engine IP but do not change the Name):
Name: oVirt DWH
Host: your-engine-ip-address:5432
user: grafana
pass: grafana
SSL mode: disable

4. Importing Dashboards from oVirt 4.4

Download Grafana Dashboards from oVirt 4.4 repository: 
https://github.com/oVirt/ovirt-dwh/tree/master/packaging/conf/grafana-dashboards

You can now import them in Grafana by navigating to Create -> Import and 
clicking on Upload .json file or by simply pasting JSON content.

I've tested this on my OLVM/oVirt 4.3 and works perfectly well.

Have fun!
Michal

Michał Gutowski
Principal Solutions Engineer, EMEA
+48 665 222 979

Oracle Open Cloud Infrastructure Software - Linux & Virtualization

On 24 Nov 2020, at 11:53, Vrgotic, Marko 
mailto:m.vrgo...@activevideo.com>> wrote:

Dear oVirt folks,

Thank you all for suggestions.

I will give it a go and see how far I get.

-
kind regards/met vriendelijke groeten

Marko Vrgotic
Sr. System Engineer @ System Administration

ActiveVideo
o: +31 (35) 6774131
m: +31 (65) 5734174
e: m.vrgo...@activevideo.com<mailto

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Tommy Sway]

The oVirt version I'm using is 4.3, and I get an error when I import JSON.

pq: relation"v4_4_latest_configuration_datacenters" does not exist.

 

 

 

From: users-boun...@ovirt.org  On Behalf Of Michal 
Gutowski
Sent: Wednesday, November 25, 2020 12:26 AM
To: Vrgotic, Marko 
Cc: users@ovirt.org
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

 

Hi Marko,





I've tested this myself as I like playing with various Grafana use-cases and 
following steps allow you to set up Grafana Monitoring for your oVirt 4.3 
environment and re-use all Grafana Dashboards from latest oVirt 4.4 on a 
previous release.

 

1. Allowing Grafana to connect to oVirt DWH database (Data Warehouse)

 

Login to the oVirt engine 4.3 and create a user "grafana" with password 
"grafana" that will get a read-only access to the ovirt_engine_history database 
and will be able to use public schema

 

# su - postgres -c 'scl enable rh-postgresql10 bash'

# psql -U postgres -c "CREATE ROLE grafana WITH LOGIN ENCRYPTED PASSWORD 
'grafana';" -d ovirt_engine_history

# psql -U postgres -c "GRANT CONNECT ON DATABASE ovirt_engine_history TO 
grafana;"

# psql -U postgres -c "GRANT USAGE ON SCHEMA public TO grafana;" 
ovirt_engine_history

 

Generate the rest of the permissions that will be granted to the newly created 
user and save them to a file:

 

# psql -U postgres -c "SELECT 'GRANT SELECT ON ' || relname || ' TO grafana;' 
FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace 
WHERE nspname = 'public' AND relkind IN ('r', 'v');" --pset=tuples_only=on  
ovirt_engine_history > grant.sql

 

Use the file you created in the previous step to grant permissions to the newly 
created user:

# psql -U postgres -f grant.sql ovirt_engine_history

 

Remove the file you used to grant permissions:

# rm grant.sql

 

Exit the postgres user shell by pressing Ctrl+d

 

Add the following lines for the newly created user to 
/var/opt/rh/rh-postgresql10/lib/pgsql/data/pg_hba.conf preceding the line 
beginning local all all

 

hostovirt_engine_history grafana 0.0.0.0/0   md5

hostovirt_engine_history grafana ::0/0   md5

 

Reload postgres service

# systemctl reload rh-postgresql10-postgresql

 

2. Installing Grafana

 

You can install Grafana directly on the oVirt Engine machine (this is how it's 
done in oVirt 4.4) or on a separate machine. Following steps shows how you can 
install Grafana on a Oracle Linux 7 server. Note: Oracle provides Grafana in 
the OLCNE yum repository - you only need to install the repository definition 
package to pickup Grafana and it's dependencies.

 

# yum install oraclelinux-release-el7

# yum install oracle-olcne-release-el7

# yum-config-manager --enable ol7_optional_latest ol7_olcne11

# yum install grafana

# systemctl enable --now grafana-server

 

3. Adding oVirt DWH database as Data Source in Grafana

 

Login to Grafana (default port 3000) and navigate to Configuration -> 
DataSources and click on Add Data Source button.

 

Select PostgreSQL source and use the following settings (adjust the Host IP 
address to match your oVirt Engine IP but do not change the Name):

Name: oVirt DWH

Host: your-engine-ip-address:5432

user: grafana

pass: grafana

SSL mode: disable

 

4. Importing Dashboards from oVirt 4.4

 

Download Grafana Dashboards from oVirt 4.4 repository: 
https://github.com/oVirt/ovirt-dwh/tree/master/packaging/conf/grafana-dashboards

 

You can now import them in Grafana by navigating to Create -> Import and 
clicking on Upload .json file or by simply pasting JSON content.

 

I've tested this on my OLVM/oVirt 4.3 and works perfectly well.

 

Have fun!

Michal





Michał Gutowski

Principal Solutions Engineer, EMEA 

+48 665 222 979

 

Oracle Open Cloud Infrastructure Software - Linux & Virtualization





On 24 Nov 2020, at 11:53, Vrgotic, Marko mailto:m.vrgo...@activevideo.com> > wrote:

 

Dear oVirt folks,

 

Thank you all for suggestions.

 

I will give it a go and see how far I get.

 

-

kind regards/met vriendelijke groeten

 

Marko Vrgotic
Sr. System Engineer @ System Administration


ActiveVideo

o: +31 (35) 6774131

m: +31 (65) 5734174

e:  <mailto:m.vrgo...@activevideo.com> m.vrgo...@activevideo.com
w:  
<https://urldefense.com/v3/__http:/www.activevideo.com__;!!GqivPVa7Brio!MNQGrdvOByNX5QiF5EXb3wflIxSqeuWuLViaoQEV9ucR5lBjqOFxuELf_UYdwIzsG6Wq$>
 www.activevideo.com

 

ActiveVideo Networks BV. Mediacentrum 3745 Joop van den Endeplein 1.1217 WJ 
Hilversum, The Netherlands. The information contained in this message may be 
legally privileged and confidential. It is intended to be read only by the 
individual or entity to whom it is addressed or by their designee. If the 
reader of this message is not the intended recipient, you are on notice that 
any distribution of this message, in any form, is st

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Nardus Geldenhuys]

Hi

Thank you. I did figured it out after a while...

Another question. How can I see LUN utilization ? We had an issue where one LUN 
was over utiliazed, meaning it was hammered by the VM's. We only discovered 
this after the SAN team told us, we moved the VM's storage around it we 
resolved the issue. Is it possible to get a Grafana graph with LUN utilization 
per VM?

Thanks

Nardus
___
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/NJXX3UBTJE54L7XWKRMS27SOHFW6K4Q2/

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Shirly Radco]

Hi Nardus,

We opened the following  [RFE] Add Data Source variable to all dashboards
, where we plan to add
a "Datasource" variable to each dashboard.
This will allow choosing a data source in each dashboard from your data
sources list.

Best regards,

--

Shirly Radco

BI Principal Software Engineer

Red Hat 




On Tue, Apr 13, 2021 at 4:44 PM Nardus Geldenhuys  wrote:

> Hey Michal
>
> Hope you are well. Thank you so much for this write up and all the work
> you put into it.
>
> Do you have a easy way of using different data sources, more than one
> oVirt engine DWH ? Or will I have to adapt all the dashboards to the
> different data sources?
>
> Thanks again
>
> Nardus
> ___
> 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/WVH2NIPY56YCTCBZRPAWKFGS54JTOJLP/
>
___
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/3H66ARBDCYPZ3UWK2GJE3AONIJWY4SD3/

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Nardus Geldenhuys]

Hey Michal

Hope you are well. Thank you so much for this write up and all the work you put 
into it.

Do you have a easy way of using different data sources, more than one oVirt 
engine DWH ? Or will I have to adapt all the dashboards to the different data 
sources?

Thanks again

Nardus
___
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/WVH2NIPY56YCTCBZRPAWKFGS54JTOJLP/

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Vrgotic, Marko]

Hi Michal,

This is fantastic.

Thank you.

-
kind regards/met vriendelijke groeten

Marko Vrgotic
Sr. System Engineer @ System Administration

ActiveVideo
o: +31 (35) 6774131
m: +31 (65) 5734174
e: m.vrgo...@activevideo.com<mailto:m.vrgo...@activevideo.com>
w: www.activevideo.com<http://www.activevideo.com>

ActiveVideo Networks BV. Mediacentrum 3745 Joop van den Endeplein 1.1217 WJ 
Hilversum, The Netherlands. The information contained in this message may be 
legally privileged and confidential. It is intended to be read only by the 
individual or entity to whom it is addressed or by their designee. If the 
reader of this message is not the intended recipient, you are on notice that 
any distribution of this message, in any form, is strictly prohibited.  If you 
have received this message in error, please immediately notify the sender 
and/or ActiveVideo Networks, LLC by telephone at +1 408.931.9200 and delete or 
destroy any copy of this message.



From: Michal Gutowski 
Date: Tuesday, 24 November 2020 at 17:26
To: "Vrgotic, Marko" 
Cc: Yedidyah Bar David , "users@ovirt.org" 
Subject: Re: [ovirt-users] oVirt 4.3 DWH with Grafana


***CAUTION: This email originated from outside of the organization. Do not 
click links or open attachments unless you recognize the sender!!!***
Hi Marko,


I've tested this myself as I like playing with various Grafana use-cases and 
following steps allow you to set up Grafana Monitoring for your oVirt 4.3 
environment and re-use all Grafana Dashboards from latest oVirt 4.4 on a 
previous release.

1. Allowing Grafana to connect to oVirt DWH database (Data Warehouse)

Login to the oVirt engine 4.3 and create a user "grafana" with password 
"grafana" that will get a read-only access to the ovirt_engine_history database 
and will be able to use public schema

# su - postgres -c 'scl enable rh-postgresql10 bash'
# psql -U postgres -c "CREATE ROLE grafana WITH LOGIN ENCRYPTED PASSWORD 
'grafana';" -d ovirt_engine_history
# psql -U postgres -c "GRANT CONNECT ON DATABASE ovirt_engine_history TO 
grafana;"
# psql -U postgres -c "GRANT USAGE ON SCHEMA public TO grafana;" 
ovirt_engine_history

Generate the rest of the permissions that will be granted to the newly created 
user and save them to a file:

# psql -U postgres -c "SELECT 'GRANT SELECT ON ' || relname || ' TO grafana;' 
FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace 
WHERE nspname = 'public' AND relkind IN ('r', 'v');" --pset=tuples_only=on  
ovirt_engine_history > grant.sql

Use the file you created in the previous step to grant permissions to the newly 
created user:
# psql -U postgres -f grant.sql ovirt_engine_history

Remove the file you used to grant permissions:
# rm grant.sql

Exit the postgres user shell by pressing Ctrl+d

Add the following lines for the newly created user to 
/var/opt/rh/rh-postgresql10/lib/pgsql/data/pg_hba.conf preceding the line 
beginning local all all

hostovirt_engine_history grafana 0.0.0.0/0   md5
hostovirt_engine_history grafana ::0/0   md5

Reload postgres service
# systemctl reload rh-postgresql10-postgresql

2. Installing Grafana

You can install Grafana directly on the oVirt Engine machine (this is how it's 
done in oVirt 4.4) or on a separate machine. Following steps shows how you can 
install Grafana on a Oracle Linux 7 server. Note: Oracle provides Grafana in 
the OLCNE yum repository - you only need to install the repository definition 
package to pickup Grafana and it's dependencies.

# yum install oraclelinux-release-el7
# yum install oracle-olcne-release-el7
# yum-config-manager --enable ol7_optional_latest ol7_olcne11
# yum install grafana
# systemctl enable --now grafana-server

3. Adding oVirt DWH database as Data Source in Grafana

Login to Grafana (default port 3000) and navigate to Configuration -> 
DataSources and click on Add Data Source button.

Select PostgreSQL source and use the following settings (adjust the Host IP 
address to match your oVirt Engine IP but do not change the Name):
Name: oVirt DWH
Host: your-engine-ip-address:5432
user: grafana
pass: grafana
SSL mode: disable

4. Importing Dashboards from oVirt 4.4

Download Grafana Dashboards from oVirt 4.4 repository: 
https://github.com/oVirt/ovirt-dwh/tree/master/packaging/conf/grafana-dashboards

You can now import them in Grafana by navigating to Create -> Import and 
clicking on Upload .json file or by simply pasting JSON content.

I've tested this on my OLVM/oVirt 4.3 and works perfectly well.

Have fun!
Michal


Michał Gutowski
Principal Solutions Engineer, EMEA
+48 665 222 979

Oracle Open Cloud Infrastructure Software - Linux & Virtualization


On 24 Nov 2020, at 11:53, Vrgotic, Marko 
mailto:m.vrgo...@activevideo.com>> wrote:

Dear oVirt folks,

Thank you all for suggestions.

I will give it a go and see how far

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Michal Gutowski]

Hi Marko,

I've tested this myself as I like playing with various Grafana use-cases and 
following steps allow you to set up Grafana Monitoring for your oVirt 4.3 
environment and re-use all Grafana Dashboards from latest oVirt 4.4 on a 
previous release.

1. Allowing Grafana to connect to oVirt DWH database (Data Warehouse)

Login to the oVirt engine 4.3 and create a user "grafana" with password 
"grafana" that will get a read-only access to the ovirt_engine_history database 
and will be able to use public schema

# su - postgres -c 'scl enable rh-postgresql10 bash'
# psql -U postgres -c "CREATE ROLE grafana WITH LOGIN ENCRYPTED PASSWORD 
'grafana';" -d ovirt_engine_history
# psql -U postgres -c "GRANT CONNECT ON DATABASE ovirt_engine_history TO 
grafana;"
# psql -U postgres -c "GRANT USAGE ON SCHEMA public TO grafana;" 
ovirt_engine_history

Generate the rest of the permissions that will be granted to the newly created 
user and save them to a file:

# psql -U postgres -c "SELECT 'GRANT SELECT ON ' || relname || ' TO grafana;' 
FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace 
WHERE nspname = 'public' AND relkind IN ('r', 'v');" --pset=tuples_only=on  
ovirt_engine_history > grant.sql

Use the file you created in the previous step to grant permissions to the newly 
created user:
# psql -U postgres -f grant.sql ovirt_engine_history

Remove the file you used to grant permissions:
# rm grant.sql

Exit the postgres user shell by pressing Ctrl+d

Add the following lines for the newly created user to 
/var/opt/rh/rh-postgresql10/lib/pgsql/data/pg_hba.conf preceding the line 
beginning local all all

hostovirt_engine_history grafana 0.0.0.0/0   md5
hostovirt_engine_history grafana ::0/0   md5

Reload postgres service
# systemctl reload rh-postgresql10-postgresql

2. Installing Grafana

You can install Grafana directly on the oVirt Engine machine (this is how it's 
done in oVirt 4.4) or on a separate machine. Following steps shows how you can 
install Grafana on a Oracle Linux 7 server. Note: Oracle provides Grafana in 
the OLCNE yum repository - you only need to install the repository definition 
package to pickup Grafana and it's dependencies.

# yum install oraclelinux-release-el7
# yum install oracle-olcne-release-el7
# yum-config-manager --enable ol7_optional_latest ol7_olcne11
# yum install grafana
# systemctl enable --now grafana-server

3. Adding oVirt DWH database as Data Source in Grafana

Login to Grafana (default port 3000) and navigate to Configuration -> 
DataSources and click on Add Data Source button.

Select PostgreSQL source and use the following settings (adjust the Host IP 
address to match your oVirt Engine IP but do not change the Name):
Name: oVirt DWH
Host: your-engine-ip-address:5432
user: grafana
pass: grafana
SSL mode: disable

4. Importing Dashboards from oVirt 4.4

Download Grafana Dashboards from oVirt 4.4 repository: 
https://github.com/oVirt/ovirt-dwh/tree/master/packaging/conf/grafana-dashboards

You can now import them in Grafana by navigating to Create -> Import and 
clicking on Upload .json file or by simply pasting JSON content.

I've tested this on my OLVM/oVirt 4.3 and works perfectly well.

Have fun!
Michal

Michał Gutowski
Principal Solutions Engineer, EMEA 
+48 665 222 979

Oracle Open Cloud Infrastructure Software - Linux & Virtualization

> On 24 Nov 2020, at 11:53, Vrgotic, Marko  wrote:
> 
> Dear oVirt folks,
>  
> Thank you all for suggestions.
>  
> I will give it a go and see how far I get.
>  
> -
> kind regards/met vriendelijke groeten
>  
> Marko Vrgotic
> Sr. System Engineer @ System Administration
> 
> ActiveVideo
> 
> o: +31 (35) 6774131
> m: +31 (65) 5734174
> e: m.vrgo...@activevideo.com <mailto:m.vrgo...@activevideo.com>
> w: www.activevideo.com 
> <https://urldefense.com/v3/__http://www.activevideo.com__;!!GqivPVa7Brio!MNQGrdvOByNX5QiF5EXb3wflIxSqeuWuLViaoQEV9ucR5lBjqOFxuELf_UYdwIzsG6Wq$>
>  
> ActiveVideo Networks BV. Mediacentrum 3745 Joop van den Endeplein 1.1217 WJ 
> Hilversum, The Netherlands. The information contained in this message may be 
> legally privileged and confidential. It is intended to be read only by the 
> individual or entity to whom it is addressed or by their designee. If the 
> reader of this message is not the intended recipient, you are on notice that 
> any distribution of this message, in any form, is strictly prohibited.  If 
> you have received this message in error, please immediately notify the sender 
> and/or ActiveVideo Networks, LLC by telephone at +1 408.931.9200 and delete 
> or destroy any copy of this message.
>  
>  
>  
> From: Yedidyah Bar David mailto:d...@redhat.com>>
> Date: Sunday, 22 November 2020 at 08:39
> To: "Vrgotic, Marko"  

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Vrgotic, Marko]

Dear oVirt folks,

Thank you all for suggestions.

I will give it a go and see how far I get.

-
kind regards/met vriendelijke groeten

Marko Vrgotic
Sr. System Engineer @ System Administration

ActiveVideo
o: +31 (35) 6774131
m: +31 (65) 5734174
e: m.vrgo...@activevideo.com<mailto:m.vrgo...@activevideo.com>
w: www.activevideo.com<http://www.activevideo.com>

ActiveVideo Networks BV. Mediacentrum 3745 Joop van den Endeplein 1.1217 WJ 
Hilversum, The Netherlands. The information contained in this message may be 
legally privileged and confidential. It is intended to be read only by the 
individual or entity to whom it is addressed or by their designee. If the 
reader of this message is not the intended recipient, you are on notice that 
any distribution of this message, in any form, is strictly prohibited.  If you 
have received this message in error, please immediately notify the sender 
and/or ActiveVideo Networks, LLC by telephone at +1 408.931.9200 and delete or 
destroy any copy of this message.



From: Yedidyah Bar David 
Date: Sunday, 22 November 2020 at 08:39
To: "Vrgotic, Marko" 
Cc: "users@ovirt.org" 
Subject: Re: [ovirt-users] oVirt 4.3 DWH with Grafana


***CAUTION: This email originated from outside of the organization. Do not 
click links or open attachments unless you recognize the sender!!!***
On Fri, Nov 20, 2020 at 8:45 AM Vrgotic, Marko 
mailto:m.vrgo...@activevideo.com>> wrote:
Dear oVirt,

We are currently running oVirt 4.3 and upgrade/migration to 4.4 won’t be 
possible for few more months.

I am looking into guidelines, how to, for setting up Grafana using 
DataWarehouse as data source.

Did anyone already did this, and would be willing to share the steps?

AFAIU this is definitely not tested/recommended/supported, but the current 
(4.4) dashboards use only 4.3 dwh compatibility views. So in theory, 4.4 
grafana setup can work against your 4.3 engine/dwh without problems. So you can 
try something like:

1. Install el8 on some machine
2. Install ovirt-release (4.4!)
3. Install ovirt-engine-dwh-grafana-integration-setup. I *think*, didn't try, 
that it would carry with it all the dependencies it needs.
4. Run engine-setup. When prompted, only accept "Configure grafana?", and reply 
"No" to everything else
5. Follow the other prompts as applicable

This should be enough.

Not sure about the commands to add SSO on the engine machine. Perhaps better 
verify this first against a test engine (can be on another el7/ovirt4.3 VM with 
no hosts).

But, repeating: this isn't recommended.

Did you consider upgrading only your engine, and keep your hosts 4.3 until you 
can upgrade them later?

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

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Yedidyah Bar David]

On Fri, Nov 20, 2020 at 8:45 AM Vrgotic, Marko 
wrote:

> Dear oVirt,
>
>
>
> We are currently running oVirt 4.3 and upgrade/migration to 4.4 won’t be
> possible for few more months.
>
>
>
> I am looking into guidelines, how to, for setting up Grafana using
> DataWarehouse as data source.
>
>
>
> Did anyone already did this, and would be willing to share the steps?
>

AFAIU this is definitely not tested/recommended/supported, but the current
(4.4) dashboards use only 4.3 dwh compatibility views. So in theory, 4.4
grafana setup can work against your 4.3 engine/dwh without problems. So you
can try something like:

1. Install el8 on some machine
2. Install ovirt-release (4.4!)
3. Install ovirt-engine-dwh-grafana-integration-setup. I *think*, didn't
try, that it would carry with it all the dependencies it needs.
4. Run engine-setup. When prompted, only accept "Configure grafana?", and
reply "No" to everything else
5. Follow the other prompts as applicable

This should be enough.

Not sure about the commands to add SSO on the engine machine. Perhaps
better verify this first against a test engine (can be on another
el7/ovirt4.3 VM with no hosts).

But, repeating: this isn't recommended.

Did you consider upgrading only your engine, and keep your hosts 4.3 until
you can upgrade them later?

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

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Michal Gutowski]

Additionally you can also install official Prometheus Node_Exporter  on each of 
your KVM hosts and that will give you tons of operating system metrics. This is 
not "ovirt aware", so you will not see any ovirt objects related metrics but 
will allow you to keep an eye on your kvm hosts performance.

Binaries: https://github.com/prometheus/node_exporter
Example Dashboard: https://grafana.com/grafana/dashboards/1860

Cheers,
Michal

Michał Gutowski
Principal Solutions Engineer, EMEA 
+48 665 222 979

Oracle Open Cloud Infrastructure Software - Linux & Virtualization

> On 20 Nov 2020, at 18:30, Vincent Royer  wrote:
> 
> I found it much easier to ignore all the DataWarehouse stuff and used a 
> project called prometheus Ovirt Exporter, spun up in a docker host, and use 
> the prom datasource in Grafana.  I was up and running with good Ovirt metrics 
> in minutes. 
> 
> Vincent Royer
> 778-825-1057
> 
> 
> SUSTAINABLE MOBILE ENERGY SOLUTIONS
> 
> 
> 
> 
> 
> On Thu, Nov 19, 2020 at 10:46 PM Vrgotic, Marko  
> wrote:
> Dear oVirt,
> 
>  
> 
> We are currently running oVirt 4.3 and upgrade/migration to 4.4 won’t be 
> possible for few more months.
> 
>  
> 
> I am looking into guidelines, how to, for setting up Grafana using 
> DataWarehouse as data source.
> 
>  
> 
> Did anyone already did this, and would be willing to share the steps?
> 
>  
> 
> Kindly awaiting your reply.
> 
> -
> 
> kind regards/met vriendelijke groeten
> 
>  
> 
> Marko Vrgotic
> Sr. System Engineer @ System Administration
> 
> 
> ActiveVideo
> 
> o: +31 (35) 6774131
> 
> m: +31 (65) 5734174
> 
> e: m.vrgo...@activevideo.com
> w: www.activevideo.com
> 
>  
> 
> ActiveVideo Networks BV. Mediacentrum 3745 Joop van den Endeplein 1.1217 WJ 
> Hilversum, The Netherlands. The information contained in this message may be 
> legally privileged and confidential. It is intended to be read only by the 
> individual or entity to whom it is addressed or by their designee. If the 
> reader of this message is not the intended recipient, you are on notice that 
> any distribution of this message, in any form, is strictly prohibited.  If 
> you have received this message in error, please immediately notify the sender 
> and/or ActiveVideo Networks, LLC by telephone at +1 408.931.9200 and delete 
> or destroy any copy of this message.
> 
>  
> 
>  
> 
> ___
> 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/LNTAUADVSD33NDQA5DFJGEID3GKV4RO5/
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: 
> https://urldefense.com/v3/__https://www.ovirt.org/privacy-policy.html__;!!GqivPVa7Brio!JuZkGrwWVEVcjmzdWe4l75c2Kd6JIwt1iQzLra0sdKH9p7-vjOW83OYw9WF7jqgQFtzm$
>  
> oVirt Code of Conduct: 
> https://urldefense.com/v3/__https://www.ovirt.org/community/about/community-guidelines/__;!!GqivPVa7Brio!JuZkGrwWVEVcjmzdWe4l75c2Kd6JIwt1iQzLra0sdKH9p7-vjOW83OYw9WF7jvSmUw1S$
>  
> List Archives: 
> https://urldefense.com/v3/__https://lists.ovirt.org/archives/list/users@ovirt.org/message/H67LRXNEY7UGRY4OWYDX2YY7CDYZ46CH/__;!!GqivPVa7Brio!JuZkGrwWVEVcjmzdWe4l75c2Kd6JIwt1iQzLra0sdKH9p7-vjOW83OYw9WF7jtWY9kod$
>  
___
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/VKEN2EVDN45RJPVT6YP4M6PLZPUABQR5/

[ovirt-users] Re: oVirt 4.3 DWH with Grafana

[Vincent Royer]

I found it much easier to ignore all the DataWarehouse stuff and used a
project called prometheus Ovirt Exporter, spun up in a docker host, and use
the prom datasource in Grafana.  I was up and running with good Ovirt
metrics in minutes.

*Vincent Royer*
*778-825-1057*



*SUSTAINABLE MOBILE ENERGY SOLUTIONS*





On Thu, Nov 19, 2020 at 10:46 PM Vrgotic, Marko 
wrote:

> Dear oVirt,
>
>
>
> We are currently running oVirt 4.3 and upgrade/migration to 4.4 won’t be
> possible for few more months.
>
>
>
> I am looking into guidelines, how to, for setting up Grafana using
> DataWarehouse as data source.
>
>
>
> Did anyone already did this, and would be willing to share the steps?
>
>
>
> Kindly awaiting your reply.
>
> -
>
> kind regards/met vriendelijke groeten
>
>
>
> Marko Vrgotic
> Sr. System Engineer @ System Administration
>
>
> ActiveVideo
>
> *o: *+31 (35) 6774131
>
> *m: +*31 (65) 5734174
>
> *e:* m.vrgo...@activevideo.com
> *w: *www.activevideo.com
>
>
>
> ActiveVideo Networks BV. Mediacentrum 3745 Joop van den Endeplein 1.1217
> WJ Hilversum, The Netherlands. The information contained in this message
> may be legally privileged and confidential. It is intended to be read only
> by the individual or entity to whom it is addressed or by their designee.
> If the reader of this message is not the intended recipient, you are on
> notice that any distribution of this message, in any form, is strictly
> prohibited.  If you have received this message in error, please immediately
> notify the sender and/or ActiveVideo Networks, LLC by telephone at +1
> 408.931.9200 and delete or destroy any copy of this message.
>
>
>
>
> ___
> 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/LNTAUADVSD33NDQA5DFJGEID3GKV4RO5/
>
___
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/H67LRXNEY7UGRY4OWYDX2YY7CDYZ46CH/