[ovirt-users] Postgresql read only user difficulties
Maton, Brett
matonb at ltresources.co.uk
Mon Mar 19 04:35:13 UTC 2018
No worries, glad you got there in the end
On 19 March 2018 at 04:16, Vincent Royer <vincent at epicenergy.ca> wrote:
> I just did it again with another user and this time it seemed to work.
>
> Thanks for your help.
>
> *Vincent Royer*
> *778-825-1057*
>
>
> <http://www.epicenergy.ca/>
> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>
>
>
>
> On Sun, Mar 18, 2018 at 8:50 PM, Maton, Brett <matonb at ltresources.co.uk>
> wrote:
>
>> 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 <(778)%20825-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/ab9fcef0/attachment.html>
More information about the Users
mailing list