Novell Home

My Favorites

Close

Please to see your favorites.

How to configure MySQL 4.0 on NetWare 6 for use with Nsure Audit 1.0.x

(Last modified: 06Sep2005)

This document (10088726) is provided subject to the disclaimer at the end of this document.

goal

How to configure MySQL 4.0 on NetWare 6 for use with Nsure Audit 1.0.x

fact

Novell Nsure Audit 1.0

Novell Nsure Audit 1.0.1

MySQL 4.0

fix

This document assumes that MySQL 4.0 is not yet installed on NetWare 6. NetWare 6 must be upgraded to Support Pack 3 in order to proceed. If MySQL is already installed on NetWare 6, skip to step  11.

  1. Download MySQL 4.0 from http://www.mysql.com/downloads/mysql-4.0.html
  2. Extract the contents of the zip file to a temporary directory. Contained in the archive is a folder name MySQL-4.0.16-pc-Netware-i686 (the version number may be different). Rename this folder to MySQL, and copy the folder and its contents to the volume where the Nsure Audit database information is to be kept. (SYS is NOT recommended). In the example used in these instructions, DATA will be the volume used to store the MySQL database.
  3. Add a search path to MySQL\bin on the volume where MySQL is located. Type the following command at the command line, and add the command to the AUTOEXEC.NCF. MySQL MUST be loaded prior to loading the Secure Logging Server commands (AUDITSVR.NCF, or LENGINE.NLM)

    SEARCH ADD DATA:\MYSQL\BIN
  4. To create the initial MySQL database that is required for all administrative purposes, issue the following command at the command prompt:

    mysql_install_db
  5. Start the MySQL daemon using the following command, and add this command to AUTOEXEC.NCF prior to the Secure Logging Server startup commands:

    mysqld_safe
  6. In order to administer users that are able to access the databases on the server, it is necessary to create a root user. Issue the following command at the server command prompt to create the initial root user. The word novell enclosed in single quotes should be replaced with the appropriate password for the root user.

    mysqladmin -u root password 'novell'

    The above command creates a user named root with the password novell that is allowed to login from 'localhost' or the server console.
  7. The remainder of the configuration takes place from MySQL monitor. To load MySQL monitor type:

    mysql -u root -p

    When prompted for the password type the password specified in step 6.
  8. From the mysql> prompt type \u mysql to instruct the MySQL monitor that we are using the database called mysql. It is also possible to type use mysql.
  9. Currently, the root user created in step 6 may only log in from localhost (the server console). It is desired, although not required to create an administrative account that can also log in from anywhere for administration purposes. MySQL authentication is host based. You may specify a certain IP address to allow access from, or you may use a global wild card. To create the root account that can login globally, issue the following commands. Each "user@host" as a separate account. Be sure to enter the ; at the end of the last line. This lets mysql monitor know that you are done typing the command and to execute it. Again, replace the word novell in single quotes with the password for the root user.

    GRANT ALL ON *.* to root@'%' IDENTIFIED by 'novell' WITH GRANT OPTION;
  10. Confirm the creation of the root@'% user with the following command:

    select host,user from user;

    This will present a table with the user accounts. root should be listed twice, once with localhost under the host column, and once with % under the host column.
  11. Create the Nsure Audit Database. This is the database that will be used by the MySQL logging channel. The logging channel can create this database if desired. In order to do that, the auditusr account created later on must be granted rights to *.*, like the root user.

    CREATE DATABASE naudit;
  12. Create the user account that the Secure Logging Server will use to update the naudit database. For simplification purposes, we will create a global user here. It may be desirable to specify the IP address of the Secure Logging Server to add enhanced security. If the SLS is on the same server, as the MySQL database, be sure to use auditusr@'localhost' instead of auditusr@'%', and specify 127.0.0.1 in the Host address for the MySQL logging channel. Remember, the word novell in single quotes is the password. Change this to the appropriate password for the auditusr account.

    GRANT all on naudit.* to auditusr@'%' IDENTIFIED by 'novell';
  13. Confirm the creation of the auditusr account.

    select host,user from user;

    auditusr should be visible in the user column, next to the appropriate host.

It is not necessary to create the table, as the Nsure Audit MySQL logging channel will create the table if the table is not already present.

.

note

For information regarding configuring the MySQL logging channel, see the MySQL log channel troubleshooting TID, refer to the administrator's guide, and the online documentation at http://www.novell.com/documentation.

disclaimer

The Origin of this information may be internal or external to Novell. Novell makes all reasonable efforts to verify this information. However, the information provided in this document is for your information only. Novell makes no explicit or implied claims to the validity of this information.
Any trademarks referenced in this document are the property of their respective owners. Consult your product manuals for complete trademark information.

  • Document ID:
  • 10088726
  • Solution ID: NOVL93890
  • Creation Date: 12Nov2003
  • Modified Date: 06Sep2005
    • NovellManagement Products

      NetWare

Did this document solve your problem? Provide Feedback