<div dir="ltr">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:<br><br>su - postgres <br>scl enable rh-postgresql95 -- psql engine engine<br></div><br><div class="gmail_quote"><div dir="ltr">On Mon, 22 Jan 2018 at 18:19 <<a href="mailto:andreil1@starlett.lv">andreil1@starlett.lv</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space"><div><br><blockquote type="cite"><div>On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <<a href="mailto:milo1@ya.ru" target="_blank">milo1@ya.ru</a>> wrote:</div><br class="m_7475799881487007602Apple-interchange-newline"><div>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></blockquote><div><br></div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div><div>I did everything as user postgres, otherwise it doesn’t work at all.</div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div><br><blockquote type="cite"><div><div><br></div><div>Best regards,</div><div><br></div><div>Mikhail.<br><br>17:58, 22 января 2018 г., Andrei V <<a href="mailto:andreil1@starlett.lv" target="_blank">andreil1@starlett.lv</a>>:<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/" target="_blank">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 <<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>> 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/" target="_blank">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" target="_blank">Users@ovirt.org</a><br><a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">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" target="_blank">Users@ovirt.org</a><br><a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br></p></blockquote><br><br>Sent from Yandex.Mail for mobile: <a href="http://m.ya.ru/ymail" target="_blank">http://m.ya.ru/ymail</a></div></div></blockquote></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
</blockquote></div>