Mitel Forums - The Unofficial Source

Mitel Forums => Mitel Software Applications => Topic started by: teqwize on July 09, 2021, 10:18:52 AM

Title: Changing default LDAP query in MiCollab
Post by: teqwize on July 09, 2021, 10:18:52 AM

Hi, Im looking want to start syncing AD contacts into MiCollab,
Currently the sync does not add contacts -  this is the query

Code: [Select]

&(objectCategory=person)(objectClass=user)( !(userAccountControl:1.2.840.113556.1.4.803:=2))
I tried to change it to

Code: [Select]

|(objectClass=user)(objectClass=contact)( !(userAccountControl:1.2.840.113556.1.4.803:=2)) i tested this query in AD and it returns enabled users and contacts, however when i entered in IDS i get this error in the log file, progress in IDS is at 0 % forever.

Code: [Select]

2021-07-08 18:07:11.138303500   File "/sbin/e-smith/ids-ad-sync", line 744, in <module>
2021-07-08 18:07:11.138526500     main(sys.argv)
2021-07-08 18:07:11.138553500   File "/sbin/e-smith/ids-ad-sync", line 741, in main
2021-07-08 18:07:11.138823500     performSync(connId, dryrun, ldapDebug=ldapDebug)
2021-07-08 18:07:11.138846500   File "/sbin/e-smith/ids-ad-sync", line 511, in performSync
2021-07-08 18:07:11.139027500     attrMappings, dryrun, True)
2021-07-08 18:07:11.139037500   File "/sbin/e-smith/ids-ad-sync", line 348, in performQuery
2021-07-08 18:07:11.139171500     queryResults = _performQueryHelper()
2021-07-08 18:07:11.139191500   File "/sbin/e-smith/ids-ad-sync", line 286, in _performQueryHelper
2021-07-08 18:07:11.139384500     userAttrs[adGuidKey] = str(uuid.UUID(bytes_le=userAttrs[adGuidKey]))
2021-07-08 18:07:11.139404500   File "/usr/lib64/python2.7/site-packages/ldap/cidict.py", line 27, in __getitem__
2021-07-08 18:07:11.139424500     return self.data[lower(key)]
2021-07-08 18:07:11.139465500 KeyError: 'objectguid'

Title: Re: Changing default LDAP query in MiCollab
Post by: mitelrvtd on August 09, 2021, 12:58:58 PM

Did you ever have any luck with this?
I'm looking to do the same thing, see if I can import AD Contact objects.
Thanks

Title: Re: Changing default LDAP query in MiCollab
Post by: teqwize on August 11, 2021, 10:55:50 AM

Kind of,
This is my current query.

Code: [Select]

|(objectClass=person)(objectClass=contact) (&(memberOf:1.2.840.113556.1.4.1941:= CN=Mitel_AD_Users,OU=Groups,DC=int,DC=MYDOMAIN,DC=org))Contacts are showing up in detained entries, but on some syncs, a whole bunch of objects that are out of scope of this query are showing up as well, since we deffer all operations, it's not a big deal. i moved on.

Title: Re: Changing default LDAP query in MiCollab
Post by: teqwize on August 11, 2021, 10:56:39 AM

users/contacts need to be a member of that AD groups

Title: Re: Changing default LDAP query in MiCollab
Post by: mitelrvtd on August 11, 2021, 03:43:57 PM

Thanks for replying!

For me, the sync is running when I included

Code: [Select]

|(objectClass=person)(objectClass=contact)
All the contacts I want to sync are just in one OU that is included.

The issue for me was that the only phone number that will sync to the account is the attribute that is mapped to "Primary Phone Directory Number". The attribute mapped to "DID Number", even though it shows in Detained Entries does not get applied to the account.

So at least this makes the accounts in Client Services so they show in the Directory but I have to put the number I want as the primary in that attribute on the AD object.

Some of my entries had multiple numbers so I had to manually add the second number in the Micollab account, at least I didn't have that many like that.
Like I wanted to publish Nupoint call flow or Ring Group extensions but also wanted to have the corresponding DID number on the account.

Just replying in case someone else sees this.
Thanks