xwu

        <Directory /var/www/>
                Options FollowSymLinks MultiViews
                AllowOverride All
                Order allow,deny
                Allow from all

                # Use only MTime and Size (not INode) in Etags calculation
                FileETag MTime Size

                # GZIP text files (requires mod_deflate)

xwu

sudo mkdir /var/trait
sudo wget http://hgdownload.cse.ucsc.edu/goldenPath/hg18/bigZips/hg18.2bit -O /var/trait/hg18.2bit

cd

# dbSNP (only two tables)
wget ftp://ftp.ncbi.nih.gov:21/snp/organisms/human_9606/database/organism_data/OmimVarLocusIdSNP.bcp.gz
wget ftp://ftp.ncbi.nih.gov:21/snp/organisms/human_9606/database/organism_data/b129/b129_SNPChrPosOnRef_36_3.bcp.gz
gunzip OmimVarLocusIdSNP.bcp.gz
gunzip b129_SNPChrPosOnRef_36_3.bcp.gz

xwu

cd
wget http://github.com/xwu/trait-o-matic/tarball/master -O trait.tar.gz
rm -Rf xwu-trait-o-matic-*
tar -zxvf trait.tar.gz
sudo rm -Rf /usr/share/trait
sudo cp -R xwu-trait-o-matic-*/core /usr/share/trait

cd /usr/share/trait
sudo python setup.py build_ext --inplace

xwu

CREATE DATABASE `ariel` DEFAULT CHARACTER SET ASCII COLLATE ascii_general_ci;
CREATE DATABASE `caliban` DEFAULT CHARACTER SET ASCII COLLATE ascii_general_ci;
CREATE DATABASE `dbsnp` DEFAULT CHARACTER SET ascii COLLATE ascii_general_ci;

CREATE USER 'reader'@'localhost' IDENTIFIED BY 'shakespeare';
GRANT SELECT ON *.* TO `reader`@'localhost';
CREATE USER 'reader'@'%' IDENTIFIED BY 'shakespeare';
GRANT SELECT ON *.* TO `reader`@'%';

CREATE USER 'updater'@'localhost' IDENTIFIED BY 'shakespeare';

xwu

sudo apt-get install wget
sudo apt-get install zip unzip

sudo apt-get install apache2
sudo apt-get install apache2-threaded-dev

cd /etc/apache2/mods-enabled
sudo ln -s /etc/apache2/mods-available/expires.load expires.load
sudo ln -s /etc/apache2/mods-available/deflate.load deflate.load
sudo ln -s /etc/apache2/mods-available/rewrite.load rewrite.load