Bug #2751: Some ldap are not indexed - Rudder - Issue Tracker

Actions

Copy link

Bug #2751

closed

Some ldap are not indexed

Added by Nicolas CHARLES over 11 years ago. Updated over 11 years ago.

Status:

Released

Priority:

Assignee:

Jonathan CLARKE

Category:

Web - Maintenance

Target version:

2.4.0~beta5

Pull Request:

Severity:

UX impact:

User visibility:

Effort required:

Priority:

Name check:

Fix check:

Regression:

Description

My logs are full of messages :

Aug 1 11:40:41 nicolas-laptop slapd¹²⁷³: <= bdb_equality_candidates: (isSystem) not indexed
Aug 1 11:40:41 nicolas-laptop slapd¹²⁷³: <= bdb_equality_candidates: (ruleTarget) not indexed
Aug 1 11:40:41 nicolas-laptop slapd¹²⁷³: <= bdb_equality_candidates: (isSystem) not indexed
Aug 1 11:40:41 nicolas-laptop slapd¹²⁷³: <= bdb_equality_candidates: (groupCategoryId) not indexed
Aug 1 11:39:10 nicolas-laptop slapd¹²⁷³: <= bdb_inequality_candidates: (ram) not indexed
Aug 1 11:38:17 nicolas-laptop slapd¹²⁷³: <= bdb_equality_candidates: (osName) not indexed
Jul 31 14:22:32 nicolas-laptop slapd¹²⁷³: <= bdb_substring_candidates: (cn) not indexed
Jul 31 14:22:32 nicolas-laptop slapd¹²⁷³: <= bdb_substring_candidates: (nodeId) not indexed
Jul 31 14:22:32 nicolas-laptop slapd¹²⁷³: <= bdb_substring_candidates: (nodeHostname) not indexed
Jul 31 14:22:32 nicolas-laptop slapd¹²⁷³: <= bdb_substring_candidates: (osName) not indexed
Jul 31 14:22:32 nicolas-laptop slapd¹²⁷³: <= bdb_substring_candidates: (osFullName) not indexed
Jul 31 14:22:32 nicolas-laptop slapd¹²⁷³: <= bdb_substring_candidates: (osVersion) not indexed
Jul 31 14:22:32 nicolas-laptop slapd¹²⁷³: <= bdb_substring_candidates: (osServicePack) not indexed
Jul 31 14:22:32 nicolas-laptop slapd¹²⁷³: <= bdb_substring_candidates: (osKernelVersion) not indexed

Not sure if it's bad or not, but an expert eye would be awesome

Related issues 1 (0 open — 1 closed)

Actions

Copy link

Updated by Jonathan CLARKE over 11 years ago

Target version changed from 2.4.0~beta4 to 2.4.0~rc1

I'll look into optimizing this.

Actions

Copy link

Updated by Jonathan CLARKE over 11 years ago

Status changed from New to Pending technical review
% Done changed from 0 to 100

Applied in changeset 4628cdcb8b02263aecc8767208df2de2bd394298.

Actions

Copy link

Updated by Jonathan CLARKE over 11 years ago

I just looked into this, based on some usage statistics from ~1 month on a Rudder server.

It turns out that not all *Id attributes were indexed, although we search on them frequently with exact values and never change them - thus making them excellent candidates for indexing. I've changed the indexes to index all "uuid" type attributes.

Similarly, the "isSystem" attribute was not indexed, so I added it.

Then, some node attributes have some sub-string searches (from the search interface, I guess), but I'm not sure it's sensible to try and index for that - there could be all sorts of different searches.

Actions

Copy link