<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=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <<a href="mailto:milo1@ya.ru" class="">milo1@ya.ru</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">Good day,<div class=""><br class=""></div><div class="">i had the same issue, you can try running the commands directly from postgres user:</div><div class="">su - postgres</div><div class="">And the run the commands from blog post.</div></div></blockquote><div><br class=""></div><div>I did everything as user postgres, otherwise it doesn’t work at all.</div><br class=""><blockquote type="cite" class=""><div class=""><div class=""><br class=""></div><div class="">Best regards,</div><div class=""><br class=""></div><div class="">Mikhail.<br class=""><br class="">17:58, 22 января 2018 г., Andrei V <<a href="mailto:andreil1@starlett.lv" class="">andreil1@starlett.lv</a>>:<br class=""><blockquote class=""><div 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 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 = 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;” -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 class=""><br class=""><blockquote type="cite" class=""><div class="">On 21 Jan 2018, at 14:21, Shirly Radco <<a href="mailto:sradco@redhat.com" class="">sradco@redhat.com</a>> wrote:</div><br class=""><div class=""><div dir="ltr" class="">Hello everyone, <div class=""><br class=""></div><div class=""><span style="font-size:12.8px;" class="">A new oVirt </span><span style="font-size:12.8px;" class="">blog</span><span style="font-size:12.8px;" class=""> post has been published, on how </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 </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> <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=""><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> <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 <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=""><a href="http://lists.ovirt.org/mailman/listinfo/users" class="">http://lists.ovirt.org/mailman/listinfo/users</a><br class=""></div></blockquote></div><br class=""></div></div><p class="">_______________________________________________<br class="">Users mailing list<br class=""><a href="mailto:Users@ovirt.org" class="">Users@ovirt.org</a><br class=""><a href="http://lists.ovirt.org/mailman/listinfo/users" class="">http://lists.ovirt.org/mailman/listinfo/users</a><br class=""></p></blockquote><br class=""><br class="">Sent from Yandex.Mail for mobile: <a href="http://m.ya.ru/ymail" class="">http://m.ya.ru/ymail</a></div></div></blockquote></div><br class=""></body></html>