Cisco Cisco Firepower Management Center 2000 Guía Del Desarrollador
2-10
FireSIGHT System Database Access Guide
Chapter 2 Setting Up Database Access
Querying the Database
To run the application in a Unix environment:
Step 1
Use the following command:
export CLASSPATH=$CLASSPATH:.:path/lib/vjdbc.jar:path/lib/commons-logging-1.1.jar
where
path
is the directory path where you unpacked the ZIP package downloaded from the Defense
Center.
To run the application in a Windows 7 environment:
Step 1
Right-click the Computer icon and select Properties.
The
System
window appears.
Step 2
Click Advanced System Settings.
The System Properties window appears.
Step 3
Select the Advanced tab.
Step 4
Click Environment Variables....
The Environment Variables window appears.
Step 5
Select the CLASSPATH system variable and click
Edit...
.
The Edit System Variable window appears.
Step 6
Add the following to the Variable value: field:
.;path\bin;.;path\lib\vjdbc.jar;.;path\lib\commons-logging-1.1.jar;.;path\lib
where
path
is the directory path where you unpacked the ZIP package downloaded from the Defense
Center.
Step 7
Click OK to save the value.
The Environment Variables window appears.
Step 8
Click OK to save the value. You can now run the application.
Querying the Database
The following sections contain information on supported query syntax and other important query-related
requirements and limitations:
requirements and limitations:
•
describes the supported MySQL
SHOW
statement
syntax for querying the Cisco database.
•
describes the supported MySQL
DESCRIBE
statement syntax for querying the Cisco database.
•
describes the supported MySQL
SELECT
statement
syntax for querying the Cisco database.
•
describes the joins supported for querying the Cisco database and
explains how to get information on the specific allowed joins for any table.