Database migration from version 3.X to 4.X
OpenIAM migration procedure is linked with fact that root encryption algorithm was changed from 3DES to AES.
RPM Installation
PostgreSQL and MySQL
For PostgreSQL and MySQL since v4.1.5.1 one can use a migration utility. Utility is stored in /usr/local/OpenIAM/data/openiam/conf/schema/migration folder.
To use the mentioned utility
- /run.sh <db_type> <current_openiam_version> <db_root_password>, where
db_typemay have the following values: mysql, postgresql;current_openiam_versionmay be:3, 4- for 3.4.X installations,3.5for 3.5, 3.6, 3.6.1 installations,db_root_passwordis a password for root. In case of using MySQ it isuserandidmuserin case of using PostgreSQL.
| Examples | ||
|---|---|---|
| 1 | ./run.sh mysql 3.4 openiam | Example of updating MySQL server with 3.4.X OpenIAM version using root user with password openiam. |
| 2 | ./run.sh mysql 3.5 openiam | Example of updating MySQL server with 3.5,3.6 or 3.6.1 OpenIAM version using root with password openiam. |
| 3 | ./run.sh postgresql 3.4 idmuser | Example of updating PostgreSQL server with 3.4.X OpenIAM version using idmuser user with password idmuser. |
| 4 | ./run.sh postgresql 3.5 idmuser | Example of updating PostgreSQL server with 3.5,3.6 or 3.6.1 OpenIAM version using idmuser user with password "idmuser" |
Oracle
Use Oracle SQL developer to apply scripts to the existing Oracle database. Please run consistently scripts from:
/data/openiam/conf/schema/oracle/4.0 /data/openiam/conf/schema/oracle/4.0.1 /data/openiam/conf/schema/oracle/4.1.0 /data/openiam/conf/schema/oracle/4.1.1
etc...
Next, apply the following script.
UPDATE PROPERTY_FILE_VALUES SET PROPERTY_VALUE = 'DES' WHERE PROPERTY_ID = 'org.openiam.iam.cryptor.algorithm';
After a successful update of the database and running the application you will be able to update your deployment to use AES encryption instead of 3DES that was used in v3.X.
To do that, perform the following steps.
- Go to webconsole as sysadmin at: http://your_server/webconsole.
- Navigate on top menu to Administration > System Configuration.
- In System tab find Crypto Algorithm Name and change the value to AES.
- Click Save button at the bottom.
- Stop OpenIAM application (you can stop only openiam-esb module).
- Login to the Redis server with
redis-clicommand. - In
redis-cliconsole, if you are using the password, typeAUTH <YOUR_REDIS_PASSWORD>. - Run
FLUSHALLcommand inredis-cliconsole. It will cleanup all cache and current active users’ sessions. Don't worry, you will not lose any kind of important information. - Run
openiam-esbapplication. - Now you can use your passwords. AES encryption is applied.