Help banner

Modify Object - MySQL Channel

The MySQL Channel object stores the information the MySQL driver needs to write events to a MySQL database.

IMPORTANT: You must restart the logging server to effect any changes in Channel object configuration. For more information on restarting the logging server, refer to the Novell Nsure Audit Administration Guide.

The following provides a description of each Channel object attribute:

Host

 

 

Address

The IP Address or host name of the database server.

If a host name is specified, only the first address associated with that name is used.

 

 

User

The user account the logging server uses to log in to the database.

NOTE: On NetWare 6.5, MySQL installs in Secure Mode. The default username for the NetWare 6.5 data store is "auditusr." (This default can be changed during the installation of Novell Nsure Audit .) This account has all privileges to the default database (naudit) and can log in from any IP address.

IMPORTANT: In Secure Mode, the default MySQL administrative account, Root, only has rights to log in at the database server. Therefore, if MySQL is running in Secure Mode and you want the logging server to use the Root account to log in to the database, MySQL and the Secure Logging Server must be located on the same server, and you must specify a loopback address ( "127.0.0.1" or "localhost") in the Address field.

 

 

Password

The password the logging server uses to authenticate with the database.

NOTE: The default password for the NetWare 6.5 data store is "auditpwd." (This default can be changed during the installation of Novell Nsure Audit.)

 

Database

 

 

Name

The name of the database to which the logging server writes events. The default database name is "naudit."

The MySQL driver, lgdmsql.*, automatically creates this database when the logging server first loads the current Channel object configuration in memory.

 

 

Table

The database table to which the logging server writes events. The default table is "log."

The MySQL driver, lgdmsql.*, automatically creates this table when the logging server first loads the current Channel object configuration in memory.

For information on the default table structure, see MySQL driver.

 

Advanced

 

 

CREATE TABLE Options

This property allows you to customize the default table structure using standard SQL Create Table commands.

For example, the max_rows and avg_row_length commands can be used to increase the maximum size of your table as follows:

max_rows=200000000 avg_row_length=76

 

 

SQL Expiration Commands

This property enables you to use SQL Expiration commands to automate database maintenance.

For example, you can automate data archiving by configuring the MySQL channel to automatically save out the current table and create a new table at designated intervals.

For a listing of command variables and sample scripts, see “SQL Expiration Command Variables” in the Novell Nsure Audit Administration Guide.

HINT: Use a semi-colon ( ; ) to separate multiple commands that must be executed in sequence. If the commands may be executed in any order, no semi-colon is needed.

 

 

Expire at specified time or interval

The frequency at which the expiration command script is executed.

IMPORTANT: This property should only be defined if the expiration command script does not iterate a start time.

For daily regimens, select a time of day.

For weekly regimens, select a day of the week. The expiration commands are executed at midnight on that day.

If you select Monthly, the expiration commands are executed at midnight on the first day of the month.

 

Status

By default, all Channel objects are enabled. This means that the logging server loads the Channel object’s configuration in memory at startup.

If the Channel object is disabled, the logging server does not load that object’s configuration at startup.

IMPORTANT: The Channel object must be located in a supported Channel container for the logging server to find it. See Creating and Configuring Channel Objects for more information.

 

For more information on the MySQL channel, see MySQL Channel.

For general information on configuring Channel objects, see Creating and Configuring Channel Objects.

For more information on using Nsure Audit, see Nsure Audit Help.

A trademark symbol (®, TM, etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For information on trademarks, see Legal Notices.