HowTos/Manage contacts in a web-based database

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
...