<div dir="ltr"><div><div><div><div>Ok that may well be the case :)<br><br></div>If generated the password as per the instructions with <pre class="gmail-highlight gmail-plaintext"><code>ENCRYPTED PASSWORD</code></pre>Postgres is expecting the password to be pre-encrypted.<br><br></div>If you connect to postgres as postgres (psql)<br><br></div>Try<br><br></div>ALTER ROLE grafana WITH PASSWORD 'clear txt password';<br><br><div class="gmail_extra"><br><div class="gmail_quote">On 18 March 2018 at 18:49, Vincent Royer <span dir="ltr"><<a href="mailto:vincent@epicenergy.ca" target="_blank">vincent@epicenergy.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">well this is frustrating. I added the read only user, but still can't connect. <div><br></div><div>pq: password authentication failed for user "grafana"<br></div><div><br></div></div><div class="gmail_extra"><span class=""><br clear="all"><div><div class="m_6984979989945624014gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div><div dir="ltr" style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b>Vincent Royer</b></font></div><div dir="ltr"><div style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b>778-825-1057</b></font></div><div style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b><br></b></font></div><div style="font-size:12.8px"><a href="http://www.epicenergy.ca/" target="_blank"><img src="https://lh3.googleusercontent.com/ezD9JxeN67lTscselHjW4ZEqvQRj_i_T_Ky_s__GkR0AtanG1nK52CD1Rdhmyzbk7XRPf-Rhhnr2-SLPmhtd0J8xVMp0xOiR20ebQVb6jU2xwJPKN4lePRq5G2p93ybqA4SnqjCWCvEsNlK37a9FtStdFcTJyIoS2aHKiL69L3bZg1g7mEAMr7IHXVYvHgq3MX9rNaqIQx9T3uPuIHEDIfxrgpCrsBoEamgaRHj5hcpEobnogqCqpa1sRcKy927TSeR5BbVLM1-wn0h-4LvE8CMqj30jpQULxZ9uXEg_S6sR3ZeZjtkkRvgK4l_wiivWlyV_SjCDQ5QREG3jkuCjXC04i1NNmziGZZNWYsaohE6khrN4JGVtvaSOiS2woYJNz3Gt0EucxJp3eUBYspzTl9iZia7bLvFEGIODvmfjRVZJmnCrFucJxGkAtWn_EUIbxJXS5NWAFnvBoixQP563Fbu7dFKL77lDcb4PHwrnJVjqcgU0OTeiMBlMvEt97YgMpMvdi7rx9L4DeEbrIGUovgx4QLfRRoF_9u2mxFu8FHupCxfocSyB3vs8gqOLvVdx42qwiLN0sGLAg8K3G_vFwVNddXQ_yb3cGeCEAOTnk7jfiP4O4jsPIW2RRbnKKL-usL11Tp7gkxbgRouLOoyqpbisjA4vRWDeylj1yDGyBg=w400-h38-no" width="200" height="18"><br></a></div><div><b><font size="2" face="arial narrow, sans-serif">SUSTAINABLE MOBILE <font color="#6aa84f">ENERGY </font>SOLUTIONS</font></b></div></div></div><div><br></div><div><br><div><div><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
<br></span><div><div class="h5"><div class="gmail_quote">On Sat, Mar 17, 2018 at 11:43 AM, Maton, Brett <span dir="ltr"><<a href="mailto:matonb@ltresources.co.uk" target="_blank">matonb@ltresources.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Yeah if postgres won't start you've probably got a typo in pg_hba.conf<br></div><div class="m_6984979989945624014HOEnZb"><div class="m_6984979989945624014h5"><div class="gmail_extra"><br><div class="gmail_quote">On 17 March 2018 at 18:11, Vincent Royer <span dir="ltr"><<a href="mailto:vincent@epicenergy.ca" target="_blank">vincent@epicenergy.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div dir="ltr"><div>I think I see the issue. Extra space after the IP address in pg_hba.conf</div><div dir="auto"><br></div><div dir="auto">I'll try again later.</div><div dir="auto"><br></div><div dir="auto">Thanks for your help!</div></div><div><div class="m_6984979989945624014m_3446506718209351880h5"><br><div class="gmail_extra" dir="auto"><div><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="auto"><div dir="ltr" style="font-size:12.8px"><br></div></div><div dir="auto"><div><div><br></div></div></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Sat, Mar 17, 2018 at 10:44 AM, Vincent Royer <span dir="ltr"><<a href="mailto:vincent@epicenergy.ca" target="_blank">vincent@epicenergy.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">hmmm. not a great result...<div><br></div><div><div> <a href="http://rh-postgresql95-postgresql.se" target="_blank">rh-postgresql95-postgresql.se</a><wbr>rvice:...1</div><div>Mar 17 10:36:32 ovirt-engine systemd[1]: Failed to start PostgreSQL database....</div><div>Mar 17 10:36:32 ovirt-engine systemd[1]: Unit rh-postgresql95-postgresql.ser<wbr>....</div><div>Mar 17 10:36:32 ovirt-engine systemd[1]: rh-postgresql95-postgresql.ser<wbr>vice ....</div></div><div><br></div><div>and can no longer login to ovirt-engine gui:</div><div><br></div><div><div>server_error: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.</div></div><div><br></div><div>tried to restart ovirt-engine and it won't come up - internal server error. </div><div><br></div><div><br></div></div><div class="gmail_extra"><span><br clear="all"><div><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071m_-6856581440173135184gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div><div dir="ltr" style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b>Vincent Royer</b></font></div><div dir="ltr"><div style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b><a href="tel:(778)%20825-1057" value="+17788251057" target="_blank">778-825-1057</a></b></font></div><div style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b><br></b></font></div><div style="font-size:12.8px"><a href="http://www.epicenergy.ca/" target="_blank"><img src="https://lh3.googleusercontent.com/ezD9JxeN67lTscselHjW4ZEqvQRj_i_T_Ky_s__GkR0AtanG1nK52CD1Rdhmyzbk7XRPf-Rhhnr2-SLPmhtd0J8xVMp0xOiR20ebQVb6jU2xwJPKN4lePRq5G2p93ybqA4SnqjCWCvEsNlK37a9FtStdFcTJyIoS2aHKiL69L3bZg1g7mEAMr7IHXVYvHgq3MX9rNaqIQx9T3uPuIHEDIfxrgpCrsBoEamgaRHj5hcpEobnogqCqpa1sRcKy927TSeR5BbVLM1-wn0h-4LvE8CMqj30jpQULxZ9uXEg_S6sR3ZeZjtkkRvgK4l_wiivWlyV_SjCDQ5QREG3jkuCjXC04i1NNmziGZZNWYsaohE6khrN4JGVtvaSOiS2woYJNz3Gt0EucxJp3eUBYspzTl9iZia7bLvFEGIODvmfjRVZJmnCrFucJxGkAtWn_EUIbxJXS5NWAFnvBoixQP563Fbu7dFKL77lDcb4PHwrnJVjqcgU0OTeiMBlMvEt97YgMpMvdi7rx9L4DeEbrIGUovgx4QLfRRoF_9u2mxFu8FHupCxfocSyB3vs8gqOLvVdx42qwiLN0sGLAg8K3G_vFwVNddXQ_yb3cGeCEAOTnk7jfiP4O4jsPIW2RRbnKKL-usL11Tp7gkxbgRouLOoyqpbisjA4vRWDeylj1yDGyBg=w400-h38-no" width="200" height="18"><br></a></div><div><b><font size="2" face="arial narrow, sans-serif">SUSTAINABLE MOBILE <font color="#6aa84f">ENERGY </font>SOLUTIONS</font></b></div></div></div><div><br></div><div><br><div><div><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
<br></span><div><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071h5"><div class="gmail_quote">On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett <span dir="ltr"><<a href="mailto:matonb@ltresources.co.uk" target="_blank">matonb@ltresources.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>You could always try reloading the configuration, pretty sure pg_hba gets reloaded these days:<br><br></div><div>su - postgres<br>scl enable rh-postgresql95 bash<br></div><div>pg_ctl reload -D /var/opt/rh/rh-postgresql95/li<wbr>b/pgsql/data<br><br></div><div>or as root<br><br></div>systemctl restart rh-postgresql95-postgresql.ser<wbr>vice<br><br></div><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071m_-6856581440173135184HOEnZb"><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071m_-6856581440173135184h5"><div class="gmail_extra"><br><div class="gmail_quote">On 17 March 2018 at 11:20, Vincent Royer <span dir="ltr"><<a href="mailto:vincent@epicenergy.ca" target="_blank">vincent@epicenergy.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">ok thanks, I did see it there but assumed that was a temp file. I updated it according to the instructions, but I still get the same error. <div><br></div><div><div># TYPE DATABASE USER ADDRESS METHOD</div><div><br></div><div># "local" is for Unix domain socket connections only</div><div>local all all peer</div><div>host ovirt_engine_history ovirt_engine_history <a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a> md5</div><div>host ovirt_engine_history ovirt_engine_history ::0/0 md5</div><div>host ovirt_engine_history grafana 172.16.30.10 /0 md5</div><div>host ovirt_engine_history grafana ::0/0 md5</div><div>host engine engine <a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a> md5</div><div>host engine engine ::0/0 md5</div></div><div><br></div><div><br></div><div>did a systemctl restart postgresql.service and I get "Unit not found". So I did systemctl restart ovirt-engine.service...</div><div><br></div><div>and the error I get when accessing from 172.16.30.10 is:</div><div><br></div><div><div>pq: no pg_hba.conf entry for host "172.16.30.10", user "grafana", database "ovirt_engine_history", SSL off</div></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071m_-6856581440173135184m_-8028108764225415095m_-3082078291216236535gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div><div dir="ltr" style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b>Vincent Royer</b></font></div><div dir="ltr"><div style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b><a href="tel:(778)%20825-1057" value="+17788251057" target="_blank">778-825-1057</a></b></font></div><div style="font-size:12.8px"><font size="4" face="arial narrow, sans-serif"><b><br></b></font></div><div style="font-size:12.8px"><a href="http://www.epicenergy.ca/" target="_blank"><img src="https://lh3.googleusercontent.com/ezD9JxeN67lTscselHjW4ZEqvQRj_i_T_Ky_s__GkR0AtanG1nK52CD1Rdhmyzbk7XRPf-Rhhnr2-SLPmhtd0J8xVMp0xOiR20ebQVb6jU2xwJPKN4lePRq5G2p93ybqA4SnqjCWCvEsNlK37a9FtStdFcTJyIoS2aHKiL69L3bZg1g7mEAMr7IHXVYvHgq3MX9rNaqIQx9T3uPuIHEDIfxrgpCrsBoEamgaRHj5hcpEobnogqCqpa1sRcKy927TSeR5BbVLM1-wn0h-4LvE8CMqj30jpQULxZ9uXEg_S6sR3ZeZjtkkRvgK4l_wiivWlyV_SjCDQ5QREG3jkuCjXC04i1NNmziGZZNWYsaohE6khrN4JGVtvaSOiS2woYJNz3Gt0EucxJp3eUBYspzTl9iZia7bLvFEGIODvmfjRVZJmnCrFucJxGkAtWn_EUIbxJXS5NWAFnvBoixQP563Fbu7dFKL77lDcb4PHwrnJVjqcgU0OTeiMBlMvEt97YgMpMvdi7rx9L4DeEbrIGUovgx4QLfRRoF_9u2mxFu8FHupCxfocSyB3vs8gqOLvVdx42qwiLN0sGLAg8K3G_vFwVNddXQ_yb3cGeCEAOTnk7jfiP4O4jsPIW2RRbnKKL-usL11Tp7gkxbgRouLOoyqpbisjA4vRWDeylj1yDGyBg=w400-h38-no" width="200" height="18"><br></a></div><div><b><font size="2" face="arial narrow, sans-serif">SUSTAINABLE MOBILE <font color="#6aa84f">ENERGY </font>SOLUTIONS</font></b></div></div></div><div><br></div><div><br><div><div><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><div><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071m_-6856581440173135184m_-8028108764225415095h5">
<br><div class="gmail_quote">On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett <span dir="ltr"><<a href="mailto:matonb@ltresources.co.uk" target="_blank">matonb@ltresources.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>Hi Vincent,<br><br></div> oVirt isn't using the stock PostgreSQL but an SCL version<br></div> You should find pg_hba.conf here /var/opt/rh/rh-postgresql95/li<wbr>b/pgsql/data/pg_hba.conf<br><br></div>Hope this helps.<br></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071m_-6856581440173135184m_-8028108764225415095m_-3082078291216236535h5">On 17 March 2018 at 09:50, Vincent Royer <span dir="ltr"><<a href="mailto:vincent@epicenergy.ca" target="_blank">vincent@epicenergy.ca</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_6984979989945624014m_3446506718209351880m_-8139152192312569141m_-2598346982086435071m_-6856581440173135184m_-8028108764225415095m_-3082078291216236535h5"><div dir="ltr"><div>Hi, </div><div><br></div><div>I followed these instructions on Ovirt self hosted engine 4.2.1:</div><div><br></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/document<wbr>ation/data-warehouse/Allowing_<wbr>Read_Only_Access_to_the_Histor<wbr>y_Database/</a><br></div><div><br></div><div>when connecting to the db from an external host I receive this error:</div><div><br></div><div><div>pq: no pg_hba.conf entry for host "", user "", database "ovirt_engine_history", SSL off</div></div><div><br></div><div>I looked in the normal place for pg_hba.conf but the file does not exist, /data does not exist in /var/lib/pgsql</div><div><br></div><div>Do i need to run engine-setup again to configure this?<br></div><div><br></div><div>Thank you!</div>
</div>
<br></div></div>______________________________<wbr>_________________<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<wbr>/listinfo/users</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div></div>