Skip to content

OGo Docs

Sections
Personal tools
You are here: Home » Members » cboulanger's Home » 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

Document Actions

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

 

Powered by Plone

This site conforms to the following standards: