Source changes
POM
In the root pom.xml
:
- change parent/version from 3.0.2 to 3.0.3
- change properties/syncope.version from 3.0.2 to 3.0.3
Files
console.properties
Remove
console.reconciliationReportKey=c3520ad9-179f-49e7-b315-d684d216dd97
Add
console.realms-full-tree-threshold=20
wa.properties
Remove
cas.authn.syncope.url=${cas.server.name}/syncope cas.authn.syncope.name=DefaultSyncopeAuthModule
MasterContent.xml
The changes described below are only needed when starting with an empty Internal Storage.
- Re-generate the following elements:
AttrReleasePolicy
AuthModule
AttrRepo
Realm
: addfullPath
attributeConnInstance
net.tirasa.connid.bundles.db.table
→net.tirasa.connid.bundles.db
net.tirasa.connid.bundles.db.scriptedsql
→net.tirasa.connid.bundles.db
connid.database.version
→connid.db.version
Add Implementation as follows:
<Implementation id="GenerateRandomPasswordPropagationActions" type="PROPAGATION_ACTIONS" engine="JAVA" body="org.apache.syncope.core.provisioning.java.propagation.GenerateRandomPasswordPropagationActions"/>
ExternalResource
- remove
randomPwdIfNotProvided
attribute - add
ExternalResourcePropAction
element withimplementation_id="GenerateRandomPasswordPropagationActions"
- remove
- Remove the following elements and re-generate after defining Report(s) in the new format:
- ReportTemplate
- Report
- ReportReportlet
- Implementation[@type='REPORTLET']
- Change any occurrence of
REALM_LIST
withREALM_SEARCH
Internal Storage
Update
ALTER TABLE Realm ADD fullPath VARCHAR(255);
For each row in the Realm
table, provide a sensible value for the fullPath
column, with the following logic:
/
for the root realm, e.g. the only row where theparent
column hasNULL
value- {parent row's
fullPath
value}/
{current row'sname
value}
for any other row
For example:
id | name | parent | fullPath |
---|---|---|---|
8915e471-9683-4356-8c92-d2a6e1993de5 | / | NULL | / |
345f0a30-5a32-442c-bd7f-c1bbcdedf293 | child1 | 8915e471-9683-4356-8c92-d2a6e1993de5 | /child1 |
d419af73-fe15-4774-95be-131b6b1f1044 | child2 | 8915e471-9683-4356-8c92-d2a6e1993de5 | /child2 |
28807a32-1314-4a85-8fe2-0d59a1a05479 | nephew1 | 8915e471-9683-4356-8c92-d2a6e1993de5 | /child1/nephew1 |
Cleanup
DROP TABLE ReportReportlet; -- this statement might be needed and adjusted to the effective constraint name ALTER TABLE Report DROP CONSTRAINT Report_ibfk_1; ALTER TABLE Report DROP COLUMN template_id; DROP TABLE ReportTemplate;
Indexes
New indexes shall be created to improve overall performance.
PostgreSQL
CREATE INDEX Realm_parent_id ON Realm(parent_id); CREATE INDEX Realm_fullPath ON Realm(fullPath); CREATE INDEX Realm_fullPath_startsWith ON Realm USING GIN (to_tsvector('english', fullPath));
Oracle | MySQL | MariaDB
CREATE INDEX Realm_parent_id ON Realm(parent_id); CREATE INDEX Realm_fullPath ON Realm(fullPath);