Help banner

Query Configuration - Databases

The Database screen allows you to create, edit, and delete database definitions.

Creating Database Definitions

Before you can query a database, iManager needs to know where to find the data store and how to communicate with the database. This information is stored in the database definition. Every database you want to query must have its own database definition in iManager.

IMPORTANT: The database definitions you create are stored in the User object you use to log in to iManager. Therefore, they are not available to other users on the system.

To create a database definition,

  1. Click New.

  2. Define the database options. For information on these options, see the following table.

  3. When finished, click OK.

The new database definition now appears in the Database Name list.

Table Option

Description

Name

The name you want to use to refer to this database.

This name appears in the Database Name list.

 

JDBC URL

JDBC URL that iManager uses to communicate with the MySQL database. This URL should contain a port if using a non-standard port, and the database name.

The following are JDBC URL examples for the most common databases using the default port. This database name must be replaced with the name of your Nsure Audit database. The default Nsure Audit database name is naudit.

MySQL jdbc:mysql://ip_address:port/database_name

Oracle jdbc:oracle:thin:@ip_address:port:sid

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

Table

The name of the table iManager queries.

In Nsure Audit, table names are defined in MySQL Channel objects. The default table name is “log.”

NOTE: If you have multiple MySQL Channel objects, you must create a separate database definition for each MySQL data store.

 

Username

The user name iManager uses to authenticate with the database.

NOTE: By default, MySQL installs in Secure Mode on NetWare 6.5. 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.)

 

Store Password

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

This enables iManager to automatically log in to the database. If you do not mark the Store Password option, you have to enter the password each time you run a query on the current database.

 

Editing Database Definitions

To modify an existing database definition,

  1. Mark the database you want to modify.

  2. Click Edit.

  3. Modify the database options. For information on these options, see the above table.

  4. When finished, click OK.

 

Deleting Database Definitions

To delete an existing database definition, mark the checkbox next to the database name and click Delete. The database definition is removed from the Database Name list.

NOTE: Deleting a database definition does not affect the actual database. It only removes the database from the Query Configuration task’s Database list, which means iManager can no longer query the database.

For more information on queries, see Creating, Editing and Deleting Queries, Running Queries, or Exporting Query Results.

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.