No worries, glad you got there in the end On 19 March 2018 at 04:16, Vincent Royer <vinc...@epicenergy.ca> wrote:
> 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 <mat...@ltresources.co.uk> > 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 <vinc...@epicenergy.ca> 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 <mat...@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 <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