Debian Etch (4.0)

This page introduces two options installing ]po[ on debian:

Manual installation
Installation using ]po[ deb packages (Alpha)

Manual Install

(originally provided by Iván Belmonte, http://ivanhq.net/)

Instructions for installing ]project-open[ on Vanilla Debian ETCH 4.0

NOTE:

As seen in a comment below, don't use PostgreSQL version 8.3 because it's still not working well with ]po[. You should use 8.1 for now.
This installation instruction will first install an older version (V3.2) of ]project-open[ and then upgrade to the latest version.

1. Packages

Install system dependencies for ]po[

apt-get install libreadline5-dev zlib1g-dev tcl8.4 tcl8.4-dev tk8.4-dev bison flex cdbs libpam0g-dev libperl-dev python2.4-dev python-dev x-dev

2. Aolserver

Install Aolserver4, needed modules and tdom

apt-get install aolserver4 aolserver4-dev aolserver4-doc aolserver4-nscache aolserver4-nsopenssl aolserver4-nspostgres aolserver4-nssha1 aolserver4-nsxml tdom

3. PostgreSQL

Install PostgreSQL and the contrib package (contains tsearch2, needed for fulltextsearch feature)

apt-get install postgresql-8.1 postgresql-contrib-8.1

You must change some behavior on PostgreSQL config. Edit /etc/postgresql/8.1/main/postgresql.conf. Look for VERSION/PLATFORM COMPATIBILITY section, and enable these variables as follows

add_missing_from = on
regex_flavor = extended
default_with_oids = on

Edit /etc/postgresql/8.1/main/pg_hba.conf. Look for the local IPv4 local connections section, and change md5 auth with ident as follows

# IPv4 local connections:
#host    all         all         127.0.0.1/32          md5
 host    all         all         127.0.0.1/32          ident sameuser

Restart postgresql

/etc/init.d/postgresql-8.1 restart

3. ]project-open[

Download and install ]po[ V3.2. We will upgrade to V3.4 in a step further down.

wget -c http://ivanhq.net/po/deb/project-open_3.2-1_i386.deb
dpkg -i project-open_3.2-1_i386.deb

Create a user and a group for running ]po[

groupadd projop
useradd -g projop -d /web/projop -s /bin/bash projop

Create a log dir and change permissions on the website for the new user

mkdir /web/projop/log
chown -R projop:projop /web/projop

Create a new database for ]po[ (default postgres charset is latin9, set it to utf8)

su - postgres
createuser -a -d projop
createdb --owner=projop projop -E UTF8
createlang plpgsql projop
exit

Load demo data into the new database

su - projop
cd /web/projop/packages/intranet-core/preconf
gzip -d project-open-3.2.sql.gz
psql projop -f project-open-3.2.sql

Check the data has been correctly imported

psql projop

projop=# select count(*) from users;
count
-------
   196
(1 row)

projop=# \\q

Edit config file (/web/projop/etc/config.tcl) and change main path settings

#set homedir                   /usr/local/aolserver
#set bindir                    [file dirname [ns_info nsd]]

set homedir                   /usr/lib/aolserver4
set bindir                    /usr/lib/aolserver4/bin

Launch the server to see if it works okay

/usr/sbin/aolserver4-nsd -f -t /web/projop/etc/config.tcl -u projop -g projop

# Ctrl+C to stop

Exit user projop

exit

4. Init system

Edit default Aolserver4 init script /etc/init.d/aolserver4 and change next parameters

#USER=www-data
#GROUP=www-data
#ADDRESS=127.0.0.1
#CONF=/etc/aolserver4/aolserver4.tcl

USER=projop
GROUP=projop
ADDRESS=0.0.0.0
CONF=/web/projop/etc/config.tcl

Change next line (about line 42, remove -s main)

#-u $USER -g $GROUP -b $ADDRESS:$PORT -s main -t $CONF >/dev/null 2>&1
 -u $USER -g $GROUP -b $ADDRESS:$PORT -t $CONF >/dev/null 2>&1

Test everything works

reboot

BE PATIENT, ]po[ can take up to 1 min to start after rebooting.

5. Config

Look into config file (/web/projop/etc/config.tcl) for tuning your server sitename, listening port, etc

6. Upgrade to ]project-open[ V3.4

Please go to http://www.sourceforge.net/projects/project-open/files/ -> V3.4 and download the latest ]po[ update (project-open-Update-3.4.x.y.z.tgz).

Rename the old /web/projop/packages folder into packages.3.2 or similar.
Extract the contents of the update installer into /web/projop/packages
Restart ]project-open[
Go to http://host:port/acs-admin/apm/ and select "Install packages" at the bottom of the page
Select all packages with status "update" and choose "Next ->"
After another restart please check the "Admin" page for additional upgrade instructions.

6. Enjoy!

Installation using ]po[ deb packages (Alpha)

This document describes how to install ]project-open[ 3.4.0.8 on a freshly installed Debian system

NOTE:

* As seen in a comment below, do not use PostgreSQL 8.3 or 8.4 because it's still not working well with ]po[. And seeing as how 8.2 is not available in Debian you should use 8.1 for now.

1. Packages

Install system dependencies for ]po[:

apt-get install libreadline5-dev zlib1g-dev tcl8.4 tcl8.4-dev tk8.4-dev bison \
flex cdbs libpam0g-dev libperl-dev python2.4-dev python-dev x-dev

2. AOLserver

2.1 AOLserver on Debian

The original Debian packages for aolserver4 in Etch and Lenny are broken. Squeeze is the only version with a working aolserver4. If you are using Squeeze skip to step 4. Otherwise start at step 1. The new aolserver4 packages (4.5.1) should make thier way into the main Debian repositories pretty soon.

step 1: add the following to your /etc/apt/sources.list

deb http://mobigroup.ru/debian/ lenny main
deb-src http://mobigroup.ru/debian/ lenny main

step 2: update all packages

apt-get update

step 3:

apt-get install debian-mobigroup-keyring

step 4: Install Aolserver4, needed modules and tdom

apt-get install aolserver4 aolserver4-dev aolserver4-doc aolserver4-nscache \
aolserver4-nsopenssl aolserver4-nspostgres aolserver4-nssha1 aolserver4-nsxml tdom

2.2 AOLserver on Ubuntu

Karmic and Lucid both have a 4.5.1 version of aolserver4-core available. Just modify the above to fit your situation.

3. PostgreSQL

3.1 PostgreSQL on Debian

Until they get around to updating the DB for ]po[ it is necessary to use PostgreSQL 8.1 which means you will need to download the packages from the Debian Etch branch.

step 1: add the following to your /etc/apt/sources.list and comment out the Lenny/Squeeze source lines

deb http://ftp.de.debian.org/debian/ etch main contrib non-free
deb-src ftp://ftp.de.debian.org/debian/ etch main contrib non-free

step 2: apt-get update

step 3: apt-get install postgresql-8.1 postgresql-contrib-8.1

step 4: add the following to /etc/apt/preferences

                  Package: postgresql-common
                  Pin: version 71
                  Pin-Priority: 1001

                  Package: postgresql-client-common
                  Pin: version 71
                  Pin-Priority: 1001

                  Package: postgresql-8.1
                  Pin: version 8.1.17-0etch1
                  Pin-Priority: 1001

step 5: remove or comment out the Etch source lines in /etc/apt/sources.list and restore the Lenny/Squeeze lines.

3.2 PostgreSQL on Ubuntu

Hardy has an 8.2 version of PostgreSQL available so just do the above steps with the hardy branch.

4. ]project-open[

Install ]po[ V3.4.0.8.

add IT Admins repository to your /etc/apt/sources.list

deb http://www.itadmins.net/packages/debian/ lenny/etch/squeeze main contrib non-free

add the IT Admins Group key to apt.

wget http://www.itadmins.net/packages/debian/itadmins_archive_keyring.gpg && cat itadmins_archive_keyring.gpg | apt-key add -

Install

apt-get update
apt-get install project-open

IMPORTANT!!! you will be asked about replacing certain configuration files during the installation of ]po[. YES!!! you want to replace the config files installed on your system with the ones that come with ]po[.

5. Init Page

Visit http://site.domain.tld:8000/ or https://site.domain.tld:8443/ and login with sysadmin@tigerpond.org (password: system)

6. Init System

There is an init script for ]po[ provided with the package. To control ]po[ simply:

/etc/init.d/projop start/restart/stop

7. Config

Look in config file (/web/projop/etc/config.tcl) for tuning your server sitename, listening port, etc