1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>
Image 1

WE Solutions / Our services

  • Previous
  • Next
  • Stop
  • Play

SAMBA/LDAP

Thin Client Server

Postfix Mail Server

Postfix Mail Server

HA Clustering

eGroupWare-1.6 + PostgreSQL

PDF Print E-mail

Written by Mr. Sontaya Photibut Wednesday, 07 January 2009 22:46

Install eGroupWare + PostgreSQL

System:

SLES 10 SP2 (32bits)
PostgreSQL 8.1.11
Apache2    2.2.3-16.18
php5       5.2.5-9.5
mysql      5.0.26-12.18

Partitional
    /boot    100 MB.
    /    10  GB.
    /swap    2   GB.
    /srv    20  GB.
    /var    20  GB.



1) Install PostgreSQL & Config permissions for postgresql.

$  yast sw_single
postgresql
postgresql-contrib
postgresql-devel
postgresql-jdbc
postgresql-server


$ vi /var/lib/pgsql/data/postgresql.conf
listen_addresses = 'localhost'

$ /var/lib/pgsql/data/pg_hba.conf

# Add the following to allow the egroupware user to connect.
# "local" is for Unix domain socket connections only
#local   all         all                               ident sameuser
local   all         all                               md5
# IPv4 local connections:
#host    all         all         127.0.0.1/32          ident sameuser
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser
# Add the following to allow the egroupware user to connect.
host egroupware     egroupware   127.0.0.1/24       <your_password>


$ rcpostgresql restart

2) Create eGroupWare DB and User
$ su - postgres

# Create the user
postgres@egroupware:~> createuser --no-adduser --no-createdb -P egroupware
Enter password for new role: <your_password>
Enter it again: <your_password>
Shall the new role be allowed to create more new roles? (y/n) n
CREATE ROLE


# Create the database
postgres@egroupware:~> createdb --owner egroupware egroupware
CREATE DATABASE


# Test out the connection
postgres@egroupware:~> psql egroupware
Welcome to psql 8.1.11, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit
egroupware=# \q
postgres@egroupware:~>


3) Install and Configure Apache (LAMP Server)

$  yast sw_single
LAMP Server
php5-mysql
php5-odbc
php5-pear
php5-pgsql
php5-mbstring
php5-ldap
php5-imap
php5-gd


4) Install Remaining Packages:
$ pear install Auth_SASL
$ pear install XML_Feed_Parser


5) Runlevel
apache2
mysql
postgresql


6) Installation/Configuration of eGroupWare:

        6.1) Download and Unpack

$ tar xvf eGroupware-1.6.001.tar.bz2 -C /srv/www/htdocs/
$ tar xvf eGroupware-egw-pear-1.6.001.tar.bz2 -C /srv/www/htdocs/
$ cd /srv/www/htdocs/
$ chown wwwrun.www egroupware/ -R

       6.2) Configure PHP

$ vi /etc/php5/apache2/php.ini


# Change the memory_limit to 16MB
upload_max_filesize = 8M

# Change the following line for UNICODE
;mbstring.func_overload = 0
mbstring.func_overload = 7

        6.3) Installing eGroupWare

http://server/egroupware/setup

Setup/Config Admin Login
Step1:

Step2:
click Edit Current Configuration

$ mkdir -p /var/lib/egroupware/default/files
$ mkdir -p /var/lib/egroupware/default/backup
$ chmod 777 /var/lib/egroupware/default/files
$ chmod 777 /var/lib/egroupware/default/backup

Step3:
click Create admin account

Step4:
click Manage Languages

Step5:
click Manage Applications  > click cencal

Step6:
click DB backup and restore > click backup now > click schedule > click Logout.


Login eGroupware
http://server/egroupware

Main > menu Admin > User accounts > Add

Finish. 


Comments (0)Add Comment

Write comment

security code
Write the displayed characters


busy