F.1 Configuration Requirements
The configuration requirements to use the JDBC channel with
a JDBC-enabled data store are as follows:
- For performance reasons, we recommend
using only the channels discussed in Data Store as the primary log channel, and
use JDBC data stores for notifications.
- Install and configure any JDBC-enabled data store
according to the instructions provided by the vendor.
- In the JDBC-enabled data store, create a Nsure Audit
database and a database user.
- The server hosting your JDBC data store must have
JVM* 1.4.1 or later.
- Obtain the JDBC drivers for your data store.
The JDBC drivers are available at the following sites:
Table F-1 JDBC Driver Sites
|
MySQL |
MySQL Connector/J |
http://dev.mysql.com/downloads/ |
|
Oracle |
Oracle Instant Client |
http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html |
|
Microsoft SQL Server |
Microsoft SQL Server Driver for JDBC |
http://www.microsoft.com/downloads/ |
|
QL Server and Sybase JDBC driver |
jTDS (S) |
http://www.sourceforge.net/ |
- Copy the JDBC drivers for your data store to the
Nsure Audit Java classpath or a subdirectory thereof.
Nsure Audit defines its Java classpath as follows:
Table F-2 Nsure Audit Java Classpath
|
Windows
Linux
Solaris |
Novell_Audit_install_directory\java\logdriver\
|
|
NetWare |
Novell_Audit_install_directory\
|
- If you are going to query a JDBC data store in iManager,
copy all required JDBC drivers (*.jar)
to the following iManager classpaths on your iManager server:
- If you are using the JDBC Channel on a Windows machine,
add the jvm.dll directory path to the Path
system variable. For example, c:\j2sdk1.4.2_09\jre\bin\server\.
You must reboot the machine for the changes to take effect.
- On Linux/Solaris, the LD_LIBRARY_PATH
variable must point to the paths for libverify.so,
and libjvm.so. You must reboot the machine
for the changes to take effect.
- On Linux and Solaris platforms, export LD_LIBRARY_PATH
to the path of the server JVM. To do this, create /etc/profile.local (if
it does not exist), then add an export line similar to the following:
export LD_LIBRARY_PATH=/usr/lib/java/jre/lib/i386/server:/usr/lib/java/jre/lib/i386/
Replace /usr/lib/java with
the full path to the Java runtime environment, for example,
/usr/lib/SunJava2-1.4.1.
- When creating the JDBC channel object in iManager,
Java classpath entries must be separated by a colon if your JDBC
data store is hosted on Linux or Solaris. If your JDBC data store
is hosted on NetWare or Windows, Java classpath entries must be
separated by a semicolon.