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

[Berger, Sandy]

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



-----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<mailto: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<mailto:sandy.berger at qg.com>

>

> www.QG.com<http://www.QG.com>

>

>

>

> Follow Us: Facebook | Twitter | LinkedIn | YouTube

>

> _______________________________________________

> Users mailing list

> Users at ovirt.org<mailto:Users at ovirt.org>

> http://lists.ovirt.org/mailman/listinfo/users

>







--

Didi

Follow Us: Facebook<http://www.qg.com/social1> | Twitter<http://www.qg.com/social2> | LinkedIn<http://www.qg.com/social3> | YouTube<http://www.qg.com/social4>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170326/3accc882/attachment.html>