[ovirt-users] Error attempting to create dwh readonly user

[Yedidyah Bar David]

On Sun, Mar 26, 2017 at 10:57 AM, Berger, Sandy <SBERGER at qg.com> wrote:
> Thanks. That worked. However, now when I try to use that user from a remote
> system I am getting this error. I’m not sure what I need to add to the
> pg_hba.conf file or what I need to do after editing it.
>
>
>
> Credential validation was not successful: no pg_hba.conf entry for host
> "ip_address", user "username", database "ovirt_engine_history", SSL off

Find the file (should be in /var/lib/pgsql/data)

Find lines in it with 'ovirt_engine_history'. You should have two, like these:
------------------------------------------------------------------------
host    ovirt_engine_history ovirt_engine_history 0.0.0.0/0               md5
host    ovirt_engine_history ovirt_engine_history ::0/0                   md5
------------------------------------------------------------------------

Duplicate them, put the duplicates right below the existing ones, and
edit the duplicates, replacing the _second_ occurrence of 'ovirt_engine_history'
with the user you created. E.g.:
------------------------------------------------------------------------
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 ro_user 0.0.0.0/0               md5
host    ovirt_engine_history ro_user ::0/0                   md5
------------------------------------------------------------------------

Then 'systemctl restart postgresql'.

Best,

>
>
>
> -----Original Message-----
> From: Yedidyah Bar David [mailto:didi at redhat.com]
> Sent: Sunday, March 26, 2017 1:43 AM
> To: Berger, Sandy <SBERGER at qg.com>
> Cc: users at ovirt.org
> Subject: Re: [ovirt-users] Error attempting to create dwh readonly user
>
>
>
> On Sun, Mar 26, 2017 at 6:12 AM, Berger, Sandy <SBERGER at qg.com> wrote:
>
>> I am running oVirt 4.1.1.
>
>>
>
>>
>
>>
>
>> I am following the instructions in the “Data Warehouse Guide” to create an
>
>> account for readonly access to the data warehouse history database. I am
>> not
>
>> familiar with postgres. I am using the command:
>
>>
>
>>
>
>>
>
>> psql -U postgres -c "CREATE ROLE username WITH LOGIN ENCRYPTED PASSWORD
>
>> 'password';" -d ovirt_engine_history
>
>>
>
>>
>
>>
>
>> But I am getting the error:
>
>>
>
>>
>
>>
>
>> psql: FATAL:  Peer authentication failed for user "postgres"
>
>>
>
>>
>
>>
>
>> Any suggestions would be appreciated.
>
>
>
> Are you doing this as root? Please try to do this from OS user 'postgres'.
>
>
>
> Best,
>
>
>
>>
>
>>
>
>>
>
>> Sandy Berger
>
>>
>
>> IT - EUX
>
>>
>
>>
>
>>
>
>> Quad/Graphics
>
>>
>
>> Performance through Innovation
>
>>
>
>>
>
>>
>
>> Sussex, Wisconsin
>
>>
>
>> 414.566.2123 phone
>
>>
>
>> 414.566.4010/2123 pager/PIN
>
>>
>
>>
>
>>
>
>> sandy.berger at qg.com
>
>>
>
>> www.QG.com
>
>>
>
>>
>
>>
>
>> Follow Us: Facebook | Twitter | LinkedIn | YouTube
>
>>
>
>> _______________________________________________
>
>> Users mailing list
>
>> Users at ovirt.org
>
>> http://lists.ovirt.org/mailman/listinfo/users
>
>>
>
>
>
>
>
>
>
> --
>
> Didi
>
> Follow Us: Facebook | Twitter | LinkedIn | YouTube



-- 
Didi