[Users] Is it possible to change the DB password for local postgresql?
(ovirt 3.2) I have changed it in /etc/ovirt-engine/.pgpass and for the 'postgres' and 'engine' users in the database but after starting the engine my logs are full of FATAL: password authentication failed for user "engine" Any tips on changing the password?
You need to change the /etc/sysconfig/ovirt-engine password as well. You have a script to encode it at /etc/pki/ovirt-engine/encryptpasswd.sh or similar. ----- Original Message -----
From: "Ernest Beinrohr" <Ernest.Beinrohr@axonpro.sk> To: users@ovirt.org Sent: Wednesday, March 13, 2013 12:52:06 PM Subject: [Users] Is it possible to change the DB password for local postgresql?
(ovirt 3.2) I have changed it in /etc/ovirt-engine/.pgpass and for the 'postgres' and 'engine' users in the database but after starting the engine my logs are full of
FATAL: password authentication failed for user "engine"
Any tips on changing the password? _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
This is a multi-part message in MIME format. --------------080001050200000208050705 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit On 13.03.2013 11:57, Alon Bar-Lev wrote:
You need to change the /etc/sysconfig/ovirt-engine password as well. You have a script to encode it at /etc/pki/ovirt-engine/encryptpasswd.sh or similar.
Worked: I also created a simple page of the change process: http://www.ovirt.org/Postgresql_changing_db_pass -- Ernest Beinrohr, AXON PRO Ing <http://www.beinrohr.sk/ing.php>, RHCE <http://www.beinrohr.sk/rhce.php>, RHCVA <http://www.beinrohr.sk/rhce.php>, LPIC <http://www.beinrohr.sk/lpic.php>, +421-2--6241-0360 <callto://+421-2--6241-0360>, +421-903--482-603 <callto://+421-903--482-603> icq:28153343, skype:oernii-work <callto://oernii-work>, jabber:oernii@jabber.org ------------------------------------------------------------------------ “The bureaucracy is expanding to meet the needs of the expanding bureaucracy.” ― Oscar Wilde --------------080001050200000208050705 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit <html> <head> <meta content="text/html; charset=UTF-8" http-equiv="Content-Type"> </head> <body text="#000000" bgcolor="#FFFFFF"> <div class="moz-cite-prefix">On 13.03.2013 11:57, Alon Bar-Lev wrote:<br> </div> <blockquote cite="mid:749514208.6481765.1363172250753.JavaMail.root@redhat.com" type="cite"> <pre wrap="">You need to change the /etc/sysconfig/ovirt-engine password as well. You have a script to encode it at /etc/pki/ovirt-engine/encryptpasswd.sh or similar. </pre> </blockquote> Worked: I also created a simple page of the change process: <br> <br> <a class="moz-txt-link-freetext" href="http://www.ovirt.org/Postgresql_changing_db_pass">http://www.ovirt.org/Postgresql_changing_db_pass</a><br> <br> <br> <div class="moz-signature">-- <br> <div id="oernii_footer" style="color: gray;"> <span style="font-family: Lucida Console, Luxi Mono, Courier, monospace; font-size: 90%;"> Ernest Beinrohr, AXON PRO<br> <a style="text-decoration: none; color: gray;" href="http://www.beinrohr.sk/ing.php">Ing</a>, <a style="text-decoration: none; color: gray;" href="http://www.beinrohr.sk/rhce.php">RHCE</a>, <a style="text-decoration: none; color: gray;" href="http://www.beinrohr.sk/rhce.php">RHCVA</a>, <a style="text-decoration: none; color: gray;" href="http://www.beinrohr.sk/lpic.php">LPIC</a>, <a style="text-decoration: none; color: gray;" href="callto://+421-2--6241-0360">+421-2--6241-0360</a>, <a style="text-decoration: none; color: gray;" href="callto://+421-903--482-603">+421-903--482-603</a><br> icq:28153343, <a style="text-decoration: none; color: gray;" href="callto://oernii-work">skype:oernii-work</a>, <a class="moz-txt-link-abbreviated" href="mailto:jabber:oernii@jabber.org">jabber:oernii@jabber.org</a> <br> </span> <hr style="height: 1px; width: 95%"> “The bureaucracy is expanding to meet the needs of the expanding bureaucracy.” ― Oscar Wilde </div> </div> </body> </html> --------------080001050200000208050705--
On Thu, 14 Mar 2013 17:17:18 +0100 Ernest Beinrohr <Ernest.Beinrohr@axonpro.sk> wrote:
On 13.03.2013 11:57, Alon Bar-Lev wrote:
You need to change the /etc/sysconfig/ovirt-engine password as well. ^^^^^^^^^^^^^^^^^^^^^^^^^^^ world readable, very funny. Are we back in 80ies when /etc/passwd had passwords and was world readable (and under attacks all the time)?
----- Original Message -----
From: "Jiri Belka" <jbelka@redhat.com> To: "Ernest Beinrohr" <Ernest.Beinrohr@axonpro.sk> Cc: "Alon Bar-Lev" <alonbl@redhat.com>, users@ovirt.org Sent: Thursday, March 14, 2013 6:38:35 PM Subject: Re: [Users] Is it possible to change the DB password for local postgresql?
On Thu, 14 Mar 2013 17:17:18 +0100 Ernest Beinrohr <Ernest.Beinrohr@axonpro.sk> wrote:
On 13.03.2013 11:57, Alon Bar-Lev wrote:
You need to change the /etc/sysconfig/ovirt-engine password as well. ^^^^^^^^^^^^^^^^^^^^^^^^^^^ world readable, very funny. Are we back in 80ies when /etc/passwd had passwords and was world readable (and under attacks all the time)?
yes... this is going to be fixed as well. Alon
participants (3)
-
Alon Bar-Lev -
Ernest Beinrohr -
Jiri Belka