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 <vinc...@epicenergy.ca> 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 <vinc...@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 <mat...@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 <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 <(778)%20825-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
