Debian

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)

 

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

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

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

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

2.2 AOLserver on Ubuntu

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

                  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.

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

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

2. 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 -

3. 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

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

7. Config

Referen­ces

• Installation Overview
• Installation FAQ