Access Manager supports MySQL, Oracle, and Microsoft SQL Server databases for storing risk history. This section provides details about how to configure these databases.
NOTE:Access Manager 4.4 supports MySQL 5.5 and earlier.
IMPORTANT:If you are using SQL database and you are upgrading to Access Manager 4.4, you must run a utility to re-factor the database. This is to ensure that Access Manager and its associated products use the same naming convention. For more information about this utility and how to run it, see Refactoring SQL Database.
Unzip the RiskDBScripts.zip file containing script to extend the database and sample configuration files. The file is located at the following location:
On Linux: /opt/novell/nids/lib/webapp/WEB-INF/RiskDBScripts.zip
On Windows: C:\Program Files\Novell\Tomcat\webapps\nidp\WEB-INF\RiskDBScripts.zip.
On the MySQL server, execute the following command to create database objects for risk-based authentication:
mysql -h host -u username -p password netiq_risk_mssql_install.sql
Download the JDBC connector for the MySQL database from MySQL.com.
Copy the JDBC connector to the /opt/novell/nids/lib/webapp/WEB-INF/lib/ folder.
Restart Identity Server.
Unzip the RiskDBScripts.zip file containing script to extend the database and sample configuration files. The file is located at the following location:
On Linux: /opt/novell/nids/lib/webapp/WEB-INF/RiskDBScripts.zip
On Windows: C:\Program Files\Novell\Tomcat\webapps\nidp\WEB-INF\RiskDBScripts.zip.
On the Oracle server, execute the following script to create database objects for risk-based authentication:
netiq_risk_oracle_install.sql
Download the JDBC connector for the Oracle database from Oracle.com.
Copy the JDBC connector jar to the /opt/novell/nids/lib/webapp/WEB-INF/lib/ folder.
Restart Identity Server.
Unzip the RiskDBScripts.zip file containing script to extend the database and sample configuration files. The file is located at the following location:
On Linux: /opt/novell/nids/lib/webapp/WEB-INF/RiskDBScripts.zip
On Windows: C:\Program Files\Novell\Tomcat\webapps\nidp\WEB-INF\RiskDBScripts.zip.
On the SQL Server, execute the following script to create database objects for risk-based authentication:
netiq_risk_sql_server_install.sql
Download the JDBC connector for the SQL Server database from Microsoft.com.
Copy the JDBC connector file sqljdbc42.jar to the /opt/novell/nids/lib/webapp/WEB-INF/lib/ folder.
Restart Identity Server.