Help banner

Modify Object - JDBC Channel

The JDBC* Channel object stores the information the JDBC driver needs to make a connection to a data store using JDBC.

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® Audit Administration Guide.

The following provides a description of each Channel object attribute:

Item

Description

Configuration

 

 

JDBC Class

Package and name of the Java* Class providing JDBC connectivity.

The Java archive file (.jar) containing this JDBC class must be located in the iManager class path. On NetWareŽ, this is sys:\tomcat\4\common\lib. On Linux*, it is /var/opt/novell/tomcat4/common/lib.

The following examples contain the JDBC class provided by the manufacturer for the most common databases:

  • MySQL*: com.mysql.jdbc.Driver

    The MySQL JDBC jar file can be downloaded from http://dev.mysql.com/downloads/. Search for the "MySQL Connector/J" file.

    The Java archive file (i.e., mysql-connector-java-3.1.10-bin.jar) containing this JDBC class must be manually copied to the iManager class path. Failure to manually copy this file will result in the error "Could not find the Driver Class: com.mysql.jdbc.Driver" when attempting to run a built-in query.

  • Oracle*: oracle.jdbc.driver.OracleDriver

    The Oracle JDBC jar file can be downloaded from Oracle (http://otn.oracle.com/ software/tech/java/sqlj_jdbc/index.html). This file must be in the classpath of your iManager server.

  • SQL Server: com.microsoft.jdbc.sqlserver.SQLServerDriver

    The SQL Server JDBC jar file can be downloaded from the Microsoft Download Center (http://www.microsoft.com/ downloads/search.asp). This file must be in the classpath of your iManager server.

     

 

JDBC URL

Valid JDBC URL for the target data store, including the table name.

For example:

  • MySQL: jdbc:mysql://192.168.0.5/naudit

  • Oracle: jdbc:oracle:thin:@<ip_address>:<port>:<sid>

  • SQL Server: jdbc:microsoft:sqlserver://<ip_address>:<port>; DatabaseName= <database_name>

 

 

Username

The username the JDBC driver requires to log in to the data store.

 

 

Password

The password the JDBC driver requires to log in to the data store.

 

 

JDBC Table

Name of the table used to log Novell Audit events.

 

 

JDBC Table Create SQL

If the table specified in the JDBC Table parameter does not exist, enter SQL commands to create the table.

 

 

Max Data Size

The maximum size (in bytes) of information that can be written at one time to the data store.

 

Status

By default, all Channel objects are enabled. This means that the logging server loads the Channel object's configuration in memory 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.

If you select the Disabled option, you must restart the Secure Logging Server for the setting to become effective. Thereafter, the logging server cannot load the object's configuration until you select Enabled.

 

Related Topics

JDBC Channel

Creating and Configuring Channel Objects

Novell Audit Help

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

Close