Versions Compared

Old Version 1

changes.mady.by.user Francesco Chicchiriccò

Saved on

compared with

New Version Current

changes.mady.by.user Francesco Chicchiriccò

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2
styledecimal

Before starting

...

Before starting the upgrade process, with 2.0.4 running, perform the following actions either via REST or Admin Console:

  1. Create a Long configuration parameter named connector.conf.history.size with value '10'
  2. Create a Long configuration parameter named resource.conf.history.size with value '10'

After completing

After completing the upgrade process, with 2.0.5 running, execute the SQL query below on your internal storage:

...

 

Code Block
languagesql
DELETESELECT FROM AccessToken;
 
DROP VIEW user_search_udyngmemb;
DROP VIEW user_search_dynrmemb;
DROP VIEW anyObject_search_adyngmemb;

DROP TABLE DynRoleMembership_User;
DROP TABLE DynGroupMembership_User;
DROP TABLE DynGroupMembership_AnyObject;

CREATE TABLE UDynGroupMembers(
    any_id CHAR(36),
    group_id CHAR(36),
    UNIQUE(any_id, group_id));

CREATE TABLE ADynGroupMembers(
    anyType_id VARCHAR(255),
    any_id CHAR(36),
    group_id CHAR(36),
    UNIQUE(anyType_id, any_id, group_id));

CREATE TABLE DynRoleMembers(
    any_id CHAR(36),
    role_id VARCHAR(255),
    UNIQUE(any_id, role_id));

CREATE TABLE DynRealmMembers(
    any_id CHAR(36),
    dynRealm_id VARCHAR(255),
    UNIQUE(any_id, dynRealm_id));

CREATE INDEX UDynGroupMembers_any_id ON UDynGroupMembers(any_id);
CREATE INDEX UDynGroupMembers_group_id ON UDynGroupMembers(group_id);
CREATE INDEX ADynGroupMembers_any_id ON ADynGroupMembers(any_id);
CREATE INDEX ADynGroupMembers_group_id ON ADynGroupMembers(group_id);
CREATE INDEX DynRoleMembers_any_id ON DynRoleMembers(any_id);
CREATE INDEX DynRoleMembers_role_id ON DynRoleMembers(role_id);
CREATE INDEX DynRealmMembers_any_id ON DynRealmMembers(any_id);
CREATE INDEX DynRealmMembers_dynRealm_id ON DynRealmMembers(dynRealm_id);
CREATE INDEX UPAttrUniqueValue_attrIndex on UPlainAttrUniqueValue(attribute_id);
CREATE INDEX GPAttrUniqueValue_attrIndex on GPlainAttrUniqueValue(attribute_id);
CREATE INDEX APAttrUniqueValue_attrIndex on APlainAttrUniqueValue(attribute_id);
CREATE INDEX CPAttrUniqueValue_attrIndex on CPlainAttrUniqueValue(attribute_id);
CREATE INDEX UPlainAttr_schema_Index on UPlainAttr(schema_id);
CREATE INDEX UPlainAttr_membership_Index on UPlainAttr(membership_id);
CREATE INDEX GPlainAttr_schema_Index on GPlainAttr(schema_id);
CREATE INDEX APlainAttr_schema_Index on APlainAttr(schema_id);
CREATE INDEX APlainAttr_membership_Index on APlainAttr(membership_id);

Please beware that the statement above will, among other things, invalidate any existing session.

id AS root_realm_id FROM REALM where name = '/';

take note of the root_realm_id value and use it for execute the following statements:

Code Block
languagesql
UPDATE Task SET sourceRealm_id='root_realm_id' WHERE DTYPE='PushTask';
UPDATE ConnInstance SET adminRealm_id='root_realm_id';

then restart the Java EE container.

Finally, perform the following actions either via REST or Admin Console:

  1. grant the ANYTYPE_LIST, ANYTYPE_READ, ANYTYPECLASS_LIST and ANYTYPECLASS_READ entitlements to any Role used for delegated administration of Users, Groups or Any Objects
  2. re-define any previously available provisioning rule for Realms, if available
  3. open and save any User, Group or Any Object template used by Realms and Pull Tasks

Source changes

POM

In the root pom.xml:

  • change parent/version from 2.0.4 to 2.0.5

  • change properties/syncope.version from 2.0.4 to 2.0.5

Other

Replace the following files with their 2.0.4 5 counterparts (re-apply any customization previously made):