InstallationGuidelines/Linux/Server/ApachePostgresqlDebian8: configure-eden-apache-postgis-debian8.sh

#!/bin/sh
# Script to configure an Eden server
# - assumes that install-eden-apache-postgis-debian8.sh has been run

# Defines for sahana eden installation 
hostanddomain="127.0.0.1"
template="default"
key="testkey"
database_type="postgres"

# Defines for database connection
database_name="sahana"
database_port="5432"
database_user="sahana"
database_password="sahana"

#########
# Eden pre-installation of database
#########
#copy config template
cp ~web2py/applications/eden/modules/templates/000_config.py ~web2py/applications/eden/models
# adopt template according to defined values
sed -i "s|settings.base.template = \"default\"|settings.base.template = \"$template\"|" ~web2py/applications/eden/models/000_config.py
sed -i 's|EDITING_CONFIG_FILE = False|EDITING_CONFIG_FILE = True|' ~web2py/applications/eden/models/000_config.py
sed -i "s|akeytochange|$key|" ~web2py/applications/eden/models/000_config.py
sed -i "s|#settings.base.public_url = \"http://127.0.0.1:8000\"|settings.base.public_url = \"http://$hostanddomain\"|" ~web2py/applications/eden/models/000_config.py
#? wherefor
sed -i 's|#settings.base.cdn = True|settings.base.cdn = True|' ~web2py/applications/eden/models/000_config.py

#########
# PostgreSQL
#########
cd ~web2py
#-------
#drop db if one already exists - before we have to stop the wsgi process!!
/etc/init.d/apache2 stop
echo "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = '$database_name';" > /tmp/delete_current_connections.sql
su - postgres -c "psql -q -p $database_port -f /tmp/delete_current_connections.sql"
su - postgres -c "dropdb -p $database_port $database_name"
echo "database dropped"
echo "CREATE USER $database_user WITH PASSWORD '$database_password';" > /tmp/pgpass.sql
su - postgres -c "psql -q -p $database_port -d template1 -f /tmp/pgpass.sql"
#template 1? - for roles
rm -f /tmp/pgpass.sql
su - postgres -c "createdb -p $database_port -O $database_user -E UTF8 $database_name -T template0"
# PostGIS
su - postgres -c "psql -q -p $database_port -d $database_name -f /usr/share/postgresql/9.4/contrib/postgis-2.1/postgis.sql"
su - postgres -c "psql -q -p $database_port -d $database_name -f /usr/share/postgresql/9.4/contrib/postgis-2.1/spatial_ref_sys.sql"
su - postgres -c "psql -q -p $database_port -d $database_name -c 'grant all on geometry_columns to $database_user;'"
# maybe new to postgis 2.x
su - postgres -c "psql -q -p $database_port -d $database_name -c 'grant all on geography_columns to $database_user;'"
su - postgres -c "psql -q -p $database_port -d $database_name -c 'grant all on spatial_ref_sys to $database_user;'"
# maybe the following is not needed
su - postgres -c "psql -q -p $database_port -d $database_name -c 'ALTER DATABASE $database_name OWNER TO $database_user;'"

#########
# Eden post-installation of database
#########
# Disable comment on postgres configuration line
sed -i 's|#settings.database.db_type = "postgres"|settings.database.db_type = "postgres"|' ~web2py/applications/eden/models/000_config.py
# Defining password for database connection
sed -i "s|#settings.database.password = \"password\"|settings.database.password = \"$database_password\"|" ~web2py/applications/eden/models/000_config.py
# Enable spatial settings
sed -i 's|#settings.gis.spatialdb = True|settings.gis.spatialdb = True|' ~web2py/applications/eden/models/000_config.py
# Create the Tables & Populate with base data
# next line from mysql installation instruction - needed?
sed -i 's|settings.base.prepopulate = 0|#settings.base.prepopulate = 0|' ~web2py/applications/eden/models/000_config.py
#sed -i 's|settings.base.prepopulate = 0|settings.base.prepopulate = 1|' ~web2py/applications/eden/models/000_config.py
# If invoked a second time maybe it stucks on commented line!
#sed -i 's|#settings.base.prepopulate = 0|settings.base.prepopulate = 1|' ~web2py/applications/eden/models/000_config.py
sed -i 's|settings.base.migrate = False|settings.base.migrate = True|' ~web2py/applications/eden/models/000_config.py
cd ~web2py
# Delete .table entries for database which exists before, cause otherwise the new database will not be prepopulated
rm -rf ~web2py/applications/eden/databases/*
rm -rf ~web2py/applications/eden/compiled
sudo -H -u web2py python web2py.py -S eden -M -R applications/eden/static/scripts/tools/noop.py
# Next line needed?
sed -i 's|#settings.base.prepopulate = 0|settings.base.prepopulate = 0|' ~web2py/applications/eden/models/000_config.py
#sed -i 's|settings.base.prepopulate = 1|settings.base.prepopulate = 0|' ~web2py/applications/eden/models/000_config.py
sed -i 's|settings.base.migrate = True|settings.base.migrate = False|' ~web2py/applications/eden/models/000_config.py
cd ~web2py
# notice - after compile the apache2 process is restarted!!!
sudo -H -u web2py python web2py.py -S eden -M -R applications/eden/static/scripts/tools/compile.py
# Schedule backups for 02:01 daily
echo "1 2   * * * root    /usr/local/bin/backup" >> "/etc/crontab"
#read -p "Press any key to Reboot..."
#########
# Reboot? - why
#########
echo "Now rebooting.."
#reboot