7:18 p.m.
--Apple-Mail=_C76ADB10-58EB-4D82-9129-AB15D3E70563
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=utf-8
On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1(a)ya.ru>
wrote:
=20
Good day,
=20
i had the same issue, you can try running the commands directly from =
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(a)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(a)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.
<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 <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users =
<http://lists.ovirt.org/mailman/listinfo/users>
=20
_______________________________________________
Users mailing list
Users(a)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(a)ya.ru</a>&gt; =
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_...
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 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(a)redhat.com</a>&gt; =
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/&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""><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(a)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<... =
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(a)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<... =
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--
![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}