Rapla resource planning server

Setup

1. Download file from http://rapla.sourceforge.net/download.html e.g. rapla-binary-1.3.zip
2. Paste this file into /usr/local/bin folder;

3. Unzip rapla-binary-1.3.zip:

   unzip -r rapla-binary-1.3.zip rapla;

4. Run rapla.sh:

   ./rapla.sh start

Connecting to MySQL

1. Create new database:

   mysql;
   create database Rapla;

2. Create a user (name - "student", password - "Student007"):

   grant all on Rapla.* to student@"%" identified by "Student007", student@localhost identified by "Student007";

3. Execute rapla-mysql.sql script to create tables (assuming you are in /webapps/rapla folders:

   mysql> use Rapla;
   mysql> source /WEB-INF/rapla-mysql.sql;
4. Download JDBC driver from http://dev.mysql.com/downloads/connector/ and put it into /WEB-INF/lib and  /webapp/WEB-INF/lib folders);

5. Change settings in raplaserver.xconf in /WEB-INF/ and /webapp/WEB-INF/:

   <store>sql</store>
   ....................
   <db-storage id="sql">
       <driver>org.gjt.mm.mysql.Driver</driver>
       <url>jdbc:mysql://localhost/Rapla</url>
       <user>student</user>
       <password>Student007</password>
   </db-storage>

6. Change the store from file to SQL (assuming you are in /rapla/ folder):

   ./raplaserver.sh import data.xml Rapla;

7. If you want to change store from SQl to file, use this:

   ./raplaserver.sh export Rapla data.xml;

Starting Rapla

1. Start Rapla's server:

   ./raplaserver.sh start
2. Go to Rapla's default URL \http://localhost:8051/rapla##;
3. Default user is admin with no password.

HTML read-only view

Rapla has a good feature - it can export calendars to HTML and automatically update them.
For now, we'll use an iframe to import it to XWiki. For example, paste this code into XWiki page:

iframe source is an external html-page created by Rapla.

&today at the end of the link means that view will always display the current situation.

Paste it into /rapla/webapp directory.

Add this style to /xwiki/skins/accenture/style.css:

Creating a navigation menu

This menu will display different exported calendars, which very useful for switching between different meeting rooms or simple events.

Also add these two links to start Rapla directly, using Java plugin or Java Web Start:

Rapla on Tomcat

1. Make an empty directory "rapla" under $TOMCAT_HOME/webapps.
2. Copy the content from Jetty's "webapps" directory to "rapla" under Tomcat.

3. Make log files accessible:

   chmod -R 777 /usr/share/tomcat5/webapps/rapla
4. Map this with JkMount and restart Apache2 and Tomcat.
5. Access URL http://localhost/rapla and log in with "admin" and empty password.