4 echo usage: $0 "[initdb | createdb | dropdb | syncdb | runserver | resetdb | dumpdata]"
8 BACKUP_DIR=/opt/planetstack_backups
12 function ensure_postgres_running {
13 # "sudo -u postgres pg_ctl -D /var/lib/postgres/data status" doesn't work
14 # right on Vicci, so let's try to detect it by seeing if the port is
17 netstat -nl | grep -i ":5432 "
18 if [[ $? == 0 ]]; then
19 echo "Postgres is already running"
23 /sbin/service postgresql initdb
24 /sbin/service postgresql start
25 /sbin/chkconfig postgresql on
27 netstat -nl | grep -i ":5432 "
28 if [[ $? != 0 ]]; then
29 # it's still not running
30 echo "Trying fallback mechanism to start Postgres"
31 sudo -u postgres initdb -D /var/lib/pgsql/data/
32 sudo -u postgres pg_ctl -D /var/lib/pgsql/data -l logfile start
37 echo "Creating OpenCloud database..."
38 sudo -u postgres createdb planetstack
41 echo "Dropping OpenCloud database..."
42 sudo -u postgres dropdb planetstack
45 echo "Syncing OpenCloud services..."
46 python /opt/planetstack/manage.py syncdb --noinput
49 echo "Syncing OpenCloud services..."
50 python /opt/planetstack/manage.py evolve --hint --execute --noinput
53 echo "Stopping any running OpenCloud Service(s)"
54 pkill -f "python.*runserver"
57 PUBLIC_HOSTNAME=`/opt/planetstack/planetstack-config.py get server_hostname $HOSTNAME`
58 echo "Starting OpenCloud Service on $PUBLIC_HOSTNAME:8000"
59 python manage.py runserver $PUBLIC_HOSTNAME:8000&
64 FN="$BACKUP_DIR/dumpdata-`date +%Y-%m-%d_%H:%M:%S`.json"
65 echo "Saving data to $FN"
66 python manage.py dumpdata core hpc syndicate_storage requestrouter -a --indent 4 > $FN
67 if [[ ! -f $FN ]]; then
68 echo "FAILED to create $FN"
71 SIZE=$(du -k "$FN" | cut -f 1)
72 if [[ $SIZE -lt 9 ]]; then
73 echo "Dumpdata was empty. Deleting and aborting"
77 rm -f $BACKUP_DIR/dumpdata-latest.json
78 ln -s $FN $BACKUP_DIR/dumpdata-latest.json
84 echo "Generating keys"
85 keyczart create --location=private_keys --name="OpenCloud" --purpose=crypt --asymmetric=rsa
86 keyczart addkey --location=private_keys --status=primary --size=1024
87 keyczart pubkey --location=private_keys --destination=public_keys
88 if [[ ! -f public_keys/1 ]]; then
89 echo "FAILED to create keys"
96 if [ "$COMMAND" = "initdb" ]; then
98 ensure_postgres_running
102 if [ "$COMMAND" = "repairdb" ]; then
104 ensure_postgres_running
106 # TODO: This is where we could run migration scripts to upgrade the
107 # dumped data to the new models.
108 mv /opt/planetstack/core/fixtures/initial_data.json /opt/planetstack/core/fixtures/initial_data.json-old
109 cp $BACKUP_DIR/dumpdata-latest.json /opt/planetstack/core/fixtures/initial_data.json
114 if [ "$COMMAND" = "restoredb" ]; then
115 if [[ ! -f $BACKUP_DIR/dumpdata-latest.json ]]; then
116 echo There is no dumpdata to restore
120 ensure_postgres_running
121 mv /opt/planetstack/core/fixtures/initial_data.json /opt/planetstack/core/fixtures/initial_data.json-old
122 cp $BACKUP_DIR/dumpdata-latest.json /opt/planetstack/core/fixtures/initial_data.json
127 if [ "$COMMAND" = "evolvedb" ]; then
129 ensure_postgres_running
132 if [ "$COMMAND" = "resetdb" ]; then
138 if [ "$COMMAND" = "syncdb" ]; then
142 if [ "$COMMAND" = "runserver" ]; then
146 if [ "$COMMAND" = "stopserver" ]; then
149 if [ "$COMMAND" = "dumpdata" ]; then
152 if [ "$COMMAND" = "genkeys" ]; then