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 <vinc...@epicenergy.ca> 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* > > > <http://www.epicenergy.ca/> > *SUSTAINABLE MOBILE ENERGY SOLUTIONS* > > > > > On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett <mat...@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 <vinc...@epicenergy.ca> 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@ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >>> >>> >> >
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users