8-39
User Guide for Cisco Secure ACS for Windows Server
78-14696-01, Version 3.1
Chapter 8 Establishing Cisco Secure ACS System Configuration
RDBMS Synchronization
Assuming a default installation, CSDBSync.exe is installed at:
C:\Program Files\CiscoSecure ACS v
x
.
x
\CSDBSync
You can write a script that uses the CSDBsync command. You can schedule times
when the script is run by 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
Preparing for CSV-Based Synchronization, page 8-39
.
Preparing for CSV-Based Synchronization
If 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 v
x
.
x
\CSDBSync\Databases\CSV
Where x.x refers to the version of your Cisco Secure ACS.
Step 2
Edit the Windows Registry:
a.
Access the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Cisco\CiscoAAAv
x
.
x
\CSDBSync
b.
Change the OdbcUpdateTable value from
AccountActions
to
accountactions.csv
.
c.
Save your changes to the registry.