New post on oVirt blog: Build oVirt Reports Using Grafana
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>
--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@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. =20 See https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/ = <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@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_Read_O= nly_Access_to_the_History_Database/" = class=3D"">https://www.ovirt.org/documentation/data-warehouse/Allowing_Rea= 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@redhat.com</a>> = 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/" = class=3D"">https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/</a>&= 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@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--
participants (2)
-
Andrei V -
Shirly Radco