Before installing MySQL, review this section for information about prerequisites, upgrading, and information that is required during the installation process. If you are installing MySQL as part of the NetWare AMP preconfigured server option, review Installing As Part of NetWare AMP for specific information about changes made to your server during installation.
If you want to install MySQL when upgrading a NetWare 5.1 or 6.0 server to NetWare 6.5, you must do so after the server is already installed. This is because MySQL requires that its databases be stored on a NetWare 6.5 NSS volume. Even if you have an NSS volume on NetWare 5, the server upgrade requires that you to run an NSS upgrade utility before the NSS volume can be mounted. You cannot install MySQL until the NSS volume is mounted.
During an upgrade, the MySQL installation process performs the following actions:
If the MySQL server is running, it is shut down.
If sys:\etc\my.cnf exists, it is saved as sys:\etc\my.cnf.upg.
MySQL is uninstalled. This does not remove any files that have been modified after they were installed.
MySQL is reinstalled. If sys:\etc\my.cnf.upg exists, MySQL copies it back to sys:\etc\my.cnf and uses it for configuring MySQL. The MySQL Options install screen is not displayed.
If the data directory already contains MySQL grant tables (the install checks for mysql\host.frm), then the MySQL install uses the existing database and does not create a new initial MySQL database.
During upgrade all the existing configuration files remain intact. However, for phpMyAdmin, the latest version of sample configuration file is copied to sys:\adminsrv\phpapps\phpmyadmin as config.inc.php-new.
HINT:If you are installing the Novell® exteNd™ Application Server, MySQL is also installed. This is because MySQL is required by the exteNd Application Server. Therefore, these same issues apply.
When upgrading a NetWare 5.1 or 6 server and installing MySQL, a message appears indicating that MySQL cannot run on a traditional volume. Because NSS volumes are not mounted or created during an upgrade, perform the following steps to configure MySQL:
After first upgrading your NetWare 5.1 server to a NetWare 6.5 server, create an NSS volume or upgrade existing NSS volumes.
To create a new NSS volume, use the NSS Management Utility, and enter nssmu at the system console.
To upgrade an existing NSS volume, enter nss \zlssvolumeupgrade=all at the system console.
Edit sys:\etc\my.cnf by entering the correct volume and path to the MySQL data directory.
For example:
datadir=nssvol:\mysql\data
At the NetWare console, enter
mysql_install_db
mysqld_safe
perl sys:\mysql\scripts\mysql_secure_installation.pl
The last command runs the mysql_secure_installation.pl Perl script, which lets you configure security for MySQL.
If Novell exteNd Application Server was installed: Configure the Novell exteNd Application Server by entering the following at the system console:
load silverinit appserverpassword adminpassword mysqlrootpassword
Each of these passwords is explained in the sys:\extend\appserver\bin\silverinit.ncf file.
The install for MySQL on NetWare does not detect if a MySQL version is already installed outside the NetWare release.
Therefore, if you have installed the latest MySQL version from the Web (for example, MySQL 4.1) to sys:\mysql, then you need to rename the folder before upgrading the NetWare server.