Created 02-04-2016 07:11 PM
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).
Created 02-04-2016 07:20 PM
$ 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
Created 02-04-2016 07:14 PM
Created 02-04-2016 07:15 PM
@Neeraj Sabharwal i think that is reseting the password for admin user. I want to change the password for the db.
Created 02-04-2016 07:18 PM
@arpit The password that you used during the ambari-server setup..correct?
Created 02-04-2016 07:19 PM
Created 02-04-2016 07:21 PM
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.
Created 02-04-2016 07:26 PM
Created 02-04-2016 08:16 PM
@Neeraj Sabharwal are you suggesting i decrypt, change password and then encrypt again?
Created 02-04-2016 08:18 PM
@arpit yes as per the doc...If it's production then need support on this.
Created 02-04-2016 08:21 PM
Its an internal production cluster. I will try to follow the steps and see how it goes.