How to install opengroupware 1.1 (with postgresql and phppgadmin) on debian etch
How to install opengroupware 1.1 (with postgresql and phppgadmin) on debian etch
This is how I managed to get opengroupware running on a fresh install of Debian Etch. I do not claim that this is the correct (or optimal) way of doing this, I just documented how it worked. Feedback is welcome (info at bibliograph dot org).
cboulanger
* login as root
* insert into /etc/apt/sources.list the following line:
deb http://download.opengroupware.org/nightly/packages/debian etch trunk
# apt-get update
* make sure apache2 is installed (not apache version 1.x)
* make sure mod_rewrite and mod_include are installed: include.load and rewrite.load
must be symlinked in /etc/apache2/mods_enabled from /etc/apache2/mods_available
# apt-get install postgresql phppgadmin
* configure postgresql for use with phppgadmin:
/ect/postgresql/postgresql.conf:
...
tcpip_socket = true
...
/etc/postgresql/pg_hba.conf (example only)
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all md5
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 md5
# IPv6-style local connections:
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff md5
/etc/config.inc.php
...
$conf['extra_login_security'] = false;
...
# cd /var/www
# ln -s /usr/share/phppgadmin
# su - postgresql
# psql template1
# ALTER USER postgres WITH PASSWORD 'your-master-password'
# \q
# exit
# apt-get install opengroupware.org libapache2-mod-ngobjweb
# /etc/init.d/apache2 force-reload
# /etc/init.d/opengroupware.org start
* there should be a wizard starting automatically, otherwise start ogo-create-instance
most default values are ok, use ogo for database name and user name, and choose a
password for this instance (ogo-instance-password).
* go into www.yourdomain.com/phppgadmin, login as postgres and your master password (not the ogo-
instance password).
* change the password for user ogo to the ogo-instance-password (is this really necessary? we do it
anyways)
* the current (2007-09-03) etch package has a bug concerning fetching images from the server. To fix:
# cd /var/www
# mkdir OpenGroupware11.woa
# cd OpenGroupware11.woa
# ln -s /usr/share/opengroupware.org-1.1/www/ WebServerResources
# /etc/init.d/opengroupware.org restart
* browse to www.yourdomain.com/OpenGroupware
View body
(text/html 2Kb)
42