Bug 48796 - Cannot create users any more after installing openproject app: Invalid syntax: openprojectActivated
Cannot create users any more after installing openproject app: Invalid syntax...
Status: CLOSED DUPLICATE of bug 48621
Product: UCS
Classification: Unclassified
Component: UMC - Users
UCS 4.4
Other Linux
: P5 normal (vote)
: UCS 4.4
Assigned To: Florian Best
Dirk Wiesenthal
:
Depends on:
Blocks: 48724
  Show dependency treegraph
 
Reported: 2019-02-26 22:58 CET by Arvid Requate
Modified: 2019-03-12 13:41 CET (History)
5 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 Arvid Requate univentionstaff 2019-02-26 22:58:40 CET
While checking Bug #48724 with the openproject app I found that I cannot create any users any longer after the installation of that app:


root@master40:~# udm users/user create --set username=user1 \
                     --set lastname=last1 --set password=univention
LDAP Error: Invalid syntax: openprojectActivated: value #0 invalid per syntax
Comment 1 Arvid Requate univentionstaff 2019-02-26 22:59:59 CET
IP: 10.200.8.40
VM: arequate_ar44pt1.40 (running)
VM-Host: lattjo
Snapshot: 440master-e0-pt1-Bug48796
Comment 2 Florian Best univentionstaff 2019-02-27 10:03:34 CET
Are you using the test appcenter or the official?
Comment 3 Arvid Requate univentionstaff 2019-02-27 10:11:01 CET
testing, becasue of Bug #48724, but let me check again with the official appcenter.
Comment 4 Florian Best univentionstaff 2019-02-27 10:14:19 CET
(In reply to Arvid Requate from comment #3)
> testing, becasue of Bug #48724, but let me check again with the official
> appcenter.

No, i just wanted to know it. No need for testing again! I will have a look soon.
Comment 5 Florian Best univentionstaff 2019-02-27 10:19:59 CET
@Dirk, could it be possible that the automatically generated OID for attributes depends on the order in which they occcur in the .attributes file? And if that changes, or the code changes how it makes for-loops, etc. then the attribute's OID changes?
Comment 6 Dirk Wiesenthal univentionstaff 2019-02-27 10:22:44 CET
(In reply to Florian Best from comment #5)
> @Dirk, could it be possible that the automatically generated OID for
> attributes depends on the order in which they occcur in the .attributes
> file? And if that changes, or the code changes how it makes for-loops, etc.
> then the attribute's OID changes?

Yes, this happens. New attributes must be appended to the end. Or given an explicit OID.
Comment 7 Florian Best univentionstaff 2019-02-27 12:49:23 CET
The schema in /usr/share/univention-appcenter/apps/openproject/openproject.schema contains:

attributetype ( 1.3.6.1.4.1.10176.5000.14209.22408.51032.30571.1151.61037.50940.9887.1.1
    NAME 'openprojectActivated'
    DESC 'Attribute created by the App Center integration for Extended Attributes'
    SYNTAX 1.3.6.1.4.1.1466.115.121.1.7 EQUALITY booleanMatch
    SINGLE-VALUE
    )

objectclass ( 1.3.6.1.4.1.10176.5000.14209.22408.51032.30571.1151.61037.50940.9887.2.1
    NAME 'openprojectUser'
    DESC 'Attribute created by the App Center integration for Extended Attributes'
    AUXILIARY
    MAY ( openprojectActivated )
    SUP top
    )

objectclass ( 1.3.6.1.4.1.10176.99998.6696237932.0.1
    NAME 'openproject-user'
    DESC 'Attribute created by the App Center integration for Extended Attributes'
    AUXILIARY
    SUP top
    )


while is should contain:

attributetype ( 1.3.6.1.4.1.10176.99998.6696237932.1.2
    NAME 'openprojectActivated'
    DESC 'Attribute created by the App Center integration for Extended Attributes'
    SYNTAX 1.3.6.1.4.1.1466.115.121.1.7 EQUALITY booleanMatch
    SINGLE-VALUE
    )

attributetype ( 1.3.6.1.4.1.10176.99998.6696237932.1.1
    NAME 'openproject-isadmin'
    DESC 'Attribute created by the App Center integration for Extended Attributes'
    SYNTAX 1.3.6.1.4.1.1466.115.121.1.15 EQUALITY caseIgnoreMatch SUBSTR caseIgnoreSubstringsMatch
    SINGLE-VALUE
    )

objectclass ( 1.3.6.1.4.1.10176.99998.6696237932.0.1
    NAME 'openproject-user'
    DESC 'Attribute created by the App Center integration for Extended Attributes'
    AUXILIARY
    MAY ( openproject-isadmin $ openprojectActivated )
    SUP top
    )
Comment 8 Florian Best univentionstaff 2019-02-27 13:19:19 CET
This was caused by .attribute files from UCS 4.3. For such cases I added backwards compatibility, which fixes the problem:

univention-appcenter (8.0.4-7)
a0b929bf3dc5 | Bug #48621: Bug #48796: be backwards compatible

*** This bug has been marked as a duplicate of bug 48621 ***
Comment 9 Dirk Wiesenthal univentionstaff 2019-03-11 14:13:39 CET
OK
Comment 10 Florian Best univentionstaff 2019-03-12 13:41:01 CET
UCS 4.4 has been released:
 https://docs.software-univention.de/release-notes-4.4-0-en.html
 https://docs.software-univention.de/release-notes-4.4-0-de.html

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