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


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




On Sat, Mar 17, 2018 at 11:43 AM, Maton, Brett <matonb at ltresources.co.uk>
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 <vincent at epicenergy.ca> 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 <vincent at epicenergy.ca>
>> 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>*
>>>
>>>
>>> <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/20180318/eea68faa/attachment.html>