Ubuntu vanilla install notes

Install ubuntu-11.10 32bit in virtual box. (also tested in 12.04 LTS Beta2 server 32bit)

Use bridged networking to get a real IP address

System requirements

# Ubuntu packages
sudo apt-get install python-dev gcc-4.4 \
     postgresql-9.1-postgis postgresql-server-dev-9.1 \
     python-gdal python-imaging python-pip \
     apache2 libapache2-mod-wsgi python-software-properties

# Mapnik
sudo add-apt-repository ppa:mapnik/nightly-2.0
sudo apt-get update
sudo apt-get install libmapnik mapnik-utils python-mapnik

# Python PyPi packages
sudo pip install virtualenv

Virtual envrionment

mkdir src
cd src
virtualenv --system-site-packages testenv
cd testenv
source bin/activate
pip install madrona  

Database setup

#run as postgres superuser
sudo su postgres
POSTGIS_SQL_PATH=`pg_config --sharedir`/contrib/postgis-1.5
createlang -d template1 plpgsql # Adding PLPGSQL language support.
psql -d template1 -f $POSTGIS_SQL_PATH/postgis.sql # Loading the PostGIS SQL routines
psql -d template1 -f $POSTGIS_SQL_PATH/spatial_ref_sys.sql
psql -d template1 -f lib/python2.7/site-packages/madrona/common/sql/cleangeometry.sql
psql -d template1 -c "GRANT ALL ON geometry_columns TO PUBLIC;" # Enabling users to alter spatial tables.
psql -d template1 -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"
createuser -s madrona -P  # ... then enter password 
exit # back to regular user
createdb example -U madrona

Create sample app

ifconfig eth0 | grep "inet addr"  # find the IP address
mkdir apps
cd apps
create-madrona-project.py \
   --project testproject \
   --app testapp \
   --domain 192.168.50.229:8000 \
   --connection "dbname='example' user='madrona' password='<PASSWORD>'" \

#   --studyregion sample.shp \
#   --features AOI POI \
#   --kmls GlobalXXX