8-31
Cisco Secure ACS 3.0 for Windows 2000/NT Servers User Guide
78-13751-01, Version 3.0
Chapter8 Establishing Cisco Secure ACS System Configuration RDBMS Synchronization
The solution is to initiate synchronization events from a script, such as a DOS
batch file. In the script, RDBMS synchronization is initiated with the CSDBSync
-run command.
Assuming a default installation, CSDBSync.exe is installed at:
C:\Program Files\CiscoSecure ACS vx.x\CSDBSync
After you have written a script that uses the CSDBsync command, you can
schedule synchronization events using the Windows at command. For
information about the at command, please refer to your Microsoft Windows
documentation.
Also, due to limitations of the Microsoft ODBC text file driver, using the CSV
format requires a change to the accountactions CSV file shipped with
Cisco Secure ACS and to Cisco Secure ACS configuration. For more
information, see the “Preparing for CSV-Based Synchronization” section on
page 8-31.
Preparing for CSV-Based SynchronizationIf you want to use a CSV file for your accountActions table, some additional
configuration is necessary. This is because the Microsoft ODBC CSV driver
cannot access the accountActions table unless the file has a .csv file extension.
To prepare for RDBMS synchronization using a CSV file, follow these steps:
Step 1 Rename the accountactions CSV file installed on your Cisco Secure ACS server
to accountactions.csv.
Assuming a default installation of Cisco Secure ACS, the accountactions file is at
the following location:
C:\Program Files\CiscoSecure ACS vx.x\CSDBSync\Databases\CSV
Step 2 Edit the Windows registry:
a. Access the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Cisco\CiscoAAAvx.x\CSDBSync
b. Edit the OdbcUpdateTable value from AccountActions to
accountactions.csv.
c. Save your changes to the registry.