Justin Sherrill jlsherrill
jlsherrill
/ force full sync
Last active
October 19, 2017 17:37
— forked from ehelms/force full sync
This file contains 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
| mongo pulp_database --eval 'db.repo_importers.update({"scratchpad": {$ne: null}}, {$set: {"scratchpad.repomd_revision": null}}, {"multi":true})' | |
| mongo pulp_database --eval 'db.repo_distributors.update({"last_publish": {$ne: null}}, {$set: {"last_publish": null}}, {"multi":true})' |
jlsherrill
/ change postgres user pass.sh
Last active
March 16, 2018 16:21
— forked from mccun934/change postgres user password
change postgres user pass
This file contains 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
| # EG : ALTER USER Postgres WITH PASSWORD '<newpassword>'; | |
| CP_PASS=`grep jpa.config.hibernate.connection.password /etc/candlepin/candlepin.conf | awk -F= '{print $2}'` | |
| F_PASS=`grep password /etc/foreman/database.yml | awk -F: '{print $2}' | sed 's/"//g'` | |
| echo "ALTER USER candlepin WITH PASSWORD '$CP_PASS';" | sudo -u postgres psql | |
| echo "ALTER USER foreman WITH PASSWORD '$F_PASS';" | sudo -u postgres psql |