<div dir="auto">Hi,<div dir="auto"><br></div><div dir="auto">Did you manage to connect Grafana to DWH?</div><div dir="auto"><br></div><div dir="auto">Best regards,<br><br><div data-smartmail="gmail_signature" dir="auto">--<br><br>SHIRLY RADCO<br><br>BI SOFTWARE ENGINEER<br><br>Red Hat Israel<br><br><br><br>TRIED. TESTED. TRUSTED.<br><br> </div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Jan 22, 2018 20:10, "Andrei V" <<a href="mailto:andreil1@starlett.lv">andreil1@starlett.lv</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 01/22/2018 06:37 PM, Roy Golan wrote:<br>
> We ship postgres 9.5 through the Software Collection. Its missing from your<br>
> path by default, so in order to run psql you need to:<br>
><br>
> su - postgres<br>
> scl enable rh-postgresql95 -- psql engine engine<br>
<br>
scl enable rh-postgresql95 -- psql engine engine<br>
psql: FATAL: Peer authentication failed for user "engine"<br>
<br>
Sorry, should it be:?<br>
scl enable rh-postgresql95 -- psql engine<br>
<br>
Do I need to re-enter everything for read-only oVirt DWH user ?<br>
<br>
><br>
> On Mon, 22 Jan 2018 at 18:19 <<a href="mailto:andreil1@starlett.lv">andreil1@starlett.lv</a>> wrote:<br>
><br>
>> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <<a href="mailto:milo1@ya.ru">milo1@ya.ru</a>> wrote:<br>
>><br>
>> Good day,<br>
>><br>
>> i had the same issue, you can try running the commands directly from<br>
>> postgres user:<br>
>> su - postgres<br>
>> And the run the commands from blog post.<br>
>><br>
>><br>
>> I did everything as user postgres, otherwise it doesn’t work at all.<br>
>><br>
>><br>
>> Best regards,<br>
>><br>
>> Mikhail.<br>
>><br>
>> 17:58, 22 января 2018 г., Andrei V <<a href="mailto:andreil1@starlett.lv">andreil1@starlett.lv</a>>:<br>
>><br>
>> Hi !<br>
>><br>
>> Thanks a lot for excellent addition !<br>
>><br>
>> I’ve got a problem with connecting Grafana to oVirt 4.2<br>
>> Followed this instruction and created read-only user usrmonovirt<br>
>> #<br>
>> <a href="https://www.ovirt.org/documentation/data-warehouse/Allowing_Read_Only_Access_to_the_History_Database/" rel="noreferrer" target="_blank">https://www.ovirt.org/<wbr>documentation/data-warehouse/<wbr>Allowing_Read_Only_Access_to_<wbr>the_History_Database/</a><br>
>><br>
>> However, from Grafana login is is always failed:<br>
>> pq: Ident authentication failed for user “usrmonovirt"<br>
>> host = localhost:5432, database = ovirt_engine_history, SSL = disable<br>
>><br>
>> Reset password with another or even NULL don’t help, still can’t connect.<br>
>> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD ‘mypassword';"<br>
>> -d ovirt_engine_history<br>
>> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;” -d<br>
>> ovirt_engine_history<br>
>><br>
>> What went wrong? I can’t understand.<br>
>><br>
>> PS. Looks like oVirt engine spawns PostgreSQL with its own data dir,<br>
>> standard restart via systemcll returns an error (data dir is empty). Yet<br>
>> "ps -aux | grep postgres" shows process is running.<br>
>><br>
>> Thanks in advance for any suggestion(s).<br>
>><br>
>><br>
>> On 21 Jan 2018, at 14:21, Shirly Radco <<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>> wrote:<br>
>><br>
>> Hello everyone,<br>
>><br>
>> A new oVirt blog post has been published, on how to build oVirt reports<br>
>> using Grafana.<br>
>> This allows connecting to oVirt DWH and create dashboards for System,<br>
>> Hosts, VMs, Storage domains etc.<br>
>><br>
>> See <a href="https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/" rel="noreferrer" target="_blank">https://ovirt.org/blog/2018/<wbr>01/ovirt-report-using-grafana/</a> for the<br>
>> full post.<br>
>><br>
>> For more information you can contact me.<br>
>><br>
>> Best regards,<br>
>><br>
>> --<br>
>><br>
>> SHIRLY RADCO<br>
>><br>
>> BI SeNIOR SOFTWARE ENGINEER<br>
>> Red Hat Israel <<a href="https://www.redhat.com/" rel="noreferrer" target="_blank">https://www.redhat.com/</a>><br>
>> <<a href="https://red.ht/sig" rel="noreferrer" target="_blank">https://red.ht/sig</a>><br>
>> TRIED. TESTED. TRUSTED. <<a href="https://redhat.com/trusted" rel="noreferrer" target="_blank">https://redhat.com/trusted</a>><br>
>> ______________________________<wbr>_________________<br>
>> Users mailing list<br>
>> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
>> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
>><br>
>><br>
>> ______________________________<wbr>_________________<br>
>> Users mailing list<br>
>> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
>> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
>><br>
>><br>
>><br>
>> Sent from Yandex.Mail for mobile: <a href="http://m.ya.ru/ymail" rel="noreferrer" target="_blank">http://m.ya.ru/ymail</a><br>
>><br>
>> ______________________________<wbr>_________________<br>
>> Users mailing list<br>
>> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
>> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
>><br>
<br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
</blockquote></div></div>