Last active
January 6, 2019 20:33
-
-
Save mrmichalis/5984131 to your computer and use it in GitHub Desktop.
Get list of password from Cloudera Manager embedded PostgreSQL DB and cloudera-scm
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env bash | |
#get-cmpasswd.sh | |
# password for amon, smon, hmon, rman, nav, scm | |
cat /etc/cloudera-scm-server/db*.properties | sed '/^#/ d' | |
# password for cloudera-scm | |
head -1 /var/lib/cloudera-scm-server-db/data/generated_password.txt | |
# password for hive | |
psql -U scm -W scm -h localhost -p 7432 -c "select attr,value from configs where attr like 'hive_metastore_database%' order by revision_id DESC limit 5;" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
thanks