Install coge

Server with existing CoGe Installation

Create new mysql database

• Dump CoGe Database schema
  • File download: http://data.iplantcollaborative.org/quickshare/71b18508287f9fb0/cogetable.sql (AUTO_INCREMENT removed)

mysqldump -d -h localhost -u root -pXXXXXXX coge | sed 's/AUTO_INCREMENT=[0-9]*\b/AUTO_INCREMENT/' > cogetable.sql

• Create new CoGe Database

create database oryza_coge

• Initialize new coge database

mysql -u root -pXXXXXXXX oryza_coge < cogetable.sql

• populate a few entries in the feature_type table
  • This is important because part of CoGe's code-base is keyed to feature_type_ids. This is done in order to improve performance of the system by using a feature_type_id to retrieve features of a particular type. An example is OrganismView which needs to find features of type "chromosome" in order to determine the size of a genome. The table loaded here contains 10 feature types
  • Download file: http://data.iplantcollaborative.org/quickshare/ac8758f83c9b29b1/feature_type.sql

mysql -u root -pXXXXXXXXX oryza_coge < feature_type.sql

• Create new user for new CoGe database
  • Want a web-user with limited write privileges and a power user to load new data

create user 'oryza_coge'@'localhost' IDENTIFIED BY 'XXXXXX';
grant all privileges on oryza_coge.* to oryza_coge;
create user 'oryza_coge_web'@'localhost' IDENTIFIED BY 'XXXXXX';
grant select on oryza_coge.* to oryza_coge_web;
flush privileges;

Note: The CoGe web-user needs edit/insert permission on some tables. Here is a snapshot of what these are:

Deploy new CoGe Web-site

git clone https://github.com/LyonsLab/coge.git

• make directories where files go and give write persmission

mkdir tmp;
chmod 777 tmp/;

cd data/;
mkdir image_cache;
chmod 777 image_cache/;
mkdir genomic_sequence;
chmod 777 genomic_sequence/;
mkdir diags;
chmod 777 diags/;
mkdir bed;
chmod 777 bed/;
mkdir fasta;
chmod 777 fasta/;
mkdir blast/db;
chmod 777 blast/db/;

• configure apache

sudo vi /etc/apache2/sites-enabled/000-default

##Configure the main website
Alias /Oryza_CoGe "/opt/apache2/Oryza_CoGe"
Alias /oryza_coge "/opt/apache2/Oryza_CoGe"
Alias /oCoGe "/opt/apache2/Oryza_CoGe"
Alias /ocoge "/opt/apache2/Oryza_CoGe"
<Directory "/opt/apache2/Oryza_CoGe">
  PerlInitHandler Apache2::Reload
  Options Includes Indexes ExecCGI FollowSymLinks
  AllowOverride AuthConfig
  SetEnv HOME "/opt/apache2/Oryza_CoGe/"
  Order allow,deny
  Allow from all
</Directory>

##configure gobe (visualization tool for GEvo)
<Directory "/opt/apache2/Oryza_CoGe/gobe/">
   Options FollowSymLinks +ExecCGI
   AddHandler wsgi-script .py
</Directory>

• Configure coge.conf file

##This is a configuration file for CoGe.  
##Key Value pairs:
##<NAME>    <PATH>

#database configuration
DBNAME    oryza_coge
DBHOST    localhost
DBPORT    3306
DBUSER    oryza_coge_web
DBPASS    XXXXXXXXXXXX

#basedir for coge
COGEDIR     /opt/apache/Oryza_CoGe/

#bin dir for coge's programs
BINDIR      /opt/apache/Oryza_CoGe/bin/ 

#data dir for coge's programs
DATADIR     /opt/apache/Oryza_CoGe/data/ 

#dir for pair-wise whole genome comparisons (e.g. SynMap)
DIAGSDIR            /opt/apache/Oryza_CoGe/diags/ 

#fasta dir
FASTADIR            /opt/apache/Oryza_CoGe/data/fasta/

#TMPL dir for coge's web page templates
TMPLDIR     /opt/apache/Oryza_CoGe/tmpl/

#temp dir for coge
TEMPDIR   /opt/apache/Oryza_CoGe/tmp/

#Base URL for web-site
URL         /Oryza_CoGe/

#URL for temp directory
TEMPURL     /Oryza_CoGe/tmp/

#blast style scoring matrix dirs
BLASTMATRIX    /opt/apache/Oryza_CoGe/data/blast/matrix/

#blastable DB
BLASTDB    /opt/apache/Oryza_CoGe/data/blast/db/

#directory for bed files
BEDDIR     /opt/apache/Oryza_CoGe/data/bed/

#servername for links
SERVER      http://coge.iplantcollaborative.org/Oryza_CoGe/

#directory for caching genome browser images
IMAGE_CACHE /opt/apache/Oryza_CoGe/data/image_cache/

Get CoGeX

• Contains the libraries for connecting to the CoGe Database
  • Contains the accessory scripts for managing data in the CoGe Database

svn co svn+sshtunnel://coge.iplantcollaborative.org/storage/SVN.d/CoGeX

Get the rest of CoGe's libraries

• There are a few other libraries CoGe's website uses which can be obtained:

svn co svn+sshtunnel://coge.iplantcollaborative.org/storage/SVN.d/CoGe

• The directories from which you should install are:
  • Accessory
  • Algos :
    • Codeml
    • KsCalc
    • Pairwise
  • Graphics
  • You may want to use one of the true-type fonts in the fonts dir and configure the coge.conf file to point to it.

Populate with test data

CoGeX/scripts/replicate_genome_between_coge_installations.pl -dsgid 11022 -u1 coge -p1 XXXXXXX -db1 coge -u2 oryza_coge -p2 XXXXXXX -db2 oryza_coge -sd /opt/apache/oryz_coge/data/genomic_sequence

Problem hunting

Visualization in GEvo does not work

This relies on a system known as Gobe. Check the following things:

• Apache configuration for gobe
• Check to see if paths hard-coded into gobe/flash/service.wsgi need to be updated
  • NOTE: Not sure if this is required