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