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