Support Packages

This page talks about the installation and configuration of add-on software that is required for a full installation of ]project-open[.

All of these packages are installed in the ]po[ CentOS virtual appliance. The installation instructions below have been tested on Centos 6.2.

Required Base Installation Packages

• AOLserver (web-server)
  
• PostgreSQL (database)
  
• Unix Commands (bash, find, tar, zip, ls)
• GraphViz and "dot" (graphics tools) 
• Postfix (mail server) 
• Taskjuggler (project scheduling)
  

Optional Add-On Packages

• Pound (HTTP reverse proxy)
• Perl-LDAP (LDAP integration) 
• Perl-POP3 (mail integration)
  
• pgAdmin III (database administration)
  

• Nagios
• CVS

CRM & Mail Integration

• Funambol
• OpenOffice

AOLserver Web-Server

The AOLserver binary is available for download from SourceForge.net.

Just extract the TAR file into the path /usr/local/aolserver.

PostgreSQL Database

]project-open[ V4.0 now supports PostgreSQL 8.1, 8.2, 8.3 and 8.4.

PG 9.0 will not work.

To install PostgreSQL, please use the package manager of your distribution. Please make sure to install the following packages:

• postgresql-server-x.y.z
• postgresql-contrib-x.y.z
• postgresql-devel-x.y.z
• postgresql-libs-x.y.z
  
• postgresql-x.y.z

Then please initialize the database (/etc/init.d/postgresql start or /etc/init.d/postgresql init) and edit the following files:

• pg_hba.conf in /var/lib/pgsql/data/:
  Please add a line at the very end to allow local user to access the database without giving a password:
  "host   all   all   127.0.0.1/32 trust"
  Please eliminate any other line beginnging with "host all all 127.0.0.1/32".
• postgresql.conf in /var/lib/pgsql/data/:
  Please search for "add_missing_from" and enable the option with "add_missing_from = on".
  

You will need to restart the database after your changes (/etc/init.d/postgresql restart).

Unix Commands

The usual Unix/Linux commands are part of any standard distribution. In the case of error (for example: perl in /usr/local/bin/perl instead of /usr/bin/perl) the system will ask you to modify the parameter (]po[: Admin -> Parameters) with the path to the command or you can create a symbolic link in your filesystem.

GraphViz and Dot

GraphViz should be part of your standard Linux distro. Just use "yum install GraphViz" or similar.

Postfix (mail server)

]project-open[ by defaults expects a local SMTP server listening on port localhost:25. By default we install Postfix and delete a possible Sendmail. Both packages should be defined in your package manager:

• yum erase sendmail
• yum install postfix
  

Taskjuggler

]po[ V4.0 will be using Taskjuggler as a scheduling engine. To install:

• yum install taskjuggler:
  You will probably be asked to install dependency packages
  

Pound (HTTP reverse proxy )

Pound listenes on port 80 (HTTP) and 443 (HTTPS) and distributes incoming requests to an AOLserver instance, depending on the headers of the HTTP request. For download and installation please see http://www.apsis.ch/pound.

Perl LDAP Libraries

These libraries are used when configuring ]project-open[ authorization against an OpenLDAP or Active Directory system.

• yum install perl-YAML
• yum install openldap openldap-clients 
• Please use the "cpan" command (package manager for Perl). cpan may ask you for some configuration options the first time. Inside cpan, please enter:
• install Socket:
  Please say "yes" if cpan asks you to "Shall I follow them and prepend them..."
• install IO::Socket::PortState: This should execute without issues.

In order to test the successfull installation please go (in the ]po[ GUI) to Admin -> SysConfig -> LDAP Wizard and start the wizard against any known LDAP server. There should be no visible error messages.

Perl POP3 Libraries

This section assumes that you have already installed the Perl LDAP libraries.

• yum install libdbi-dbd-pgsql:
  This will probably install some dependent packages.

pgAdminIII (database administration)

The pgAdminIII tool is a graphical frontend for the PostgreSQL database, similar to "Toad" and other graphical database tools. We recommend the installation for all users who might want to explore the ]po[ data-model or play around with SQL statements or reports.

• Install the required "wx" libraries: wxGTK and wxGTK-devel using your package manager.
• Download the RPM ("pgadmin3-1.8.4-1.el5.rf.i386.rpm" for CentOS 5 or CentOS 6) and try to install using "rpm -i pgadmin3-1.8.4-1.el5.rf.i386.rpm".
• RPM may complain about "Failed dependencies: libpq.so.4 is needed". You can ignore this message and then install pgAdminIII using "rpm --nodeps -i pgadmin3-1.8.4-1.el5.rf.i386.rpm".
  

After the installation, the pgAdminIII "elephant" should appear in the Linux GUI in the section Applications -> Programming -> pgAdmin III.

Funambol

OpenOffice

]po[ V4.0 contains an option to convert reports in OpenOffice Impress format into PowerPoint and PDF. For this option to work you need to install OO.oo V3.0 or higher in your machine:

• yum install openoffice.org-impress openoffice.org-headless
  

Linux VMware Configuration

This is a list of small configuration changes in the VMware V4.0 ]po[ appliance:

• Configure Desktop background image
• Configure Desktop links and bookmarks
• Crontab: Automatic backup
• Crontab: Nightly vacuum
• Crontab: Log roll for AOLserver