jlsherrill

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

# 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