About the accountactions table – Cisco 3.3 User Manual

Page 359

Advertising
background image

9-31

User Guide for Cisco Secure ACS for Windows Server

78-16592-01

Chapter 9 System Configuration: Advanced

RDBMS Synchronization

About the accountActions Table

The accountActions table contains a set of rows that define actions CSDBSync is
to perform in the CiscoSecure user database. Each row in the accountActions
table holds user, user group, or AAA client information. Each row also contains
an action field and several other fields. These fields provide CSDBSync with the
information it needs to update the CiscoSecure user database. For full details of
the accountActions table format and available actions, see

Appendix F, “RDBMS

Synchronization Import Definitions”

.

The database containing the accountActions table must support a multi-threaded
ODBC driver. This is required to prevent problems if Cisco Secure ACS and the
third-party system attempt to access the accountActions table simultaneously.

Cisco Secure ACS includes files to help you create your accountActions table for
several common formats. You can find these files on the Cisco Secure ACS in the
following location, assuming a default installation of Cisco Secure ACS:

C:\Program Files\CiscoSecure ACS v

x

.

x

\CSDBSync\Databases

The Databases directory contains the following subdirectories:

Access—Contains the file

CiscoSecure Transactions.mdb

.

CiscoSecure Transactions.mdb

contains a preconfigured accountActions

table. When you install Cisco Secure ACS, the installation routine creates a
system DSN named CiscoSecure DBSync. This system DSN is configured to
communicate with

CiscoSecure Transactions.mdb

.

Note

By default, the username and password for the

CiscoSecure

Transactions.mdb

database are set to null. To increase the security

of RDBMS synchronizations performed using this database, change
the username and password, both in the

CiscoSecure

Transactions.mdb

database and in Cisco Secure ACS. Any other

processes that access the

CiscoSecure Transactions.mdb

database

should be changed to use the new username and password, too.

CSV—Contains the files

accountactions

and

schema.ini

.

The

accountactions

file is the accountActions table in a comma-separated

value file. The

schema.ini

file provides the Microsoft ODBC text file driver

with the information it needs to access the accountactions file.

Advertising