Re: [ovirt-users] Postgresql read only user difficulties
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(a)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(a)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(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
Attachments:
- attachment.html (text/html — 5.4 KB)