<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class="">Hi !</div><div class=""><br class=""></div><div class="">Thanks a lot for excellent addition !</div><div class=""><br class=""></div><div class="">I’ve got a problem with connecting Grafana to oVirt 4.2</div><div class="">Followed this instruction and created read-only user&nbsp;usrmonovirt</div><div class=""># <a href="https://www.ovirt.org/documentation/data-warehouse/Allowing_Read_Only_Access_to_the_History_Database/" class="">https://www.ovirt.org/documentation/data-warehouse/Allowing_Read_Only_Access_to_the_History_Database/</a></div><div class=""><br class=""></div>However, from Grafana login is is always failed:<div class="">pq: Ident authentication failed for user “usrmonovirt"</div><div class="">host = localhost:5432, database =&nbsp;ovirt_engine_history, SSL = disable</div><div class=""><br class=""></div><div class="">Reset password with another or even NULL don’t help, still can’t connect.</div><div class="">psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD ‘mypassword';" -d ovirt_engine_history</div><div class="">psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;” &nbsp;-d ovirt_engine_history</div><div class=""><br class=""></div><div class="">What went wrong? I can’t understand.</div><div class=""><br class=""></div><div class="">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.</div><div class=""><br class=""></div><div class="">Thanks in advance for any suggestion(s).</div><div class=""><br class="">
<div><br class=""><blockquote type="cite" class=""><div class="">On 21 Jan 2018, at 14:21, Shirly Radco &lt;<a href="mailto:sradco@redhat.com" class="">sradco@redhat.com</a>&gt; wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hello everyone,&nbsp;<div class=""><br class=""></div><div class=""><span style="font-size:12.8px" class="">A new oVirt&nbsp;</span><span class="gmail-il" style="font-size:12.8px">blog</span><span style="font-size:12.8px" class="">&nbsp;post has been published, on how&nbsp;</span>to build oVirt reports using Grafana.</div><div class="">This allows connecting to oVirt DWH and create dashboards for System, Hosts, VMs, Storage domains etc.</div><div class=""><br class=""></div><div class=""><span style="font-size:12.8px" class="">See&nbsp;</span><a href="https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/" class="">https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/</a>&nbsp;<span style="font-size:12.8px" class="">for the full post.</span></div><div class=""><br class=""></div><div class="">For more information you can contact me.</div><div class=""><br class=""></div><div class="">Best regards,<br clear="all" class=""><div class=""><div class="gmail_signature"><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><pre cols="72" style="white-space:pre-wrap" class=""><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px" class=""><font color="#666666" class="">--</font></span></pre><div style="font-family: overpass, sans-serif; font-weight: bold; margin: 0px; padding: 0px; font-size: 14px; text-transform: uppercase;" class=""><span class="">SHIRLY</span>&nbsp;<span class="">RADCO</span></div><p style="font-family: overpass, sans-serif; font-size: 10px; margin: 0px 0px 4px; text-transform: uppercase;" class=""><span class="">BI SeNIOR SOFTWARE ENGINEER</span><span style="color:rgb(170,170,170);margin:0px" class=""></span></p><div style="font-family: overpass, sans-serif; margin: 0px; font-size: 10px; color: rgb(153, 153, 153);" class=""><a href="https://www.redhat.com/" style="color:rgb(0,136,206);margin:0px;text-decoration:none" target="_blank" class="">Red Hat&nbsp;<span class="">Israel</span></a></div><table border="0" style="font-family: overpass, sans-serif; font-size: inherit;" class=""><tbody class=""><tr class=""><td width="100px" class=""><a href="https://red.ht/sig" target="_blank" class=""><img src="https://www.redhat.com/files/brand/email/sig-redhat.png" width="90" height="auto" class=""></a></td><td style="font-size:10px" class=""><div class=""><a href="https://redhat.com/trusted" style="text-decoration:none;color:rgb(204,0,0);font-weight:bold" target="_blank" class="">TRIED. TESTED. TRUSTED.</a></div></td></tr></tbody></table></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div></div>
_______________________________________________<br class="">Users mailing list<br class=""><a href="mailto:Users@ovirt.org" class="">Users@ovirt.org</a><br class="">http://lists.ovirt.org/mailman/listinfo/users<br class=""></div></blockquote></div><br class=""></div></body></html>