question Re: how to change password for ambari db post install in Archives of Support Questions (Read Only)

how to change password for ambari db post install

arpit1 — Fri, 05 Feb 2016 03:11:55 GMT

I have a cluster deployed via ambari and would like to change the password that is used to talk to db (psql). I also have encryption on for ambari db and ldap password (http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.0.0/bk_Ambari_Security_Guide/content/_optional_encrypt_database_and_ldap_passwords.html).

Re: how to change password for ambari db post install

nsabharwal — Fri, 05 Feb 2016 03:14:15 GMT

@arpit

See this

Re: how to change password for ambari db post install

arpit1 — Fri, 05 Feb 2016 03:15:22 GMT

@Neeraj Sabharwal i think that is reseting the password for admin user. I want to change the password for the db.

Re: how to change password for ambari db post install

nsabharwal — Fri, 05 Feb 2016 03:18:03 GMT

@arpit The password that you used during the ambari-server setup..correct?

Re: how to change password for ambari db post install

nsabharwal — Fri, 05 Feb 2016 03:19:08 GMT

@arpit Try this

Re: how to change password for ambari db post install

afernandez — Fri, 05 Feb 2016 03:20:05 GMT

$ grep "password" /etc/ambari-server/conf/ambari.properties
server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat

$ echo "bigdata_custom" > /etc/ambari-server/conf/password.dat

$ sudo -u postgres psql
postgres=# ALTER USER ambari WITH PASSWORD 'bigdata_custom';
postgres=# \q

$ ambari-server restart

Re: how to change password for ambari db post install

arpit1 — Fri, 05 Feb 2016 03:21:29 GMT

i dont have the file /etc/ambari-server/conf/password.dat. In ambari properties i see

server.jdbc.user.passwd=${alias=ambari.db.password}

But i cant find ambari.db.password in the properties file. I have encryption enabled for passwords.

Re: how to change password for ambari db post install

nsabharwal — Fri, 05 Feb 2016 03:26:53 GMT

@arpit See this https://ambari.apache.org/current/installing-hadoop-using-ambari/content/ch02s06s01s02.html

Re: how to change password for ambari db post install

arpit1 — Fri, 05 Feb 2016 04:16:39 GMT

@Neeraj Sabharwal are you suggesting i decrypt, change password and then encrypt again?

Re: how to change password for ambari db post install

nsabharwal — Fri, 05 Feb 2016 04:18:37 GMT

@arpit yes as per the doc...If it's production then need support on this.

Re: how to change password for ambari db post install

arpit1 — Fri, 05 Feb 2016 04:21:02 GMT

Its an internal production cluster. I will try to follow the steps and see how it goes.

Re: how to change password for ambari db post install

arpit1 — Thu, 11 Feb 2016 02:20:47 GMT

Thanks @Neeraj Sabharwal and @Alejandro Fernandez i used information from both answers and updated the password.

Re: how to change password for ambari db post install

Shelton — Thu, 11 Feb 2016 04:19:51 GMT

My ambari.properties has the following entries !

[root@amuru]# grep "password" /etc/ambari-server/conf/ambari.properties

server.jdbc.rca.user.passwd=/etc/ambari-server/conf/password.dat

server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat

All have the same password so enlighten me does the echo cascade the change ?

Re: how to change password for ambari db post install

nsabharwal — Thu, 11 Feb 2016 04:35:38 GMT

@arpit How did you handle the encryption?

Re: how to change password for ambari db post install

arpit1 — Thu, 11 Feb 2016 04:40:34 GMT

i un encrypted it and changed the password based on what @Alejandro Fernandez had and then encrypted it again.

Re: how to change password for ambari db post install

nsabharwal — Thu, 11 Feb 2016 05:35:02 GMT

@arpit The doc that I shared had a note on encryption...Just curious if you had chance to try that ..Link

Taking notes to make sure that we have a best answer to close the thread.

Re: how to change password for ambari db post install

arpit1 — Thu, 11 Feb 2016 05:37:45 GMT

@Neeraj that doc talks about changing master key for encryption. I had to change the password for DB. So i un encrypted. Changed password and encrypted it.