Red Hat Enterprise 5 / CentOS

]project-open[ is fully supported with RHEL 5 (CentOS 5) 32 bit. To install ]po[ on this platform you will have to go through the following steps:

• Check preconditions
• Download the installer files 
• Extract the Installer Contents
  
• Install AOLserver
• Setup PostgreSQL
• Install Other Software
  
• Start ]project-open[ Server
• Automate ]project-open[ Startup
• Upgrade ]project-open[

For 64 bit installations please refer to the Open Dicussions forum at http://www.sourceforge.net/projects/project-open/ .

Check Preconditions

You will need:

• A 32 bit Red Hat Enterprise Linux 5/CentOS 5 server with:
  
• Minimum 1GByte RAM, recommended 4GByte
• Minimum 1GByte free hard disk space, recommended 20GByte
• Minimum Pentium 4 processor, recommended dual core processor

 The "minimum" requirements are OK for a test system, while the "recommended" requirements are OK for a small company with 5 "active" users. Please see our benchmark section for more information on scalability and sizing.

Download the InstallerFiles

You will need the following installer files from http://www.sourceforge.net/projects/project-open/files/ .

• aolserver-4.5-rhel5-rpms.tar (Support Files section)
• project-open-RHEL5-3.4.0.final.tgz (V3.4 section)­­

Extract the Installer Contents 

Please go through the following steps to create a ]po[ user "projop" and to extract the installer into this user's home directory:

• groupadd projop (create a group called "projop")
• mkdir /web/ (create a super-directory for all Web servers, we use /web/ by default)
• useradd -d /web/projop -g projop projop (create user "projop" with home directory /web/projop)
• cd /web/projop/; tar xzf /tmp/project-open-RHEL5-3.4.0.final.tgz (extract the installer contents)
• cd /web/projop/; tar xf /tmp/aolserver-4.5-rhel5-rpms.tar (extract the RPMs for AOLserver)
  
• chown -R projop:projop /web/projop (set ownership to all files)
  

Install AOLserver

AOLserver is an open-source Web server similar to Apache. However, it includes elements of an application server externsively used by ]project-open[, so it can't be replaced by Apache.

On a 32 bit platform you just need to install the following RPMs:

• aolserver-4.5.0-1.po.rhel5.i386.rpm
• aolserver-tcl-8.4.14-1.po.rhel5.i386.rpm
• nscache-1.5-1.po.rhel5.i386.rpm
• nspostgres-4.0-2.po.rhel5.i386.rpm
• nssha1-0.1-1.po.rhel5.i386.rpm
• tDOM-0.8.1cvs-3.po.rhel5.i386.rpm

The RPMs are located by default in /web/projop/, so you can install them by executing the following commands as root:

• cd /web/projop/
• rpm -i *.rpm 

• /usr/local/aolserver/bin/nsd -h (show help for AOLserver) 

Please consult the SourceForge forum for the installation of AOLserver on 64 bit platforms. 

Setup PostgreSQL 8.1

PostgreSQL 8.1 is part of RHEL 5. You can install the database using:

• yum install postgresql postgresql-server postgresql-contrib postgresql-devel postgresql-docs
  

Then please start the database. Starting PG for the first time will initialize the database:

• /etc/init.d/postgresql start
  

Now please edit the file /var/lib/pgsql/data/postgresql.conf, search for the following parameters and set the values accordingly (don't forget to remove the comments):

• add_missing_from = on
• regex_flavor = extended
  
• default_with_oids = on
  

Then please execute as root:

• /etc/init.d/postgresql restart (restart the database, in order to activate the new configuration)
• su - postgres -c "createuser -s projop" (create a database user "projop" with admin rights)
• su - projop -c "createdb -E utf8 -O projop projop" (create a new database as user "projop")
• su - projop -c "createlang plpgsql projop" (enable the procedural language PlPg/SQL for database "projop").

To check if the database is working please enter:

• su - projop (become user projop)
  
• psql (start psql, the command line client for PostgreSQL. You should see a greeting mesage).
  
• \q (quit from psql)
  

Then please load the database dump into the database. The database dump can be found in /web/projop/filestorage/backup/pg_dump.xxx.yyy.zzz.sql (currently: pg_dump.project-open-v34.projop.20091026.203522.sql)

• su - projop (become user "projop")
• psql -f filestorage/backup/pg_dump.xxx.yyy.sql  >  import.log 2>&1 (load the database dump into the DB and send any error messages into the file "import.log")
• Open "import.log" for error with you favourite text editor. It's OK if there are some 3000 error messages in the beginning of import.log saying "ERROR: .. .does not exist", because the database is empty, and the dump includes instructions to delete a previous data model. However, there should not be any "ERROR:" message after the first "CREATE" statements appear around line 3000.
  

 To check if the database dump has loaded correctly, please execute:

• su - projop (if you are not user "projop" already...)
• psql (start the database client)
• select count(*) from cc_users; (resulting in 194 users)
• \q (quit)

Install Other Software

Please install the following additional software packages:

• yum install cvs (CVS is part of CentOS 5)
  
• yum install ImageMagick (ImageMagic is part of CentOS 5)
  
• yum install wget (wget is part of CentOS 5)
  
• rpm -i graphviz-2.8-1.el5.rf.i386.rpm (install GraphViz, afer downloading it from http://dag.wieers.com/rpm/packages/graphviz/ 
  

Start ]project-open[

]project-open[ requires AOLserver and PostgreSQL to work properly. Once these two components are working please execute the command as root:

• /usr/local/aolserver/bin/nsd -f -t /web/projop/etc/config.tcl -u projop -g projop

This command starts AOLserver in foreground mode (-f), showing all log messages in the console.

In order to check for correct startup please check that the last output line says something like:

• Notice: nssock: listening on 0.0.0.0:8000

Now please point your favourite Web browser to http://localhost:8000/.

In order to access ]project-open[ from a computer different from localhost please make sure your RHEL firewall is disabled or port 8000 has been enabled explicitly.

Please enter "service postgresql start" to start the postgresql-service.

Automate ]project-open[ Startup

Once ]po[ is running successfully, you can edit /etc/inittab and add the following line at the very end(!) of the very file:

•  ns1:345:respawn:/usr/local/aolserver/bin/nsd -it /web/projop/etc/config.tcl -u projop -g projop
  

Upgrade ]project-open[

Please see ­http://www.project-open.org/documentation/tutorial_updates 

If you can't update from CVS, follow these instructions:
Please check http://www.sourceforge.net/projects/project-open/files/  for files with a name of "project-open-Update-x.y.z.v.w.tgz", choose the most recent version and download the file.

These "Upgrade Installers" contain the /web/projop/packages/ directory with the source code of ]project-open[. Please update to the latest version by executing:

• su - projop
• mv packages packages.old
• tar xzf  /tmp/project-open-Update-x.y.z.v.w.tgz

You should see that a new packages directory has been created. Then please restart your ]project-open[ instance (killall -9 nsd) and watch for messages in the "Home" page of ]project-open[ (in the Web browser).

Before you restart the server, run the following command "chkconfig postgresql on".

This integrates postgresql in your system startup. 

References

• Installation Overview
• Installation FAQ