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


SUSTAINABLE MOBILE ENERGY SOLUTIONS




On Sat, Mar 17, 2018 at 11:43 AM, Maton, Brett <matonb@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 <vincent@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 <vincent@epicenergy.ca> wrote:
hmmm.  not a great result...

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


SUSTAINABLE MOBILE ENERGY SOLUTIONS




On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett <matonb@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 <vincent@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


SUSTAINABLE MOBILE ENERGY SOLUTIONS




On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett <matonb@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/lib/pgsql/data/pg_hba.conf

Hope this helps.

On 17 March 2018 at 09:50, Vincent Royer <vincent@epicenergy.ca> wrote:
Hi, 

I followed these instructions on Ovirt self hosted engine 4.2.1:


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