Database Installation

Dependancies

For Ubuntu or Debian Linux:

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib libpq-dev python3-dev graphviz python3-pip

Then install the python requirements (recommended in its own virtual environment) using:

pip install -r requirements.txt
pip install .
pip install -r webapp_tracet/requirements.txt

Environment Variables

To run the web application, you will need to set the following environment variables:

Variable	Description
DB_USER	Postgres user name which you will set in the next section.
DB_PASSWORD	Postgres password which you will set in the next section.
DB_SECRET_KEY	Django secret key. Here is a description of how to generate one.
TWILIO_ACCOUNT_SID	Your account SID from your Twilio Account which will be billed for the SMS and calls the database generates.
TWILIO_AUTH_TOKEN	Your auth token from your Twilio Account which will be billed for the SMS and calls the database generates.
TWILIO_PHONE_NUMBER	Your Twilio phone number from your Twilio Account which will be billed for the SMS and calls the database generates.
GMAIL_APP_PASSWORD	The app password for the mwa.trigger@gmail.com email. This can be supplied by Nick Swainston.
MWA_SECURE_KEY	This a project dependent secure key to schedule MWA observations. Contact the MWA operations team to receive one.
ATCA_SECURE_KEY_FILE	This a project dependent secure key file to schedule ATCA observations. Contact the ATCA operations team to receive one.
SYSTEM_ENV	Set this either to ‘PRODUCTION’ to turn off debug and enable CSRF_COOKIE_SECURE, or ‘DEVELOPMENT’ to turn on debug
UPLOAD_USER	A username of an account that will be used by upload_xml.py to upload VOEvents
UPLOAD_PASSWORD	The password of the upload user

Start the Postgres Database

The following commands will set up the Postgres database for the web app. Replace $DB_USER and $DB_PASSWORD with the environment variable values.

sudo -u postgres psql

CREATE DATABASE trigger_db;
CREATE USER $DB_USER WITH ENCRYPTED PASSWORD '$DB_PASSWORD';

ALTER ROLE $DB_USER SET client_encoding TO 'utf8';
ALTER ROLE $DB_USER SET default_transaction_isolation TO 'read committed';
ALTER ROLE $DB_USER SET timezone TO 'UTC';

Setup database for the first time

Run the following commands from the webapp_tracet subdirectory so Django can setup up the database structure and upload defaults

python manage.py makemigrations trigger_app
python manage.py migrate trigger_app
python manage.py migrate
python manage.py migrate --run-syncdb
python manage.py loaddata default_data.yaml

Create a superuser

These commands will set up a superuser account.

python manage.py createsuperuser

Delete Postgres Database

Only do this is you want to restart the database!

To delete the database use the following commands

sudo -u postgres psql

DROP DATABASE trigger_db;
CREATE DATABASE trigger_db;

You will then have to recreate the database using the commands in Setup database for the first time