> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <[email protected]> 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 <[email protected]>: > 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/ > > <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 <[email protected] >> <mailto:[email protected]>> 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/ >> <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 >> [email protected] <mailto:[email protected]> >> http://lists.ovirt.org/mailman/listinfo/users >> <http://lists.ovirt.org/mailman/listinfo/users> > > _______________________________________________ > Users mailing list > [email protected] <mailto:[email protected]> > http://lists.ovirt.org/mailman/listinfo/users > <http://lists.ovirt.org/mailman/listinfo/users> > > > Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
