-

---

Tomcat Postgresql Installation original author Paul Norton v1.0 04/07/05:BST(GMT+1) 19:00

---

Requires

• rapla-1.0beta
• Postgresql 8.0.3
• java 1.4.2 /1.5 (Tested on both)
• M$ windoze XP (generic so should run on linux 2) Fedora

..she is beautiful i love her :)

• Jakarta Tomcat 4.1.31 NOTE: Jakarta Tomcat 5.5.9 Untested but I dont see an issue

---

Important

<YOUR_POSTGRESQL_INSTALL_DIR> == install directory of your Postgresql Server
-
Eg D:\Program Files\PostgreSQL == <YOUR_POSTGRESQL_INSTALL_DIR>

<YOUR_RAPLA_DIR> == install directory of your rapla
-
Eg c:\rapla-webapp-1.0beta1 ==<YOUR_RAPLA_DIR>

<TOMCAT_HOME> == the directory root of Tomcat
-
Eg D:\apps\tomcat\jakarta-tomcat-4.1.31==<TOMCAT_HOME>
-

---

1)follow these instructions for setting up the webapp and Postgresql

2)Copy the postgresql-8.0-311.jdbc3.jar to the webapp server

Copy <YOUR_POSTGRESQL_INSTALL_DIR>\8.0\jdbc\postgresql-8.0-311.jdbc3.jar
to <TOMCAT_HOME>\common\lib\postgresql-8.0-311.jdbc3.jar

3)NOTE: you MUST have followed these instructions for setting up the webapp and Postgresql

cd into <YOUR_RAPLA_DIR>
-
create a directory named rapla
mkdir rapla
copy the <YOUR_RAPLA_DIR>\webapp\* and all the contents
to <YOUR_RAPLA_DIR>\rapla\

4) Sanity check

<YOUR_RAPLA_DIR>\webapp\
and
<YOUR_RAPLA_DIR>\rapla\
SHOULD BE INDENTICAL

5) Deploy rapla under Tomcat

Copy <YOUR_RAPLA_DIR>\rapla
to <TOMCAT_HOME>\webapps\

NOTE: chown and chmod linux peeps 6)Start Tomcat and running Rapla

cd into <TOMCAT_HOME>\bin
run startup.bat or startup.sh

point your browser @

http://localhost:8080/rapla or http://your_app_srv_ip:your_app_srv_port/your_app_name

7) Data Sanity check

In the rapla user interface create a new resource under person give it values tomcat tomcat then

psql -U rapla rapla
select * from resource_attribute_value where value='tomcat';

---

Hope this helps you. Remember I'm human and this is a first draft any positive comments or suggestions for improvements to alien_morph/hotmail.com replace / with @ and make sure you mention Rapla Tomcat in your topic - I'd also like to thanks the Rapla team for their great work, I'm sure you agree this is a best of breed solution :) Kind regards Paul