Installing the latest nightly build of  UniTime 3.2 on a Debian Lenny box (using Oracle 10g XE database).

1) Install Java

apt-get install sun-java6-jdk

2) Install Tomcat

apt-get install tomcat5

apt-get install tomcat5.5-admin

Stop tomcat

/etc/init.d/tomcat5.5 stop

Edit /var/lib/tomcat5.5/conf/tomcat-users.xml

<?xml version='1.0' encoding='utf-8'?>

<tomcat-users>

  <role rolename="admin"/>

  <role rolename="tomcat"/>

  <role rolename="manager"/>

  <user username="tomcat" password="######"

        roles="tomcat,admin,manager"/>

</tomcat-users>

Edit /etc/init.d/tomcat5.5, add the following lines at the beginning of the file

(in the block where PATH, NAME, DESC and other variables are being set)

JAVA_HOME=/usr/lib/jvm/java-6-sun

JAVA_OPTS=-Xmx1024m

Start tomcat

/etc/init.d/tomcat5.5 start

Now, the tomcat should be running at http://localhost:8180

3) Install Oracle Database

apt-get install libc6-i386

wget -c \
  http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb \

  http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/oracle-xe-universal_10.2.0.1-1.1_i386.deb 

dpkg -i --force-architecture libaio_0.3.104-1_i386.deb

dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb

/etc/init.d/oracle-xe configure

Add the following lines to your ~/.bashrc

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

export ORACLE_SID=XE

export PATH=$PATH:$ORACLE_HOME/bin

Install Oracle JDBC driver

cp /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/jdbc/lib/ojdbc14.jar \

  /usr/share/tomcat5.5/common/lib

4) Install UniTime

Stop tomcat

/etc/init.d/tomcat5.5 stop

Create timetable database

wget -c \

http://unitime.cvs.sourceforge.net/viewvc/unitime/UniTime/Documentation/Database/Oracle/woebegon.dat -O woebegon.dat

sqlplus system@xe

create user timetable identified by ######;

grant dba to timetable;

exit

imp timetable/###### file=woebegon.dat full=y

Edit /etc/tomcat5.5/catalina.properties, add the following lines

# UniTime custom properties

tmtbl.custom.properties=/etc/tomcat5.5/unitime.properties

Edit /etc/tomcat5.5/unitime.properties

# Database connection settings

connection.url=jdbc:oracle:thin:@127.0.0.1:1521:xe

connection.driver_class=oracle.jdbc.driver.OracleDriver

dialect=org.hibernate.dialect.Oracle10gDialect

tmtbl.uniqueid.generator=org.hibernate.id.SequenceGenerator

connection.username=timetable

connection.password=######

default_schema=timetable

Get UniTime.war

wget -U "Mozilla/5.0 (compatible; Konqueror/3.2; Linux)" \

        http://www.unitime.org/builds/UniTime3.2/UniTime.war \

        -O /var/lib/tomcat5.5/webapps/UniTime.war

Edit /etc/tomcat5.5/policy.d/04webapps.policy, add the following lines

grant codeBase "file:/var/lib/tomcat5.5/webapps/UniTime/-" {

        permission java.security.AllPermission;

};

Create data folder

mkdir /var/lib/tomcat5.5/data

chown tomat55 /var/lib/tomcat5.5/data

Start tomcat

/etc/init.d/tomcat5.5 start

Now, the UniTime should be running at http://localhost:8080/UniTime