To install Identity Manager Home, you must modify the existing User Application database schema. To update the PostgreSQL database schema, we recommend you start your JBoss application server, which automatically updates the schema.
NOTE:
You can also update the PostgreSQL schema manually using a SQL script. However, you should only use the SQL script to update the schema if your organization requires users make all database updates using scripts or if the User Application tables were originally created or updated using the SQL script option during the Identity Manager Roles Based Provisioning Module 4.0.2 installation process. For information about updating the PostgreSQL schema using a SQL script, see Using a SQL Script to Update the PostgreSQL Schema.
If you use a database other than PostgreSQL, see Configuring Non-PostgreSQL User Application Databases.
To update the PostgreSQL database schema by starting your JBoss application server, complete the following steps:
Navigate to the User Application deploy directory within the JBoss installation. For example: /opt/novell/idm/jboss/server/IDMProv/deploy
In the deploy directory, use a text editor to open the IDMProv-ds.xml file.
In the <connection-url> element, append ?compatible=true to the existing text. For example:
<connection-url>jdbc:postgresql://localhost:5432/idmuserappdb?compatible=true</connection-url>
Save and close the IDMProv-ds.xml file.
In a command prompt, enter the following command:
/etc/init.d/jboss_init start
Use the JBoss log to verify that the server started completely and address any issues or errors.
NOTE:JBoss may log an error regarding the OSP keystore. This error occurs because you have not yet configured SSO in your Identity Manager Home environment. You can ignore the error.