[ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana

[Roy Golan]

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 at starlett.lv> wrote:

>
> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1 at 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 at 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 at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
>
> Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180122/9a5565d2/attachment.html>