Re: [ovirt-users] Postgresql read only user difficulties

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 <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 >> >> >