Support Questions
Find answers, ask questions, and share your expertise

[AMBARI 2.7.4] Change Postgres Ambari database default password

Explorer

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

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!!

1 ACCEPTED SOLUTION

Explorer

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 solution in original post

1 REPLY 1

Explorer

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
; ;