JVM

First of all, you need to install a JAVA virtual machine. I personnaly choosed to install the SUN one. Depending on your Debian version, the SUN JVM is either available as a package, eithier you need to make your own .deb from the standard SUN installation.

Have a look in the available installations for SUN JVM, and install it if found:

# apt-cache search sun-java5-jdk
sun-java5-bin - Sun Java(TM) Runtime Environment (JRE) 5.0 (architecture dependent files)
sun-java5-jdk - Sun Java(TM) Development Kit (JDK) 5.0
sun-java5-jre - Sun Java(TM) Runtime Environment (JRE) 5.0 (architecture independent files)
# apt-get install sun-java5-jdk sun-java5-jre 
        

If there is no installation available, you need to download the Java 2 Platform Standard Edition 5.0. Then, you have to make it a Debian package in order to register it as the Java virtual machine of your Debian system.

# apt-get install java-package
# fakeroot make-jpkg jdk-1_5_0_05-linux-i586.bin
# dpkg -i sun-j2sdk1.5_1.5.0+update05_i386.deb
        

Web Container

The web archive is to be deployed in a web container, configured with a datasource pointing to a Bugzilla database, and other configuration parameters detailled below.

Installing Tomcat 5, mySQL java driver and referencing it in Tomcat 5.5

# apt-get install tomcat5.5
# apt-get install libmysql-java
# cd /usr/share/tomcat5.5/common/lib/
# ln -s /usr/share/java/mysql.jar
         

Database backend

The application needs a database backend to store users, rights, and meta information. As it uses hibernate, you do not have to care about creating the database objects: the application will do it itself. Nevertheless, it does require an existing database instance.

Please note that for the moment, only MySQL is supported. To install it:

# apt-get install mysql-server
         

Download and extract to installation directory

The application is packaged in a tar.gz format. Download, Gunzip and Untar it in your software installation directory:

# cd /usr/local/java
# wget http://www.jujunie.com/downloads/jujunie-integration-x.y.z.tar.gz
# tar -zxvf jujunie-integration-x.y.z.tar.gz
# rm jujunie-integration-x.y.z.tar.gz
        

TODO: More secure configuration have to be documented: In order to access a Planner file on your filesystem, edit the /etc/default/tomcat5.5 and set the TOMCAT5_SECURITY=no.

Create the database

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 40920
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database my_integration;
Query OK, 1 row affected (0.06 sec)

mysql> grant all privileges on my_integration.* to 'integration_usr'@'%' identified by 'integration_usr_password';
Query OK, 0 rows affected (0.05 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

mysql> exit
Bye
        

Define Datasources in web container

A datasource must be available to connect to the integration database. This datatasource must be resolved using the JNDI name jdbc/integration. To configure the datasource, edit the /etc/tomcat5/server.xml file and add the datasource configuration into the host node where the application will be deployed. Hereafter a datasource configuration sample (created using Tomcat user guide):

<Context path="/jujunie-integration" 
            docBase="jujunie-integration"
            debug="5"
            reloadable="true"
            crossContext="true">
...
  <Resource name="jdbc/integration"
               auth="Container"
               type="javax.sql.DataSource"
               maxActive="100"
               maxIdle="30"
               maxWait="10000"
               username="integration_usr"
               password="integration_usr_pasword"
               driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://www.example.com:3306/my_integration?autoReconnect=true"/>
...
</Context>    
         

The only required datasource is to access the jujunie integration database you've just created. But depending on the functionalities you will use, you'll have to configure others:

Properties configuration

You then have to configure several properties to match your environment. The properties have a default value listed below. To override one, you have to define it in your JNDI tree. Hereafter the smtp server hostname property configuration sample (created using Tomcat user guide ):

<Environment name="jujunie-integration/common/mail/smtp-hostname"
                   value="mail.intranet.fimasys.fr"
                   type="java.lang.String"
                   override="false"/>
         

<?xml version="1.0" encoding="UTF-8"?>
<reports>
  <hours-worked>
    <report id="sample1" name="Preset Query Sample">
      <selector name="With 'delivery' keyword"
                   add-from=", keywords, keyworddefs"
                   add-where=" and keyworddefs.name='delivery'
                               and keyworddefs.id = keywords.keywordid
                               and keywords.bug_id = bugs.bug_id"/>
    </report>
  </hours-worked>
  <deadline>
    <report id="deadline-opened" name="Opened bugs that have a deadline">
      <selector name="Opened with deadline"
                   add-from=""
                   add-where=" and bugs.deadline is not null
                               and bug_status in ('UNCONFIRMED',
                                                  'NEW',
                                                  'ASSIGNED',
                                                  'REOPENED')"/>
    </report>
  </deadline>
</reports>