LDAP Query different on Solaris Sparc

LDAp Query makes a FT Query on Solaris Sparc System and returns nothingon win32 it works.We cannot change the query.

Query:

ldapsearch -h notesldap01.domain -D user -w password “(|(|(|(mail=harry.hasler@domain.com*) (proxyAddresses=smtp:harry.hasler@domain.com*))(proxyAddresses=SMTP:harry.hasler@domain.com*))(rfc822mailbox=harry.hasler@domain.com))”

ldap_Debug:

12/15/2008 16:57:23.15 [18416:00007-00007] LDAP CIServ Listen> Connection Accepted on Port 389 for Session 01A2007F

12/15/2008 16:57:23.15 [18416:00069-00028] LDAP> InitForSearch

12/15/2008 16:57:23.15 [18416:00069-00028] LDAP> InitForSearch

12/15/2008 16:57:23.27 [18416:00069-00025] LDAP> BERGetTag State

12/15/2008 16:57:23.27 [18416:00069-00023] LDAP> BERGetLeadingLengthByte State

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> BERGetNext State

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> Bind State

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> Version: 3

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> DN: user

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> Method: 0x80 (Simple)

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> Groups for name CN=user/O=domain:

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> *

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> */O=domain

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> SYS.ADMIN.GLOBAL

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> SYS.MGR

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> SRV.USER.NOTESLDAP01.ALL

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> LocalDomainAdmins

12/15/2008 16:57:23.27 [18416:00069-00026] LDAP> Successful bind, user user authenticated as CN=user/O=domain

12/15/2008 16:57:23.28 [18416:00069-00026] LDAP> Return Result State (Bind operation)

12/15/2008 16:57:23.28 [18416:00069-00026] LDAP> StateReturnResult returning resultCode 0 (Success)

12/15/2008 16:57:23.28 [18416:00069-00011] LDAP> SendBufferFree

12/15/2008 16:57:23.28 [18416:00069-00011] LDAP> InitForSearch

12/15/2008 16:57:23.28 [18416:00069-00024] LDAP> BERGetTag State

12/15/2008 16:57:23.28 [18416:00069-00021] LDAP> BERGetLeadingLengthByte State

12/15/2008 16:57:23.28 [18416:00069-00020] LDAP> BERGetLength State

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> BERGetNext State

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> ***** Start search request processing *****

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> Scope: SUBTREE

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> Dereference Aliases: 0

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> TimeLimit: 15

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> SizeLimit: 0

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> Attributes to return: ALL

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> Base:

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> *** Searching in database /var/lotus/notesdata/dirjbexchange.nsf …

12/15/2008 16:57:23.28 [18416:00069-00013] LDAP> Type of search: FT Search

12/15/2008 16:57:23.29 [18416:00069-00013] LDAP> FT Query: (((([$$MAIL] Contains (“harry Kny”)) OR ([proxyaddresses] Contains (“smtp:harry.Kny@domain.com))) OR ([proxyaddresses] Contains (“SMTP:harry.Kny@domain.com”*))) OR ([$$MAIL] Co

12/15/2008 16:57:23.30 [18416:00069-00013] LDAP> GetSearchEntry State

12/15/2008 16:57:23.30 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.30 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.31 [18416:00069-00013] LDAP> *** Searching in database /var/lotus/notesdata/dirsldap.nsf …

12/15/2008 16:57:23.31 [18416:00069-00013] LDAP> Type of search: FT Search

12/15/2008 16:57:23.31 [18416:00069-00013] LDAP> FT Query: (((([$$MAIL] Contains (“harry Kny”)) OR ([proxyaddresses] Contains (“smtp:harry.Kny@domain.com))) OR ([proxyaddresses] Contains (“SMTP:harry.Kny@domain.com”*))) OR ([$$MAIL] Co

12/15/2008 16:57:23.33 [18416:00069-00013] LDAP> GetSearchEntry State

12/15/2008 16:57:23.33 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.33 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.33 [18416:00069-00013] LDAP> *** Searching in database /var/lotus/notesdata/dirspec.nsf …

12/15/2008 16:57:23.33 [18416:00069-00013] LDAP> Type of search: FT Search

12/15/2008 16:57:23.33 [18416:00069-00013] LDAP> FT Query: (((([$$MAIL] Contains (“harry Kny”)) OR ([proxyaddresses] Contains (“smtp:harry.Kny@domain.com))) OR ([proxyaddresses] Contains (“SMTP:harry.Kny@domain.com”*))) OR ([$$MAIL] Co

12/15/2008 16:57:23 LDAP Server: 159.103.83.116 connected

12/15/2008 16:57:23.35 [18416:00069-00013] LDAP> GetSearchEntry State

12/15/2008 16:57:23.35 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.35 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.35 [18416:00069-00013] LDAP> *** Searching in database /var/lotus/notesdata/jbnames.nsf …

12/15/2008 16:57:23.35 [18416:00069-00013] LDAP> Type of search: FT Search

12/15/2008 16:57:23.35 [18416:00069-00013] LDAP> FT Query: (((([$$MAIL] Contains (“harry Kny”)) OR ([proxyaddresses] Contains (“smtp:harry.Kny@domain.com))) OR ([proxyaddresses] Contains (“SMTP:harry.Kny@domain.com”*))) OR ([$$MAIL] Co

12/15/2008 16:57:23.37 [18416:00069-00013] LDAP> GetSearchEntry State

12/15/2008 16:57:23.37 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.37 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.37 [18416:00069-00013] LDAP> *** Searching in database /var/lotus/notesdata/dirgam.nsf …

12/15/2008 16:57:23.37 [18416:00069-00013] LDAP> Type of search: FT Search

12/15/2008 16:57:23.38 [18416:00069-00013] LDAP> FT Query: (((([$$MAIL] Contains (“harry Kny”)) OR ([proxyaddresses] Contains (“smtp:harry.Kny@domain.com))) OR ([proxyaddresses] Contains (“SMTP:harry.Kny@domain.com”*))) OR ([$$MAIL] Co

12/15/2008 16:57:23.39 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.39 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.40 [18416:00069-00013] LDAP> *** Searching in database /var/lotus/notesdata/dirartio.nsf …

12/15/2008 16:57:23.40 [18416:00069-00013] LDAP> Type of search: FT Search

12/15/2008 16:57:23.40 [18416:00069-00013] LDAP> FT Query: (((([$$MAIL] Contains (“harry Kny”)) OR ([proxyaddresses] Contains (“smtp:harry.Kny@domain.com))) OR ([proxyaddresses] Contains (“SMTP:harry.Kny@domain.com”*))) OR ([$$MAIL] Co

12/15/2008 16:57:23.41 [18416:00069-00013] LDAP> GetSearchEntry State

12/15/2008 16:57:23.41 [18416:00069-00013] LDAP> Search State

12/15/2008 16:57:23.41 [18416:00069-00013] LDAP> ***** Count of search entries returned (total): 0 *****

12/15/2008 16:57:23.41 [18416:00069-00013] LDAP> Return Result State (Search operation)

12/15/2008 16:57:23.41 [18416:00069-00013] LDAP> StateReturnResult returning resultCode 0 (Success)

12/15/2008 16:57:23.41 [18416:00069-00010] LDAP> SendBufferFree

12/15/2008 16:57:23.41 [18416:00069-00010] LDAP> InitForSearch

12/15/2008 16:57:23.52 [18416:00069-00017] LDAP> BERGetTag State

12/15/2008 16:57:23 LDAP Server: 159.103.83.116 disconnected

Subject: LDAP Query different on Solaris Sparc

Hi Stefan,

Sorry for asking the obvious, but do you have the Fulltext index built for all of the six databases that were searched? Have you run fixup on the databases and tried the search again?

If your answer to those questions is “yes”, you probably want to open a ticket with support.

Regards,

– Josh Burchard