7:18 p.m.
New subject: New post on oVirt blog: Build oVirt Reports Using Grafana
--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}
7:37 p.m.
New subject: New post on oVirt blog: Build oVirt Reports Using Grafana
We ship postgres 9.5 through the Software Collection. Its missing from your
path by default, so in order to run psql you need to:
su - postgres
scl enable rh-postgresql95 -- psql engine engine
On Mon, 22 Jan 2018 at 18:19 <andreil1(a)starlett.lv> wrote:
On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1(a)ya.ru> wrote:
Good day,
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’t work at all.
Best regards,
Mikhail.
17:58, 22 января 2018 г., Andrei V <andreil1(a)starlett.lv>:
Hi !
Thanks a lot for excellent addition !
I’ve 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_Acc...
However, from Grafana login is is always failed:
pq: Ident authentication failed for user “usrmonovirt"
host = localhost:5432, database = ovirt_engine_history, SSL = disable
Reset password with another or even NULL don’t help, still can’t connect.
psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD ‘mypassword';"
-d ovirt_engine_history
psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;” -d
ovirt_engine_history
What went wrong? I can’t 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:
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>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
9:09 p.m.
New subject: New post on oVirt blog: Build oVirt Reports Using Grafana
On 01/22/2018 06:37 PM, Roy Golan wrote:
We ship postgres 9.5 through the Software Collection. Its missing
from your
path by default, so in order to run psql you need to:
su - postgres
scl enable rh-postgresql95 -- psql engine engine
scl enable rh-postgresql95 -- psql engine engine
psql: FATAL: Peer authentication failed for user "engine"
Sorry, should it be:?
scl enable rh-postgresql95 -- psql engine
Do I need to re-enter everything for read-only oVirt DWH user ?
On Mon, 22 Jan 2018 at 18:19 <andreil1(a)starlett.lv> wrote:
> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1(a)ya.ru> wrote:
>
> Good day,
>
> 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’t work at all.
>
>
> Best regards,
>
> Mikhail.
>
> 17:58, 22 января 2018 г., Andrei V <andreil1(a)starlett.lv>:
>
> Hi !
>
> Thanks a lot for excellent addition !
>
> I’ve 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_Acc...
>
> However, from Grafana login is is always failed:
> pq: Ident authentication failed for user “usrmonovirt"
> host = localhost:5432, database = ovirt_engine_history, SSL = disable
>
> Reset password with another or even NULL don’t help, still can’t connect.
> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD
‘mypassword';"
> -d ovirt_engine_history
> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;” -d
> ovirt_engine_history
>
> What went wrong? I can’t 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:
>
> 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>
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
>
> Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
>
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
9:57 p.m.
New subject: New post on oVirt blog: Build oVirt Reports Using Grafana
On Mon, Jan 22, 2018, 8:10 PM Andrei V <andreil1(a)starlett.lv> wrote:
On 01/22/2018 06:37 PM, Roy Golan wrote:
> We ship postgres 9.5 through the Software Collection. Its missing from
your
> path by default, so in order to run psql you need to:
>
> su - postgres
> scl enable rh-postgresql95 -- psql engine engine
scl enable rh-postgresql95 -- psql engine engine
psql: FATAL: Peer authentication failed for user "engine"
Sorry, should it be:?
scl enable rh-postgresql95 -- psql engine
Do I need to re-enter everything for read-only oVirt DWH user ?
I think so.
> On Mon, 22 Jan 2018 at 18:19 <andreil1(a)starlett.lv> wrote:
>
>> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1(a)ya.ru> wrote:
>>
>> Good day,
>>
>> 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’t work at all.
>>
>>
>> Best regards,
>>
>> Mikhail.
>>
>> 17:58, 22 января 2018 г., Andrei V <andreil1(a)starlett.lv>:
>>
>> Hi !
>>
>> Thanks a lot for excellent addition !
>>
>> I’ve 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_Acc...
>>
>> However, from Grafana login is is always failed:
>> pq: Ident authentication failed for user “usrmonovirt"
>> host = localhost:5432, database = ovirt_engine_history, SSL = disable
>>
>> Reset password with another or even NULL don’t help, still can’t
connect.
>> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD
‘mypassword';"
>> -d ovirt_engine_history
>> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;” -d
>> ovirt_engine_history
>>
>> What went wrong? I can’t 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:
>>
>> 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>
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>>
>> Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
>>
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
2:55 p.m.
New subject: New post on oVirt blog: Build oVirt Reports Using Grafana
Hi,
Did you manage to connect Grafana to DWH?
Best regards,
--
SHIRLY RADCO
BI SOFTWARE ENGINEER
Red Hat Israel

TRIED. TESTED. TRUSTED.
On Jan 22, 2018 20:10, "Andrei V" <andreil1(a)starlett.lv> wrote:
On 01/22/2018 06:37 PM, Roy Golan wrote:
> We ship postgres 9.5 through the Software Collection. Its missing from
your
> path by default, so in order to run psql you need to:
>
> su - postgres
> scl enable rh-postgresql95 -- psql engine engine
scl enable rh-postgresql95 -- psql engine engine
psql: FATAL: Peer authentication failed for user "engine"
Sorry, should it be:?
scl enable rh-postgresql95 -- psql engine
Do I need to re-enter everything for read-only oVirt DWH user ?
>
> On Mon, 22 Jan 2018 at 18:19 <andreil1(a)starlett.lv> wrote:
>
>> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1(a)ya.ru> wrote:
>>
>> Good day,
>>
>> 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’t work at all.
>>
>>
>> Best regards,
>>
>> Mikhail.
>>
>> 17:58, 22 января 2018 г., Andrei V <andreil1(a)starlett.lv>:
>>
>> Hi !
>>
>> Thanks a lot for excellent addition !
>>
>> I’ve 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_Access_to_the_History_Database/
>>
>> However, from Grafana login is is always failed:
>> pq: Ident authentication failed for user “usrmonovirt"
>> host = localhost:5432, database = ovirt_engine_history, SSL = disable
>>
>> Reset password with another or even NULL don’t help, still can’t
connect.
>> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD
‘mypassword';"
>> -d ovirt_engine_history
>> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;” -d
>> ovirt_engine_history
>>
>> What went wrong? I can’t 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:
>>
>> 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>
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>>
>> Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
>>
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
2494
days inactive
2496
days old
5 comments
5 participants
participants (5)
-
Andrei V -
andreil1＠starlett.lv
-
Mikhail Krasnobaev -
Roy Golan -
Shirly Radco