CartoDB installation on Ubuntu 12.04

cartodb20_build.sh

###################################
## CartoDB 2.0 Install [Working] ##
## Tested on Ubuntu 12.04        ##
###################################

sudo apt-get update
sudo apt-get safe-upgrade -y

# Install miscellaneous dependencies packages
sudo apt-get install -y git-core python-software-properties openmpi-bin libopenmpi-dev build-essential libxslt-dev zlib1g-dev ruby gems unzip

# Install RVM
bash -s stable < <(curl -s https://raw.github.com/wayneeseguin/rvm/master/binscripts/rvm-installer )

## REBOOT

# Install ruby and its dependencies
rvm pkg install openssl
# rvm pkg install zlib
rvm install 1.9.2 --with-openssl-dir=$rvm_path/usr # Not sure this needs to be specified
## ENTER q
rvm use 1.9.2
rvm use 1.9.2 --default
sudo apt-get install -y build-essential openssl libreadline6 libreadline6-dev curl git-core zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bison subversion pkg-config

# git:// port might be closed
git config --global url."https://".insteadOf "git://"

# Install CartoDB repo and unp
git clone --recursive https://github.com/CartoDB/cartodb20.git
cd cartodb20
git checkout master
git submodule update
git submodule foreach git checkout master
sudo apt-get install -y unp

# Install GDAL, GEOS, PROJ, JSON-C, and PostGIS
echo 'yes' | sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
sudo apt-get update
sudo apt-get install -y libgdal-dev libgeos-dev libproj-dev gdal-bin postgis postgresql-plpython-9.1 postgresql-contrib-9.1 postgresql-server-dev-9.1 libjson0 libjson0-dev python-gdal

# Install Redis
sudo apt-get install -y redis-server

# Install python dependencies
sudo apt-get install -y python-setuptools python-dev
sudo easy_install pip
cd cartodb20

## ENTER 'y'  -- maybe hit 'n'?
sudo pip install -r python_requirements.txt

# If GDAL installation fails
pip install --no-install GDAL
python setup.py build_ext --include-dirs=<path to GDAL download location>
pip install --no-download GDAL

# Repeat requirements installation
sudo pip install -r python_requirements.txt

sudo pip install -e git+https://github.com/RealGeeks/python-varnish.git@0971d6024fbb2614350853a5e0f8736ba3fb1f0d#egg=python-varnish
## ENTER 's'
cd ~

# Install Mapnik

# Add boost. Mapnik has a dependency on it
sudo add-apt-repository ppa:mapnik/boost
sudo apt-get update

echo 'yes' | sudo add-apt-repository ppa:mapnik/v2.0.2
sudo apt-get update
sudo apt-get install -y libmapnik mapnik-utils python-mapnik libmapnik-dev

# Install Node (For CDB 2.0, need version higher than what apt has, v0.6.12, so we will install from source.)
git clone https://github.com/joyent/node.git
cd ./node
git checkout v0.8.25-release ## 0.6.19 version works (I think?) with both CartoDB-SQL-API and Windshaft but try 0.4.12
./configure
make
sudo make install
cd ..

# Install npm
curl https://npmjs.org/install.sh | sudo sh

## Install CartoDB SQL API (need nodejs 0.8.x; works on 0.8.25)
git clone git://github.com/CartoDB/CartoDB-SQL-API.git
cd CartoDB-SQL-API
sudo npm install
cd ..


## Mapnik requires a ton of RAM to compile, so setup a swapdisk if needed.
cd /
sudo dd if=/dev/zero of=swapfile bs=1M count=3000
sudo mkswap swapfile
sudo swapon swapfile
sudo vim /etc/fstab ## Add:  /swapfile none swap sw 0 0
cd ~

## To try: install mapnik latest PPA
## Install nvm and install 0.6.19 from it (For CDB 2.0 install, seems to work fine with node v0.8.25)
git clone git://github.com/Vizzuality/Windshaft-cartodb.git
cd Windshaft-cartodb
sudo npm install
cd ../

cd cartodb20
bundle install --binstubs

## Set the right stuff here!
cp config/app_config.yml.sample config/app_config.yml
vim config/app_config.yml

cp config/database.yml.sample config/database.yml
vim config/database.yml


# Install varnish
sudo curl http://repo.varnish-cache.org/debian/GPG-key.txt | sudo apt-key add -
sudo vim /etc/apt/sources.list
# ADD: deb http://repo.varnish-cache.org/ubuntu/ lucid varnish-3.0
sudo apt-get update
sudo apt-get install varnish


## This inits the postgres–CartoDB connection & DBs
sed -i 's,some_secret,3b7de655b4a0064e0e08a7dc4a3eb156,g' ~/cartodb20/config/app_config.yml
sudo rm /etc/postgresql/9.1/main/pg_hba.conf
sudo touch /etc/postgresql/9.1/main/pg_hba.conf
sudo sh -c "echo 'local   all             postgres                                trust' >> /etc/postgresql/9.1/main/pg_hba.conf "
sudo sh -c "echo 'local   all             all                                     trust' >> /etc/postgresql/9.1/main/pg_hba.conf "
sudo sh -c "echo 'host    all             all             127.0.0.1/32            trust' >> /etc/postgresql/9.1/main/pg_hba.conf "
sudo sh -c "echo 'host    all             all             ::1/128                 trust' >> /etc/postgresql/9.1/main/pg_hba.conf "
sudo chown postgres:postgres /etc/postgresql/9.1/main/pg_hba.conf
sudo /etc/init.d/postgresql restart

# Install PostGIS from source, somehow the installation using the ppa:ubuntugis didn't work

cd /usr/local/src
wget http://download.osgeo.org/postgis/source/postgis-2.0.2.tar.gz
tar xzf postgis-2.0.2.tar.gz
cd postgis-2.0.2
./configure --with-raster --with-topology
make
make install


# Setup PostgreSQL with needed template
sudo pg_dropcluster --stop 9.1 main
sudo pg_createcluster --start -e UTF-8 9.1 main


sudo su - postgres
cd ~

psql

# ALTER USER postgres WITH PASSWORD '<your-new-password>';
# CREATE USER ubuntu WITH PASSWORD '<password>';
# ALTER ROLE ubuntu SUPERUSER;
# \q

vim template # Add the following:
#####
#!/bin/bash
POSTGIS_SQL_PATH=`pg_config --sharedir`/contrib/postgis-2.0
createdb -E UTF8 template_postgis
createlang -d template_postgis plpgsql
psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis'"
psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis.sql
psql -d template_postgis -f $POSTGIS_SQL_PATH/spatial_ref_sys.sql
psql -d template_postgis -f $POSTGIS_SQL_PATH/legacy.sql
psql -d template_postgis -f $POSTGIS_SQL_PATH/rtpostgis.sql
psql -d template_postgis -f $POSTGIS_SQL_PATH/topology.sql
psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;"
psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"
#####
chmod +x template
./template


export SUBDOMAIN=yoursubdomain
echo "127.0.0.1 ${SUBDOMAIN}.localhost.lan" | sudo tee -a /etc/hosts
sh script/create_dev_user ${SUBDOMAIN}
exit

# If there're errors related to 'publicuser' authentication problems, check the changes made to
# /etc/postgresql/9.1/main/pg_hba.conf

# touch ~/cartodb/config/redis.conf # Needed for CDB 2.0?
rails server -p 3000 ## Don't need this if starting with foreman as below



# EXPERIMENTAL
## make sure to rvmsudo any rails command that needs sudoing
## Also, be sure to make sure POSTGRES and REDIS aren't launching on boot if using foreman.
## (Could also change PROCFILE to restart these services rather than just starting them)
## also make sure postgres default port is 5432 and not 5433.

rvmsudo bundle exec foreman start -p 80

## OR add it add a startup item (can control via start cartodb, stop cartodb, restart cartodb)
rvmsudo foreman export upstart /etc/init --start-on-boot --user eric --port 80 --app cartodb

########################################
# FOR PRODUCTION MODE ONLY!!!
########################################

#Launch Varnish on another port
sudo varnishd -f /etc/varnish/default.vcl -s malloc,1G -T 0.0.0.0:6082 -a 0.0.0.0:6081

# Disable SSL
# In app/controllers/application_controller.rb, comment out line #18 & #25 to disable SSL
vim app/controllers/application_controller.rb