· Index · Login/Register

Search: 

Debian

The following instructions were originally written by Iván Belmonte.

 

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!

 

 

References

• Installation Overview
• Installation FAQ