Good day,<div><br /></div><div>i had the same issue, you can try running the commands directly from postgres user:</div><div>su - postgres</div><div>And the run the commands from blog post.</div><div><br /></div><div>Best regards,</div><div><br /></div><div>Mikhail.<br /><br />17:58, 22 января 2018 г., Andrei V &lt;andreil1@starlett.lv&gt;:<br /><blockquote><div><div>Hi !</div><div><br /></div><div>Thanks a lot for excellent addition !</div><div><br /></div><div>I’ve got a problem with connecting Grafana to oVirt 4.2</div><div>Followed this instruction and created read-only user usrmonovirt</div><div># <a href="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/</a></div><div><br /></div>However, from Grafana login is is always failed:<div>pq: Ident authentication failed for user “usrmonovirt"</div><div>host = localhost:5432, database = ovirt_engine_history, SSL = disable</div><div><br /></div><div>Reset password with another or even NULL don’t help, still can’t connect.</div><div>psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD ‘mypassword';" -d ovirt_engine_history</div><div>psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;”  -d ovirt_engine_history</div><div><br /></div><div>What went wrong? I can’t understand.</div><div><br /></div><div>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><br /></div><div>Thanks in advance for any suggestion(s).</div><div><br />
<div><br /><blockquote type="cite"><div>On 21 Jan 2018, at 14:21, Shirly Radco &lt;<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>&gt; wrote:</div><br /><div><div dir="ltr">Hello everyone, <div><br /></div><div><span style="font-size:12.8px;">A new oVirt </span><span style="font-size:12.8px;">blog</span><span style="font-size:12.8px;"> post has been published, on how </span>to build oVirt reports using Grafana.</div><div>This allows connecting to oVirt DWH and create dashboards for System, Hosts, VMs, Storage domains etc.</div><div><br /></div><div><span style="font-size:12.8px;">See </span><a href="https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/">https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/</a> <span style="font-size:12.8px;">for the full post.</span></div><div><br /></div><div>For more information you can contact me.</div><div><br /></div><div>Best regards,<br clear="all" /><div><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><pre cols="72" style="white-space:pre-wrap;"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px;"><font color="#666666">--</font></span></pre><div style="font-family:overpass,sans-serif;font-weight:bold;margin:0px;padding:0px;font-size:14px;text-transform:uppercase;"><span>SHIRLY</span> <span>RADCO</span></div><p style="font-family:overpass,sans-serif;font-size:10px;margin:0px 0px 4px;text-transform:uppercase;"><span>BI SeNIOR SOFTWARE ENGINEER</span><span style="color:rgb(170,170,170);margin:0px;"></span></p><div style="font-family:overpass,sans-serif;margin:0px;font-size:10px;color:rgb(153,153,153);"><a href="https://www.redhat.com/" style="color:rgb(0,136,206);margin:0px;text-decoration:none;" target="_blank">Red Hat <span>Israel</span></a></div><table border="0" style="font-family:overpass,sans-serif;font-size:inherit;"><tbody><tr><td width="100px"><a href="https://red.ht/sig" target="_blank"><img src="https://www.redhat.com/files/brand/email/sig-redhat.png" width="90" height="auto" /></a></td><td style="font-size:10px;"><div><a href="https://redhat.com/trusted" style="text-decoration:none;color:rgb(204,0,0);font-weight:bold;" target="_blank">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 />Users mailing list<br /><a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br /><a href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a><br /></div></blockquote></div><br /></div></div><p>_______________________________________________<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">http://lists.ovirt.org/mailman/listinfo/users</a><br /></p></blockquote><br /><br />Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail</div>