Help banner

MySQL Channel

The MySQL channel allows the logging server to log events to a MySQL database. The logging server can use the MySQL channel to create the central data store or a filtered database.

For further information, see Appendix B, “Using MySQL with Nsure Audit,” in the Novell Nsure Audit Administration Guide.

MySQL Channel Driver

When the MySQL Channel object configuration is loaded in the logging server’s memory, the MySQL channel driver, lgdmsql.*, automatically creates the following table structure for the MySQL data store:

SourceIP INT UNSIGNED, ClientTimestamp INT UNSIGNED, ServerTimestamp INT UNSIGNED, Component VARCHAR(255), EventID INT UNSIGNED, Severity SMALLINT UNSIGNED, Grouping INT UNSIGNED, Text1 VARCHAR(255), Text2 VARCHAR(255), Value1 BIGINT UNSIGNED, Value2 BIGINT UNSIGNED, MIMEType SMALLINT UNSIGNED, DataSize INTEGER UNSIGNED, Data MEDIUMBLOB, INDEX(ClientTimestamp), INDEX(EventID)

The default number of rows depends on the operating system. The default maximum size for a MySQL table is 4 GB (or 2 GB if your operating system only supports 2 GB tables). This default size limitation keeps pointer sizes down, making the index smaller and faster.

NOTE: If you need larger tables, use the max_rows and avg_row_length commands in the MySQL Channel object’s Create Table Options property.

For information on configuring a MySQL Channel object, see MySQL Channel Configuration.

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.