Hi Vincent, oVirt isn't using the stock PostgreSQL but an SCL version You should find pg_hba.conf here /var/opt/rh/rh-postgresql95/ lib/pgsql/data/pg_hba.conf Hope this helps. On 17 March 2018 at 09:50, Vincent Royer <vincent(a)epicenergy.ca&gt; wrote: > Hi, > > I followed these instructions on Ovirt self hosted engine 4.2.1: > > https://www.ovirt.org/documentation/data-warehouse/Allowing_ > Read_Only_Access_to_the_History_Database/ > > when connecting to the db from an external host I receive this error: > > pq: no pg_hba.conf entry for host "", user "", database > "ovirt_engine_history", SSL off > > I looked in the normal place for pg_hba.conf but the file does not exist, > /data does not exist in /var/lib/pgsql > > Do i need to run engine-setup again to configure this? > > Thank you! > > _______________________________________________ > Users mailing list > Users(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > >

You could always try reloading the configuration, pretty sure pg_hba gets reloaded these days: su - postgres scl enable rh-postgresql95 bash pg_ctl reload -D /var/opt/rh/rh-postgresql95/lib/pgsql/data or as root systemctl restart rh-postgresql95-postgresql.service On 17 March 2018 at 11:20, Vincent Royer <vincent(a)epicenergy.ca&gt; wrote: > 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. > > # TYPE DATABASE USER ADDRESS METHOD > > # "local" is for Unix domain socket connections only > local all all peer > host ovirt_engine_history ovirt_engine_history 0.0.0.0/0 > md5 > host ovirt_engine_history ovirt_engine_history ::0/0 > md5 > host ovirt_engine_history grafana 172.16.30.10 /0 md5 > host ovirt_engine_history grafana ::0/0 md5 > host engine engine 0.0.0.0/0 md5 > host engine engine ::0/0 md5 > > > did a systemctl restart postgresql.service and I get "Unit not found". > So I did systemctl restart ovirt-engine.service... > > and the error I get when accessing from 172.16.30.10 is: > > pq: no pg_hba.conf entry for host "172.16.30.10", user "grafana", > database "ovirt_engine_history", SSL off > > > > > *Vincent Royer* > *778-825-1057 <(778)%20825-1057>* > > > <http://www.epicenergy.ca/> > *SUSTAINABLE MOBILE ENERGY SOLUTIONS* > > > > > On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett <matonb(a)ltresources.co.uk&gt; > wrote: > >> Hi Vincent, >> >> oVirt isn't using the stock PostgreSQL but an SCL version >> You should find pg_hba.conf here /var/opt/rh/rh-postgresql95/li >> b/pgsql/data/pg_hba.conf >> >> Hope this helps. >> >> On 17 March 2018 at 09:50, Vincent Royer <vincent(a)epicenergy.ca&gt; wrote: >> >>> Hi, >>> >>> I followed these instructions on Ovirt self hosted engine 4.2.1: >>> >>> https://www.ovirt.org/documentation/data-warehouse/Allowing_ >>> Read_Only_Access_to_the_History_Database/ >>> >>> when connecting to the db from an external host I receive this error: >>> >>> pq: no pg_hba.conf entry for host "", user "", database >>> "ovirt_engine_history", SSL off >>> >>> I looked in the normal place for pg_hba.conf but the file does not >>> exist, /data does not exist in /var/lib/pgsql >>> >>> Do i need to run engine-setup again to configure this? >>> >>> Thank you! >>> >>> _______________________________________________ >>> Users mailing list >>> Users(a)ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >>> >>> >> >

I think I see the issue. Extra space after the IP address in pg_hba.conf I'll try again later. Thanks for your help! On Sat, Mar 17, 2018 at 10:44 AM, Vincent Royer <vincent(a)epicenergy.ca&gt; wrote: > hmmm. not a great result... > > rh-postgresql95-postgresql.service:...1 > Mar 17 10:36:32 ovirt-engine systemd[1]: Failed to start PostgreSQL > database.... > Mar 17 10:36:32 ovirt-engine systemd[1]: Unit > rh-postgresql95-postgresql.ser.... > Mar 17 10:36:32 ovirt-engine systemd[1]: rh-postgresql95-postgresql.service > .... > > and can no longer login to ovirt-engine gui: > > server_error: Connection refused. Check that the hostname and port are > correct and that the postmaster is accepting TCP/IP connections. > > tried to restart ovirt-engine and it won't come up - internal server > error. > > > > *Vincent Royer* > *778-825-1057 <(778)%20825-1057>* > > > <http://www.epicenergy.ca/> > *SUSTAINABLE MOBILE ENERGY SOLUTIONS* > > > > > On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett <matonb(a)ltresources.co.uk&gt; > wrote: > >> You could always try reloading the configuration, pretty sure pg_hba >> gets reloaded these days: >> >> su - postgres >> scl enable rh-postgresql95 bash >> pg_ctl reload -D /var/opt/rh/rh-postgresql95/lib/pgsql/data >> >> or as root >> >> systemctl restart rh-postgresql95-postgresql.service >> >> >> On 17 March 2018 at 11:20, Vincent Royer <vincent(a)epicenergy.ca&gt; wrote: >> >>> 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. >>> >>> # TYPE DATABASE USER ADDRESS METHOD >>> >>> # "local" is for Unix domain socket connections only >>> local all all peer >>> host ovirt_engine_history ovirt_engine_history 0.0.0.0/0 >>> md5 >>> host ovirt_engine_history ovirt_engine_history ::0/0 >>> md5 >>> host ovirt_engine_history grafana 172.16.30.10 /0 md5 >>> host ovirt_engine_history grafana ::0/0 md5 >>> host engine engine 0.0.0.0/0 md5 >>> host engine engine ::0/0 md5 >>> >>> >>> did a systemctl restart postgresql.service and I get "Unit not found". >>> So I did systemctl restart ovirt-engine.service... >>> >>> and the error I get when accessing from 172.16.30.10 is: >>> >>> pq: no pg_hba.conf entry for host "172.16.30.10", user "grafana", >>> database "ovirt_engine_history", SSL off >>> >>> >>> >>> >>> *Vincent Royer* >>> *778-825-1057 <(778)%20825-1057>* >>> >>> >>> <http://www.epicenergy.ca/> >>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS* >>> >>> >>> >>> >>> On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett <matonb(a)ltresources.co.uk >>> > wrote: >>> >>>> Hi Vincent, >>>> >>>> oVirt isn't using the stock PostgreSQL but an SCL version >>>> You should find pg_hba.conf here /var/opt/rh/rh-postgresql95/li >>>> b/pgsql/data/pg_hba.conf >>>> >>>> Hope this helps. >>>> >>>> On 17 March 2018 at 09:50, Vincent Royer <vincent(a)epicenergy.ca&gt; >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> I followed these instructions on Ovirt self hosted engine 4.2.1: >>>>> >>>>> https://www.ovirt.org/documentation/data-warehouse/Allowing_ >>>>> Read_Only_Access_to_the_History_Database/ >>>>> >>>>> when connecting to the db from an external host I receive this error: >>>>> >>>>> pq: no pg_hba.conf entry for host "", user "", database >>>>> "ovirt_engine_history", SSL off >>>>> >>>>> I looked in the normal place for pg_hba.conf but the file does not >>>>> exist, /data does not exist in /var/lib/pgsql >>>>> >>>>> Do i need to run engine-setup again to configure this? >>>>> >>>>> Thank you! >>>>> >>>>> _______________________________________________ >>>>> Users mailing list >>>>> Users(a)ovirt.org >>>>> http://lists.ovirt.org/mailman/listinfo/users >>>>> >>>>> >>>> >>> >> >

well this is frustrating. I added the read only user, but still can't connect. pq: password authentication failed for user "grafana" *Vincent Royer* *778-825-1057* <http://www.epicenergy.ca/> *SUSTAINABLE MOBILE ENERGY SOLUTIONS* On Sat, Mar 17, 2018 at 11:43 AM, Maton, Brett <matonb(a)ltresources.co.uk&gt; wrote: > Yeah if postgres won't start you've probably got a typo in pg_hba.conf > > On 17 March 2018 at 18:11, Vincent Royer <vincent(a)epicenergy.ca&gt; wrote: > >> I think I see the issue. Extra space after the IP address in pg_hba.conf >> >> I'll try again later. >> >> Thanks for your help! >> >> >> >> >> On Sat, Mar 17, 2018 at 10:44 AM, Vincent Royer <vincent(a)epicenergy.ca&gt; >> wrote: >> >>> hmmm. not a great result... >>> >>> rh-postgresql95-postgresql.service:...1 >>> Mar 17 10:36:32 ovirt-engine systemd[1]: Failed to start PostgreSQL >>> database.... >>> Mar 17 10:36:32 ovirt-engine systemd[1]: Unit >>> rh-postgresql95-postgresql.ser.... >>> Mar 17 10:36:32 ovirt-engine systemd[1]: rh-postgresql95-postgresql.service >>> .... >>> >>> and can no longer login to ovirt-engine gui: >>> >>> server_error: Connection refused. Check that the hostname and port are >>> correct and that the postmaster is accepting TCP/IP connections. >>> >>> tried to restart ovirt-engine and it won't come up - internal server >>> error. >>> >>> >>> >>> *Vincent Royer* >>> *778-825-1057 <(778)%20825-1057>* >>> >>> >>> <http://www.epicenergy.ca/> >>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS* >>> >>> >>> >>> >>> On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett <matonb(a)ltresources.co.uk >>> > wrote: >>> >>>> You could always try reloading the configuration, pretty sure pg_hba >>>> gets reloaded these days: >>>> >>>> su - postgres >>>> scl enable rh-postgresql95 bash >>>> pg_ctl reload -D /var/opt/rh/rh-postgresql95/lib/pgsql/data >>>> >>>> or as root >>>> >>>> systemctl restart rh-postgresql95-postgresql.service >>>> >>>> >>>> On 17 March 2018 at 11:20, Vincent Royer <vincent(a)epicenergy.ca&gt; >>>> wrote: >>>> >>>>> 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. >>>>> >>>>> # TYPE DATABASE USER ADDRESS METHOD >>>>> >>>>> # "local" is for Unix domain socket connections only >>>>> local all all peer >>>>> host ovirt_engine_history ovirt_engine_history 0.0.0.0/0 >>>>> md5 >>>>> host ovirt_engine_history ovirt_engine_history ::0/0 >>>>> md5 >>>>> host ovirt_engine_history grafana 172.16.30.10 /0 md5 >>>>> host ovirt_engine_history grafana ::0/0 md5 >>>>> host engine engine 0.0.0.0/0 md5 >>>>> host engine engine ::0/0 md5 >>>>> >>>>> >>>>> did a systemctl restart postgresql.service and I get "Unit not >>>>> found". So I did systemctl restart ovirt-engine.service... >>>>> >>>>> and the error I get when accessing from 172.16.30.10 is: >>>>> >>>>> pq: no pg_hba.conf entry for host "172.16.30.10", user "grafana", >>>>> database "ovirt_engine_history", SSL off >>>>> >>>>> >>>>> >>>>> >>>>> *Vincent Royer* >>>>> *778-825-1057 <(778)%20825-1057>* >>>>> >>>>> >>>>> <http://www.epicenergy.ca/> >>>>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS* >>>>> >>>>> >>>>> >>>>> >>>>> On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett < >>>>> matonb(a)ltresources.co.uk&gt; wrote: >>>>> >>>>>> Hi Vincent, >>>>>> >>>>>> oVirt isn't using the stock PostgreSQL but an SCL version >>>>>> You should find pg_hba.conf here /var/opt/rh/rh-postgresql95/li >>>>>> b/pgsql/data/pg_hba.conf >>>>>> >>>>>> Hope this helps. >>>>>> >>>>>> On 17 March 2018 at 09:50, Vincent Royer <vincent(a)epicenergy.ca&gt; >>>>>> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> I followed these instructions on Ovirt self hosted engine 4.2.1: >>>>>>> >>>>>>> https://www.ovirt.org/documentation/data-warehouse/Allowing_ >>>>>>> Read_Only_Access_to_the_History_Database/ >>>>>>> >>>>>>> when connecting to the db from an external host I receive this >>>>>>> error: >>>>>>> >>>>>>> pq: no pg_hba.conf entry for host "", user "", database >>>>>>> "ovirt_engine_history", SSL off >>>>>>> >>>>>>> I looked in the normal place for pg_hba.conf but the file does not >>>>>>> exist, /data does not exist in /var/lib/pgsql >>>>>>> >>>>>>> Do i need to run engine-setup again to configure this? >>>>>>> >>>>>>> Thank you! >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Users mailing list >>>>>>> Users(a)ovirt.org >>>>>>> http://lists.ovirt.org/mailman/listinfo/users >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >

I just did it again with another user and this time it seemed to work. Thanks for your help. *Vincent Royer* *778-825-1057* <http://www.epicenergy.ca/> *SUSTAINABLE MOBILE ENERGY SOLUTIONS* On Sun, Mar 18, 2018 at 8:50 PM, Maton, Brett <matonb(a)ltresources.co.uk&gt; wrote: > Ok that may well be the case :) > > If generated the password as per the instructions with > > ENCRYPTED PASSWORD > > Postgres is expecting the password to be pre-encrypted. > > If you connect to postgres as postgres (psql) > > Try > > ALTER ROLE grafana WITH PASSWORD 'clear txt password'; > > > > On 18 March 2018 at 18:49, Vincent Royer <vincent(a)epicenergy.ca&gt; wrote: > >> well this is frustrating. I added the read only user, but still can't >> connect. >> >> pq: password authentication failed for user "grafana" >> >> >> *Vincent Royer* >> *778-825-1057 <(778)%20825-1057>* >> >> >> <http://www.epicenergy.ca/> >> *SUSTAINABLE MOBILE ENERGY SOLUTIONS* >> >> >> >> >> On Sat, Mar 17, 2018 at 11:43 AM, Maton, Brett <matonb(a)ltresources.co.uk >> > wrote: >> >>> Yeah if postgres won't start you've probably got a typo in pg_hba.conf >>> >>> On 17 March 2018 at 18:11, Vincent Royer <vincent(a)epicenergy.ca&gt; wrote: >>> >>>> I think I see the issue. Extra space after the IP address in >>>> pg_hba.conf >>>> >>>> I'll try again later. >>>> >>>> Thanks for your help! >>>> >>>> >>>> >>>> >>>> On Sat, Mar 17, 2018 at 10:44 AM, Vincent Royer <vincent(a)epicenergy.ca >>>> > wrote: >>>> >>>>> hmmm. not a great result... >>>>> >>>>> rh-postgresql95-postgresql.service:...1 >>>>> Mar 17 10:36:32 ovirt-engine systemd[1]: Failed to start PostgreSQL >>>>> database.... >>>>> Mar 17 10:36:32 ovirt-engine systemd[1]: Unit >>>>> rh-postgresql95-postgresql.ser.... >>>>> Mar 17 10:36:32 ovirt-engine systemd[1]: >>>>> rh-postgresql95-postgresql.service .... >>>>> >>>>> and can no longer login to ovirt-engine gui: >>>>> >>>>> server_error: Connection refused. Check that the hostname and port >>>>> are correct and that the postmaster is accepting TCP/IP connections. >>>>> >>>>> tried to restart ovirt-engine and it won't come up - internal server >>>>> error. >>>>> >>>>> >>>>> >>>>> *Vincent Royer* >>>>> *778-825-1057 <(778)%20825-1057>* >>>>> >>>>> >>>>> <http://www.epicenergy.ca/> >>>>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS* >>>>> >>>>> >>>>> >>>>> >>>>> On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett < >>>>> matonb(a)ltresources.co.uk&gt; wrote: >>>>> >>>>>> You could always try reloading the configuration, pretty sure pg_hba >>>>>> gets reloaded these days: >>>>>> >>>>>> su - postgres >>>>>> scl enable rh-postgresql95 bash >>>>>> pg_ctl reload -D /var/opt/rh/rh-postgresql95/lib/pgsql/data >>>>>> >>>>>> or as root >>>>>> >>>>>> systemctl restart rh-postgresql95-postgresql.service >>>>>> >>>>>> >>>>>> On 17 March 2018 at 11:20, Vincent Royer <vincent(a)epicenergy.ca&gt; >>>>>> wrote: >>>>>> >>>>>>> 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. >>>>>>> >>>>>>> # TYPE DATABASE USER ADDRESS >>>>>>> METHOD >>>>>>> >>>>>>> # "local" is for Unix domain socket connections only >>>>>>> local all all peer >>>>>>> host ovirt_engine_history ovirt_engine_history 0.0.0.0/0 >>>>>>> md5 >>>>>>> host ovirt_engine_history ovirt_engine_history ::0/0 >>>>>>> md5 >>>>>>> host ovirt_engine_history grafana 172.16.30.10 /0 >>>>>>> md5 >>>>>>> host ovirt_engine_history grafana ::0/0 md5 >>>>>>> host engine engine 0.0.0.0/0 md5 >>>>>>> host engine engine ::0/0 md5 >>>>>>> >>>>>>> >>>>>>> did a systemctl restart postgresql.service and I get "Unit not >>>>>>> found". So I did systemctl restart ovirt-engine.service... >>>>>>> >>>>>>> and the error I get when accessing from 172.16.30.10 is: >>>>>>> >>>>>>> pq: no pg_hba.conf entry for host "172.16.30.10", user "grafana", >>>>>>> database "ovirt_engine_history", SSL off >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> *Vincent Royer* >>>>>>> *778-825-1057 <(778)%20825-1057>* >>>>>>> >>>>>>> >>>>>>> <http://www.epicenergy.ca/> >>>>>>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS* >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett < >>>>>>> matonb(a)ltresources.co.uk&gt; wrote: >>>>>>> >>>>>>>> Hi Vincent, >>>>>>>> >>>>>>>> oVirt isn't using the stock PostgreSQL but an SCL version >>>>>>>> You should find pg_hba.conf here /var/opt/rh/rh-postgresql95/li >>>>>>>> b/pgsql/data/pg_hba.conf >>>>>>>> >>>>>>>> Hope this helps. >>>>>>>> >>>>>>>> On 17 March 2018 at 09:50, Vincent Royer <vincent(a)epicenergy.ca&gt; >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> I followed these instructions on Ovirt self hosted engine 4.2.1: >>>>>>>>> >>>>>>>>> https://www.ovirt.org/documentation/data-warehouse/Allowing_ >>>>>>>>> Read_Only_Access_to_the_History_Database/ >>>>>>>>> >>>>>>>>> when connecting to the db from an external host I receive this >>>>>>>>> error: >>>>>>>>> >>>>>>>>> pq: no pg_hba.conf entry for host "", user "", database >>>>>>>>> "ovirt_engine_history", SSL off >>>>>>>>> >>>>>>>>> I looked in the normal place for pg_hba.conf but the file does >>>>>>>>> not exist, /data does not exist in /var/lib/pgsql >>>>>>>>> >>>>>>>>> Do i need to run engine-setup again to configure this? >>>>>>>>> >>>>>>>>> Thank you! >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Users mailing list >>>>>>>>> Users(a)ovirt.org >>>>>>>>> http://lists.ovirt.org/mailman/listinfo/users >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >