Postgresql read only user difficulties

Hi, I followed these instructions on Ovirt self hosted engine 4.2.1: https://www.ovirt.org/documentation/data-warehouse/Allowing_Read_Only_Access... 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!

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:
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

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* <http://www.epicenergy.ca/> *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:
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

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* *778-825-1057*
<http://www.epicenergy.ca/> *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/li b/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:
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

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* <http://www.epicenergy.ca/> *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* *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@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 <vincent@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

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...
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@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* *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@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 <vincent@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

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...
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@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* *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@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 <vincent@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

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* <http://www.epicenergy.ca/> *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...
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@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* *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@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 <vincent@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 > >

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@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*
<http://www.epicenergy.ca/> *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...
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@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* *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@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 <vincent@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 >> >> >

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 <matonb@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 <vincent@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 <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...
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@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* > *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@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 <vincent@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 >>> >>> >> >

No worries, glad you got there in the end On 19 March 2018 at 04:16, Vincent Royer <vincent@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 <matonb@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 <vincent@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 <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...
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@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* >> *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@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 <vincent@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 >>>> >>>> >>> >> >
participants (2)
-
Maton, Brett
-
Vincent Royer