Ft. Collins Research

Visualizing media files across time and space.

Odessa Server installation prerequisites

Before installing the Odessa application the server must have the following prerequisite applications installed and runnging

Installing Java

apt-get install sun-java6-bin sun-java6-jre sun-java6-jdk
update-java-alternatives -s java-6-sun

To view the current java version run the command

java -version

Install the build environment for later compiling / installing modules

apt-get install build-essential linux-headers-$(uname -r)

Install apache2

apt-get install apache2

Apache Extension Tool (apxs2)

apt-get install apache2-threaded-dev

Install Tomcat

Ubuntu Lucid uses Tomcat version 6 not 5.5

apt-get install tomcat6
apt-get install tomcat6-admin

Install PostgreSQL 8.4.3-1 or higher version

PostgreSQL installation Help Install Help

apt-get install postgresql-8.4

Enter psql command prompt and change the postgres password in the 'postgres' database to something else.

sudo -u postgres psql postgres

\password postgres

Configuring Postgresql for TCP/IP connectivity

Edit the /etc/postgresql/8.*/main/pg_hba.conf to allow connections from other systems. Example assumes the non-routable IP 192.168.0.0 block is being used for the server. If your server is using a different IP block edit accordingly.

# Database administrative login by UNIX sockets
local   all         postgres                          ident

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    all         all         192.168.0.1/24        trust
# IPv6 local connections:
host    all         all         ::1/128               md5

Edit the etc/postgresql/8.*/main/postgresql.conf in your favourite editor and alter the listen_addresses as below.

Change the following line from 
#listen_addresses = 'localhost'
	To 
listen_addresses = '*'

Install PostGIS spatial cartidge for PostgreSQL (1.4.0-2 at time of documentation)

apt-get install postgis
apt-get install postgresql-8.4-postgis

Alternate build installation for latest version of Postgis (1.5.1)

# Documentation URL: http://www.postgis.org/documentation/manual-1.4/
# apt-get install libxml2-dev
# apt-get install postgresql-server-dev-8.4 libpq-dev
# apt-get install libgeos-dev
# apt-get install proj

Alternate install for GEOS 3.1.1

Postgis version 1.5.1 demands GEOS 3.1.1 so if you have installed that version you will need to perform the following installation procedure.

# wget http://postgis.refractions.net/download/postgis-1.5.1.tar.gz
# tar xvfz postgis-1.5.1.tar.gz
# cd postgis-1.5.1
# ./configure
# make
# make install