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

[Andrei V]

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/ <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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180122/b90407ef/attachment.html>