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

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 <vincent(a)epicenergy.ca&gt; 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 <matonb(a)ltresources.co.uk&gt; > 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 <vincent(a)epicenergy.ca&gt; 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 <vincent(a)epicenergy.ca&gt; >>> 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 < >>>> matonb(a)ltresources.co.uk&gt; 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 <vincent(a)epicenergy.ca&gt; >>>>> 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 < >>>>>> 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 >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >