Bug 48246 - ucsschoolRole attribute should support substring search
ucsschoolRole attribute should support substring search
Status: CLOSED FIXED
Product: UCS@school
Classification: Unclassified
Component: General
UCS@school 4.3
Other Linux
: P5 normal (vote)
: UCS@school 4.4 v1
Assigned To: Jürn Brodersen
Daniel Tröder
:
Depends on:
Blocks: 48384
  Show dependency treegraph
 
Reported: 2018-11-30 13:57 CET by Daniel Tröder
Modified: 2019-03-12 13:26 CET (History)
4 users (show)

See Also:
What kind of report is it?: Bug Report
What type of bug is this?: 4: Minor Usability: Impairs usability in secondary scenarios
Who will be affected by this bug?: 2: Will only affect a few installed domains
How will those affected feel about the bug?: 2: A Pain – users won’t like this once they notice it
User Pain: 0.091
Enterprise Customer affected?:
School Customer affected?: Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Tröder univentionstaff 2018-11-30 13:57:57 CET
Currently the LDAP schema is:
------------------------------------------------------------------
attributetype ( univentionSchool:5101
        NAME 'ucsschoolRole'
        DESC 'Role of UCS@school object in given context'
        EQUALITY caseIgnoreMatch
        SYNTAX 1.3.6.1.4.1.1466.115.121.1.15 )
------------------------------------------------------------------

It is missing:

------------------------------------------------------------------
SUBSTR caseIgnoreSubstringsMatch
------------------------------------------------------------------

This prevents from searching for all school_classes or all objects of a school, etc.
Comment 1 Daniel Tröder univentionstaff 2018-12-10 15:13:03 CET
Listener module for customer had to be written with filtering code in the listener, because the LDAP filter could not do the job.
Comment 2 Jürn Brodersen univentionstaff 2019-01-17 17:28:55 CET
[4.4 095edefb4] Bug #48246: Add substring search for ucsschoolRole
[4.4 062b13297] Bug #48246: yaml

Package: ucs-school-import
Version: 17.2.0-2A~4.4.0.201901171723
Branch: ucs_4.4-0
Scope: ucs-school-4.4
Comment 3 Daniel Tröder univentionstaff 2019-01-18 09:32:18 CET
OK: before substring search didn't work, after update works
REOPEN: join script VERSION was not raised, join script didn't run and thus the new schema wasn't installed (I did it manually for testing)
REOPEN: OpenLDAP index for ucsschoolRole wasn't rebuilt: -- /var/log/syslog --
Jan 18 09:28:59 m65 slapd[25327]: <= mdb_equality_candidates: (ucsschoolRole) not indexed
Jan 18 09:29:03 m65 slapd[25327]: <= mdb_substring_candidates: (ucsschoolRole) not indexed
Comment 4 Jürn Brodersen univentionstaff 2019-01-18 13:46:05 CET
Join script version was raised in commit 0dd045d981 for bug 48226.

Index should now be added, see bug #48384.
Comment 5 Daniel Tröder univentionstaff 2019-01-21 08:58:49 CET
Substring search works as expected (and using indices).
Comment 6 Sönke Schwardt-Krummrich univentionstaff 2019-03-12 10:59:18 CET
UCS@school 4.4 v1 has been released.

https://docs.software-univention.de/release-notes-ucsschool-4.4v1-de.html

If this error occurs again, please clone this bug.
Comment 7 Valentin Heidelberger univentionstaff 2019-03-12 11:05:31 CET
Has this already been released?
If not please -> reopen
Comment 8 Sönke Schwardt-Krummrich univentionstaff 2019-03-12 13:26:17 CET
(In reply to Valentin Heidelberger from comment #7)
> Has this already been released?

Yes, UCS@school 4.4v1.