First install of Project.net on Linux

From Project.net :

Project.net for Mission Critical Project Portfolio Management

Project.net is a complete Project Portfolio Management (PPM) solution designed to capture, display, report on, and resolve the complex interrelationships organizations tackle when planning and executing major initiatives.

I’m going to publish this regularly so that interested parties can see the progress.

I have been given a VM running CentOS 6.3 with 60GB of disk, 4GB of RAM and 1 CPU.  Of course, as the service gets taken up this can be scaled up.  I’m following the document for installing on Linux.  The following is a list of steps taken including the gotchas:

  • yum update
  • yum -y install rsync
  • setup server for SSH without passwords
  • yum -y groupinstall “Web Server”
  • mkdir -p /usr1/home
  • useradd -d /usr1/home/www -c ‘Web Server’ www
  • chown -R www:www /var/lib/dav /var/cache/mod_proxy /var/cache/mod_ssl
  • All links to Oracle XE 10g lead to 11g.  This could be a problem.  An admin on a forum states that 11g will work.
  •  yum -y install libaio-devel bc<—- !!!!
  • unzip the oracle archive and rpm -ivh it
  • make sure /etc/hosts has you server defined in it
  • /etc/init.d/oracle-xe configure
    • Oracle Application Express likes port 8080 (so does Tomcat, hmmm.)
    • HTTP Port 8081
    • Listener Port 1521
    • Haz database!
  •  Pull Project.net archive to /usr/local/src
  • mkdir /usr/local/projectnet
  • unzip archive to /usr/local/projectnet
  • find /usr/local/project.net/database/ -type f -exec dos2unix {} \;
  • edit …9.2.0/new/pnetMasterDBBuild.sh to reflect install
  • “If you are using Oracle Express set the PNET_BUILD_DB_DATABASE_NAME variable to the value XE
  • cd /usr/local/project.net/database/create-scripts/versions/9.2.0/new/
  • run the script, sip something nice, sip something nice…
  • tail -f /tmp/pnet_test_db_build.log the script pauses waiting for input.  The script doesn’t prompt for answers or supply default values.  I was checking the install log when I noticed it stop and ask a question.  I hit return in running script window.  Fingers crossed. (10pm)  Just checking the log now (9.25am) There are errors such as:
  • install java jre 6.0.x rpm
  • alternatives –install /usr/bin/java java /usr/java/jre1.6.0_37/bin/java 6037
  • pull jce_policy-6.zip to /usr/local/src
  • cp jce/*.jar /usr/java/jre1.6.0_37/lib/security/
  • pull apache-tomcat-6.0.35.tar.gz to /usr/local/src
  • pull apache-activemq-5.7.0-bin.tar.gz to /usr/local/src
  • useradd -d /usr1/home/projectnet -c ‘Project Net’ projectnet
  • su – projectnet
  • tar xf /usr/local/src/apache-tomcat-6.0.35.tar.gz
  • edit .bashrc to reflect CATALINA_HOME and JAVA_HOME
  • edit ./apache-tomcat-6.0.35/conf/tomcat-users.xml change passwords
  •  cp /usr/local/project.net/lib/mail.jar /usr/local/project.net/lib/activation.jar ~/apache-tomcat-6.0.35/lib/
  • cp /usr/local/project.net/lib/jdbc/ojdbc14.jar ~/apache-tomcat-6.0.35/lib/
  • mkdir ~/apache-tomcat-6.0.35/endorsed
  • cp /usr/local/project.net/lib/endorsed/* ~/apache-tomcat-6.0.35/endorsed/
  • edit apache-tomcat-6.0.35/conf/server.xml and change port 8080 to 9090
  • edit catalina.sh to reflect production system with -Xms256m -Xmx1024m
  • logging : using Log4j 1.2.9 and commons-logging-1.1.1-bin.tar.gz
  • create /etc/init.d/tomcat
  • chkconfig tomcat on
  • yum -y install apr-devel openssl-devel ant
  • pull jdk-6u37-linux-x64-rpm.bin to /usr/local/src/
  • alternatives –install /usr/bin/javac javac /usr/java/jdk1.6.0_37/bin/javac 6038
  • alternatives –config javac
  • build APR in /usr1/home/projectnet/apache-tomcat-6.0.35/bin/tomcat-native-1.1.22-src/jni
  • ant and ant jar in /usr1/home/projectnet/apache-tomcat-6.0.35/bin/tomcat-native-1.1.22-src/jni
  • Adjust JAVA_OPTS to reflect -Djava.library.path=/usr/local/apr/lib/
  • edit bin/linux-x86-64/activemq to reflect ActiveMQ home
  • edit bin/linux-x86-64/wrapper.conf to reflect ActiveMQ home in set.default.ACTIVEMQ_HOME and set.default.ACTIVEMQ_BASE
  • ln -s /usr1/home/projectnet/apache-activemq-5.6.0/bin/linux-x86-64/activemq /etc/init.d/activemq (as root)
  • chkconfig –add activemq
  • service activemq start (check data/wrapper.log)
  • For project.net edit conf/context.xml to connect to Oracle and a mail server.
  • As projectnet : cp /usr1/local/project.net/app/pnet.war ~/apache-tomcat-6.0.35/webapps/
  • mv ROOT ../ROOT.webapp
  • mv pnet.war ROOT.war
  • make sure passwords are correct in webapps/ROOT/META-INF/context.xml ./conf/Catalina/localhost/ROOT.xml conf/context.xml
  • (as root) /etc/init.d/tomcat restart
  • Haz Project.net application!
  •  Prepare Apache to be the port 80 frontend
  • create /etc/httpd/conf.d/pm4s.conf :
  • # tomcat integration
    ProxyPreserveHost On
    ProxyPass / ajp://localhost:8009/ min=5 ttl=120 keepalive=On ping=1
    ProxyPassReverse / ajp://localhost:8009/
  •  Needs SSL set up.  Done but needs proper SSL cert.
  • Configure Project.net
  • Change password and some other details
  • Setup up docvault to be in ~projectnet/docvault
  • Setup up Sys.Settings to reflect /usr1/home/projectnet install
  • Additional:
  • keystore (for LDAP cert) for java needs creating and tomcat needs to run with keystore arguments.
  • Installed licence key.  Every user must be given the key before registration
  • Redirect http to https.

About c3iq

Opensource, Linux, Unix, Fish, Family
This entry was posted in Library, Linux SysAdmin. Bookmark the permalink.