Filter
Top Products
15-19
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 15 Managing System Operations and Configuration in the Monitoring and Report Viewer
Configuring Remote Database Settings
Note ACS does not support remote database with cluster setup.
To configure a remote database:
Step 1 From the Monitoring and Report Viewer, choose Monitoring Configuration > System Configuration
> Remote Database Settings.
The Remote Database Settings Page appears as described in Table 15-12.
Step 2 Click Submit to configure the remote database.
Note Special characters are not supported in remote database names.
Table 15-12 Remote Database Settings Page
Option Description
Publish to Remote Database Check the check box for ACS to export data to the remote database periodically. By
default, ACS exports data to the remote database every 4 hours.
Server Enter the IP address of the remote database.
Port Enter the port number of the remote database. The default port for Microsoft
database is 1433 and the default port for Oracle database is 1521. To change the port
number for Oracle database, see Changing the Port Numbers for Oracle Database,
page 15-20.
Username Enter the username for remote database access.
Password Enter the password for remote database access.
Export Every Minutes Choose a time interval from the drop-down list box for ACS to use to export data.
Valid options are 20 and 40 minutes. The default interval is 20 minutes.
Note If you choose the time interval as 40 minutes, ACS starts the remote database
export operation immediately for the first time and it continues to do the
operation every 40 minutes from then.
Export Every Hours Choose a time interval from the drop-down list box for ACS to use to export data.
Valid options are 1, 2, 4, 6, 8, 12, and 24 hours. The default interval is 4 hours.
Database Type The type of remote database that you want to configure:
• Click Microsoft Database radio button to configure a Microsoft database, and
enter the name of the remote database.
• Click Oracle SID radio button to configure an Oracle database, and enter the
system identifier for the Oracle database.
Download Remote Database schema
files
Click this link to download the remote database schema files. The following two
schema files are downloaded:
• acsview_microsoft_schema.sql
• acsview_oracle_schema.sql