Enterasys Security Information and Event Manager, Configuration Manual

Page: 337 / 426

Configuring DSMs
Sophos PureMessage 321
Port Type the port number used by the database server. The default
port is 1532.
The JDBC configuration port must match the listener port of the
Sophos database. The Sophos database must have incoming TCP
connections enabled to communicate with SIEM.
Username Type the username required to access the database.
Password Type the password required to access the database. The
password can be up to 255 characters in length.
Confirm
Password Confirm the password required to access the database. The
confirmation password must be identical to the password entered
in the Password parameter.
Database
Instance Optional. Type the database instance, if you have multiple SQL
server instances on your database server.
Note: If you use a non-standard port in your database
configuration, or have blocked access to port 1434 for SQL
database resolution, you must leave the Database Instance
parameter blank in your SIEM configuration.
Table Name Type
siem_view
as the name of the table or view that includes
the event records.
Select List Type
*
for all fields from the table or view.
You may use a comma-separated list to define specific fields from
tables or views, if required for your configuration. The list must
contain the field defined in the Compare Field parameter. The
comma-separated list can be up to 255 alphanumeric characters in
length. Also, the list may include the following special characters:
dollar sign ($), number sign (#), underscore (_), en dash (-), and
period(.).
Compare Field Type ID .
The Compare Field parameter is used to identify new events
added between queries to the table.
Use Prepared
Statements Select the check box to use prepared statements.
Prepared statements allows the JDBC protocol source to set up
the SQL statement once, and then execute the SQL statement
many times with different parameters. For security and
performance reasons, we recommend that you use prepared
statements.
Clearing this check box requires you to use an alternative method
of querying that does not use pre-compiled statements.
Start Date and
Time Optional. Type the start date and time for database polling.
The Start Date and Time parameter must be formatted as
yyyy-MM-dd HH:mm with HH specified using a 24-hour clock. If
the Start Date and Time parameter is clear, polling begins
immediately and repeats at the specified polling interval.
Table 61-2 Sophos PureMessage JDBC Parameters (continued)
Parameter Description