6:12 a.m.
--_000_DM5PR05MB316109DAF0F0DE0E2753E1E3D5300DM5PR05MB3161namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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 no=
t familiar with postgres. I am using the command:
psql -U postgres -c "CREATE ROLE username WITH LOGIN ENCRYPTED PASSWORD 'pa=
ssword';" -d ovirt_engine_history
But I am getting the error:
psql: FATAL: Peer authentication failed for user "postgres"
Any suggestions would be appreciated.
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<mailto:sandy.berger@qg.com
www.QG.com<http://www.qg.com/
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
--_000_DM5PR05MB316109DAF0F0DE0E2753E1E3D5300DM5PR05MB3161namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml"
xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word"
=
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
xmlns=3D"http:=
//www.w3.org/TR/REC-html40" <head <meta http-equiv=3D"Content-Type"
content=3D"text/html; charset=3Dus-ascii"=
<meta name=3D"Generator" content=3D"Microsoft
Word 15 (filtered medium)" <style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:DejaVuSansMono;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" / </xml><![endif]--><!--[if gte mso
9]><xml <o:shapelayout
v:ext=3D"edit" <o:idmap v:ext=3D"edit"
data=3D"1" /
</o:shapelayout></xml><![endif]--
</head <body lang=3D"EN-US"
link=3D"#0563C1" vlink=3D"#954F72" <div
class=3D"WordSection1" <p
class=3D"MsoNormal">I am running oVirt
4.1.1.<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p class=3D"MsoNormal">I am following the
instructions in the “Data W=
arehouse 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:<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p class=3D"MsoNormal"
style=3D"text-autospace:none"><span style=3D"font-si=
ze:8.0pt;font-family:"Courier New"">psql -U postgres -c
"CRE=
ATE ROLE
<i>username </i>WITH LOGIN ENCRYPTED PASSWORD
'<i>password</i>';" -d o=
virt_engine_history<o:p></o:p></span></p <p
class=3D"MsoNormal"><span
style=3D"font-size:10.5pt;font-family:DejaVuSa=
nsMono"><o:p> </o:p></span></p <p class=3D"MsoNormal">But I am getting the
error:<o:p></o:p></p <p
class=3D"MsoNormal"><span
style=3D"font-size:10.5pt;font-family:DejaVuSa=
nsMono"><o:p> </o:p></span></p <p class=3D"MsoNormal"><span
style=3D"font-size:8.0pt;font-family:"Cou=
rier New"">psql: FATAL: Peer authentication failed for user
&quo=
t;postgres"<o:p></o:p></span></p <p class=3D"MsoNormal"><span
style=3D"font-size:8.0pt;font-family:"Cou=
rier New""><o:p> </o:p></span></p <p class=3D"MsoNormal">Any suggestions would be
appreciated.<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p class=3D"MsoNormal"><b><span
style=3D"font-size:10.0pt;font-family:"=
;Arial",sans-serif;color:#1E47A4">Sandy Berger
</span></b><span
style=3D"font-size:10.5pt;font-family:"Arial",sa=
ns-serif;color:#444444"><o:p></o:p></span></p <p class=3D"MsoNormal"><i><span
style=3D"font-size:10.0pt;font-family:"=
;Arial",sans-serif;color:#434D5B">IT - EUX</span></i><span
style=3D"fo=
nt-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><o:p=
></o:p></span></p <p
class=3D"MsoNormal"><span
style=3D"font-size:10.5pt;font-family:"Ar=
ial",sans-serif;color:#444444"> <o:p></o:p></span></p <p class=3D"MsoNormal"><span
style=3D"font-size:10.0pt;font-family:"Ar=
ial",sans-serif;color:#1E47A4">Quad/Graphics</span><span
style=3D"font=
-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><o:p><=
/o:p></span></p <p
class=3D"MsoNormal"><i><span
style=3D"font-size:8.0pt;font-family:"=
Arial",sans-serif;color:#434D5B">Performance</span></i><span
style=3D"=
font-size:8.0pt;font-family:"Arial",sans-serif;color:#434D5B">&nb=
sp;through </span><i><span
style=3D"font-size:8.5pt;font-family:"=
Arial",sans-serif;color:#434D5B">Innovation</span></i><span
style=3D"f=
ont-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><o:=
p></o:p></span></p <p
class=3D"MsoNormal"><span
style=3D"font-size:10.5pt;font-family:"Ar=
ial",sans-serif;color:#434D5B"> </span><span
style=3D"font-size:1=
0.5pt;font-family:"Arial",sans-serif;color:#444444"><o:p></o:p></=
span></p <p
class=3D"MsoNormal"><span
style=3D"font-size:10.0pt;font-family:"Ar=
ial",sans-serif;color:#434D5B">Sussex, Wisconsin</span><span
style=3D"=
font-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><o=
:p></o:p></span></p <p
class=3D"MsoNormal"><span
style=3D"font-size:10.0pt;font-family:"Ar=
ial",sans-serif;color:#434D5B">414.566.2123 phone</span><span
style=3D=
"font-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><=
o:p></o:p></span></p <p
class=3D"MsoNormal"><span
style=3D"font-size:10.0pt;font-family:"Ar=
ial",sans-serif;color:#434D5B">414.566.4010/2123
pager/PIN</span><span=
style=3D"font-size:10.5pt;font-family:"Arial",sans-serif;color:#=
444444"><o:p></o:p></span></p <p
class=3D"MsoNormal"><span
style=3D"font-size:10.5pt;color:black"> <=
/span><span
style=3D"font-size:10.5pt;font-family:"Arial",sans-se=
rif;color:#444444"><o:p></o:p></span></p <p class=3D"MsoNormal"><span
style=3D"font-size:10.0pt;font-family:"Ar=
ial",sans-serif;color:black"><a
href=3D"mailto:sandy.berger@qg.com"><s=
pan
style=3D"color:blue">sandy.berger@qg.com</span></a></span><span
style=
=3D"font-size:10.5pt;font-family:"Arial",sans-serif;color:#444444=
"><o:p></o:p></span></p <p
class=3D"MsoNormal"><span
style=3D"font-family:"Arial",sans-se=
rif;color:black"><a href=3D"http://www.qg.com/"><span
style=3D"font-size:10=
.0pt;color:blue">www.QG.com</span></a></span><span
style=3D"font-size:10.5p=
t;font-family:"Arial",sans-serif;color:#444444"><o:p></o:p></span=
></p <p
class=3D"MsoNormal"><o:p> </o:p></p </div Follow
Us: <a href=3D"http://www.qg.com/social1">Facebook</a> | <a
href=3D"=
http://www.qg.com/social2" Twitter</a> | <a
href=3D"http://www.qg.com/social3">LinkedIn</a> | <a href=
=3D"http://www.qg.com/social4"
YouTube</a </body </html
--_000_DM5PR05MB316109DAF0F0DE0E2753E1E3D5300DM5PR05MB3161namp_--
9:43 a.m.
On Sun, Mar 26, 2017 at 6:12 AM, Berger, Sandy <SBERGER(a)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(a)qg.com
www.QG.com
Follow Us: Facebook | Twitter | LinkedIn | YouTube
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
--
Didi
10:57 a.m.
--_000_DM5PR05MB3161248763CD1DA59000D79DD5300DM5PR05MB3161namp_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
VGhhbmtzLiBUaGF0IHdvcmtlZC4gSG93ZXZlciwgbm93IHdoZW4gSSB0cnkgdG8gdXNlIHRoYXQg
dXNlciBmcm9tIGEgcmVtb3RlIHN5c3RlbSBJIGFtIGdldHRpbmcgdGhpcyBlcnJvci4gSeKAmW0g
bm90IHN1cmUgd2hhdCBJIG5lZWQgdG8gYWRkIHRvIHRoZSBwZ19oYmEuY29uZiBmaWxlIG9yIHdo
YXQgSSBuZWVkIHRvIGRvIGFmdGVyIGVkaXRpbmcgaXQuDQoNCg0KDQpDcmVkZW50aWFsIHZhbGlk
YXRpb24gd2FzIG5vdCBzdWNjZXNzZnVsOiBubyBwZ19oYmEuY29uZiBlbnRyeSBmb3IgaG9zdCAi
aXBfYWRkcmVzcyIsIHVzZXIgInVzZXJuYW1lIiwgZGF0YWJhc2UgIm92aXJ0X2VuZ2luZV9oaXN0
b3J5IiwgU1NMIG9mZg0KDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IFll
ZGlkeWFoIEJhciBEYXZpZCBbbWFpbHRvOmRpZGlAcmVkaGF0LmNvbV0NClNlbnQ6IFN1bmRheSwg
TWFyY2ggMjYsIDIwMTcgMTo0MyBBTQ0KVG86IEJlcmdlciwgU2FuZHkgPFNCRVJHRVJAcWcuY29t
Pg0KQ2M6IHVzZXJzQG92aXJ0Lm9yZw0KU3ViamVjdDogUmU6IFtvdmlydC11c2Vyc10gRXJyb3Ig
YXR0ZW1wdGluZyB0byBjcmVhdGUgZHdoIHJlYWRvbmx5IHVzZXINCg0KDQoNCk9uIFN1biwgTWFy
IDI2LCAyMDE3IGF0IDY6MTIgQU0sIEJlcmdlciwgU2FuZHkgPFNCRVJHRVJAcWcuY29tPG1haWx0
bzpTQkVSR0VSQHFnLmNvbT4+IHdyb3RlOg0KDQo+IEkgYW0gcnVubmluZyBvVmlydCA0LjEuMS4N
Cg0KPg0KDQo+DQoNCj4NCg0KPiBJIGFtIGZvbGxvd2luZyB0aGUgaW5zdHJ1Y3Rpb25zIGluIHRo
ZSDigJxEYXRhIFdhcmVob3VzZSBHdWlkZeKAnSB0byBjcmVhdGUgYW4NCg0KPiBhY2NvdW50IGZv
ciByZWFkb25seSBhY2Nlc3MgdG8gdGhlIGRhdGEgd2FyZWhvdXNlIGhpc3RvcnkgZGF0YWJhc2Uu
IEkgYW0gbm90DQoNCj4gZmFtaWxpYXIgd2l0aCBwb3N0Z3Jlcy4gSSBhbSB1c2luZyB0aGUgY29t
bWFuZDoNCg0KPg0KDQo+DQoNCj4NCg0KPiBwc3FsIC1VIHBvc3RncmVzIC1jICJDUkVBVEUgUk9M
RSB1c2VybmFtZSBXSVRIIExPR0lOIEVOQ1JZUFRFRCBQQVNTV09SRA0KDQo+ICdwYXNzd29yZCc7
IiAtZCBvdmlydF9lbmdpbmVfaGlzdG9yeQ0KDQo+DQoNCj4NCg0KPg0KDQo+IEJ1dCBJIGFtIGdl
dHRpbmcgdGhlIGVycm9yOg0KDQo+DQoNCj4NCg0KPg0KDQo+IHBzcWw6IEZBVEFMOiAgUGVlciBh
dXRoZW50aWNhdGlvbiBmYWlsZWQgZm9yIHVzZXIgInBvc3RncmVzIg0KDQo+DQoNCj4NCg0KPg0K
DQo+IEFueSBzdWdnZXN0aW9ucyB3b3VsZCBiZSBhcHByZWNpYXRlZC4NCg0KDQoNCkFyZSB5b3Ug
ZG9pbmcgdGhpcyBhcyByb290PyBQbGVhc2UgdHJ5IHRvIGRvIHRoaXMgZnJvbSBPUyB1c2VyICdw
b3N0Z3JlcycuDQoNCg0KDQpCZXN0LA0KDQoNCg0KPg0KDQo+DQoNCj4NCg0KPiBTYW5keSBCZXJn
ZXINCg0KPg0KDQo+IElUIC0gRVVYDQoNCj4NCg0KPg0KDQo+DQoNCj4gUXVhZC9HcmFwaGljcw0K
DQo+DQoNCj4gUGVyZm9ybWFuY2UgdGhyb3VnaCBJbm5vdmF0aW9uDQoNCj4NCg0KPg0KDQo+DQoN
Cj4gU3Vzc2V4LCBXaXNjb25zaW4NCg0KPg0KDQo+IDQxNC41NjYuMjEyMyBwaG9uZQ0KDQo+DQoN
Cj4gNDE0LjU2Ni40MDEwLzIxMjMgcGFnZXIvUElODQoNCj4NCg0KPg0KDQo+DQoNCj4gc2FuZHku
YmVyZ2VyQHFnLmNvbTxtYWlsdG86c2FuZHkuYmVyZ2VyQHFnLmNvbT4NCg0KPg0KDQo+IHd3dy5R
Ry5jb208aHR0cDovL3d3dy5RRy5jb20+DQoNCj4NCg0KPg0KDQo+DQoNCj4gRm9sbG93IFVzOiBG
YWNlYm9vayB8IFR3aXR0ZXIgfCBMaW5rZWRJbiB8IFlvdVR1YmUNCg0KPg0KDQo+IF9fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQoNCj4gVXNlcnMgbWFpbGlu
ZyBsaXN0DQoNCj4gVXNlcnNAb3ZpcnQub3JnPG1haWx0bzpVc2Vyc0BvdmlydC5vcmc+DQoNCj4g
aHR0cDovL2xpc3RzLm92aXJ0Lm9yZy9tYWlsbWFuL2xpc3RpbmZvL3VzZXJzDQoNCj4NCg0KDQoN
Cg0KDQoNCg0KLS0NCg0KRGlkaQ0KDQpGb2xsb3cgVXM6IEZhY2Vib29rPGh0dHA6Ly93d3cucWcu
Y29tL3NvY2lhbDE+IHwgVHdpdHRlcjxodHRwOi8vd3d3LnFnLmNvbS9zb2NpYWwyPiB8IExpbmtl
ZEluPGh0dHA6Ly93d3cucWcuY29tL3NvY2lhbDM+IHwgWW91VHViZTxodHRwOi8vd3d3LnFnLmNv
bS9zb2NpYWw0Pg0K
--_000_DM5PR05MB3161248763CD1DA59000D79DD5300DM5PR05MB3161namp_
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: base64
PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg
Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv
ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl
PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6
IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m
YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy
IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws
IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ
Zm9udC1zaXplOjExLjBwdDsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjt9DQph
OmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xv
cjojMDU2M0MxOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBzcGFu
Lk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xvcjoj
OTU0RjcyOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KcC5Nc29QbGFpblRleHQsIGxp
Lk1zb1BsYWluVGV4dCwgZGl2Lk1zb1BsYWluVGV4dA0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7
DQoJbXNvLXN0eWxlLWxpbms6IlBsYWluIFRleHQgQ2hhciI7DQoJbWFyZ2luOjBpbjsNCgltYXJn
aW4tYm90dG9tOi4wMDAxcHQ7DQoJZm9udC1zaXplOjExLjBwdDsNCglmb250LWZhbWlseToiQ2Fs
aWJyaSIsc2Fucy1zZXJpZjt9DQpzcGFuLlBsYWluVGV4dENoYXINCgl7bXNvLXN0eWxlLW5hbWU6
IlBsYWluIFRleHQgQ2hhciI7DQoJbXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCW1zby1zdHlsZS1s
aW5rOiJQbGFpbiBUZXh0IjsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjt9DQou
TXNvQ2hwRGVmYXVsdA0KCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTsNCglmb250LWZhbWls
eToiQ2FsaWJyaSIsc2Fucy1zZXJpZjt9DQpAcGFnZSBXb3JkU2VjdGlvbjENCgl7c2l6ZTo4LjVp
biAxMS4waW47DQoJbWFyZ2luOjEuMGluIDEuMGluIDEuMGluIDEuMGluO30NCmRpdi5Xb3JkU2Vj
dGlvbjENCgl7cGFnZTpXb3JkU2VjdGlvbjE7fQ0KLS0+PC9zdHlsZT48IS0tW2lmIGd0ZSBtc28g
OV0+PHhtbD4NCjxvOnNoYXBlZGVmYXVsdHMgdjpleHQ9ImVkaXQiIHNwaWRtYXg9IjEwMjYiIC8+
DQo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlbGF5
b3V0IHY6ZXh0PSJlZGl0Ij4NCjxvOmlkbWFwIHY6ZXh0PSJlZGl0IiBkYXRhPSIxIiAvPg0KPC9v
OnNoYXBlbGF5b3V0PjwveG1sPjwhW2VuZGlmXS0tPg0KPC9oZWFkPg0KPGJvZHkgbGFuZz0iRU4t
VVMiIGxpbms9IiMwNTYzQzEiIHZsaW5rPSIjOTU0RjcyIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0
aW9uMSI+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij5UaGFua3MuIFRoYXQgd29ya2VkLiBIb3dl
dmVyLCBub3cgd2hlbiBJIHRyeSB0byB1c2UgdGhhdCB1c2VyIGZyb20gYSByZW1vdGUgc3lzdGVt
IEkgYW0gZ2V0dGluZyB0aGlzIGVycm9yLiBJ4oCZbSBub3Qgc3VyZSB3aGF0IEkgbmVlZCB0byBh
ZGQgdG8gdGhlIHBnX2hiYS5jb25mIGZpbGUgb3Igd2hhdCBJIG5lZWQgdG8gZG8gYWZ0ZXIgZWRp
dGluZyBpdC48bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPjxzcGFuIHN0
eWxlPSJmb250LXNpemU6OC4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q291cmllciBOZXcmcXVvdDsi
PjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPjxz
cGFuIHN0eWxlPSJmb250LXNpemU6OC4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q291cmllciBOZXcm
cXVvdDsiPkNyZWRlbnRpYWwgdmFsaWRhdGlvbiB3YXMgbm90IHN1Y2Nlc3NmdWw6IG5vIHBnX2hi
YS5jb25mIGVudHJ5IGZvciBob3N0ICZxdW90OzxpPmlwX2FkZHJlc3M8L2k+JnF1b3Q7LCB1c2Vy
ICZxdW90OzxpPnVzZXJuYW1lPC9pPiZxdW90OywgZGF0YWJhc2UgJnF1b3Q7b3ZpcnRfZW5naW5l
X2hpc3RvcnkmcXVvdDssIFNTTCBvZmY8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0i
TXNvUGxhaW5UZXh0Ij48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRl
eHQiPi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tPGJyPg0KRnJvbTogWWVkaWR5YWggQmFyIERh
dmlkIFttYWlsdG86ZGlkaUByZWRoYXQuY29tXSA8YnI+DQpTZW50OiBTdW5kYXksIE1hcmNoIDI2
LCAyMDE3IDE6NDMgQU08YnI+DQpUbzogQmVyZ2VyLCBTYW5keSAmbHQ7U0JFUkdFUkBxZy5jb20m
Z3Q7PGJyPg0KQ2M6IHVzZXJzQG92aXJ0Lm9yZzxicj4NClN1YmplY3Q6IFJlOiBbb3ZpcnQtdXNl
cnNdIEVycm9yIGF0dGVtcHRpbmcgdG8gY3JlYXRlIGR3aCByZWFkb25seSB1c2VyPC9wPg0KPHAg
Y2xhc3M9Ik1zb1BsYWluVGV4dCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNv
UGxhaW5UZXh0Ij5PbiBTdW4sIE1hciAyNiwgMjAxNyBhdCA2OjEyIEFNLCBCZXJnZXIsIFNhbmR5
ICZsdDs8YSBocmVmPSJtYWlsdG86U0JFUkdFUkBxZy5jb20iPjxzcGFuIHN0eWxlPSJjb2xvcjp3
aW5kb3d0ZXh0O3RleHQtZGVjb3JhdGlvbjpub25lIj5TQkVSR0VSQHFnLmNvbTwvc3Bhbj48L2E+
Jmd0OyB3cm90ZTo8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPiZndDsg
SSBhbSBydW5uaW5nIG9WaXJ0IDQuMS4xLjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1Bs
YWluVGV4dCI+Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4
dCI+Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0
OzxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OyBJIGFt
IGZvbGxvd2luZyB0aGUgaW5zdHJ1Y3Rpb25zIGluIHRoZSDigJxEYXRhIFdhcmVob3VzZSBHdWlk
ZeKAnSB0byBjcmVhdGUgYW48bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQi
PiZndDsgYWNjb3VudCBmb3IgcmVhZG9ubHkgYWNjZXNzIHRvIHRoZSBkYXRhIHdhcmVob3VzZSBo
aXN0b3J5IGRhdGFiYXNlLiBJIGFtIG5vdDxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1Bs
YWluVGV4dCI+Jmd0OyBmYW1pbGlhciB3aXRoIHBvc3RncmVzLiBJIGFtIHVzaW5nIHRoZSBjb21t
YW5kOjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5i
c3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5ic3A7PC9v
OnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+PC9w
Pg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OyBwc3FsIC1VIHBvc3RncmVzIC1jICZxdW90
O0NSRUFURSBST0xFIHVzZXJuYW1lIFdJVEggTE9HSU4gRU5DUllQVEVEIFBBU1NXT1JEPG86cD48
L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7ICdwYXNzd29yZCc7JnF1b3Q7
IC1kIG92aXJ0X2VuZ2luZV9oaXN0b3J5PG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxh
aW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0
Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7
PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7IEJ1dCBJ
IGFtIGdldHRpbmcgdGhlIGVycm9yOjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWlu
VGV4dCI+Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+
Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0Ozxv
OnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OyBwc3FsOiBG
QVRBTDombmJzcDsgUGVlciBhdXRoZW50aWNhdGlvbiBmYWlsZWQgZm9yIHVzZXIgJnF1b3Q7cG9z
dGdyZXMmcXVvdDs8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPiZndDs8
bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPiZndDs8bzpwPiZu
YnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPiZndDs8bzpwPiZuYnNwOzwv
bzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPiZndDsgQW55IHN1Z2dlc3Rpb25zIHdv
dWxkIGJlIGFwcHJlY2lhdGVkLjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4
dCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij5BcmUgeW91
IGRvaW5nIHRoaXMgYXMgcm9vdD8gUGxlYXNlIHRyeSB0byBkbyB0aGlzIGZyb20gT1MgdXNlciAn
cG9zdGdyZXMnLjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+PG86cD4m
bmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij5CZXN0LDxvOnA+PC9vOnA+
PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBj
bGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0i
TXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxh
aW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0
Ij4mZ3Q7IFNhbmR5IEJlcmdlcjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4
dCI+Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0
OyBJVCAtIEVVWDxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0Ozxv
OnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5i
c3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5ic3A7PC9v
OnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OyBRdWFkL0dyYXBoaWNzPG86cD48
L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48
L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7IFBlcmZvcm1hbmNlIHRocm91Z2ggSW5u
b3ZhdGlvbjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+
Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5ic3A7
PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+
PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OyBTdXNzZXgsIFdpc2NvbnNpbjxvOnA+
PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+
PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OyA0MTQuNTY2LjIxMjMgcGhvbmU8bzpw
PjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPiZndDs8bzpwPiZuYnNwOzwvbzpw
PjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPiZndDsgNDE0LjU2Ni40MDEwLzIxMjMgcGFn
ZXIvUElOPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4m
bmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8
L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48
L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7IDxhIGhyZWY9Im1haWx0bzpzYW5keS5i
ZXJnZXJAcWcuY29tIj48c3BhbiBzdHlsZT0iY29sb3I6d2luZG93dGV4dDt0ZXh0LWRlY29yYXRp
b246bm9uZSI+c2FuZHkuYmVyZ2VyQHFnLmNvbTwvc3Bhbj48L2E+PG86cD48L286cD48L3A+DQo8
cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFz
cz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7IDxhIGhyZWY9Imh0dHA6Ly93d3cuUUcuY29tIj48c3BhbiBz
dHlsZT0iY29sb3I6d2luZG93dGV4dDt0ZXh0LWRlY29yYXRpb246bm9uZSI+d3d3LlFHLmNvbTwv
c3Bhbj48L2E+PG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86
cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJz
cDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286
cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7IEZvbGxvdyBVczogRmFjZWJvb2sg
fCBUd2l0dGVyIHwgTGlua2VkSW4gfCBZb3VUdWJlPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0i
TXNvUGxhaW5UZXh0Ij4mZ3Q7PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxh
aW5UZXh0Ij4mZ3Q7IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij4mZ3Q7IFVzZXJzIG1h
aWxpbmcgbGlzdDxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OyA8
YSBocmVmPSJtYWlsdG86VXNlcnNAb3ZpcnQub3JnIj48c3BhbiBzdHlsZT0iY29sb3I6d2luZG93
dGV4dDt0ZXh0LWRlY29yYXRpb246bm9uZSI+VXNlcnNAb3ZpcnQub3JnPC9zcGFuPjwvYT48bzpw
PjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPiZndDsgPGEgaHJlZj0iaHR0cDov
L2xpc3RzLm92aXJ0Lm9yZy9tYWlsbWFuL2xpc3RpbmZvL3VzZXJzIj4NCjxzcGFuIHN0eWxlPSJj
b2xvcjp3aW5kb3d0ZXh0O3RleHQtZGVjb3JhdGlvbjpub25lIj5odHRwOi8vbGlzdHMub3ZpcnQu
b3JnL21haWxtYW4vbGlzdGluZm8vdXNlcnM8L3NwYW4+PC9hPjxvOnA+PC9vOnA+PC9wPg0KPHAg
Y2xhc3M9Ik1zb1BsYWluVGV4dCI+Jmd0OzxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9
Ik1zb1BsYWluVGV4dCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5U
ZXh0Ij48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29QbGFpblRleHQiPjxvOnA+
Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb1BsYWluVGV4dCI+LS0gPG86cD48L286cD48
L3A+DQo8cCBjbGFzcz0iTXNvUGxhaW5UZXh0Ij5EaWRpPG86cD48L286cD48L3A+DQo8L2Rpdj4N
CkZvbGxvdyBVczogPGEgaHJlZj0iaHR0cDovL3d3dy5xZy5jb20vc29jaWFsMSI+RmFjZWJvb2s8
L2E+IHwgPGEgaHJlZj0iaHR0cDovL3d3dy5xZy5jb20vc29jaWFsMiI+DQpUd2l0dGVyPC9hPiB8
IDxhIGhyZWY9Imh0dHA6Ly93d3cucWcuY29tL3NvY2lhbDMiPkxpbmtlZEluPC9hPiB8IDxhIGhy
ZWY9Imh0dHA6Ly93d3cucWcuY29tL3NvY2lhbDQiPg0KWW91VHViZTwvYT4NCjwvYm9keT4NCjwv
aHRtbD4NCg==
--_000_DM5PR05MB3161248763CD1DA59000D79DD5300DM5PR05MB3161namp_--
11:15 a.m.
On Sun, Mar 26, 2017 at 10:57 AM, Berger, Sandy <SBERGER(a)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(a)qg.com>
Cc: users(a)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(a)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(a)qg.com
>
> www.QG.com
>
>
>
> Follow Us: Facebook | Twitter | LinkedIn | YouTube
>
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
--
Didi
Follow Us: Facebook | Twitter | LinkedIn | YouTube
--
Didi
2798
days inactive
2798
days old
3 comments
2 participants
participants (2)
-
Berger, Sandy -
Yedidyah Bar David