14.7 Migrating Identity Applications

Do not use case-sensitive collation for your database. Case-sensitive collation is not supported. The case-sensitive collation might cause duplicate key errors during migration. If a duplicate key error is encountered, check the collation and correct it, then re-install the identity applications. The only supported collation is SQL_Latin1_General_CP1_CI_AS.

Before you migrate Identity Applications, you must install the libssl.so.1.0.0 and libcrypto.so.1.0.0 libraries from the /opt/netiq/common/openssl/lib64/ directory.

The migration of Identity Applications involves the following:

14.7.1 Migrating the Database to the New Server

If your User Application database is on PostgreSQL, perform the following steps:

  1. Log in to the server where PostgreSQL is installed.

  2. Open command prompt, navigate to postgres bin directory and export the data to a .sql file.

    Example: pg_dumpall -U postgres > dump.sql

  3. Log in to the new server where you want to install PostgreSQL.

  4. Install the PostgreSQL as mentioned below:

    1. Download and mount the Identity_Manager_4.8.x_Windows.iso from the Software License and Download portal.

    2. Navigate to the location where you have mounted the Identity_Manager_4.8.x_Windows.iso.

    3. Navigate to: <Mount location>\common\packages\postgres\ directory.

    4. Run the PostgreSQL installer.

  5. Navigate to C:\NetIQ\IDM\postgres and delete the Data directory.

  6. Create a data directory in the PostgreSQL installed location and make sure postgres user has access rights to the directory.

  7. Open command prompt, navigate to postgres bin directory and initialize the database as shown below:

    Example:initdb.exe -D C:\NetIQ\IDM\postgres\data -E WIN1252 -U postgres.

  8. Ensure that the following entries are present in pg_hba.conffile located under C:\NetIQ\IDM\postgres\data.

    # IPv6 local connections:

    host all all ::1/128 trust

    host all all 0.0.0.0/0 trust

  9. Ensure that the following is uncommented in postgresql.conf file:

    listen_addresses = '*'

    port = 5432

  10. Restart postgres services from running services.msc from run.

  11. Open command prompt, navigate to postgres bin directory, and import the data to the new PostgreSQL database, and then use the collected dump as explained in step 2.

    Example: psql -U postgres < dump.sql.

14.7.2 Installing Identity Applications on the New Server

The following procedure explains about installing Identity Application on the New Server:

  1. Download the Identity_Manager_4.8.x_Windows.iso from the NetIQ Downloads Website.

  2. Mount the .iso file.

  3. Navigate to Identity apps directory, install Identity Applications and skip the deployment of User Application, and Roles & Resources Service driver.

    1. Select the Custom Installation mode.

    2. Enter the Identity Vault details.

    3. Uncheck Deploy Identity Applications Driver.

  4. Select Existing PostgreSQL server, provide the required details, and proceed with the installation.