On Mon, Jan 22, 2018, 8:10 PM Andrei V <[email protected]> wrote: > 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 <[email protected]> wrote: > > > >> 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/ > >> > >> 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]> 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 > >> [email protected] > >> http://lists.ovirt.org/mailman/listinfo/users > >> > >> > >> _______________________________________________ > >> Users mailing list > >> [email protected] > >> 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 > >> > > _______________________________________________ > Users mailing list > [email protected] > http://lists.ovirt.org/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
