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.
When the MySQL Channel object configuration is loaded in the logging servers 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 objects 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.