The Database page allows you to create, edit, and delete 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:
Click New.
Define the database options.
When finished, click OK.
The new database definition now appears in the Database Name list.
To modify an existing database definition:
Select the database you want to modify.
Click Edit.
Modify the database options.
When finished, click OK.
To delete an existing database definition, select the check box 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 Options task's Database list, which means iManager can no longer query the database.
Item |
Description | |
Name |
The name you want to use to refer to this database.
| |
JDBC Class |
Package and name of the Java* class providing JDBC* connectivity. The Java archive file (.jar) containing the JDBC class must be located in the The following examples contain the JDBC class provided by the manufacturer for the most common databases:
| |
JDBC URL |
The 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 Novell® Audit database. The default Novell Audit database name is naudit.
| |
Table |
The name of the table iManager queries. In Novell Audit, table names are defined in MySQL and Oracle Channel objects. The default table name is NAUDITLOG. If you have multiple MySQL or Oracle Channel objects, you must create a separate database definition for each data store.
| |
Username |
The user name iManager uses to authenticate with the database. The default username for the NetWare 6.5 data store is auditusr. (This default can be changed during the installation of Novell Audit.) This account has all privileges to the default database (naudit) and can log in from any IP address. By default, MySQL installs in Secure Mode on NetWare 6.5. In Secure Mode, the default MySQL administrative account, Root, has rights to log in only at the database server. Therefore, if MySQL is running in Secure Mode and you want iManager to use the Root account to log in to the database, MySQL and the iManager Web server must be located on the same server and you must specify a loopback address (127.0.0.1 or localhost) in the Host field.
| |
Password |
The password the logging server uses to authenticate with the database. The default password for the NetWare 6.5 data store is auditpwd. (This default can be changed during the installation of Novell Audit.) IMPORTANT: If you do not specify a different default password during the installation, new databases can be created and accessed using the default username and password. To prevent this, specify a different default password during the install.
| |
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 select the Store Password option, you must enter the password each time you run a query on the current database.
|
A trademark symbol (®, , etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For information on trademarks, see Legal Notices.