And another one of my setup series. These are the intended versions:
Fedora Linux 13 32 bit - Note that the 64 bit version does not work without further
VMWare esx3i
project.net 9.2.0
Oracle Database XE 10.2
First, allocate at least 512MB of memory as well as 10GB to the VMWare system
Install Fedora Linux 13 as Webserver. I tried minimal but couldn't get the Oracle DB server to install. Create a minimum of 1GB swap space or the database installer will complain!
Configure the networking
Copy the oracle DB server rpm and the client rpm into the tmp folder
setup # configure firewall and ensure the iptables service is selected
cd /tmp
rpm -ivh oracle*.rpm
run the shown configure script and keep the default ports (8080 and 1521 so you can access http://127.0.0.1:8080/apex later)
#add the following to all users .bash_profile
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
#log out and in again
sqlplus system/<database admin password>@XE # check for working connection
cd /tmp
wget http://downloads.sourceforge.net/project/projectnet/Project.net%20Production/Project.net%209.2.0/Custom_installation_920.zip?use_mirror=iweb&ts=1279504676
unzip Custom_installation_920.zip
cd database
find . -type f -exec dos2unix {} \;
cd create-scripts/versions/9.2.0/new/
vi pnetMasterDBBuild.sh
# data folder: /usr/lib/oracle/xe/oradata/XE/
chmod a+x *.sh
../pnetMasterDBBuild.sh
install Fedora 13 - minimal version
yum install setuptool java tomcat6 wget unzip
cd /tmp
wget http://downloads.sourceforge.net/project/projectnet/Project.net%20Production/Project.net%209.2.0/Custom_installation_920.zip?use_mirror=iweb&ts=1279504676
unzip Custom_installation_920.zip
yum install activemq-cpp
#cp lib/jce6/*.jar /usr/share/tomcat6/lib/
cd /usr/share/tomcat6/webapps/
cp /tmp/app/pnet.war projects.war
cp /tmp/lib/jdbc/ojdbc14.jar /usr/share/tomcat6/lib
cp /tmp/lib/mail.jar /usr/share/tomcat6/lib
# modify the file /usr/share/tomcat6/conf/context.xml to include this line in the context tags (change db server name and password
<Resource name="jdbc/PnetDB" auth="Container" type="javax.sql.DataSource" username="pnet_user" password="pnet_user" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@db1.example.com:1521:XE" maxActive="125" maxIdle="25" />