Novell Home

Setting Up the MySQL Channel for Novell Audit

Novell Cool Solutions: Tip

Digg This - Slashdot This

Posted: 22 Nov 2004
 

Setting up the Novell Audit MySQL Channel is a key part of Novell Audit installation. These steps will help you get the job done, whether from WebAdmin or from iManager. See also TID 10091164.

WebAdmin Process

  1. Go to the Logging Services Container and create a new object.
  2. For object type, select Novell Audit MySQL Channel.
  3. When prompted for the name, provide the name, and continue. When the object details screen appears, the configuration should be displayed, all values will be blank.
  4. In the Host Section, fill in the following values:
  5. Host - IP address of the MYSQL server, OR localhost is the MySQL database is running on the same server as the SLS
    User - username supplied during the account configuration (see TID 10088985 for MySQL server configuration instructions)
    Password - the password created during the user account creation.
  6. In the Database section, provide the following values:
  7. Name - the name of the database created to store Novell Audit records (example naudit)
    Table - any value (most configurations will use the name 'log').
  8. For Advanced Options refer to the Novell Audit Documentation.
  9. To use the MySQL channel as the primary log channel for the Secure Logging Server, make this change on the SERVERNAME Logging Server object in the Logging Services container.

The Log Channel needs to point to the MySQL channel, and not the file channel. Without specifying the MySQL channel as the log channel on the SLS, or creating a Notification object to send data to the MySQL channel, the MySQL channel will not receive any information.

iManager Process

  1. In iManager, expand the Novell Audit task and select Server Configuration.
  2. Click the Channels tab.
  3. Check the box next to the Channels container, and then click New. Create a channel of type MySQL (use any name).
  4. On the Channels Container screen, check the box next to the MySQL channel under the Channels container, and then click Edit.
  5. When the edit MySQL channel screen appears, fill in the following information. ALL FIELDS ARE CASE SENSITIVE!
    • Host: IP address of the server running MySQL. If MySQL is installed on the same server as the logging server, and the account created to access the Novell Audit databse is auditusr@'%', then this should be the logging servers IP address.
    • User: auditusr
    • Password: Password for auditusr@'%'
    • Database: naudit
    • Table: log
    • Advanced Create Table Options: Blank
    • SQL Expiration Commands (see section below)
    • Expire time or interval: Mondays. This means that the expiration script will run at every Monday at Midnight.
  6. Click apply, then close.
  7. Click on the General Tab (general tab of Logging Server object)
  8. In the Log Channel Field, use the magnifying glass to browse for the MySQL channel that was just created (example, mysql.Channels.Logging Services) - This tells the logging server to send all data to the MySQL channel.
  9. Click Apply to save the changes.

Using SQL Expiration Commands

Create the following script:

create table newtable ($T) $e;RENAME TABLE $l TO l$n, newtable TO $l

This script does the following things:

  • "create table" - Creates a new table using the CREATE TABLE Options.
  • Renames the current table so it includes the date and time in decimal.
  • Renames the new table with the default table name.

Testing the Configuration

To test your configuration, load lengine -d from the server console. If the Novell Audit 1.0.1 console loads, then everything is configured correctly. If it does not load, follow these troubleshooting steps:

  1. Check the Logger Screen on the Netware Server for error messages.
  2. Double-check your accounts created for MySQL: was the user created auditusr@'%' or was it auditusr@localhost? If you created auditusr@localhost but not auditusr@'%', then it is necessary to change the address on the MySQL channel to be 127.0.0.1. Based on the experiences from Technical Support, it is best to use auditusr@'%'.
  3. Make sure the case matches for the username and password.
  4. Verify that MySQL is loaded.

If everything is configured correctly, continue the installation process.


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell