Cisco Systems Servers Working with ODBC Logs

9-25

Cisco Secure ACS 3.0 for Windows 2000/NT Servers User Guide

78-13751-01, Version 3.0

Chapter9 Working with Logging and Reports Working with ODBC Logs

Working with ODBC Logs

This section contains procedures for the following topics:

•Preparing to Use ODBC Logging, page 9-25

•Configuring a System Data Source Name for ODBC Logging, page 9-26

•Configuring a CSV Log, page 9-22

If you plan to use ODBC logging, there are several steps you must complete

before you configure an ODBC log.

To prepare to use ODBC logging, follow these steps:

Step 1 Set up the relational database to which you want to export logging data. For more

information, refer to your relational database documentation.

Step 2 Set up a system data source name (DSN) on the Cisco Secure ACS server. For

instructions, see the “Configuring a System Data Source Name for ODBC

Logging” section on page 9-26.

Step 3 Enable ODBC logging in the Cisco Secure ACS HTML interface:

a. In the navigation bar, click Interface Configuration.

b. Click Advanced Options.

c. Select the ODBC Logging check box.

d. Click Submit.

Result: Cisco Secure ACS enables the ODBC logging feature. On the

Logging page, in the System Configuration section, Cisco Secure ACS

displays links for configuring ODBC logs.

Result: You can now configure individual ODBC logs. For instructions, see the

“Configuring an ODBC Log” section on page 9-27.