On Sun, Mar 26, 2017 at 10:57 AM, Berger, Sandy <[email protected]> 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:[email protected]] > Sent: Sunday, March 26, 2017 1:43 AM > To: Berger, Sandy <[email protected]> > Cc: [email protected] > Subject: Re: [ovirt-users] Error attempting to create dwh readonly user > > > > On Sun, Mar 26, 2017 at 6:12 AM, Berger, Sandy <[email protected]> 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 > >> > >> > >> > >> [email protected] > >> > >> www.QG.com > >> > >> > >> > >> Follow Us: Facebook | Twitter | LinkedIn | YouTube > >> > >> _______________________________________________ > >> Users mailing list > >> [email protected] > >> http://lists.ovirt.org/mailman/listinfo/users > >> > > > > > > > > -- > > Didi > > Follow Us: Facebook | Twitter | LinkedIn | YouTube -- Didi _______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
