Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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.