CA AuthMinder UNIX Installation Guide › Upgrading to Release 7.1 › Upgrading to 7.1 › Migrating the Database to Release 6.0 for Arcot Common Components

Migrating the Database to Release 6.0 for Arcot Common Components

Note: Perform the procedure that is described in this section only if you are upgrading from 5.3.x or 5.4.x. If you are upgrading from 6.x or 7.0, you need not migrate the database to 6.0 for Arcot common components.

Important! If you have installed CA RiskMinder with CA AuthMinder and you have completed the RiskMinder upgrade, then do not migrate the database for Arcot common components because this step has already been performed during the RiskMinder upgrade.

Migrate the database for the Arcot common components that are used in release 6.0.

Follow these steps:

1. Copy the upgrade directory to a temporary location on the system where you plan to upgrade.

   This folder contains the following zip files that are applicable for this migration path:

   • arcot-common-upgrade-0.x-1.0.zip
   • arcot-webfort-upgrade-5.x-6.0.zip
2. Copy the arcot-common-upgrade-0.x-1.0.zip file to the $ARCOT_HOME directory:
3. Extract the contents of the arcot-common-upgrade-0.x-1.0.zip file in this directory.
4. Navigate to the following directory:

   $ARCOT_HOME/dbscripts/<db_type>/
   

5. Run the arcot-db-config-for-common-1.0.sql script.

   Note: For Microsoft SQL server, if you run the database script from the command line using SQLCMD, then specify the -I option to set the QUOTED_IDENTIFER connection option to ON.

6. Navigate to the following directory:

   $ARCOT_HOME/dbscripts/<db_type>/upgrade-scripts/
   

7. Run the arcot-upgrade-for-common-1.0.sql script.

   Note: For Microsoft SQL server, if you run the database script from the command line using SQLCMD, then specify the -I option to set the QUOTED_IDENTIFER connection option to ON and the -x option to disable variable substitution.

8. Copy the JDBC JAR that is compatible with the database that you are using to the following directory:

   $ARCOT_HOME/java/lib
   

9. Copy the libArcotAccessKeyProvider.so file to <JAVA_HOME used by App Server>/jre/bin. In AuthMinder release 6.x, the libArcotAccessKeyProvider.so file is available in java/ext/<platform name>/<32bit or 64 bit>.
10. Copy the $ARCOT_HOME/java/lib/arcot-crypto-util.jar file

    to

    JAVA_HOME-used-by-App-Server/jre/lib/ext
    

11. Set and export the LD_LIBRARY_PATH to the directory where libArcotAccessKeyProvider.so is copied.
12. Change your working directory to:

    $ARCOT_HOME/tools/upgrade
    

13. Ensure that you have the permission to run the upgrade-common.sh upgrade tool.
14. Run the upgrade tool by entering the following command at the prompt:

    upgrade-common.sh
    

15. Check the log file $ARCOT_HOME/logs/upgrade-common.log to ensure that the common database migration was successful.

    Important! While migrating the database, if you encounter errors due to a step that you have performed incorrectly, restore the database backup that you created earlier. After you verify that the database is correctly restored, retry the database migration procedure.