Daniel,
The fields we query against are O, OU, T, CN, SN. The only one that I had one
character fields in was the OU attribute. Over the weekend I reloaded my attributes
using 1st, 2nd, 3rd, 4th, and 5th instead of 1,2,3,4, and 5.
With these values I am able to get responses but the strange thing is not all of the
matching users are found.
Example, on my server, I query for OU = 2nd and I I get 30 responses. However, my
test account (bob test) is not listed in the results. When I query for bob test, the
OU value has 2nd included.
What I'm wondering now is if I have any other 1 character OU values that maybe
corrupting the search criteria as before with only 1,2,3,4,5 as the OU value I did not
get any matches and now at least get some...
It is strange with this.
As an aside, in our O (organization) value, I have multiple entries that are 2
character values. We have had no problems querying against this attribute.
Also, on your return of 100 queryies, my chance is your client set to only return 100
responses? We had to set our ldap results on our clients to greater than 100 in order
to get all results. I wonder if your's is the same...
bob
On Monday, March 19, 2001 10:40 AM, Daniel Donnelly <[EMAIL PROTECTED]> wrote:
>Bob,
>
>I never get more than 100 records from your server, regardless of how I
>setup the query. I do not know of any limitation in my client that would
>cause this, so I have to think IMail is limiting it, with its setting. But
>you say it is set for 300. So the only thing I can suggest is that you
>stop/start the LDAP service, so IMail will use your 300
>setting.
>
>Yep, I get 2 'bob test' records. But neither has a '1' in the OU field. So,
>trying your second step does not match your expected or real results. I get
>30 responses with '1' or more in that field. I tried this with my server and
>got 2 records, but the response does not show the '1'. I then Optimized and
>now I get no records (which is what I should get!)
>
>I just tried my server and a '1' in the OU field and did not get a response.
>So I tried '12' and still did not get a response. So I 'optimized' and tried
>again, and now I get a response. So I reset the OU to '1' and then Optimized
>and I don't get a response. So I then tried 'q' in that field and no
>response, even if I 'Optimize'. I then tried 'qa' and no response, then
>Optimized and I got the response (query was looking only for
>'q').
>
>So, it looks to me that a single character is 'not enough' in the OU field,
>to cause IMail to match/send the results. It looks like you need a minimum
>of 2 characters, at least in that field.
>
>Hmmm... I just changed from 'qa' to 'Marketing' (in IMail) and modified my
>query to look for 'm' and I got the response, without 'Optimize' button.
>Guess, if the field is 'long enough' (have not figured out what that is
>yet!), IMail will match/send updated data, without
>Optimization.
>
>I've been making all my changes with IMail Admin, so your using ldaper,
>should also be OK, too.
>
>So, I see what you are saying, now. It kind of looks like you cannot get a
>response (at least from the OU field), when it contains only a single
>character and when you query for only that field. Guess someone needs to try
>this on other fields to see if it applies to all of them (just tried First
>and Last Name fields and they worked OK, The Organization field seems to
>work like OU field, needs 2 chars to match a search for the
>first).
>
>Daniel Donnelly
>________________________________________________________
>
>----- Original Message -----
>From: "Bob McGregor" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, March 16, 2001 6:44 PM
>Subject: Re: [IMail Forum] ldap queries if numbers are involved
>
>
>First off, thanks for looking Daniel!
>
>I have the max to return in the settings to 300. Querying a in the CN would
>return more than that.
>
>We do not have an issue of the OU value displaying correctly when quering
>for example the CN attribute. The problem is when we attempt to query
>against the OU value with a value of 1 or 1st.
>
>For example, if you query for cn of bob test, you'll get two responses for
>test accounts. If you look at the available attributes, you'll see the
>department (OU) value as 'dob 1st'.
>
>So now if you queried with the search value for department (OU) it should
>find the entry for userid bobtest1, but it does not... that is what we are
>trying to get to work.. however, if you query for department(OU) value of
>'dob' multiple entries are returned for our staff.
>
>it's strange...
>
>oh, I am changing values either with ldaper or with the mail administrator,
>probably most with ldaper... I have done the optimize ldap many times with
>no success.... I have created a batch file that will reload the attributes
>with ldaper so maybe I'll come in over the weekend and initialize and reload
>the info and see what that does...
>
>thanks again Daniel.... bob
>
>On Friday, March 16, 2001 4:13 PM, Daniel Donnelly <[EMAIL PROTECTED]>
>wrote:
>>Bob,
>>
>>Well I use '12345' and '1st' and '1' and those worked OK for me as the OU
>>value. I did not do a query for that specific field, but the OU field was
>>returned as part of the query, even when it was empty.
>>
>>I added these with the IMail Admin, Attributes, Add and gave then name of
>>'OU'. However, if I tried 'editing' them in the 'Attribute, Value' field,
>>that seem not to work and often IMail reverted to reporting the value for
>>the 'Department' (which it says is the 'OrganizationalUnit' field) field in
>>the General tab (for that user).
>>
>>So that makes me wonder how you were 'changing' the data?
>>
>>You might try the 'Optimize LDAP' button on the General tab, when that
>users
>>domain is highlighted. That does some LDAP housekeeping and
>>often helps.
>>
>>I tried your LDAP and when I looked for 'Full Name' contains 'a', I got a
>>few records and then my LDAP client closed all by itself (it has not done
>>that before!). Searching for other characters (e,i,o,u) returned 100
>answers
>>and did not close the client. The last name I saw in the 'a' search, was
>>'Amie Nugent', so either here record or the next one (OK, maybe the next
>>few) might have a 'bad' record. I'd tell you to 'Initialize IMail LDAP, but
>>that will cause the loss of data you already entered and I don't want to be
>>the cause of your frustration. You might try deleting a few users, first,
>to
>>see if that helps and points you to the problem record, first.
>>
>>I just tried some other combinations and 'al' in the Full Name, also caused
>>the client to close unexpectedly, but only once, later tries returned 100
>>records. Weird!!!
>>
>>Daniel Donnelly
>>________________________________________________________
>>
>>----- Original Message -----
>>From: "Bob McGregor" <[EMAIL PROTECTED]>
>>To: "IMailList" <[EMAIL PROTECTED]>
>>Sent: Thursday, March 15, 2001 7:08 PM
>>Subject: [IMail Forum] ldap queries if numbers are involved
>>
>>
>>I am attempting to use LDAP and have been unable to us it for my OU
>>attribute.
>>I just ran across something interesting but not sure if I'm
>>correct.
>>
>>Here's what I've done:
>>1. I had single character OU values so I changed them to be larger...
>> they were for grades in a K-12 school 1 through 5. I changed
>> them to 1st, 2nd, ....
>>
>>Before the change I could get nothing looked up with the OU value. Now,
>>after the change, I can get other things to look up (other OU values than
>>the numbers) but I still cannot get the 1st, 2nd, etc to query successfully
>>on the OU value. If I query on another attribute,such as the cn or sn, the
>>value of OU will display. I just cannot query against the ou
>>value...
>>
>>so, has anyone else gotten LDAP in iMail to query against an attribute that
>>begins with numbers? I'm just looking to see if that may be the issue...
>>I have imail 6.05
>>
>>thanks, bob
>>
>>
>>
>>Please visit http://www.ipswitch.com/support/mailing-lists.html
>>to be removed from this list.
>>
>>An Archive of this list is available at:
>>http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
>>
>>
>>
>>Please visit http://www.ipswitch.com/support/mailing-lists.html
>>to be removed from this list.
>>
>>An Archive of this list is available at:
>>http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
>>
>
>
>Please visit http://www.ipswitch.com/support/mailing-lists.html
>to be removed from this list.
>
>An Archive of this list is available at:
>http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
>
>
>
>Please visit http://www.ipswitch.com/support/mailing-lists.html
>to be removed from this list.
>
>An Archive of this list is available at:
>http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
