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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> 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 <[email protected]> >>> 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 <[email protected]> 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 >>>>> [email protected] >>>>> http://lists.ovirt.org/mailman/listinfo/users >>>>> >>>>> >>>> >>> >> >
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
