5.10 Creating the Schema for the Databases

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 the 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.jar" com.netiq.iac.config.util.IacConfigUtil -dbDriver org.postgresql.Driver -dbUser %igops-user% -dbPassword %password% -dbUrl "jdbc:postgresql://%postgresql-server%:%port%/%igops-db%" -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%" -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" -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.