Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana
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--
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@starlett.lv> wrote:
On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1@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@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...
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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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@starlett.lv> wrote:
On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1@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@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...
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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
On Mon, Jan 22, 2018, 8:10 PM Andrei V <andreil1@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@starlett.lv> wrote:
On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1@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@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...
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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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@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@starlett.lv> wrote:
On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1@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@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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (5)
-
Andrei V -
andreil1＠starlett.lv
-
Mikhail Krasnobaev -
Roy Golan -
Shirly Radco