Database Installation
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)
For JRE 8, make sure you also have version 8 of the Java Cryptography Extension (JCE) installed (for details, see Installing the JCE Unlimited Strength Jurisdiction Policy Files),
Note: Some versions of JRE 8 may already include JCE 8.
For JRE 11, make sure you have version 2.3.2 or higher of the Java API In the context of ActivID CMS, an Application Programming Interface (API) is an external interface (for example, the CCM API) that makes it possible for applications not supported by HID Global to incorporate ActivID functionality. for XML Web Services (JAX-WS) Reference Implementation (RI) installed (see JAX WS RI Standalone Zipped Bundle Repository; click on the desired version, then click View All in the Files row).
Note: To install the JAX-WS RI, download the desired version and then take all the .jar files from the \lib folder in the archive and place them in the SDK\API\CCM\Java\lib directory.
Oracle® Database
-
Make sure that the SET APP_CLASSPATH entry points to the Oracle binary:
CopySET APP_CLASSPATH=%APP_CLASSPATH%;C:\app\administrator\product\12.1.0\client_1\jdbc\lib\ojdbc7.jar -
Modify the SET PATH entry so that it points to either the Oracle client or database server as applicable:
CopySET PATH=%PATH%;C:\app\DBA\product\12.1.0\client_1\BIN\;C:\app\DBA\product\12.1.0\dbhome_1\BIN -
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. -
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.
Microsoft® SQL Server
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.
-
Launch the SQL Query Analyzer or SQL Server Management studio and log on to the SQL Server database using the AIMSEE user account.
-
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.
