Re: [ovirt-users] 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 ?

I think so.

> On Mon, 22 Jan 2018 at 18:19 <andreil1(a)starlett.lv&gt; wrote: > >> 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 >> _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users