Database Installation

Prerequisites: Before configuring the automatic certificate renewal:

  • The ActivID CMS database must have been upgraded with a new table and SQL stored procedures.

  • Make sure the SQL scripts are located in the Tools\Automatic_Cert_Renewal\SQL folder of the ActivID CMS distribution. For details, see PKI Renewal Software Configuration.

  • Check that the PKI_CREDENTIAL_DETAILS_PCD table is created in the AIMSEE database.

  • Be sure to use the Java™ version delivered with ActivID CMS in C:\Program Files\HID Global\Credential Management System\jvm; otherwise, you need to install either Java Runtime Environment (JRE) version 11 or 17.

Note: Check.bat does not work until setenv.bat is modified as follows:

  1. Make sure that the SET APP_CLASSPATH entry points to the Oracle binary:

    Copy 
    SET APP_CLASSPATH=%APP_CLASSPATH%;C:\app\administrator\product\12.1.0\client_1\jdbc\lib\ojdbc7.jar

  2. Modify the SET PATH entry so that it points to either the Oracle client or database server as applicable:

    Copy 
    SET PATH=%PATH%;C:\app\DBA\product\12.1.0\client_1\BIN\;C:\app\DBA\product\12.1.0\dbhome_1\BIN

  3. Launch the Oracle SQL*Plus client and log in to the Oracle database using the AIMSEE user account.

    Note: Before executing the following scripts, make sure that the AIMSEE user account has the “CREATE ANY PROCEDURE” privilege.

  4. Execute the CERTIFICATE_RENEWAL.pks and CERTIFICATE_RENEWAL.pkb script files located in the Tools\Automatic_Cert_Renewal\sql\oracle folder in order to create the PL/SQL stored procedures.

Note: Before executing the following scripts:

  • Using the “sa” user account, make sure that the AIMSEE user account has permission to create stored procedures on the AIMSEE database.

  • Make sure the SQL Server script files are located in the Tools\Automatic_Cert_Renewal\sql\sqlserver folder.

  1. Launch the SQL Query Analyzer or SQL Server Management studio and log on to the SQL Server database using the AIMSEE user account.

  2. Execute the three SQL scripts (GET_EXP_CERTS.sql, GET_EXP_CERTS_NO_PENDING.sql, and GET_EXP_CERTS_PENDING.sql) located in the Tools\Automatic_Cert_Renewal\sql\sqlserver folder in order to create the SQL stored procedures.

    Note: The three SQL scripts (GET_EXP_CERTS.sql, GET_EXP_CERTS_NO_PENDING.sql, and GET_EXP_CERTS_PENDING.sql) do not usually need to be executed in the case of an upgrade unless they have been modified.