3:21 p.m.
Hello everyone,
A new oVirt blog post has been published, on how to build oVirt reports
using Grafana.
This allows connecting to oVirt DWH and create dashboards for System,
Hosts, VMs, Storage domains etc.
See https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/ for the full
post.
For more information you can contact me.
Best regards,
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
6:57 p.m.
--Apple-Mail=_C380FEE6-D294-4EC1-95F0-9E030069A1FE
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=utf-8
Hi !
Thanks a lot for excellent addition !
I=E2=80=99ve got a problem with connecting Grafana to oVirt 4.2
Followed this instruction and created read-only user usrmonovirt
# =
https://www.ovirt.org/documentation/data-warehouse/Allowing_Read_Only_Acce=
ss_to_the_History_Database/
However, from Grafana login is is always failed:
pq: Ident authentication failed for user =E2=80=9Cusrmonovirt"
host =3D localhost:5432, database =3D ovirt_engine_history, SSL =3D =
disable
Reset password with another or even NULL don=E2=80=99t help, still =
can=E2=80=99t connect.
psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD =
=E2=80=98mypassword';" -d ovirt_engine_history
psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;=E2=80=9D =
-d ovirt_engine_history
What went wrong? I can=E2=80=99t understand.
PS. Looks like oVirt engine spawns PostgreSQL with its own data dir, =
standard restart via systemcll returns an error (data dir is empty). Yet =
"ps -aux | grep postgres" shows process is running.
Thanks in advance for any suggestion(s).
On 21 Jan 2018, at 14:21, Shirly Radco <sradco(a)redhat.com>
wrote:
=20
Hello everyone,=20
=20
A new oVirt blog post has been published, on how to build oVirt =
reports using
Grafana.
This allows connecting to oVirt DWH and create dashboards for System,
=
Hosts, VMs, Storage domains etc.
<https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/> for the =
full post.
=20
For more information you can contact me.
=20
Best regards,
--
SHIRLY RADCO
BI SENIOR SOFTWARE ENGINEER
Red Hat=C2=A0Israel <https://www.redhat.com/>
<https://red.ht/sig>=09
TRIED. TESTED. TRUSTED. =
<https://redhat.com/trusted>___________________________________________...
_
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
--Apple-Mail=_C380FEE6-D294-4EC1-95F0-9E030069A1FE
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset=utf-8
<html><head><meta http-equiv=3D"Content-Type"
content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;"
class=3D""><div =
class=3D"">Hi !</div><div class=3D""><br
class=3D""></div><div =
class=3D"">Thanks a lot for excellent addition !</div><div
class=3D""><br =
class=3D""></div><div class=3D"">I=E2=80=99ve got a
problem with =
connecting Grafana to oVirt 4.2</div><div class=3D"">Followed this
=
instruction and created read-only user usrmonovirt</div><div =
class=3D""># <a =
href=3D"https://www.ovirt.org/documentation/data-warehouse/Allowing_...
nly_Access_to_the_History_Database/" =
class=3D"">https://www.ovirt.org/documentation/data-warehous...
d_Only_Access_to_the_History_Database/</a></div><div
class=3D""><br =
class=3D""></div>However, from Grafana login is is always
failed:<div =
class=3D"">pq: Ident authentication failed for user =
=E2=80=9Cusrmonovirt"</div><div class=3D"">host =3D
localhost:5432, =
database =3D ovirt_engine_history, SSL =3D disable</div><div =
class=3D""><br class=3D""></div><div
class=3D"">Reset password with =
another or even NULL don=E2=80=99t help, still can=E2=80=99t =
connect.</div><div class=3D"">psql -U postgres -c "ALTER ROLE
=
usrmonovirt WITH PASSWORD =E2=80=98mypassword';" -d =
ovirt_engine_history</div><div class=3D"">psql -U postgres -c
"ALTER =
ROLE usrmonovirt WITH PASSWORD NULL;=E2=80=9D -d =
ovirt_engine_history</div><div class=3D""><br
class=3D""></div><div =
class=3D"">What went wrong? I can=E2=80=99t understand.</div><div =
class=3D""><br class=3D""></div><div
class=3D"">PS. Looks like oVirt =
engine spawns PostgreSQL with its own data dir, standard restart via =
systemcll returns an error (data dir is empty). Yet "ps -aux | grep =
postgres" shows process is running.</div><div class=3D""><br
=
class=3D""></div><div class=3D"">Thanks in advance for
any =
suggestion(s).</div><div class=3D""><br class=3D"">
<div><br class=3D""><blockquote type=3D"cite"
class=3D""><div =
class=3D"">On 21 Jan 2018, at 14:21, Shirly Radco <<a =
href=3D"mailto:sradco@redhat.com"
class=3D"">sradco(a)redhat.com</a>&gt; =
wrote:</div><br class=3D"Apple-interchange-newline"><div
class=3D""><div =
dir=3D"ltr" class=3D"">Hello everyone, <div
class=3D""><br =
class=3D""></div><div class=3D""><span
style=3D"font-size:12.8px" =
class=3D"">A new oVirt </span><span
class=3D"gmail-il" =
style=3D"font-size:12.8px">blog</span><span
style=3D"font-size:12.8px" =
class=3D""> post has been published, on how </span>to
build =
oVirt reports using Grafana.</div><div class=3D"">This allows
connecting =
to oVirt DWH and create dashboards for System, Hosts, VMs, Storage =
domains etc.</div><div class=3D""><br
class=3D""></div><div =
class=3D""><span style=3D"font-size:12.8px"
class=3D"">See </span><a =
href=3D"https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/&q... =
class=3D"">https://ovirt.org/blog/2018/01/ovirt-report-using...
nbsp;<span style=3D"font-size:12.8px" class=3D"">for the full =
post.</span></div><div class=3D""><br
class=3D""></div><div class=3D"">For=
more information you can contact me.</div><div class=3D""><br =
class=3D""></div><div class=3D"">Best regards,<br
clear=3D"all" =
class=3D""><div class=3D""><div
class=3D"gmail_signature"><div dir=3D"ltr"=
class=3D""><div class=3D""><div dir=3D"ltr"
class=3D""><div =
class=3D""><div dir=3D"ltr" class=3D""><div
dir=3D"ltr" class=3D""><div =
dir=3D"ltr" class=3D""><div dir=3D"ltr"
class=3D""><div dir=3D"ltr" =
class=3D""><div dir=3D"ltr" class=3D""><div
dir=3D"ltr" class=3D""><div =
dir=3D"ltr" class=3D""><pre cols=3D"72"
style=3D"white-space:pre-wrap" =
class=3D""><span =
style=3D"font-family:arial,helvetica,sans-serif;font-size:12.8px" =
class=3D""><font color=3D"#666666"
class=3D"">--</font></span></pre><div =
style=3D"font-family: overpass, sans-serif; font-weight: bold; margin: =
0px; padding: 0px; font-size: 14px; text-transform: uppercase;" =
class=3D""><span
class=3D"">SHIRLY</span> <span =
class=3D"">RADCO</span></div><p style=3D"font-family:
overpass, =
sans-serif; font-size: 10px; margin: 0px 0px 4px; text-transform: =
uppercase;" class=3D""><span class=3D"">BI SeNIOR
SOFTWARE =
ENGINEER</span><span style=3D"color:rgb(170,170,170);margin:0px" =
class=3D""></span></p><div style=3D"font-family:
overpass, sans-serif; =
margin: 0px; font-size: 10px; color: rgb(153, 153, 153);"
class=3D""><a =
href=3D"https://www.redhat.com/" =
style=3D"color:rgb(0,136,206);margin:0px;text-decoration:none" =
target=3D"_blank" class=3D"">Red Hat <span =
class=3D"">Israel</span></a></div><table
border=3D"0" =
style=3D"font-family: overpass, sans-serif; font-size: inherit;" =
class=3D""><tbody class=3D""><tr
class=3D""><td width=3D"100px" =
class=3D""><a href=3D"https://red.ht/sig"
target=3D"_blank" =
class=3D""><img =
src=3D"https://www.redhat.com/files/brand/email/sig-redhat.png" =
width=3D"90" height=3D"auto"
class=3D""></a></td><td =
style=3D"font-size:10px" class=3D""><div
class=3D""><a =
href=3D"https://redhat.com/trusted" =
style=3D"text-decoration:none;color:rgb(204,0,0);font-weight:bold" =
target=3D"_blank" class=3D"">TRIED. TESTED. =
TRUSTED.</a></div></td></tr></tbody></table></div></div></div></div></div>=
</div></div></div></div></div></div></div></div></div>
</div></div>
_______________________________________________<br class=3D"">Users =
mailing list<br class=3D""><a href=3D"mailto:Users@ovirt.org"
=
class=3D"">Users(a)ovirt.org</a><br =
class=3D"">http://lists.ovirt.org/mailman/listinfo/users<br =
class=3D""></div></blockquote></div><br
class=3D""></div></body></html>=
--Apple-Mail=_C380FEE6-D294-4EC1-95F0-9E030069A1FE--
![src=3D"https://www.redhat.com/files/brand/email/sig-redhat.png"](http://src=3D"https://www.redhat.com/files/brand/email/sig-redhat.png%22){kind=link}
2496
days inactive
2497
days old
1 comments
2 participants
participants (2)
-
Andrei V -
Shirly Radco