[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  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/
> lib/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/5351fb27/attachment.html>