Odo.lv » Recipes » Rapla resource planning server

Warning: Šis apraksts jau vairāk ka gadu nav mainīts. Iespējams, ka tas ir novecojis!

Rapla resource planning server

Setup

Download rapla-binary-1.3.zip;
Paste this file into /usr/local/bin folder;
Unzip rapla-binary-1.3.zip:

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

Run rapla.sh:

./rapla.sh start

Connecting to MySQL

Create new database:

> mysql;
> create database Rapla;

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

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

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;

Download JDBC driver for MySQL and put it into /WEB-INF/lib and /webapp/WEB-INF/lib folders);
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>

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

./raplaserver.sh import data.xml Rapla;

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

./raplaserver.sh export Rapla data.xml;

Starting Rapla

Start Rapla's server:

./raplaserver.sh start

Go to Rapla's default URL http://localhost:8051/rapla;
Default user is admin with no password.

LDAP Authentication

Not implemented yet :(

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

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

Make log files accessible:

chmod -R 777 /usr/share/tomcat5/webapps/rapla

Map this with JkMount and restart Apache2 and Tomcat.
Access URL http://localhost/rapla and log in with "admin" and empty password.

Tags: Linux Java Birojs Pārvaldība English

Created by Valdis Vītoliņš on 2008/08/09 20:28

Last modified by Valdis Vītoliņš on 2009/12/21 09:34