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


<http://www.epicenergy.ca/>
*SUSTAINABLE MOBILE ENERGY SOLUTIONS*




On Sat, Mar 17, 2018 at 4:34 AM, Maton, Brett <matonb at 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 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 <(778)%20825-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/99229c31/attachment.html>