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

[andreil1 at starlett.lv]

> 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/ <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 <mailto: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 <mailto:Users at ovirt.org>
>> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
> 
> _______________________________________________
> Users mailing list
> Users at ovirt.org <mailto:Users at ovirt.org>
> 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

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