[ovirt-users] Postgresql read only user difficulties

[Maton, Brett]

Ok that may well  be the case :)

If generated the password as per the instructions with

ENCRYPTED PASSWORD

Postgres is expecting the password to be pre-encrypted.

If you connect to postgres as postgres (psql)

Try

ALTER ROLE grafana WITH PASSWORD 'clear txt password';


On 18 March 2018 at 18:49, Vincent Royer <vincent at epicenergy.ca> wrote:

> 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/20180319/56f84040/attachment.html>