Note, that this recipe is not updated long time and could be outdated!
Got it.

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:

<div style="overflow: hidden">
<iframe src="http://192.168.220.128:8051/rapla?page=calendar&user=admin&file=Jupiter&today"  name="iframe" id="html-calendar" frameborder="0">
</iframe>
</div>

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:

iframe#html-calendar {
    width: 100%;
    height: 460px;
    border: 0;
    display: block;
    overflow: hidden;
}

Creating a navigation menu

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

<div class="floatcontainer">
<ul class="xwikitabbar">
<li><a href="http://192.168.220.128:8051/rapla?page=calendar&user=admin&file=All+rooms&today" target="iframe">All rooms load</a></li>
<li><a href="http://192.168.220.128:8051/rapla?page=calendar&user=admin&file=Jupiter&today" target="iframe">Jupiter</a></li>
</ul>
</div>

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

* <a href="http://192.168.220.128:8051/rapla?page=calendar&user=admin&file=Jupiter&today">Start Rapla (with Java Web Start)</a>
* <a href="http://192.168.220.128:8051/rapla?page=raplaapplet" target="_blank">Start Rapla (with Java plugin)</a>

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.

 

Created by Valdis Vītoliņš on 2008-08-09 17:29
Last modified by Valdis Vītoliņš on 2013-09-08 17:17
Translated into en by Valdis Vītoliņš on 2013-09-08 17:17
 
Xwiki Powered
Creative Commons Attribution 3.0 Unported License