(originally provided by Iván Belmonte, http://ivanhq.net/)
NOTE:
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).
6. Enjoy!
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.
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
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
Karmic and Lucid both have a 4.5.1 version of aolserver4-core available. Just modify the above to fit your situation.
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.
Hardy has an 8.2 version of PostgreSQL available so just do the above steps with the hardy branch.
Install ]po[ V3.4.0.8.
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 -
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[.
Visit http://site.domain.tld:8000/ or https://site.domain.tld:8443/ and login with sysadmin@tigerpond.org (password: system)
/etc/init.d/projop start/restart/stop
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com