ROLE problems
PostPosted:Thu Jul 09, 2026 2:44 pm
OpenKM CE 7.0.2, MariaDB/MySQL, DatabasePrincipalAdapter, no LDAP.
Problem exists even on a clean fresh installation.
Steps to reproduce:
1. Create a new role, for example TEST.
2. Create a new user.
3. During user creation, the Roles field shows all roles and TEST can be selected.
4. Save the user.
5. Open the same user again with Edit user.
6. Try to add another role, for example TEST or ROLE_PRODAJA.
7. The role selector does not show the role. Typing the exact role name gives "No results match".
8. If I manually insert the role into OKM_USER_ROLE through SQL, then the role appears in the user edit screen and can be removed.
Database checks:
- OKM_ROLE contains all roles.
- ROL_ACTIVE = T.
- OKM_USER_ROLE accepts manual inserts.
- The issue is reproducible on a clean OpenKM 7.0.2 installation, so it is not caused by migration.
Expected behavior:
Edit user should show available roles in the same way as Create user.
Problem exists even on a clean fresh installation.
Steps to reproduce:
1. Create a new role, for example TEST.
2. Create a new user.
3. During user creation, the Roles field shows all roles and TEST can be selected.
4. Save the user.
5. Open the same user again with Edit user.
6. Try to add another role, for example TEST or ROLE_PRODAJA.
7. The role selector does not show the role. Typing the exact role name gives "No results match".
8. If I manually insert the role into OKM_USER_ROLE through SQL, then the role appears in the user edit screen and can be removed.
Database checks:
- OKM_ROLE contains all roles.
- ROL_ACTIVE = T.
- OKM_USER_ROLE accepts manual inserts.
- The issue is reproducible on a clean OpenKM 7.0.2 installation, so it is not caused by migration.
Expected behavior:
Edit user should show available roles in the same way as Create user.
