Author: mcbrown
Date: 2007-07-23 11:28:15 +0200 (Mon, 23 Jul 2007)
New Revision: 7176
Log:
Enabling the i5/OS installation instructions
Modified:
trunk/refman-5.0/installing-cs.xml
Modified: trunk/refman-5.0/installing-cs.xml
===================================================================
--- trunk/refman-5.0/installing-cs.xml 2007-07-23 03:35:59 UTC (rev 7175)
+++ trunk/refman-5.0/installing-cs.xml 2007-07-23 09:28:15 UTC (rev 7176)
Changed blocks: 1, Lines Added: 251, Lines Deleted: 0; 8511 bytes
@@ -5568,6 +5568,257 @@
</section>
+ <section id="installation-i5os">
+
+ <title>Installing MySQL on i5/OS</title>
+
+ <indexterm>
+ <primary>IBM i5/OS</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>i5/OS</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>AS/400</primary>
+ </indexterm>
+
+ <para>
+ The i5/OS POWER MySQL package was created in cooperation with IBM.
+ MySQL works within the Portable Application Solution Environment
+ (PASE) on the System i series of hardware and will also provide
+ database services for the Zend Core for i5/OS.
+ </para>
+
+ <para>
+ MySQL for i5/OS is provided as a save file
+ (<literal>.savf</literal>) package that can be downloaded and
+ installed directly without any additional installation steps
+ required.
+ </para>
+
+ <para>
+ MySQL is only supported on i5/OS V5R4 or later releases. The i5/OS
+ PASE must be installed for MySQL to operate. You must be able to
+ login as a user in <literal>*SECOFR</literal> class.
+ </para>
+
+ <para>
+ To install MySQL on i5/OS, follow these steps:
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Create a user profile <literal>MYSQL</literal>. The
+ <literal>MYSQL</literal> user profile will own all the MySQL
+ files and databases and be the active user used when the MySQL
+ server is running. The profile should be disabled so that you
+ cannot log in as the MySQL user. To create a user profile, use
+ <command>CRTUSRPRF</command>:
+ </para>
+
+<programlisting>CRTUSRPRF USRPRF(MYSQL) STATUS(*DISABLED) TEXT('MySQL user id')</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ On the System i machine, create a save file that will be used
+ to receive the downloaded installation save file. The file
+ should be located within the General Purpose Library
+ (<filename>QGPL</filename>):
+ </para>
+
+<programlisting>CRTSAVF FILE(QGPL/MYSQLINST)</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ Download the MySQL installation save file in 32-bit
+ (<filename>mysql-<replaceable>5.0.42</replaceable>-i5os-power-32bit.savf</filename>)
+ or 64-bit
+ (<filename>mysql-<replaceable>5.0.42</replaceable>-i5os-power-64bit.savf</filename>)
+ from <xref linkend="http://dev.mysql.com/downloads"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You need to FTP the downloaded <literal>.savf</literal> file
+ directly into the <literal>QGPL/MYSQLINST</literal> file on
+ the System i server. You can do this through FTP using the
+ following steps after logging in to the System i machine:
+ </para>
+
+<programlisting>ftp> bin
+ftp> cd qgpl
+ftp> put mysql-<replaceable>5.0.42</replaceable>-i5os-power.savf mysqlinst</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ Log into the System i server using a user in the
+ <literal>*SECOFR</literal> class, such as the
+ <literal>QSECOFR</literal> user ID.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You need to restore the installation library stored in the
+ <filename>.savf</filename> save file:
+ </para>
+
+<programlisting>RSTLIB MYSQLINST DEV(*SAVF) SAVF(QGPL/MYSQLINST)</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ You need to execute the installation command,
+ <filename>MYSQLINST/INSMYSQL</filename>. You must specify an
+ installation directory and the user profile that will own the
+ files that are installed. Both the directory and profile will
+ be created if they do not already exist. The recommended
+ directory is <filename>/usr/local</filename>. The
+ <literal>MYSQL</literal> user profile that was created earlier
+ in this sequence should be used for the profile:
+ </para>
+
+<programlisting>MYSQLINST/INSMYSQL DIR('/usr/local') USRPRF(MYSQL)</programlisting>
+
+ <para>
+ The installation copies all the necessary files into a
+ directory matching the package version (for example
+ <filename>mysql-5.0.42-i5os-power-32bit</filename>), sets the
+ ownership on those files, sets up the MySQL environment, and
+ creates the default initial database, completing all the steps
+ in a typical binary installation process automatically.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Once the installation has completed, you can delete the
+ installation file:
+ </para>
+
+<programlisting>DLTLIB LIB(MYSQLINST)</programlisting>
+ </listitem>
+
+ </orderedlist>
+
+ <para>
+ To start MySQL:
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Log into the System i server using a user within the
+ <literal>*SECOFR</literal> class, such as the
+ <literal>QSECOFR</literal> user ID.
+ </para>
+
+ <note>
+ <para>
+ You should start <command>mysqld_safe</command> using a user
+ that in the PASE environment has the id=0 (the equivalent of
+ the standard Unix <literal>root</literal> user). If you do
+ not use a user with this ID then the system will be unable
+ to change the user when executing <command>mysqld</command>
+ as set using <literal>--user</literal> option. If this
+ happens, <command>mysqld</command> may be unable to read the
+ files located within the MySQL data directory and the
+ execution will fail.
+ </para>
+ </note>
+ </listitem>
+
+ <listitem>
+ <para>
+ Enter the PASE environment using <literal>call
+ qpterm</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Start the MySQL server by changing to the installation
+ directory and running <command>mysqld_safe</command>,
+ specifying the user name used to install the server:
+ </para>
+
+<programlisting>> cd
+/usr/local/<replaceable>mysql-5.0.42-i5os-power-32bit</replaceable>
+> bin/mysqld_safe --user=mysql &</programlisting>
+
+ <para>
+ You should see a message similar to the following:
+ </para>
+
+<programlisting>Starting mysqld daemon with databases »
+ from /usr/local/mysql-enterprise-5.0.42-i5os-power-32bit/data</programlisting>
+ </listitem>
+
+ </orderedlist>
+
+ <para>
+ If you are having problems starting MySQL server, see
+ <xref linkend="starting-server"/>.
+ </para>
+
+ <para>
+ To stop MySQL:
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Log into the System i server using the
+ <literal>*SECOFR</literal> class, such as the
+ <literal>QSECOFR</literal> user ID.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Enter the PASE environment.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Stop the MySQL server by changing into the installation
+ directory and running <command>mysqladmin</command>,
+ specifying the user name used to install the server:
+ </para>
+
+<programlisting>> cd /usr/local/<replaceable>mysql-5.0.42-i5os-power-32bit</replaceable> > bin/mysqladmin -u root shutdown</programlisting>
+
+ <para>
+ If the session that you started and stopped MySQL are the
+ same, you may get the log output from
+ <literal>mysqld</literal>:
+ </para>
+
+<programlisting> STOPPING server from pid file »
+ /usr/local/mysql-enterprise-5.0.42-i5os-power-32bit/data/I5DBX.RCHLAND.IBM.COM.pid
+ 070718 10:34:20 mysqld ended</programlisting>
+
+ <para>
+ If the sessions used to start and stop MySQL are different,
+ you will not receive any confirmation of the shutdown.
+ </para>
+ </listitem>
+
+ </orderedlist>
+
+ </section>
+
<section id="netware-installation" role="cs">
<title>Installing MySQL on NetWare</title>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7176 - trunk/refman-5.0 | mcbrown | 23 Jul |
