Secondary addressbook

[kanderson]

We have a situation where I'd like to add a secondary address book.

The Canadian operations are running Scalix, but in the US, they're running Exchange (for now).

I am able to set up an LDAP addressbook with Outlook that allows this to be searchable, but that requires 'per desktop' administration. Is there a way that I could set up a "secondary" addressbook within Scalix which would automatically be available to all the users?

Thanks
Kev.

[florian]

Kevin,

sure there is... you can create an additional Scalix directory using omnewdir, populate it using omaddent or even local (directory2directory dirsync) and make it available to Outlook using MAPI.CFG [Directories] configuration. It can also be made available using LDAP using slapd.conf and then brought into SWA using the partner.xml.

I should add that this is only documented in manpages.... :-)

Cheers,
Florian.

[kanderson]

Thanks Florian

I'm not sure which man pages I'll even need to read for this. Neither omnewdir nor dirsync really talks about Exchange at all. I can likely fake the mapi.cfg, partner.xml and slapd.conf entries from the Scalix ones, but in terms of the behind the scenes stuff, I have no idea.

Actually, will it follow the same method as setting up syncronization for the purpose of migrating from Exchange to Scalix? That's fairly well documented.

Thanks.
Kev.

[florian]

Where does the Exchange part come into play here?

OK, now assuming that you want to use this secondary address book to load the foreign exchange entries into it, correct?

In principle, you're right and the procedure should work. is this Ex55 or Ex2000?

Thx,
Florian.

[kanderson]

Hi Florian.

Yes, our southern counterpart runs Exchange, I'm not sure of the version, but I'd expect it'll be 2003. I'd like to have their names and addresses pulled into our addressbook. I can likely do this without exchange by just using AD, but I don't know where to start. I'm anything but an MS guy (we've had a Samba domain controller from day one).

I know Scalix can authenticate against AD, but I don't want that.

I want to have a system addressbook with all of us Canadians in it, and then have a USians addressbook which is populated with the names of the USian employees as provided by Active directory, or Exchange's LDAP.

Should I just ignore Exchange completely, and go after AD? Or should I hit the Exchange server? I have zero experience with either.

Thanks
Kev.

[mephisto]

sure there is... you can create an additional Scalix directory using omnewdir, populate it using omaddent or even local (directory2directory dirsync) and make it available to Outlook using MAPI.CFG [Directories] configuration. It can also be made available using LDAP using slapd.conf and then brought into SWA using the partner.xml.

I could not find any information on how to change slapd.conf and partner.xml (that would be swa.properties in v10, right?). I created a directory for my resources and it's displayed just fine in Outlook. However, it does not show up in SWA. Here's what I did:

I added this to the end of /var/opt/scalix/sys/slapd.conf:

Code: Select all

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

and this to the end of /etc/opt/scalix/webmail/swa.properties:

Code: Select all

swa.ldap.3.type=ressourcen
swa.ldap.3.server=scalix.mydomain.com
swa.ldap.3.port=389
swa.ldap.3.baseDN=o=scalix
swa.ldap.3.displayName.resourceID=addressbooksearch_title_resources
swa.ldap.3.displayName.resourceLabel=Ressourcen
swa.ldap.3.authType=none
swa.ldap.3.filter=(|(&(cn=%s*)(mail=*))(&(sn=%s*)(mail=*))(&(gn=%s*)(mail=*))(mail=%s*)(&(omalias=%s*)(mail=*)))
swa.ldap.3.addressSearchLimit=100

[ScalixSupport]

The information for adding this to swa.properties is in the installation guide starting from page 102.

For your particular issue, you need to do a couple of things to slapd.conf to get it to work:

1. Remove the comment from the front of the Directory line
2. Change the suffix from o=Scalix to o=AnythingElse
   The reason for that is that the base DN for SYSTEM is o=Scalix and entries further up slapd.conf will redirect your resource request to SYSTEM
3. Make sure that the section for your resource directory is above the

   Code: Select all

   suffix          ""
   section as this acts as a catch-all / default.

In swa.properties, you shoudl then change the swa.ldap.3.baseDN to be the new baseDN you specified in slapd.conf.

Cheers

Dave

[mephisto]

OK, I inserted this into /var/opt/scalix/sys/slapd.conf above the section with suffix "":

Code: Select all

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

and this to the end of /etc/opt/scalix/webmail/swa.properties:

Code: Select all

swa.ldap.3.type=ressourcen
swa.ldap.3.server=scalix.mydomain.com
swa.ldap.3.port=389
swa.ldap.3.baseDN=o=ourresources
swa.ldap.3.displayName.resourceID=addressbooksearch_title_resources
swa.ldap.3.displayName.resourceLabel=Ressourcen
swa.ldap.3.authType=none
swa.ldap.3.filter=(|(&(cn=%s*)(mail=*))(&(sn=%s*)(mail=*))(&(gn=%s*)(mail=*))(mail=%s*)(&(omalias=%s*)(mail=*)))
swa.ldap.3.addressSearchLimit=100

This completely blew up my installation. I can't login to SWA with my two test users, but I can log into SAC as sxadmin. "omon -s" shows that the "Remote Client Interface" is shutting down. I reversed my changes but even after a reboot I can't login. I had to start over completely, even had to delete my data store. Sorry, no error messages available and I'm afraid to try it again.

[mephisto]

Having our RESOURCES adress book in SWA is kind of important for us, but as I described, I'm currently stuck. Is there anything you can help me with, please?

[ScalixSupport]

Can you post all the uncommented sections of omslapd.conf ?

Cheers

Dave

[mephisto]

The way it was, when it got borked? It looked like this:

Code: Select all

subschemaSubentry       "cn=subSchema,o=Scalix"
altServer                       ""
portNum                         389
filelanguage            C
filecharset                     IA5
language                        C
threadlimit                     64
database        om
suffix          "o=MyContacts"
flatSuffix      "o=MyContacts"
directory       _MYCONTACTS_
sizelimit       1000
timelimit       15
useDit          false
engines         10
database        om
suffix          "o=Scalix"
flatSuffix      "o=Scalix"
#directory      SYSTEM
sizelimit       1000
timelimit       15
useDit          false
engines         10
database om
suffix "o=ourresources"
flatSuffix "o=ourresources"
directory RESSOURCEN
sizelimit 1000
timelimit 15
useDit false
engines 10
database        om
suffix          ""
flatSuffix      "o=Scalix"
#directory      SYSTEM
sizelimit       1000
timelimit       15
useDit          false
engines         10

[ScalixSupport]

Here's what I did to get my server working...

1. Create the directory

   Code: Select all

   omnewdir -d RESOURCES -t S
2. Populate the entries
3. Add the directory to /var/opt/scalix/sys/slapd.conf

   Code: Select all

   subschemaSubentry       "cn=subSchema,o=Scalix"
altServer                       ""
portNum                         389

filelanguage            C
filecharset                     IA5

language                        C

threadlimit                     64

database        om
suffix          "o=MyContacts"
flatSuffix      "o=MyContacts"
directory       _MYCONTACTS_
sizelimit       1000
timelimit       15
useDit          false
engines         10

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

database        om
suffix          "o=Resources"
flatSuffix      "o=Resources"
directory      RESOURCES
sizelimit       1000
timelimit       15
useDit          false
engines         10

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

4. Restart the Scalix LDAP server

   Code: Select all

   omoff -d0 slapd; omon slapd
5. Test that the data can be retrieved

   Code: Select all

   root@desktop sys]# ldapsearch -xh localhost -b "o=resources"
# extended LDIF
#
# LDAPv3
# base <o=resources> with scope sub
# filter: (objectclass=*)
# requesting: ALL
#

# Conference Room1, Resources
dn: cn=Conference Room1, o=Resources
cn: Conference Room1
objectClass: top
objectClass: scalixResource
surname: Room1
givenName: Conference
mhsORAddresses: S=Room1/G=Conference/OU1=desktop/OU2=ravelox/CN=Conference Roo
 m1
 omInternetAddr: "Conference Room1" <Conference.Room1@domain.com>
 mail: Conference.Room1@domain.com
 rfc822Mailbox: Conference.Room1@domain.com
 omAddress: Conference Room1 /desktop,ravelox/CN=Conference Room1
 omMailnode: desktop,ravelox
 omCn: Conference Room1
 omGlobalUniqueId: 07100000b779eb34-11.0.861.291
 omLocalUniqueId: 384
 omUlClass: Limited
 omResourceFlags: Accept
 omResourceFlags: DeclineRecurring
 omResourceFlags: DeclineConflicting

 # search result
 search: 2
 result: 0 Success

 # numResponses: 2
 # numEntries: 1

6. Edit /etc/opt/scalix/webmail/swa.properties and append the directory information:

   Code: Select all

    swa.ldap.3.type=other
 swa.ldap.3.server=server.domain.com
 swa.ldap.3.port=389
 swa.ldap.3.baseDN=o=Resources
 swa.ldap.3.displayName.resourceID=
 swa.ldap.3.displayName.resourceLabel=Resources
 swa.ldap.3.authType=none
swa.ldap.3.filter=(|(&(cn=%s*)(mail=*))(&(sn=%s*)(mail=*))(&(gn=%s*)(mail=*))(mail=%s*)(&(omalias=%s*)(mail=*)))
 swa.ldap.3.addressSearchLimit=100
 swa.ldap.3.search.1.header=true
 swa.ldap.3.search.1.type=name
 swa.ldap.3.search.1.name.resourceID=addressbooksearch_label_name
 swa.ldap.3.search.1.name.resourceLabel=Name
 swa.ldap.3.search.1.dirAttribute=omcn
 swa.ldap.3.search.2.header=true
 swa.ldap.3.search.2.type=email
 swa.ldap.3.search.2.name.resourceID=addressbooksearch_label_email
 swa.ldap.3.search.2.name.resourceLabel=Email Address
 swa.ldap.3.search.2.dirAttribute=rfc822Mailbox
 swa.ldap.3.search.3.header=true
 swa.ldap.3.search.3.type=
 swa.ldap.3.search.3.name.resourceID=addressbooksearch_label_phone
 swa.ldap.3.search.3.name.resourceLabel=Phone
 swa.ldap.3.search.3.dirAttribute=telephoneNumber
 swa.ldap.3.search.4.header=
 swa.ldap.3.search.4.type=
 swa.ldap.3.search.4.name.resourceID=
 swa.ldap.3.search.4.name.resourceLabel=Fax Phone
 swa.ldap.3.search.4.dirAttribute=facsimileTelephoneNumber
 swa.ldap.3.search.5.header=
 swa.ldap.3.search.5.type=
 swa.ldap.3.search.5.name.resourceID=
 swa.ldap.3.search.5.name.resourceLabel=Mobile Phone
 swa.ldap.3.search.5.dirAttribute=mobileTelephoneNumber
 swa.ldap.3.search.6.header=
 swa.ldap.3.search.6.type=
 swa.ldap.3.search.6.name.resourceID=
 swa.ldap.3.search.6.name.resourceLabel=Pager Phone
 swa.ldap.3.search.6.dirAttribute=pagerTelephoneNumber

7. Restart tomcat

   Code: Select all

   /etc/init.d/scalix-tomcat restart

You should be able to sign in to SWA and select Tools->Address Book. The new directory will be in the drop down list.

Cheers

Dave

[mephisto]

Thanks Dave, I can see the new adress book now. I did however discover some other problems/inconsistencies:

When I book resources in Outlook, all is fine.
When I book the same resources in SWA, their time-bar gets greyed out, so I can't see if they are available.
If I open a meeting in SWA that has been created in Outlook, I can see the resources' normal time bars.
If I open a meeting in Outlook that has been created in SWA, the time bars are greyed out, too and outlook crashes if I try to make any changes to the meeting and inform the attendees.

Also: Meetings booked in Outlook have the ressources in brackets behind the meeting's name. Those booked in SWA haven't.

[rudi]

Hi,

I added in additional address book via mapi.cfg to outlook. Now I have the SYSTEM and a LOCAL adressbook.

Is it possible if I open the addressbook on outlook and the LOCAL addressbook appears first? Well, I know that this is possible in the Outlook Settings, but I want to make this global. May I can realize this with mapi.cfg?

Thanks!!

[dwerthmu]

This is exactly what I want to do. I was told I can't via this post:

viewtopic.php?t=7889&highlight=

This dirsync program allow you to one way sync from openldap to an additional scalix directory? as mentioned above?

But once you have the other directory how can you add them to Public distribution lists?

Thanks

Derek