Last active
October 2, 2018 19:06
-
-
Save zyluo/a7a7adcdf1f58a33409382672ff6925d to your computer and use it in GitHub Desktop.
CDH6.0.0 Postgresql Database setup script
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
export PG_PASSWD="USE_UR_PASSWD" | |
for db_name in scm amon rman hue metastore sentry nav navms oozie; do sudo -u postgres psql -c "CREATE ROLE $db_name LOGIN PASSWORD '$PG_PASSWD';"; sudo -u postgres psql -c "CREATE DATABASE $db_name OWNER $db_name ENCODING 'UTF8';"; done | |
sudo -u postgres psql -c "SELECT rolname FROM pg_roles;" && sudo -u postgres psql -c "\l" | |
for db_name in metastore oozie; do sudo -u postgres psql -c "ALTER DATABASE $db_name SET standard_conforming_strings=off;"; done | |
sudo /opt/cloudera/cm/schema/scm_prepare_database.sh postgresql scm scm $DB_PASSWD |
Visualization Server Environment Advanced Configuration Snippet (Safety Valve)
VENV_PATH=AVOID_SYSTEM_PYTHON
ln -s /opt/cloudera/parcels/CDH-6.0.0-1.cdh6.0.0.p0.537114/jars/logredactor-2.0.6.jar /opt/cloudera/parcels/CDH/lib/spark/jars/logredactor-2.0.6.jar
cd /opt/cloudera/parcels/ARCADIAENTERPRISE-4.3.0.0-1531519736.cdh5/lib/arcviz/
./arcviz util user --list
./arcviz createsuperuser
./arcviz util user --username bduser --firstname admin --lastname admin --email zhongyue.nah@intel.com --password admin --group default
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
sudo find /usr -name "*.pyc" -delete