Difference between revisions of "HowTos/Manage contacts in a web-based database"

From Scalix Wiki
Jump to: navigation, search
(Created page with ' - Vorgehen zum initialen Sync 1) globales Addressbuch anlegen - anlegen omnewdir -d ITSD -t s - anzeigen omlistdirs ** SYSTEM Shared LOCAL DB config up...')
 
m (added naviagtion to top of page)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
 +
[[Scalix Wiki]] -> [[How-Tos]] -> '''Manage contacts in an web-based database and sync them to a corporate Scalix adressbook, usable by Outlook and SWA'''
  
- Vorgehen zum initialen Sync
+
== Introduction ==
 +
To integrate an enterprise-wide contact database, Scalix offers the possibility of a public contacts folder or an additional corporate LDAP directory.
 +
Public Contact-folders have the disadvantage that they are not directly available from SWA, and the search in great contact-folders  from Outlook is very slow.
 +
An additional company-wide LDAP address book can be integrated both in Outlook and SWA and is rapidly searchable. Scalix just brings a complicated commandline to manage the data in an additional enterprise-wide LDAP directory.
  
 +
Based on our freely available open source database Frameworks "openfd" http://www.openfd.net we have developed a web-based address book, which manages the addresses via a simple user interface and automatically synchronizes them in the company Scalix-Ldap directory.
  
1) globales Addressbuch anlegen
+
Feature list:
 +
* Hierarchical structure of firms and their employees
 +
* Access to public address books via SWA when writing emails
 +
* Instant update of the LDAP entry when  clicking on the Save-Button
  
- anlegen
+
Download + Info http://www.openfd.net/adressverwaltung-mit-scalix-openldap-anbindung/2009/07/
omnewdir -d ITSD -t s
+
  
- anzeigen
+
Demo: http://demo.openfd.net/kontakte/ user+pw demo
 +
 
 +
Openfd is a php-pear package and is licenced under the LGPL. The Adressbook-Skript is also licenced under the LGPL, copyright by Dr. Michael Krocka, itsystems Deutschland AG.
 +
 
 +
==HowTo prepare the initial sync ==
 +
There are some steps you have to do, before you can use it with scalix
 +
 
 +
===Create a new directory ===
 +
omnewdir -d ITSD -t s
 +
 
 +
Show a list of existent directories
 
  omlistdirs
 
  omlistdirs
** SYSTEM          Shared      LOCAL DB    config update read modifyself
+
** SYSTEM          Shared      LOCAL DB    config update read modifyself
 
     FREEBUSY        Shared      LOCAL DB    config update read modifyself
 
     FREEBUSY        Shared      LOCAL DB    config update read modifyself
 
     SXMIGUSERDIR    Shared      LOCAL DB    config update read modifyself
 
     SXMIGUSERDIR    Shared      LOCAL DB    config update read modifyself
 
     ITSD            Shared      LOCAL DB    config update read modifyself
 
     ITSD            Shared      LOCAL DB    config update read modifyself
  
- gegebenenfalls entfernen
+
perhaps you want to remove it again
omremdir -d ITSD -t s
+
omremdir -d ITSD -t s
  
2) Fügt globales Addressbuch dem CDA Server hinzu
+
===Add to CDA Server ===
- hinzufügen
+
You have to add the new directory to the CDA Server
 +
add
 
  omaddcda -d ITSD -t s -b 2048
 
  omaddcda -d ITSD -t s -b 2048
- neu starten
+
restart the CDA server
 
  omoff -s cda
 
  omoff -s cda
 
  omon -s cda
 
  omon -s cda
  
- gegebenenfalls entfernen
+
in case you want to remove it again
 
  omdelcda -d ITSD -t s
 
  omdelcda -d ITSD -t s
  
  
3) LDAP Konfiguration
+
===LDAP Configuration ===
 
+
Now you have to tell the scalix ldap, that there is a new direcotry which it shoud show
  
vi ~/s/sys/slapd.conf
+
vi ~/s/sys/slapd.conf
  
- Directory mit LDAP Pfad verknüpfen
+
Connect Directory with LDAP path
  
database        om
+
database        om
suffix          "o=itsd"
+
suffix          "o=itsd"
flatSuffix      "o=itsd"
+
flatSuffix      "o=itsd"
directory      ITSD
+
directory      ITSD
sizelimit      1000
+
sizelimit      1000
timelimit      15
+
timelimit      15
useDit          false
+
useDit          false
engines        10
+
engines        10
#
+
#
  
4) globales Addressbuch SWA hinzufügen
+
===Add global adressbook to SWA === 
vi ~/webmail/swa.properties
+
vi ~/webmail/swa.properties
  
swa.debug.defaultClientLogDestination=0
+
swa.debug.defaultClientLogDestination=0
swa.ldap.3.search.2.name.resourceLabel=Email Address
+
swa.ldap.3.search.2.name.resourceLabel=Email Address
swa.ldap.3.displayName.resourceLabel=ITSD
+
swa.ldap.3.displayName.resourceLabel=ITSD
swa.ldap.3.search.5.type=
+
swa.ldap.3.search.5.type=
swa.ldap.3.search.3.type=
+
swa.ldap.3.search.3.type=
swa.ldap.3.search.4.type=
+
swa.ldap.3.search.4.type=
swa.ldap.3.search.5.dirAttribute=mobileTelephoneNumber
+
swa.ldap.3.search.5.dirAttribute=mobileTelephoneNumber
swa.ldap.3.search.5.header=
+
swa.ldap.3.search.5.header=
swa.ldap.3.search.3.name.resourceID=addressbooksearch_label_phone
+
swa.ldap.3.search.3.name.resourceID=addressbooksearch_label_phone
swa.ldap.3.server=bordeaux.itsd.de
+
swa.ldap.3.server=bordeaux.itsd.de
swa.ldap.3.search.3.header=true
+
swa.ldap.3.search.3.header=true
swa.ldap.3.search.4.name.resourceLabel=Fax Phone
+
swa.ldap.3.search.4.name.resourceLabel=Fax Phone
swa.ldap.3.search.4.dirAttribute=facsimileTelephoneNumber
+
swa.ldap.3.search.4.dirAttribute=facsimileTelephoneNumber
swa.ldap.3.baseDN=o=ITSD
+
swa.ldap.3.baseDN=o=ITSD
swa.ldap.3.search.6.name.resourceID=
+
swa.ldap.3.search.6.name.resourceID=
swa.ldap.3.search.2.type=email
+
swa.ldap.3.search.2.type=email
swa.ldap.3.search.1.header=true
+
swa.ldap.3.search.1.header=true
swa.ldap.3.port=3890
+
swa.ldap.3.port=3890
swa.ldap.3.search.2.name.resourceID=addressbooksearch_label_email
+
swa.ldap.3.search.2.name.resourceID=addressbooksearch_label_email
swa.ldap.3.filter=(|(&(cn=%s*)(mail=*))(&(sn=%s*)(mail=*))(&(gn=%s*)(mail=*))(mail=%s*)(&(omalias=%s*)(mail=*)))
+
swa.ldap.3.filter=(|(&(cn=%s*)(mail=*))(&(sn=%s*)(mail=*))(&(gn=%s*)(mail=*))(mail=%s*)(&(omalias=%s*)(mail=*)))
swa.ldap.3.search.6.header=
+
swa.ldap.3.search.6.header=
swa.ldap.3.search.2.header=true
+
swa.ldap.3.search.2.header=true
swa.ldap.3.search.4.name.resourceID=
+
swa.ldap.3.search.4.name.resourceID=
swa.ldap.3.search.5.name.resourceLabel=Mobile Phone
+
swa.ldap.3.search.5.name.resourceLabel=Mobile Phone
swa.ldap.3.search.5.name.resourceID=
+
swa.ldap.3.search.5.name.resourceID=
swa.ldap.3.authType=none
+
swa.ldap.3.authType=none
swa.ldap.3.search.6.type=
+
swa.ldap.3.search.6.type=
swa.ldap.3.type=ITSD
+
swa.ldap.3.type=ITSD
swa.ldap.3.displayName.resourceID=
+
swa.ldap.3.displayName.resourceID=
swa.ldap.3.search.1.dirAttribute=omcn
+
swa.ldap.3.search.1.dirAttribute=omcn
swa.ldap.3.search.1.name.resourceID=addressbooksearch_label_name
+
swa.ldap.3.search.1.name.resourceID=addressbooksearch_label_name
swa.ldap.3.search.2.dirAttribute=rfc822Mailbox
+
swa.ldap.3.search.2.dirAttribute=rfc822Mailbox
swa.ldap.3.search.3.name.resourceLabel=Phone
+
swa.ldap.3.search.3.name.resourceLabel=Phone
swa.ldap.3.addressSearchLimit=100
+
swa.ldap.3.addressSearchLimit=100
swa.ldap.3.search.1.type=name
+
swa.ldap.3.search.1.type=name
swa.ldap.3.search.6.dirAttribute=pagerTelephoneNumber
+
swa.ldap.3.search.6.dirAttribute=pagerTelephoneNumber
swa.ldap.3.search.6.name.resourceLabel=Pager Phone
+
swa.ldap.3.search.6.name.resourceLabel=Pager Phone
swa.ldap.3.search.4.header=
+
swa.ldap.3.search.4.header=
swa.ldap.3.search.1.name.resourceLabel=Name
+
swa.ldap.3.search.1.name.resourceLabel=Name
swa.ldap.3.search.3.dirAttribute=telephoneNumber
+
swa.ldap.3.search.3.dirAttribute=telephoneNumber
  
- Tomcat neu starten
 
/etc/init.d/scalix-tomcat restart
 
  
 +
===Restart Tomcat === 
 +
/etc/init.d/scalix-tomcat restart
  
5) globales Adressbuch für Mapi Clients bekannt geben
 
  
vi ~/s/nls/C/mapi.cfg     
+
===Mapi Clients ===
 +
Tell your Mapi-Clients, that there is a new adressbook
  
 +
vi ~/s/nls/C/mapi.cfg     
  
[Directories]
+
...
1=ITSD
+
[Directories]
 +
1=ITSD
 +
...

Latest revision as of 15:07, 30 June 2010

Scalix Wiki -> How-Tos -> Manage contacts in an web-based database and sync them to a corporate Scalix adressbook, usable by Outlook and SWA

Introduction

To integrate an enterprise-wide contact database, Scalix offers the possibility of a public contacts folder or an additional corporate LDAP directory. Public Contact-folders have the disadvantage that they are not directly available from SWA, and the search in great contact-folders from Outlook is very slow. An additional company-wide LDAP address book can be integrated both in Outlook and SWA and is rapidly searchable. Scalix just brings a complicated commandline to manage the data in an additional enterprise-wide LDAP directory.

Based on our freely available open source database Frameworks "openfd" http://www.openfd.net we have developed a web-based address book, which manages the addresses via a simple user interface and automatically synchronizes them in the company Scalix-Ldap directory.

Feature list:

  • Hierarchical structure of firms and their employees
  • Access to public address books via SWA when writing emails
  • Instant update of the LDAP entry when clicking on the Save-Button

Download + Info http://www.openfd.net/adressverwaltung-mit-scalix-openldap-anbindung/2009/07/

Demo: http://demo.openfd.net/kontakte/ user+pw demo

Openfd is a php-pear package and is licenced under the LGPL. The Adressbook-Skript is also licenced under the LGPL, copyright by Dr. Michael Krocka, itsystems Deutschland AG.

HowTo prepare the initial sync

There are some steps you have to do, before you can use it with scalix

Create a new directory

omnewdir -d ITSD -t s

Show a list of existent directories

omlistdirs
** SYSTEM           Shared       LOCAL DB     config update read modifyself
   FREEBUSY         Shared       LOCAL DB     config update read modifyself
   SXMIGUSERDIR     Shared       LOCAL DB     config update read modifyself
   ITSD             Shared       LOCAL DB     config update read modifyself

perhaps you want to remove it again

omremdir -d ITSD -t s

Add to CDA Server

You have to add the new directory to the CDA Server add

omaddcda -d ITSD -t s -b 2048

restart the CDA server

omoff -s cda
omon -s cda

in case you want to remove it again

omdelcda -d ITSD -t s


LDAP Configuration

Now you have to tell the scalix ldap, that there is a new direcotry which it shoud show

vi ~/s/sys/slapd.conf

Connect Directory with LDAP path

database        om
suffix          "o=itsd"
flatSuffix      "o=itsd"
directory      ITSD
sizelimit       1000
timelimit       15
useDit          false
engines         10
#

Add global adressbook to SWA

vi ~/webmail/swa.properties
swa.debug.defaultClientLogDestination=0
swa.ldap.3.search.2.name.resourceLabel=Email Address
swa.ldap.3.displayName.resourceLabel=ITSD
swa.ldap.3.search.5.type=
swa.ldap.3.search.3.type=
swa.ldap.3.search.4.type=
swa.ldap.3.search.5.dirAttribute=mobileTelephoneNumber
swa.ldap.3.search.5.header=
swa.ldap.3.search.3.name.resourceID=addressbooksearch_label_phone
swa.ldap.3.server=bordeaux.itsd.de
swa.ldap.3.search.3.header=true
swa.ldap.3.search.4.name.resourceLabel=Fax Phone
swa.ldap.3.search.4.dirAttribute=facsimileTelephoneNumber
swa.ldap.3.baseDN=o=ITSD
swa.ldap.3.search.6.name.resourceID=
swa.ldap.3.search.2.type=email
swa.ldap.3.search.1.header=true
swa.ldap.3.port=3890
swa.ldap.3.search.2.name.resourceID=addressbooksearch_label_email
swa.ldap.3.filter=(|(&(cn=%s*)(mail=*))(&(sn=%s*)(mail=*))(&(gn=%s*)(mail=*))(mail=%s*)(&(omalias=%s*)(mail=*)))
swa.ldap.3.search.6.header=
swa.ldap.3.search.2.header=true
swa.ldap.3.search.4.name.resourceID=
swa.ldap.3.search.5.name.resourceLabel=Mobile Phone
swa.ldap.3.search.5.name.resourceID=
swa.ldap.3.authType=none
swa.ldap.3.search.6.type=
swa.ldap.3.type=ITSD
swa.ldap.3.displayName.resourceID=
swa.ldap.3.search.1.dirAttribute=omcn
swa.ldap.3.search.1.name.resourceID=addressbooksearch_label_name
swa.ldap.3.search.2.dirAttribute=rfc822Mailbox
swa.ldap.3.search.3.name.resourceLabel=Phone
swa.ldap.3.addressSearchLimit=100
swa.ldap.3.search.1.type=name
swa.ldap.3.search.6.dirAttribute=pagerTelephoneNumber
swa.ldap.3.search.6.name.resourceLabel=Pager Phone
swa.ldap.3.search.4.header=
swa.ldap.3.search.1.name.resourceLabel=Name
swa.ldap.3.search.3.dirAttribute=telephoneNumber


Restart Tomcat

/etc/init.d/scalix-tomcat restart


Mapi Clients

Tell your Mapi-Clients, that there is a new adressbook

vi ~/s/nls/C/mapi.cfg       
...
[Directories]
1=ITSD
...