Debian Sarge OpenGroupware 1.0a install

These are the steps I followed to install the latest OGo release (v1.0a8) on a clean Debian Sarge install.

OpenGroupware 1.0alpha8 install on Debian Sarge HOWTO

v0.1 Last Updated: 29/10/2004 by Guillaume Estival (Dawan)--

This is mostly just an update of Yedidia Klein's RedHat Install HowTo (http://sukka.jct.ac.il/~yedidia/ogo_rh.html) and an adaptation from the Fedora core 2 install from Gavin Young http://docs.opengroupware.org/Members/gyoung/Document.2004-10-26.0852/view

Prerequisites: Apache and Postgres installed (distribution ones) All commands completed as root unless otherwise stated

1)-------------OGo Repository--------------------------* Add this line on your /etc/apt/source.list file deb http://download.opengroupware.org/packages/debian sarge trunk

2)-------------Installation----------------------------* At this time (29/10), the dependancy is buggy and it will forgot some needed packages. Here a way to install everything:

Go here with your favorite browser: http://download.opengroupware.org/packages/debian/dists/sarge/trunk/binary-i386/ Save the page as text file (list.txt). Then, create 3 files:

-extract.awk- $3 !~ /latest/ {print $3;}

-removeUnde.awk- BEGIN { FS="_"}

$1 !~ /-dev/ { printf("%s ",$1); }

-installogo- for deb in $* do apt-get install $deb done

then type: ./installogo `cat list.txt |awk -f extract.awk |grep deb |awk -f removeUnde.awk` it will install all the file (with some dependencies) (If you have a better idea to do the job, you're welcome)

Note: The libapache-mod-ngobjweb-*.deb will complain it needs apache 1.3 and will uninstall apache 2. If you absolutely need Apache 2, you can use: _old source code here: http://download.opengroupware.org/sources/old-cvs-sources/opengroupware.org-mod_ngobjweb-200407092000.tar.gz _old debian package here: http://download.opengroupware.org/packages/debian-old/deb/opengroupware.org-mod_ngobjweb-200310102348.tar.gz I personnaly use the old source package, it works.

3)-------------- Postgres Configuration --------------- With a clean install, postgres may be started to initialise data directory: $ /etc/init.d/postgresql start $ vi /var/lib/postgres/data/postgresql.conf - change tcpip_socket = true $ vi /var/lib/postgres/data/pg_hba.conf - add:local all all trust host all all 127.0.0.1 255.255.255.255 trust host all all 0.0.0.0 255.255.255.255 reject $ /etc/init.d/postgresql restart ------------------------------------------------------*

4)------------ Postgres Database Creation ------------- ## Create new postgres database called "ogo" $ su - postgres $ createdb ogo $ createuser -A -D ogo $ exit ## Import OpenGroupware Schema into "ogo" database $su - ogo $ cd /usr/lib/opengroupware.org-1.0a/commands/OGo.model/Resources/ $ psql ogo -U ogo Welcome to psql 7.4.5, the PostgreSQL interactive terminal. ---snip--- ogo=> \i pg-build-schema.psql ---snip--- ogo=> \q -------------------------------------------------------*

5)--------------- Apache Configuration -----------------* #assuming you use apache2. The configuration is the same for 1.3 version

$ vi /etc/apache2/apache2.conf LoadModule ngobjweb_module /usr/lib/opengroupware.org-1.0a/WebServer/ngobjweb_2.0.50. so

SetHandler ngobjweb-adaptor SetAppPort 20000

Alias /OpenGroupware10a.woa/WebServerResources/ /usr/share/opengroupware.org-1.0a/www/

# Exchange public folders URL SetHandler ngobjweb-adaptor SetAppPort 21000

$ /etc/init.d/apache2 restart --------------------------------------------------------

6)------------------- INIT Script -----------------------* #You need to modify the init script $ vi /etc/init.d/opengroupware.org-webui1.0a # change the ARGS definition to this: ARGS="--WOPort 20000 --WOHttpAllowHost localhost --OGoMinimumActiveSessionCount 0" -------------------------------------------------------

7)------------------ OGo Env setup ---------------------* ## The Defaults seems buggy at start, alter them $ su - ogo ## copy/paste the following lines: Defaults write NSGlobalDomain LSAdaptor PostgreSQL Defaults write NSGlobalDomain LSConnectionDictionary {databaseName = ogo; hostName = localhost; password = ""; port = 5432; userName = ogo} Defaults write NSGlobalDomain NGBundlePath /usr/lib/opengroupware.org-1.0a/ Defaults write NSGlobalDomain LSAttachmentPath /var/lib/opengroupware.org/documents/

$ exit -------------------------------------------------------

8)----------------- Daemon Startup -------------------- ## Restart all services making sure config changes are implimented /etc/init.d/apache2 restart /etc/init.d/postgresql restart /etc/init.d/opengroupware.org-webui1.0a restart /etc/init.d/opengroupware.org-zidestore1.3 restart $ tail -f /var/log/daemon.log |grep ogo -------------------------------------------------------*

9) Open browser, goto: http://localhost/OpenGroupware

10) Set root password then logout

DONE!