Bug 53192 - mXRecord aAAARecord cNAMERecord sRVRecord tXTRecord nSRecord not indexed
mXRecord aAAARecord cNAMERecord sRVRecord tXTRecord nSRecord not indexed
Status: CLOSED FIXED
Product: UCS
Classification: Unclassified
Component: LDAP
UCS 5.0
Other Linux
: P5 normal (vote)
: UCS 5.0
Assigned To: Arvid Requate
Philipp Hahn
https://unix.stackexchange.com/questi...
: interim-4
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2021-04-29 10:32 CEST by Jürn Brodersen
Modified: 2021-05-25 16:00 CEST (History)
3 users (show)

See Also:
What kind of report is it?: Development Internal
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
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 Jürn Brodersen univentionstaff 2021-04-29 10:32:14 CEST
mXRecord aAAARecord cNAMERecord sRVRecord tXTRecord nSRecord not indexed

Apr 29 10:27:38 ucs-2888 slapd[15731]: <= mdb_presence_candidates: (aAAARecord) not indexed
Apr 29 10:27:38 ucs-2888 slapd[15731]: <= mdb_presence_candidates: (mXRecord) not indexed
Apr 29 10:27:38 ucs-2888 slapd[15731]: <= mdb_presence_candidates: (cNAMERecord) not indexed
Apr 29 10:27:38 ucs-2888 slapd[15731]: <= mdb_presence_candidates: (sRVRecord) not indexed
Apr 29 10:27:38 ucs-2888 slapd[15731]: <= mdb_presence_candidates: (tXTRecord) not indexed
Apr 29 10:27:38 ucs-2888 slapd[15731]: <= mdb_presence_candidates: (nSRecord) not indexed

https://hutten.knut.univention.de/mediawiki/index.php/Produkttests_UCS_5.0_LDAP#LDAP-Indizes_aktualisieren

How to reproduce:
Open the dns umc module
Comment 1 Arvid Requate univentionstaff 2021-05-11 15:17:34 CEST
* For this one it would probably reduce performance:

management/univention-directory-manager-modules/modules/univention/admin/handlers/__init__.py:                  searchResult = self.lo.searchDn(u'(&(|(objectClass=univentionDomainController)(objectClass=univentionMemberServer))(univentionService=S4 Connector)(|(aRecord=*)(aAAARecord=*)))')

* For the lookup in the UDM Module dns/txt_record it may increase performance:

        def unmapped_lookup_filter(cls):
                return univention.admin.filter.conjunction('&', [
                        univention.admin.filter.expression('objectClass', 'dNSZone'),
                        univention.admin.filter.conjunction('!', [univention.admin.filter.expression('relativeDomainName', '@')]),
                        univention.admin.filter.conjunction('!', [univention.admin.filter.expression('zoneName', '*.in-addr.arpa', escape=False)]),
                        univention.admin.filter.conjunction('!', [univention.admin.filter.expression('cNAMERecord', '*', escape=False)]),
                        univention.admin.filter.conjunction('!', [univention.admin.filter.expression('sRVRecord', '*', escape=False)]),
                        univention.admin.filter.conjunction('!', [univention.admin.filter.expression('aRecord', '*', escape=False)]),
                        univention.admin.filter.conjunction('!', [univention.admin.filter.expression('aAAARecord', '*', escape=False)]),
                        univention.admin.filter.conjunction('!', [univention.admin.filter.expression('mXRecord', '*', escape=False)]),
                        univention.admin.filter.expression('tXTRecord', '*', escape=False)
                ])


So I've added them to the default list of attributes indexed for presence:

aa0545f0ab | Add presence indices for some DNS attributes

Package: univention-ldap
Version: 16.0.7-3A~5.0.0.202105111516
Branch: ucs_5.0-0
Comment 2 Philipp Hahn univentionstaff 2021-05-12 13:46:32 CEST
OK: aa0545f0ab
OK: ucr get ldap/index/pres | tr , '\n' | sort | grep Record
OK: journalctl -u slapd.service | grep _candidate | cut -d' ' -f 7- | sort -u
FIXED: changelog-5.0-0.xml

[5.0-0] a85caa6c91 fixup! Bug #53192: Add presence indices for some DNS attributes
 doc/changelog/changelog-5.0-0.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)


FYI: attributes are only indexed for new installations, NOT on upgrade.
Comment 3 Florian Best univentionstaff 2021-05-25 16:00:35 CEST
UCS 5.0 has been released:
 https://docs.software-univention.de/release-notes-5.0-0-en.html
 https://docs.software-univention.de/release-notes-5.0-0-de.html

If this error occurs again, please use "Clone This Bug".