Setting Up the MySQL Channel for Novell Audit
Novell Cool Solutions: Tip
Digg 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.
- Go to the Logging Services Container and create a new object.
- For object type, select Novell Audit MySQL Channel.
- 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.
- In the Host Section, fill in the following values: Host - IP address of the MYSQL server, OR localhost is the MySQL database is running on the same server as the SLS
- In the Database section, provide the following values: Name - the name of the database created to store Novell Audit records (example naudit)
- For Advanced Options refer to the Novell Audit Documentation.
- 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.
User - username supplied during the account configuration (see TID 10088985 for MySQL server configuration instructions)
Password - the password created during the user account creation.
Table - any value (most configurations will use the name 'log').
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.
- In iManager, expand the Novell Audit task and select Server Configuration.
- Click the Channels tab.
- Check the box next to the Channels container, and then click New. Create a channel of type MySQL (use any name).
- On the Channels Container screen, check the box next to the MySQL channel under the Channels container, and then click Edit.
- 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.
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:
- Check the Logger Screen on the Netware Server for error messages.
- 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@'%'.
- Make sure the case matches for the username and password.
- 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