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

26 Mar 2017

      On Sun, Mar 26, 2017 at 10:57 AM, Berger, Sandy <SBERGER@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@redhat.com]
Sent: Sunday, March 26, 2017 1:43 AM
To: Berger, Sandy <SBERGER@qg.com>
Cc: users@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@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@qg.com
...
...
www.QG.com
...
...
...
...
Follow Us: Facebook | Twitter | LinkedIn | YouTube
...
...
_______________________________________________
...
Users mailing list
...
Users@ovirt.org
...
http://lists.ovirt.org/mailman/listinfo/users
...
--
Didi
Follow Us: Facebook | Twitter | LinkedIn | YouTube
-- 
Didi