manual_deployment.txt

MANUAL DEPLOYMENT

Target: Linux 3.13.0-34-generic #60-Ubuntu SMP x86_64 GNU/Linux

Main sources:
https://uwsgi.readthedocs.org/en/latest/tutorials/Django_and_nginx.html
https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-django-with-postgres-nginx-and-gunicorn
http://stackoverflow.com/questions/23073829/uwsgi-wont-reload-restart-or-let-me-run-service

sudo aptitude install python-pip libpq-dev python-dev git nginx python-virtualenv tmux postgresql postgresql-contrib uwsgi-plugin-python
sudo pip install uwsgi  

mkdir ~/radar
touch ~/radar/radar_nginx.conf
touch ~/radar/uwsgi_params
touch ~/radar/radar_uwsgi.ini 
sudo ln -s ~/radar/radar_nginx.conf /etc/nginx/sites-enabled/
sudo rm /etc/nginx/sites-enabled/default

cd ~/radar
virtualenv --no-site-packages venv_radar
source venv_radar/bin/activate 
git clone https://github.com/leonardofl/radar_parlamentar.git repo
cd repo
easy_install -U distribute
pip install -r requirements.txt
pip install ipython
mkdir /tmp/django_cache
sudo chmod 666 -R /tmp/django_cache/

sudo su - postgres
createdb radar
createuser radar -P
psql
GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser;
echo "localhost:5432:radar:radar:$SENHA" > ~/.pgpass
chmod 600 .pgpass

cd ~/radar/repo/radar_parlamentar/settings
<create settings/production.py>
cd ~/radar/repo/radar_parlamentar
python manage.py syncdb
python manage.py migrate

export LANG="en_US.UTF-8" # avoids a django bug. not necessary if $LANG is already set
python manage.py createsuperuser (admin / password)

#add root user to nginx’s group (www-data), or vice-versa, 
#so that nginx can read and write to the socket properly
sudo usermod -a -G root www-data 
sudo usermod -a -G www-data root 
#obs: "usermod -a -G ftp tony" adds tony user to ftp group

# importing radar data
cd ~/radar/repo/radar_parlamentar
python manage.py shell
from importadores import cmsp
cmsp.main()
from importadores import senado
senado.main()
from importadores import camara
camara.main()

# configuring uwsgi to start at boot 
sudo mkdir -p /var/log/uwsgi
touch /etc/init/uwsgi.conf
sudo initctl start uwsgi
#(sudo restart uwsgi)

sudo /etc/init.d/nginx restart

echo "" >> .bashrc
echo "#Radar section" >> .profile
echo "export RADAR_HOME=\$HOME/radar/repo/radar_parlamentar" >> .profile
echo "source \$RADAR_HOME/settings/is_prod.sh" >> .profile
echo "export PATH=\$PATH:\$RADAR_HOME/cron" >> .profile
echo "source \$HOME/radar/venv_radar/bin/activate" >> .profile

crontab $RADAR_HOME/cron/crontab

sudo mkdir /var/log/radar
sudo chown $USER /var/log/radar


**** 

#Updating
git pull
sudo restart uwsgi
clear-cache.sh

***

Using manage.py:
source venv_radar/bin/activate # activate virtual env if it is not already activated
python manage.py ... # whatever

Exploring the database:
psql radar radar -h localhost
show tables: \dt
show table schema: \d <table_name>