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

[Andrei V]

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 ?

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