[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 <vincent at 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 at 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 at 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 at ovirt.org
>>> http://lists.ovirt.org/mailman/listinfo/users
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180317/abe375f4/attachment.html>