Skip to main content
loridigia
loridigia
Gold ⭐️
May 3, 2022
Solved

[AMBARI 2.7.4] Change Postgres Ambari database default password

Hi all, i saw this guide: https://community.cloudera.com/t5/Support-Questions/how-to-change-password-for-ambari-db-post-install/td-p/126685

but it was for Ambari 2.2.0 and i was wondering if do you think is the same for Ambari 2.7.4.
I have in ambari.properties:
 - server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat
Doing "cat /etc/ambari-server/conf/password.dat " i see the default password (bigdata) in plain, so NO PASSWORD ENCRYPTION ENABLED.
I'm using Postgres 9.3

Thanks!!

loridigia
loridigiaAnswer
Gold ⭐️
May 3, 2022

As described in the link that i posted above, those steps works perfectly:
P.S. i stopped ambari-server before doing those

$ 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 in thread

1 reply

loridigia
loridigiaAuthorAnswer
Gold ⭐️
May 3, 2022

As described in the link that i posted above, those steps works perfectly:
P.S. i stopped ambari-server before doing those

$ 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

Translate
Terms & ConditionsAccessibility statement