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

On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1(a)ya.ru&gt; 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&gt;: 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&gt; 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