Difference between revisions of "HowTos/Manage contacts in a web-based database"
(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''' | ||
− | - | + | == 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 | omlistdirs | ||
− | ** | + | ** 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 | ||
− | + | perhaps you want to remove it again | |
− | omremdir -d ITSD -t s | + | 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 | omaddcda -d ITSD -t s -b 2048 | ||
− | + | restart the CDA server | |
omoff -s cda | omoff -s cda | ||
omon -s cda | omon -s cda | ||
− | + | in case you want to remove it again | |
omdelcda -d ITSD -t s | 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 | + | vi ~/s/sys/slapd.conf |
− | + | 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 |
− | # | + | # |
− | + | ===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 |
− | |||
− | |||
+ | ===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 | + | [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
Contents
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 ...