cvs commit: BLFS/BOOK/introduction/welcome changelog.xml

highos at linuxfromscratch.org highos at linuxfromscratch.org
Thu Aug 15 18:24:10 PDT 2002


highos      02/08/15 18:24:09

  Modified:    BOOK     index.xml
               BOOK/appendices/symlinks rc0.xml rc1.xml rc2.xml rc3.xml
                        rc4.xml rc5.xml rc6.xml
               BOOK/content/databases mysql.xml
               BOOK/content/databases/mysql mysql.ent
               BOOK/introduction/welcome changelog.xml
  Added:       BOOK/content/databases/mysql mysql-config.xml mysql-desc.xml
                        mysql-exp.xml mysql-inst.xml mysql-intro.xml
  Log:
  Adding MySQl-3.23.51.
  
  Revision  Changes    Path
  1.25      +2 -2      BLFS/BOOK/index.xml
  
  Index: index.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/index.xml,v
  retrieving revision 1.24
  retrieving revision 1.25
  diff -u -r1.24 -r1.25
  --- index.xml	14 Aug 2002 03:24:19 -0000	1.24
  +++ index.xml	16 Aug 2002 01:23:58 -0000	1.25
  @@ -2,8 +2,8 @@
   <!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.1.2//EN" 
   			"/usr/share/docbook/docbookx.dtd" [
   
  -<!ENTITY version "20020813">
  -<!ENTITY releasedate "August 13th, 2002">
  +<!ENTITY version "20020815">
  +<!ENTITY releasedate "August 15th, 2002">
   
   <!ENTITY % book SYSTEM "book/book.ent">
   <!ENTITY % preface SYSTEM "preface/preface.ent">
  
  
  
  1.3       +7 -0      BLFS/BOOK/appendices/symlinks/rc0.xml
  
  Index: rc0.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/appendices/symlinks/rc0.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- rc0.xml	19 Jul 2002 19:53:15 -0000	1.2
  +++ rc0.xml	16 Aug 2002 01:23:59 -0000	1.3
  @@ -35,6 +35,13 @@
   </row>
   
   <row>
  +<entry>K26</entry>
  +<entry>mysql</entry>
  +<entry><filename>../init.d/mysql</filename></entry>
  +<entry>Shut down MySQL Daeomon: <xref linkend="mysql"/></entry>
  +</row>
  +
  +<row>
   <entry>K30</entry>
   <entry>sshd</entry>
   <entry><filename>../init.d/sshd</filename></entry>
  
  
  
  1.3       +7 -0      BLFS/BOOK/appendices/symlinks/rc1.xml
  
  Index: rc1.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/appendices/symlinks/rc1.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- rc1.xml	19 Jul 2002 19:53:15 -0000	1.2
  +++ rc1.xml	16 Aug 2002 01:23:59 -0000	1.3
  @@ -35,6 +35,13 @@
   </row>
   
   <row>
  +<entry>K26</entry>
  +<entry>mysql</entry>
  +<entry><filename>../init.d/mysql</filename></entry>
  +<entry>Shut down MySQL Daemon: <xref linkend="mysql"/></entry>
  +</row>
  +
  +<row>
   <entry>K30</entry>
   <entry>sshd</entry>
   <entry><filename>../init.d/sshd</filename></entry>
  
  
  
  1.3       +7 -0      BLFS/BOOK/appendices/symlinks/rc2.xml
  
  Index: rc2.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/appendices/symlinks/rc2.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- rc2.xml	19 Jul 2002 19:53:15 -0000	1.2
  +++ rc2.xml	16 Aug 2002 01:23:59 -0000	1.3
  @@ -35,6 +35,13 @@
   </row>
   
   <row>
  +<entry>K26</entry>
  +<entry>mysql</entry>
  +<entry><filename>../init.d/mysql</filename></entry>
  +<entry>Shut down MySQL Daemon: <xref linkend="mysql"/></entry>
  +</row>
  +
  +<row>
   <entry>K30</entry>
   <entry>sshd</entry>
   <entry><filename>../init.d/sshd</filename></entry>
  
  
  
  1.3       +7 -0      BLFS/BOOK/appendices/symlinks/rc3.xml
  
  Index: rc3.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/appendices/symlinks/rc3.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- rc3.xml	19 Jul 2002 19:53:15 -0000	1.2
  +++ rc3.xml	16 Aug 2002 01:23:59 -0000	1.3
  @@ -49,6 +49,13 @@
   </row>
   
   <row>
  +<entry>S34</entry>
  +<entry>mysql</entry>
  +<entry><filename>../init.d/mysql</filename></entry>
  +<entry>Start MySQL Daemon: <xref linkend="mysql"/></entry>
  +</row>
  +
  +<row>
   <entry>S35</entry>
   <entry>postfix</entry>
   <entry><filename>../init.d/postfix</filename></entry>
  
  
  
  1.3       +7 -0      BLFS/BOOK/appendices/symlinks/rc4.xml
  
  Index: rc4.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/appendices/symlinks/rc4.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- rc4.xml	19 Jul 2002 19:53:15 -0000	1.2
  +++ rc4.xml	16 Aug 2002 01:23:59 -0000	1.3
  @@ -49,6 +49,13 @@
   </row>
   
   <row>
  +<entry>S34</entry>
  +<entry>mysql</entry>
  +<entry><filename>../init.d/mysql</filename></entry>
  +<entry>Start MySQL Daemon: <xref linkend="mysql"/></entry>
  +</row>
  +
  +<row>
   <entry>S35</entry>
   <entry>postfix</entry>
   <entry><filename>../init.d/postfix</filename></entry>
  
  
  
  1.3       +7 -0      BLFS/BOOK/appendices/symlinks/rc5.xml
  
  Index: rc5.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/appendices/symlinks/rc5.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- rc5.xml	19 Jul 2002 19:53:15 -0000	1.2
  +++ rc5.xml	16 Aug 2002 01:23:59 -0000	1.3
  @@ -49,6 +49,13 @@
   </row>
   
   <row>
  +<entry>S34</entry>
  +<entry>mysql</entry>
  +<entry><filename>../init.d/mysql</filename></entry>
  +<entry>Start MySQL Daemon: <xref linkend="mysql"/></entry>
  +</row>
  +
  +<row>
   <entry>S35</entry>
   <entry>postfix</entry>
   <entry><filename>../init.d/postfix</filename></entry>
  
  
  
  1.3       +7 -0      BLFS/BOOK/appendices/symlinks/rc6.xml
  
  Index: rc6.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/appendices/symlinks/rc6.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- rc6.xml	19 Jul 2002 19:53:15 -0000	1.2
  +++ rc6.xml	16 Aug 2002 01:23:59 -0000	1.3
  @@ -35,6 +35,13 @@
   </row>
   
   <row>
  +<entry>K26</entry>
  +<entry>mysql</entry>
  +<entry><filename>../init.d/mysql</filename></entry>
  +<entry>Shut down MySQL Daemon: <xref linkend="mysql"/></entry>
  +</row>
  +
  +<row>
   <entry>K30</entry>
   <entry>sshd</entry>
   <entry><filename>../init.d/sshd</filename></entry>
  
  
  
  1.2       +7 -4      BLFS/BOOK/content/databases/mysql.xml
  
  Index: mysql.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/content/databases/mysql.xml,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- mysql.xml	7 Jul 2002 20:28:47 -0000	1.1
  +++ mysql.xml	16 Aug 2002 01:24:03 -0000	1.2
  @@ -1,8 +1,11 @@
  -<sect1 id="mysql" xreflabel="mysql">
  +<sect1 id="mysql" xreflabel="MySQL-&mysql-version;">
   <?dbhtml filename="mysql.html" dir="content"?>
  -<title>mysql</title>
  +<title>MySQL-&mysql-version;</title>
   
  -<para>TO BE DONE</para>
  +&mysql-intro;
  +&mysql-inst;
  +&mysql-exp;
  +&mysql-config;
  +&mysql-desc;
   
   </sect1>
  -
  
  
  
  1.2       +10 -0     BLFS/BOOK/content/databases/mysql/mysql.ent
  
  Index: mysql.ent
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/content/databases/mysql/mysql.ent,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- mysql.ent	7 Jul 2002 20:28:47 -0000	1.1
  +++ mysql.ent	16 Aug 2002 01:24:03 -0000	1.2
  @@ -1 +1,11 @@
   <!ENTITY mysql SYSTEM "../mysql.xml">
  +<!ENTITY mysql-intro SYSTEM "mysql-intro.xml">
  +<!ENTITY mysql-inst SYSTEM "mysql-inst.xml">
  +<!ENTITY mysql-exp SYSTEM "mysql-exp.xml">
  +<!ENTITY mysql-config SYSTEM "mysql-config.xml">
  +<!ENTITY mysql-desc SYSTEM "mysql-desc.xml">
  +<!ENTITY mysql-version "3.23.51">
  +<!ENTITY mysql-download-http "http://mysql.he.net/Downloads/MySQL-3.23/mysql-3.23.51.tar.gz">
  +<!ENTITY mysql-download-ftp "ftp://mirror.mcs.anl.gov/pub/mysql/Downloads/MySQL-3.23/mysql-3.23.51.tar.gz">
  +<!ENTITY mysql-size "11 MB">
  +<!ENTITY mysql-buildsize "68 MB">
  
  
  
  1.1                  BLFS/BOOK/content/databases/mysql/mysql-config.xml
  
  Index: mysql-config.xml
  ===================================================================
  <sect2>
  <title>Configuring mysql</title>
  
  <sect3>
  <title>Config files</title>
  
  <para><userinput>/etc/my.cnf, ~/.my.cnf</userinput></para>
  
  </sect3>
  
  <sect3>
  <title>Configuration Information</title>
  
  <para>There are several default configurations file available in
  /usr/share/mysql which you can use.</para>
  
  <screen><userinput>cp /usr/share/mysql/my-medium.cnf /etc/my.cnf</userinput></screen>
  
  <para>We can now install a database and change the ownership to the
  unpriviledged user and group.</para>
  
  <screen><userinput>mysql_install_db
  chown -R mysql:mysql /var/mysql</userinput></screen>
  
  <para>Further configuration requires that the mysql server be running:</para>
  
  <screen><userinput>safe_mysqld 2>&1 >/dev/null &</userinput></screen>
  
  <para>A default installation, does not setup a password for the administrator.
  So here we will login and set one.  We strongly suggest changing
  'new-password' to your own.</para>
  
  <screen><userinput>mysql -uroot mysql</userinput>
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 2 to server version: 3.23.51-log
  
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  
  mysql> <userinput>UPDATE user SET password=password('new-password') WHERE user='root';</userinput>
  Query OK, 2 rows affected (0.00 sec)
  Rows matched: 2  Changed: 2  Warnings: 0
  
  mysql> <userinput>FLUSH PRIVILEGES;</userinput>
  Query OK, 0 rows affected (0.00 sec)
  
  mysql> <userinput>EXIT;</userinput>
  bye
  </screen>
  
  <para>Now that we are done with the configuration of the server, we can
  shut it down.</para>
  
  <screen><userinput>kill `pidof -x safe_mysqld mysqld`</userinput></screen>
  
  
  <sect4>
  <title>mysql init.d script</title>
  
  <para>To automate the running of mysql, use the following command to create
  the init.d script:</para>
  
  <screen><userinput>cat > /etc/rc.d/init.d/mysql << "EOF"</userinput>
  #!/bin/bash
  # Begin $rc_base/init.d/
  
  # Based on sysklogd script from LFS-3.1 and earlier.
  # Rewritten by Gerard Beekmans  - gerard at linuxfromscratch.org
  
  source /etc/sysconfig/rc
  source $rc_functions
  
  case "$1" in
          start)
                  echo "Starting MySQL daemon..."
                  /usr/bin/safe_mysqld 2>&1 >/dev/null &
                  evaluate_retval
                  ;;
  
          stop)
                  echo "Stopping MySQL daemon..."
                  killproc mysqld
                  ;;
  
          restart)
                  $0 stop
                  sleep 1
                  $0 start
                  ;;
  
          status)
                  statusproc /usr/sbin/mysqld
                  ;;
  
          *)
                  echo "Usage: $0 {start|stop|restart|status}"
                  exit 1
                  ;;
  esac
  
  # End $rc_base/init.d/
  <userinput>EOF
  chmod 755 /etc/rc.d/init.d/mysql</userinput></screen>
  
  <para>Create the symbolic links to this file in the relevant rc.d directory
  with the following commands:</para>
  
  <screen><userinput>cd /etc/rc.d/init.d &&
  ln -sf ../init.d/mysql ../rc0.d/K26mysql &&
  ln -sf ../init.d/mysql ../rc1.d/K26mysql &&
  ln -sf ../init.d/mysql ../rc2.d/K26mysql &&
  ln -sf ../init.d/mysql ../rc3.d/S34mysql &&
  ln -sf ../init.d/mysql ../rc4.d/S34mysql &&
  ln -sf ../init.d/mysql ../rc5.d/S34mysql &&
  ln -sf ../init.d/mysql ../rc6.d/K26mysql</userinput></screen>
  
  </sect4>
  
  </sect3>
  
  </sect2>
  
  
  
  
  1.1                  BLFS/BOOK/content/databases/mysql/mysql-desc.xml
  
  Index: mysql-desc.xml
  ===================================================================
  <sect2>
  <title>Contents</title>
  
  <para>The mysql package contains <userinput>mysql mysqladmin mysqlcheck mysqlshow mysqldump mysqlimport mysqltest mysqlbinlog replace comp_err perror resolveip my_print_defaults resolve_stack_dump isamchk isamlog pack_isam myisamchk myisamlog myisampack safe_mysqld mysql_install_db msql2mysql mysql_config mysql_fix_privilege_tables mysql_setpermission mysql_zap mysqlacess mysqlbug mysql_convert_table_format mysql_find_rows mysqlhotcopy mysqldumbslow mysqld_multi mysqld</userinput></para>
  
  </sect2>
  
  <sect2><title>Description</title>
  
  <para>A full package listing would be several pages long, for that reason, we suggest consulting the mysql documetation for full details, instead.</para>
  
  <para>Certain mysql support programs may require the perl DBI modules to be installed to function properly.</para>
  
  </sect2>
  
  
  
  1.1                  BLFS/BOOK/content/databases/mysql/mysql-exp.xml
  
  Index: mysql-exp.xml
  ===================================================================
  <sect2>
  <title>Command explanations</title>
  
  <para><userinput>sed -e "s%mysql-test/Makefile%%" -e "s% mysql-test%%" configure.old > configure</userinput>:
  This sed is used to disable the mysql test suite.</para>
  
  </sect2>
  
  
  
  1.1                  BLFS/BOOK/content/databases/mysql/mysql-inst.xml
  
  Index: mysql-inst.xml
  ===================================================================
  <sect2>
  <title>Installation of mysql</title>
  
  <para>For security reasons, running the server as an unpriviledged user and group is strongly encouraged:</para>
  
  <screen><userinput>groupadd mysql &&
  useradd -c mysql -d /dev/null -g mysql -s /bin/false mysql</userinput></screen>
  
  <para>Build and install mysql by running the following commands:</para>
  
  <screen><userinput>cp configure configure.old &&
  sed -e "s%mysql-test/Makefile%%" -e "s% mysql-test%%" configure.old > configure &&
  ./configure --prefix=/usr \
              --sysconfdir=/etc \
              --libexecdir=/usr/sbin \
              --localstatedir=/var/mysql \
              --enable-thread-safe-client \
              --without-debug \
              --without-bench &&
  make &&
  make install</userinput></screen>
  
  </sect2>
  
  
  
  1.1                  BLFS/BOOK/content/databases/mysql/mysql-intro.xml
  
  Index: mysql-intro.xml
  ===================================================================
  <sect2>
  <title>Introduction to MySQL</title>
  
  <screen>Download location (HTTP):       <ulink url="&mysql-download-http;" />
  Download location (FTP):        <ulink url="&mysql-download-ftp;" />
  Version used:                   &mysql-version;
  Package size:                   &mysql-size;
  Estimated Disk space required:  &mysql-buildsize;</screen>
  
  <para>The MySQL package contains the mysql library, server and client utilities.</para>
  
  </sect2>
  
  
  
  1.59      +3 -0      BLFS/BOOK/introduction/welcome/changelog.xml
  
  Index: changelog.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/introduction/welcome/changelog.xml,v
  retrieving revision 1.58
  retrieving revision 1.59
  diff -u -r1.58 -r1.59
  --- changelog.xml	14 Aug 2002 03:24:19 -0000	1.58
  +++ changelog.xml	16 Aug 2002 01:24:08 -0000	1.59
  @@ -10,6 +10,9 @@
   
   <itemizedlist>
   
  +<listitem><para>August 15th, 2002 [highos]: Content Databases: Added
  +MySQL-3.23.51.</para></listitem>
  +
   <listitem><para>August 13th, 2002 [larry]: X: updated to
   qt-3.0.5.</para></listitem>
   
  
  
  
-- 
Unsubscribe: send email to listar at linuxfromscratch.org
and put 'unsubscribe blfs-book' in the subject header of the message



More information about the blfs-book mailing list