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

[Maton, Brett]

No worries, glad you got there in the end

On 19 March 2018 at 04:16, Vincent Royer  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*
>
>
> 
> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>
>
>
>
> On Sun, Mar 18, 2018 at 8:50 PM, Maton, Brett 
> 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  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>*
>>>
>>>
>>> 
>>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>>>
>>>
>>>
>>>
>>> On Sat, Mar 17, 2018 at 11:43 AM, Maton, Brett >> > 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  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  > 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>*
>>
>>
>> 
>> *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 
>>> 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  DATABASEUSERADDRESS
  METHOD

 # "local" is for Unix domain socket connections only
 local   all all peer
 hostovirt_engine_history ovirt_engine_history 0.0.0.0/0
md5
 hostovirt_engine_history ovirt_engine_history ::0/0
md5
 hostovirt_engine_history grafana 172.16.30.10 /0
  md5
 hostovirt_engine_history grafana ::0/0   md5
 hostengine  engine  0.0.0.0/0   md5
 hostengine  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>*


 
 *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 

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

[Maton, Brett]

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  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*
>
>
> 
> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>
>
>
>
> On Sat, Mar 17, 2018 at 11:43 AM, Maton, Brett 
> 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  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 
>>> 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>*


 
 *SUSTAINABLE MOBILE ENERGY SOLUTIONS*




 On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett  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 
> 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  DATABASEUSERADDRESS METHOD
>>
>> # "local" is for Unix domain socket connections only
>> local   all all peer
>> hostovirt_engine_history ovirt_engine_history 0.0.0.0/0
>>  md5
>> hostovirt_engine_history ovirt_engine_history ::0/0
>>  md5
>> hostovirt_engine_history grafana 172.16.30.10 /0   md5
>> hostovirt_engine_history grafana ::0/0   md5
>> hostengine  engine  0.0.0.0/0   md5
>> hostengine  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>*
>>
>>
>> 
>> *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 
>>> 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!

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

[Vincent Royer]

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 
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  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 
>> 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>*
>>>
>>>
>>> 
>>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>>>
>>>
>>>
>>>
>>> On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett 
>>> 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  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  DATABASEUSERADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local   all all peer
> hostovirt_engine_history ovirt_engine_history 0.0.0.0/0
>  md5
> hostovirt_engine_history ovirt_engine_history ::0/0
>md5
> hostovirt_engine_history grafana 172.16.30.10 /0   md5
> hostovirt_engine_history grafana ::0/0   md5
> hostengine  engine  0.0.0.0/0   md5
> hostengine  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>*
>
>
> 
> *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 
>> 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

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

[Maton, Brett]

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  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 
> 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>*
>>
>>
>> 
>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>>
>>
>>
>>
>> On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett 
>> 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  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  DATABASEUSERADDRESS METHOD

 # "local" is for Unix domain socket connections only
 local   all all peer
 hostovirt_engine_history ovirt_engine_history 0.0.0.0/0
md5
 hostovirt_engine_history ovirt_engine_history ::0/0
md5
 hostovirt_engine_history grafana 172.16.30.10 /0   md5
 hostovirt_engine_history grafana ::0/0   md5
 hostengine  engine  0.0.0.0/0   md5
 hostengine  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>*


 
 *SUSTAINABLE MOBILE ENERGY SOLUTIONS*




 On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett  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 
> 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

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

[Vincent Royer]

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 
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>*
>
>
> 
> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>
>
>
>
> On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett 
> 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  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  DATABASEUSERADDRESS METHOD
>>>
>>> # "local" is for Unix domain socket connections only
>>> local   all all peer
>>> hostovirt_engine_history ovirt_engine_history 0.0.0.0/0
>>>md5
>>> hostovirt_engine_history ovirt_engine_history ::0/0
>>>  md5
>>> hostovirt_engine_history grafana 172.16.30.10 /0   md5
>>> hostovirt_engine_history grafana ::0/0   md5
>>> hostengine  engine  0.0.0.0/0   md5
>>> hostengine  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>*
>>>
>>>
>>> 
>>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>>>
>>>
>>>
>>>
>>> On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett 
>>> 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  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

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

[Vincent Royer]

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*



*SUSTAINABLE MOBILE ENERGY SOLUTIONS*




On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett 
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  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  DATABASEUSERADDRESS METHOD
>>
>> # "local" is for Unix domain socket connections only
>> local   all all peer
>> hostovirt_engine_history ovirt_engine_history 0.0.0.0/0
>>  md5
>> hostovirt_engine_history ovirt_engine_history ::0/0
>>  md5
>> hostovirt_engine_history grafana 172.16.30.10 /0   md5
>> hostovirt_engine_history grafana ::0/0   md5
>> hostengine  engine  0.0.0.0/0   md5
>> hostengine  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>*
>>
>>
>> 
>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>>
>>
>>
>>
>> On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett 
>> 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  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

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

[Maton, Brett]

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  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  DATABASEUSERADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local   all all peer
> hostovirt_engine_history ovirt_engine_history 0.0.0.0/0
>  md5
> hostovirt_engine_history ovirt_engine_history ::0/0
>  md5
> hostovirt_engine_history grafana 172.16.30.10 /0   md5
> hostovirt_engine_history grafana ::0/0   md5
> hostengine  engine  0.0.0.0/0   md5
> hostengine  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*
>
>
> 
> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>
>
>
>
> On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett 
> 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  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

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

[Vincent Royer]

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  DATABASEUSERADDRESS METHOD

# "local" is for Unix domain socket connections only
local   all all peer
hostovirt_engine_history ovirt_engine_history 0.0.0.0/0
 md5
hostovirt_engine_history ovirt_engine_history ::0/0
 md5
hostovirt_engine_history grafana 172.16.30.10 /0   md5
hostovirt_engine_history grafana ::0/0   md5
hostengine  engine  0.0.0.0/0   md5
hostengine  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*



*SUSTAINABLE MOBILE ENERGY SOLUTIONS*




On Sat, Mar 17, 2018 at 3:42 AM, Maton, Brett 
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  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

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

[Maton, Brett]

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