[ovirt-users] Postgresql read only user difficulties
Vincent Royer
vincent at epicenergy.ca
Mon Mar 19 04:16:09 UTC 2018
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/20180318/174676dd/attachment.html>
More information about the Users
mailing list