5.10 Creating the Schema for Each Database

If you choose to manually create the database or use the SQL scripts to allow your database administrator to create the database, you must manually add the schema to each Identity Governance database. If you allow the Identity Governance installer to create the databases, you can skip this section.

You can add the schema before the Identity Governance installation starts or after the installation completes. Perform the following steps to add the schema before the installation.

To create the schema for your specific database type:

  1. Initialize or reset the database with the following Liquibase commands:

    • Linux: Default location in /opt/netiq/idm/apps/idgov/bin

      ./db-init.sh -password database-password

    • Windows: Default location in c:\netiq\idm\apps\idgov\bin

      db-init.bat -password database-password

  2. Import or re-import the global configuration for Identity Governance to the database:

    • PostgreSQL: Use the following command:

      "/opt/netiq/idm/apps/jre/bin/java" -Djava.util.logging.config.file="/opt/netiq/idm/apps/idgov/conf/logging.properties" -Djava.security.egd=file:///dev/urandom -Dcom.netiq.ism.config="/opt/netiq/idm/apps/idgov/conf/unused.props" -classpath "/opt/netiq/idm/apps/idgov/lib/ig-configutil.jar":"/opt/netiq/idm/apps/idgov/lib/postgresql-42.2.6.0.jar" com.netiq.iac.config.util.IacConfigUtil -dbDriver org.postgresql.Driver -dbUser igops -dbPassword password -dbUrl "jdbc:postgresql://postgresql-server:port/igops" -keystore "/opt/netiq/idm/apps/tomcat/conf/encrypt-keys.pkcs12" -storepass encryption-keystore-password -script "/opt/netiq/idm/apps/idgov/scripts/all-import-configs.script"

    • Oracle: Use the following command:

      "/opt/netiq/idm/apps/jre/bin/java" -Djava.util.logging.config.file="/opt/netiq/idm/apps/idgov/conf/logging.properties" -Djava.security.egd=file:///dev/urandom -Dcom.netiq.ism.config="/opt/netiq/idm/apps/idgov/conf/unused.props" -classpath "/opt/netiq/idm/apps/idgov/lib/ig-configutil.jar":"/opt/netiq/idm/apps/idgov/lib/ojdbc.jar" com.netiq.iac.config.util.IacConfigUtil -dbDriver oracle.jdbc.OracleDriver -dbUser igops-user -dbPassword password -dbUrl "jdbc:oracle:thin:@oracle-server:port/sid" -keystore "/opt/netiq/idm/apps/tomcat/conf/encrypt-keys.pkcs12" -storepass encryption-keystore-password -script "/opt/netiq/idm/apps/idgov/scripts/all-import-configs.script"

    • Microsoft SQL: Use the following command:

      "/opt/netiq/idm/apps/jre/bin/java" -Djava.util.logging.config.file="/opt/netiq/idm/apps/idgov/conf/logging.properties"  -Dcom.netiq.ism.config="/opt/netiq/idm/apps/idgov/conf/unused.props" -classpath "/opt/netiq/idm/apps/idgov/lib/ig-configutil.jar":"/opt/netiq/idm/apps/idgov/lib/msjdbc.jar" com.netiq.iac.config.util.IacConfigUtil -dbDriver com.microsoft.sqlserver.jdbc.SQLServerDriver -dbUser igops -dbPassword igops-password -dbUrl "jdbc:sqlserver://server:port;databaseName=igops" -keystore "/opt/netiq/idm/apps/tomcat/conf/encrypt-keys.pkcs12" -storepass encryption-keystore-password -script "/opt/netiq/idm/apps/idgov/scripts/all-import-configs.script"

    NOTE:The commands in these examples contain the default installation path of /opt/netiq/idm/apps.