Chapter 9 Working with Logging and Reports
Working with ODBC Logs
9-22
User Guide for Cisco Secure ACS for Windows Server
78-14696-01, Version 3.1
Step 5 In the ODBC Connection Settings table, configure Cisco Secure ACS to
communicate with the ODBC database. To do so, follow these steps:
a. From the Data Source list, select the system DSN you created to allow
Cisco Secure ACS to send ODBC logging data to your relational database.
b. In the Username box, type the username of a user account in your relational
database (up to 80 characters).
Note The user must have sufficient privileges in the relational database to
write the ODBC logging data to the appropriate table.
c. In the Password box, type the password (up to 80 characters) for the relational
database user account you specified in Step b.
d. In the Table Name box, type the name (up to 80 characters) of the table to
which you want ODBC logging data appended.
Step 6 Click Submit.
Result: Cisco Secure ACS saves the log configuration.
Step 7 Click the name of the ODBC log you are configuring.
Result: Cisco Secure ACS displays the ODBC log configuration page again.
Step 8 Click Show Create Table.
Result: The right side of the browser displays an SQL create table statement for
Microsoft SQL Server. The table name is the name specified in the Table Name
box. The column names are the attributes specified in the Logged Attributes list.
Note The generated SQL is valid for Microsoft SQL Server only. If you are
using another relational database, refer to your relational database
documentation for information about writing a command to create a table.
Step 9 Using the information provided in the generated SQL, create a table in your
relational database for this ODBC log.
Note For ODBC logging to work, the table name and the column names must
match exactly the names in the generated SQL.
To Next Page
Loading...
Need help?
General