Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

how to change password for ambari db post install

avatar
New Member

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
New Member

@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
New Member

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
New Member

@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
New Member

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