CA Strong Authentication UNIX Installation Guide › How to Deploy CA Strong Authentication on Distributed Systems › Post-Installation Tasks on the First System › Create the Database Schema

Create the Database Schema

CA Strong Authentication comes with SQL scripts that create the schema and set initial configuration values in the CA Strong Authentication database.

Follow these steps:

1. Locate the folder with the scripts for your database type. The default location is:

   (For Microsoft SQL Server) <install_location>/arcot/dbscripts/mssql

   (For Oracle Database) <install_location>/arcot/dbscripts/oracle

   (For IBM DB2 UDB) <install_location>/arcot/dbscripts/db2

   (For MySQL) <install_location>/arcot/dbscripts/mysql

2. Run the scripts in the following order by using the database vendor tools:
   1. arcot-db-config-for-common-8.0.sql

      Important! If you have installed CA Risk Authentication 8.0, do not run arcot-db-config-for-common-8.0.sql because you have already run it while installing CA Risk Authentication 8.0.

   2. arcot-db-config-for-webfort-8.0.sql

Note: If you encounter any errors while running the scripts, then check whether you have the required privileges.