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

[Roy Golan]

On Mon, Jan 22, 2018, 8:10 PM Andrei V <andreil1 at starlett.lv> 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 <andreil1 at starlett.lv> wrote:
> >
> >> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1 at ya.ru> 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 at starlett.lv>:
> >>
> >> 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 <sradco at redhat.com> 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 at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> >>
> >>
> >> Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180122/a471dd01/attachment.html>