On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1@ya.ru> wrote: =20 Good day, =20 i had the same issue, you can try running the commands directly from =
--Apple-Mail=_C76ADB10-58EB-4D82-9129-AB15D3E70563 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 postgres user:
su - postgres And the run the commands from blog post.
I did everything as user postgres, otherwise it doesn=E2=80=99t work at = all.
=20 Best regards, =20 Mikhail. =20 17:58, 22 =D1=8F=D0=BD=D0=B2=D0=B0=D1=80=D1=8F 2018 =D0=B3., Andrei V = <andreil1@starlett.lv>: Hi ! =20 Thanks a lot for excellent addition ! =20 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/ = <https://www.ovirt.org/documentation/data-warehouse/Allowing_Read_Only_Acc= ess_to_the_History_Database/> =20 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 =20 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 =20 What went wrong? I can=E2=80=99t understand. =20 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. =20 Thanks in advance for any suggestion(s). =20 =20
On 21 Jan 2018, at 14:21, Shirly Radco <sradco@redhat.com = <mailto: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 <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users = <http://lists.ovirt.org/mailman/listinfo/users> =20
Users mailing list Users@ovirt.org <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users = <http://lists.ovirt.org/mailman/listinfo/users> =20 =20 Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
--Apple-Mail=_C76ADB10-58EB-4D82-9129-AB15D3E70563 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""><br = class=3D""><div><br class=3D""><blockquote type=3D"cite" class=3D""><div = class=3D"">On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <<a = href=3D"mailto:milo1@ya.ru" class=3D"">milo1@ya.ru</a>> = wrote:</div><br class=3D"Apple-interchange-newline"><div class=3D"">Good = day,<div class=3D""><br class=3D""></div><div class=3D"">i had the same = issue, you can try running the commands directly from postgres = user:</div><div class=3D"">su - postgres</div><div class=3D"">And the = run the commands from blog post.</div></div></blockquote><div><br = class=3D""></div><div>I did everything as user postgres, otherwise it = doesn=E2=80=99t work at all.</div><br class=3D""><blockquote type=3D"cite"= class=3D""><div class=3D""><div class=3D""><br class=3D""></div><div = class=3D"">Best regards,</div><div class=3D""><br class=3D""></div><div = class=3D"">Mikhail.<br class=3D""><br class=3D"">17:58, 22 =D1=8F=D0=BD=D0= =B2=D0=B0=D1=80=D1=8F 2018 =D0=B3., Andrei V <<a = href=3D"mailto:andreil1@starlett.lv" = class=3D"">andreil1@starlett.lv</a>>:<br class=3D""><blockquote = class=3D""><div 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 class=3D""><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""><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 style=3D"font-size:12.8px;" = class=3D"">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""><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;paddi= ng: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:r= gb(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""><a = href=3D"http://lists.ovirt.org/mailman/listinfo/users" = class=3D"">http://lists.ovirt.org/mailman/listinfo/users</a><br = class=3D""></div></blockquote></div><br class=3D""></div></div><p = class=3D"">_______________________________________________<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""><a href=3D"http://lists.ovirt.org/mailman/listinfo/users" = class=3D"">http://lists.ovirt.org/mailman/listinfo/users</a><br = class=3D""></p></blockquote><br class=3D""><br class=3D"">Sent from = Yandex.Mail for mobile: <a href=3D"http://m.ya.ru/ymail" = class=3D"">http://m.ya.ru/ymail</a></div></div></blockquote></div><br = class=3D""></body></html>= --Apple-Mail=_C76ADB10-58EB-4D82-9129-AB15D3E70563--