Support Questions

Find answers, ask questions, and share your expertise

how to change password for ambari db post install

avatar
Contributor

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).

1 ACCEPTED SOLUTION

avatar
$ 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

View solution in original post

16 REPLIES 16

avatar
Master Mentor

avatar
Contributor

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

avatar
Master Mentor

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

avatar
Master Mentor

@arpit Try this

avatar
Contributor

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.

avatar
Master Mentor

avatar
Contributor

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

avatar
Master Mentor

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

avatar
Contributor

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