Changeset cd34755


Ignore:
Timestamp:
01/24/2013 04:36:58 PM (11 years ago)
Author:
Krejzi <krejzi@…>
Branches:
10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, 7.10, 7.4, 7.5, 7.6, 7.6-blfs, 7.6-systemd, 7.7, 7.8, 7.9, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, gnome, kde5-13430, kde5-14269, kde5-14686, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, krejzi/svn, lazarus, lxqt, nosym, perl-modules, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, systemd-11177, systemd-13485, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
Children:
5a464e4d
Parents:
4a29e2b
Message:

Updated to MySQL 5.5.29 and fixed several defect bugs in trac.

git-svn-id: svn://svn.linuxfromscratch.org/BLFS/trunk/BOOK@10972 af4574ff-66df-0310-9fd7-8a98e5e911e0

Files:
8 edited

Legend:

Unmodified
Added
Removed

  • general.ent

    r4a29e2b rcd34755  
    526526<!-- Chapter 22 -->
    527527<!ENTITY db-version                   "5.3.21">
    528 <!ENTITY mysql-version                "5.5.28">
     528<!ENTITY mysql-version                "5.5.29">
    529529<!ENTITY postgresql-version           "9.2.1">
    530530<!ENTITY sqlite-version               "3.7.15.2">

  • general/genutils/gtk-doc.xml

    r4a29e2b rcd34755  
    116116  </sect2>
    117117
    118   <sect2 role="commands">
    119     <title>Command Explanations</title>
    120 
    121     <para><command>sed -i '...' gtkdoc-fixxref.in</command>: This command fixes
    122     an issue where invocations of the <application>Vim</application> editor
    123     does not behave as expected. See upstream bug at
    124     <ulink url="https://bugzilla.gnome.org/show_bug.cgi?id=627223"/>.</para>
    125 
    126   </sect2>
    127 
    128118  <sect2 role="content">
    129119    <title>Contents</title>

  • general/graphlib/libpng.xml

    r4a29e2b rcd34755  
    100100    </para>
    101101
    102 <screen><userinput>gzip -cd ../libpng-&libpng-version;-apng.patch.gz | patch -p1</userinput></screen>
     102<screen><userinput>gzip -cd ../libpng-&libpng-version;-apng.patch.gz | patch -p1 &amp;&amp;
     103START=$(awk '/@/' scripts/symbols.def | sort -k2.3n | tail -1 | cut -d "@" -f2) &amp;&amp;
     104awk -v v="$START" '/^PNG(_.+)?_EXPORTA?\(/ {gsub(/PNG(_.+)?_EXPORTA?\(/, ""); gsub(/,/, ""); \
     105if($1 > v) print $3 " @"$1}' png.h | sort -k2.3n &gt;&gt; scripts/symbols.def</userinput></screen>
    103106
    104107    <para>
    … …  
    125128  <sect2 role="commands">
    126129    <title>Command Explanations</title>
     130
     131    <para>
     132      <command>awk -v ...</command>: This command fixes the testsuite
     133      when APNG patch is applied.
     134    </para>
    127135
    128136    <xi:include xmlns:xi="http://www.w3.org/2001/XInclude"

  • introduction/welcome/changelog.xml

    r4a29e2b rcd34755  
    4949      <itemizedlist>
    5050        <listitem>
     51          <para>[krejzi] - MySQL 5.5.29.</para>
     52        </listitem>
     53        <listitem>
    5154          <para>[randy] - Updated Audacious/Audacious-Plugins to 3.3.3</para>
    5255        </listitem>

  • networking/netlibs/libtirpc.xml

    r4a29e2b rcd34755  
    102102
    103103    <para condition="html" role="usernotes">User Notes:
    104     <ulink url="&blfs-wiki;/libtirpc"/></para>
    105 
     104      <ulink url="&blfs-wiki;/libtirpc"/>
     105    </para>
    106106  </sect2>
    107107
    … …  
    110110
    111111    <para>
    112       Glibc-2.14 and later do not install NIS and RPC related headers by
    113       default. If needed, install them here:
    114     </para>
    115 
    116 <screen><userinput>if [ ! -r /usr/include/rpc/rpc.h ]; then
     112      Glibc 2.14 and later does not install NIS and RPC related headers by
     113      default. If needed, install them by running the following command
     114      as the <systemitem class="username">root</systemitem> user:
     115    </para>
     116
     117<screen role="root"><userinput>if [ ! -r /usr/include/rpc/rpc.h ]; then
    117118   tar -xvf ../rpcnis-headers.tar.bz2 -C /usr/include
    118119fi</userinput></screen>
    … …  
    124125
    125126<screen><userinput>patch -Np1 -i ../libtirpc-&libtirpc-version;-remove-nis-2.patch &amp;&amp;
    126 autoreconf &amp;&amp;
     127sed "s@AM_CONFIG_HEADER@AC_CONFIG_HEADERS@g" -i configure.ac &amp;&amp;
     128autoreconf -fi &amp;&amp;
    127129./configure --prefix=/usr CFLAGS="-fPIC" &amp;&amp;
    128130make</userinput></screen>
    … …  
    144146  <sect2 role="commands">
    145147    <title>Command Explanations</title>
     148
     149    <para>
     150      <command>sed "s@AM_CONFIG_HEADER@AC_CONFIG_HEADERS@g"
     151      -i configure.ac</command>: This sed fixes some issues with
     152      <application>Automake</application> 1.13 and later.
     153    </para>
    146154
    147155    <para>
    … …  
    176184
    177185      <varlistentry id="libtirpc-lib">
    178         <term><filename class='libraryfile'>libtirpc.{so,a}</filename></term>
     186        <term><filename class="libraryfile">libtirpc.{so,a}</filename></term>
    179187        <listitem>
    180188          <para>

  • postlfs/security/mitkrb.xml

    r4a29e2b rcd34755  
    178178chmod -v 755 /bin/ksu   &amp;&amp;
    179179
    180 install -m644 -v ../doc/*.info /usr/share/info &amp;&amp;
    181 
    182 for INFOFILE in admin install user; do
    183     install-info --info-dir=/usr/share/info \
    184                  /usr/share/info/krb5-$INFOFILE.info
    185     rm ../doc/krb5-$INFOFILE.info
    186 done &amp;&amp;
    187 
    188180install -v -dm755 /usr/share/doc/krb5-&mitkrb-version; &amp;&amp;
    189181cp -vfr ../doc/*  /usr/share/doc/krb5-&mitkrb-version; &amp;&amp;
    190182
    191 unset LIBRARY INFOFILE</userinput></screen>
     183unset LIBRARY</userinput></screen>
    192184
    193185    <para>

  • server/databases/mysql.xml

    r4a29e2b rcd34755  
    77  <!ENTITY mysql-download-http "http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-&mysql-version;.tar.gz">
    88  <!ENTITY mysql-download-ftp  " ">
    9   <!ENTITY mysql-md5sum        "da8ddb3d00e6e159153d2444360f52a8">
     9  <!ENTITY mysql-md5sum        "e6b9f9cb82e990bd8f0474df7462904e">
    1010  <!ENTITY mysql-size          "24 MB">
    11   <!ENTITY mysql-buildsize     "932 MB (additional 170 MB to run the test suite)">
     11  <!ENTITY mysql-buildsize     "760 MB (additional 170 MB to run the test suite)">
    1212  <!ENTITY mysql-time          "4.0 SBU (Test suite is an additional 45 minutes, only partially CPU dependent)">
    1313]>
    … …  
    3030    <title>Introduction to MySQL</title>
    3131
    32     <para><application>MySQL</application> is a widely used and fast SQL
    33     database server. It is a client/server implementation that consists of a
    34     server daemon and many different client programs and libraries.</para>
     32    <para>
     33      <application>MySQL</application> is a widely used and fast SQL database
     34      server. It is a client/server implementation that consists of a
     35      server daemon and many different client programs and libraries.
     36    </para>
    3537
    3638    &lfs72_checked;
    … …  
    3941    <itemizedlist spacing="compact">
    4042      <listitem>
    41         <para>Download (HTTP): <ulink url="&mysql-download-http;"/></para>
    42       </listitem>
    43       <listitem>
    44         <para>Download (FTP): <ulink url="&mysql-download-ftp;"/></para>
    45       </listitem>
    46       <listitem>
    47         <para>Download MD5 sum: &mysql-md5sum;</para>
    48       </listitem>
    49       <listitem>
    50         <para>Download size: &mysql-size;</para>
    51       </listitem>
    52       <listitem>
    53         <para>Estimated disk space required: &mysql-buildsize;</para>
    54       </listitem>
    55       <listitem>
    56         <para>Estimated build time: &mysql-time;</para>
     43        <para>
     44          Download (HTTP): <ulink url="&mysql-download-http;"/>
     45        </para>
     46      </listitem>
     47      <listitem>
     48        <para>
     49          Download (FTP): <ulink url="&mysql-download-ftp;"/>
     50        </para>
     51      </listitem>
     52      <listitem>
     53        <para>
     54          Download MD5 sum: &mysql-md5sum;
     55        </para>
     56      </listitem>
     57      <listitem>
     58        <para>
     59          Download size: &mysql-size;
     60        </para>
     61      </listitem>
     62      <listitem>
     63        <para>
     64          Estimated disk space required: &mysql-buildsize;
     65        </para>
     66      </listitem>
     67      <listitem>
     68        <para>
     69          Estimated build time: &mysql-time;
     70        </para>
    5771      </listitem>
    5872    </itemizedlist>
    … …  
    6175    <itemizedlist spacing="compact">
    6276      <listitem>
    63         <para>Optional patch (required if building for Amarok): <ulink
    64         url="&patch-root;/mysql-&mysql-version;-embedded_library_shared-1.patch"/></para>
    65       </listitem>
    66       <listitem>
    67         <para>Optional patch (required if building only the client): <ulink
    68         url="&patch-root;/mysql-&mysql-version;-fix_client_only-1.patch"/></para>
    69       </listitem>
    70       <listitem>
    71         <para>Optional Documentation (see tip below):
     77        <para>
     78          Optional patch (recommended if building for Amarok):
     79          <ulink url="&patch-root;/mysql-&mysql-version;-embedded_library_shared-1.patch"/>
     80        </para>
     81      </listitem>
     82      <listitem>
     83        <para>
     84          Optional Documentation (see tip below):
    7285          <ulink url="http://dev.mysql.com/doc/"/>
    7386        </para>
    … …  
    7891
    7992    <bridgehead renderas="sect4">Required</bridgehead>
    80     <para role="optional"><xref linkend="cmake"/></para>
     93    <para role="required">
     94      <xref linkend="cmake"/>
     95    </para>
    8196
    8297    <bridgehead renderas="sect4">Recommended</bridgehead>
    83     <para role="optional"><xref linkend="openssl"/></para>
     98    <para role="recommended">
     99      <xref linkend="openssl"/>
     100    </para>
    84101
    85102    <bridgehead renderas="sect4">Optional</bridgehead>
    … …  
    89106
    90107    <para condition="html" role="usernotes">User Notes:
    91     <ulink url="&blfs-wiki;/mysql"/></para>
    92 
     108      <ulink url="&blfs-wiki;/mysql"/>
     109    </para>
    93110  </sect2>
    94111 
    95112  <sect2 role="installation">
    96113    <title>Installation of MySQL</title>
    97 
    98     <sect3>
    99     <title>Building</title>
    100114   
    101     <para>For security reasons, running the server as an unprivileged user
    102     and group is strongly encouraged. Issue the following (as
    103     <systemitem class="username">root</systemitem>) to create the user and
    104     group:</para>
     115    <para>
     116      For security reasons, running the server as an unprivileged user
     117      and group is strongly encouraged. Issue the following (as
     118      <systemitem class="username">root</systemitem>) to create the
     119      user and group:
     120    </para>
    105121
    106122<screen role="root"><userinput>groupadd -g 40 mysql &amp;&amp;
    107 useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false -u 40 mysql</userinput></screen>
    108 
    109     <para>If the MySQL server is not needed, it is possible to build only the
    110     client libraries of MySQL. To do this you need to apply the optional patch,
    111     use the cmake option <parameter>-DWITHOUT_SERVER=ON</parameter> and the
    112     client-only installation instructions below.</para>
    113 
    114     <para>MySQL contains an embedded server library which can be enabled with
    115     the cmake option <parameter>-DWITH_EMBEDDED_SERVER=ON</parameter>. By default
    116     this server is built as a statically linked library,
    117     <filename>libmysqld.a</filename>, but by applying the optional patch, a
    118     shared version of this library can be built. The shared library is needed
    119     by certain applications, such as <application>Amarok</application>.</para>
    120    
    121     <para>There are numerous options available to
    122     <userinput>cmake</userinput>. Check the output of the `<userinput>cmake .
    123     -LH</userinput>` for additional customization options. See the <ulink
    124     url="http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html">MySQL
    125     Documentation</ulink> for a full listing of all options.</para>
    126    
    127     <para>If you want the shared version of the embedded server library, apply
    128     the patch:</para>
     123useradd -c "MySQL Server" -d /srv/mysql -g mysql -s /bin/false -u 40 mysql</userinput></screen>
     124
     125    <para>
     126      If the MySQL server is not needed, it is possible to build only the
     127      client libraries of MySQL. To do this you need to add
     128      <parameter>-DWITHOUT_SERVER=ON</parameter> to the <command>cmake</command>
     129      command below.
     130    </para>
     131
     132    <para>
     133      MySQL contains an embedded server library which can be enabled with
     134      the cmake option <parameter>-DWITH_EMBEDDED_SERVER=ON</parameter>. By
     135      default this server is built as a statically linked library,
     136      <filename>libmysqld.a</filename>, but by applying the optional patch, a
     137      shared version of this library can be built. The library is needed
     138      by certain applications, such as <application>Amarok</application> and
     139      we recommend use of the shared libraries.
     140    </para>
     141   
     142    <para>
     143      There are numerous options available to
     144      <userinput>cmake</userinput>. Check the output of the `<userinput>cmake .
     145      -LH</userinput>` for additional customization options. See the <ulink
     146      url="http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html">MySQL
     147      Documentation</ulink> for a full listing of all options.
     148    </para>
     149   
     150    <para>
     151      If you want to build shared version of the embedded server library, apply
     152      the following patch:
     153    </para>
    129154   
    130155<screen><userinput>patch -Np1 -i ../mysql-&mysql-version;-embedded_library_shared-1.patch</userinput></screen>
    131 
    132      <para>If building the client-only, apply the patch:</para>
    133 
    134 <screen><userinput>patch -Np1 -i ../mysql-&mysql-version;-fix_client_only-1.patch</userinput></screen>
    135    
    136     <para>Configure and build <application>MySQL</application> by
    137     running the following commands:</para>
    138    
    139 <screen><userinput>mkdir build &amp;&amp;
     156   
     157    <para>
     158      Install <application>MySQL</application> by running the
     159      following commands:
     160    </para>
     161   
     162<screen><userinput>sed -i "/ADD_SUBDIRECTORY(sql\/share)/d" CMakeLists.txt &amp;&amp;
     163sed -i "s/ADD_SUBDIRECTORY(libmysql)/&amp;\\nADD_SUBDIRECTORY(sql\/share)/" CMakeLists.txt &amp;&amp;
     164sed -i "s@data/test@\${INSTALL_MYSQLSHAREDIR}@g" sql/CMakeLists.txt &amp;&amp;
     165sed -i "s@data/mysql@\${INSTALL_MYSQLTESTDIR}@g" sql/CMakeLists.txt &amp;&amp;
     166mkdir build &amp;&amp;
    140167cd build &amp;&amp;
    141 cmake -DCMAKE_INSTALL_PREFIX=/usr                   \
     168cmake -DCMAKE_BUILD_TYPE=Release                    \
     169      -DCMAKE_INSTALL_PREFIX=/usr                   \
    142170      -DINSTALL_DOCDIR=share/doc/mysql              \
    143171      -DINSTALL_DOCREADMEDIR=share/doc/mysql        \
    … …  
    155183      -DMYSQL_DATADIR=/srv/mysql                    \
    156184      -DMYSQL_UNIX_ADDR=/var/run/mysql/mysql.sock   \
    157       -DSYSCONFDIR=/etc                             \
     185      -DSYSCONFDIR=/etc/mysql                       \
    158186      -DWITH_PARTITION_STORAGE_ENGINE=OFF           \
    159187      -DWITH_PERFSCHEMA_STORAGE_ENGINE=OFF          \
    … …  
    163191make</userinput></screen>
    164192
    165     <para>To test the results, issue: <command>make test-force 2>&amp;1 | tee
    166     test.log</command>.  This forces the test to run to completion and logs all
    167     the test output.  There will be many tests that are not run due to
    168     configuration options and developer considerations.  Note that if you use
    169     TCP Wrappers and have a restrictive <filename>/etc/hosts.deny</filename>
    170     file, you will need to add an appropriate entry to the
    171     <filename>/etc/hosts.allow</filename> file for the
    172     <command>mysqld</command> daemon. Otherwise many of the tests will
    173     fail.  Also, two tests will fail if ipv6 is not available in the kernel
    174     either as a module or built in.</para>
    175 
    176     <note><para>The SSL tests may fail due to expired certificates.</para></note>
    177     </sect3>
    178    
    179     <sect3>
    180       <title>Installation (server and client)</title>
    181    
    182       <para>To install the server and client, issue the following command (as
    183       the <systemitem class="username">root</systemitem> user):</para>
    184 
    185 <screen role="root"><userinput>SEGMENTS="Client Server IniFiles ManPages SharedLibraries"
    186 SEGMENTS="$SEGMENTS Development Documentation Info Readme"
    187 
    188 for segment in $SEGMENTS; do
    189    cmake -DCMAKE_INSTALL_COMPONENT=$segment -P cmake_install.cmake
    190 done
    191 
    192 unset SEGMENTS</userinput></screen>
    193 
    194       <note><para>If you built the embedded server library add
    195       <userinput>Embedded</userinput> to the <userinput>SEGMENTS</userinput>
    196       variable above.</para></note>
    197 
    198       <tip><para>The only documentation shipped in the source tarball are
    199       <filename>mysql.info</filename> and man pages. You can download various
    200       formats of the <application>MySQL</application> Reference Manual
    201       from <ulink url="http://dev.mysql.com/doc/"/>.</para></tip>
    202 
    203     </sect3>
    204 
    205     <sect3>
    206       <title>Installation (client only)</title>
    207       <para>If you would like to install the client software only, issue the
    208       following (as <systemitem class="username">root</systemitem>):</para>
    209 
    210 <screen role="root"><userinput>SEGMENTS="Client ManPages SharedLibraries"
    211 SEGMENTS="$SEGMENTS Development Documentation Info Readme"
    212 
    213 for segment in $SEGMENTS; do
    214    cmake -DCMAKE_INSTALL_COMPONENT=$segment -P cmake_install.cmake
    215 done
    216 
    217 unset SEGMENTS</userinput></screen>
    218 
    219     </sect3>
     193    <para>
     194      To test the results, issue: <command>make test-force 2>&amp;1 | tee
     195      test.log</command>. This forces the test to run to completion and logs all
     196      the test output. There will be many tests that are not run due to
     197      configuration options and developer considerations. Otherwise many of the
     198      tests will fail. Also, two tests will fail if ipv6 is not available in
     199      the kernel either as a module or built in.
     200    </para>
     201
     202    <note>
     203      <para>
     204        The SSL tests may fail due to expired certificates.
     205      </para>
     206    </note>
     207   
     208    <para>
     209      Now, as the <systemitem class="username">root</systemitem> user:
     210    </para>
     211
     212<screen role="root"><userinput>make install</userinput></screen>
     213
     214    <tip>
     215      <para>
     216        The only documentation shipped in the source tarball are
     217        <filename>mysql.info</filename> and man pages. You can download
     218        various formats of the <application>MySQL</application>
     219        Reference Manual from <ulink url="http://dev.mysql.com/doc/"/>.
     220      </para>
     221    </tip>
    220222
    221223  </sect2>
    … …  
    224226    <title>Command Explanations</title>
    225227
    226     <para><parameter>-DWITH_&lt;engine&gt;_STORAGE_ENGINE=ON</parameter>: The default
    227     instructions only build the innobase (InnoDB) storage engine. If other
    228     storage engines are desired use this switch to enable them. Valid choices
    229     are ARCHIVE, BLACKHOLE, EXAMPLE, FEDERATED, INNOBASE, NDBCLUSTER,
    230     PARTITION and PERFSCHEMA.</para>
    231 
    232     <para><parameter>-DWITHOUT_SERVER=ON</parameter>: Use this switch if you don't
    233     want the server and would like to build the client only.</para>
    234 
    235     <para><parameter>-DWITH_EMBEDDED_SERVER=ON</parameter>: Use this switch to build
    236     the embedded server library.</para>
    237    
    238     <para><parameter>-DWITH_SSL=system</parameter>: Use this switch to build
    239     against a system version of SSL.</para>
    240 
    241     <para><command>cmake -DCMAKE_INSTALL_COMPONENT=$segment ...</command>: This
    242     command installs the appropriate portion of the package. Different
    243     segments may be added or deleted as desired.  Valid segments are listed
    244     with `<command>make list_install_components</command>`.
    245     Note that the 'DataFiles' install segment does not honor the
    246     -DMYSQL_DATADIR or -DINSTALL_MYSQLDATADIR statements and installs datafiles
    247     in <filename class="directory">/usr/data</filename>.</para>
     228    <para>
     229      <command>sed -i ...</command>: First two seds fix client-only builds. Last
     230      two seds set correct installation directories for some components.
     231    </para>
     232
     233    <para>
     234      <parameter>-DWITH_&lt;engine&gt;_STORAGE_ENGINE=ON</parameter>: The default
     235      instructions only build the innobase (InnoDB) storage engine. If other
     236      storage engines are desired use this switch to enable them. Valid choices
     237      are ARCHIVE, BLACKHOLE, EXAMPLE, FEDERATED, INNOBASE, NDBCLUSTER,
     238      PARTITION and PERFSCHEMA.
     239    </para>
     240
     241    <para>
     242      <parameter>-DWITHOUT_SERVER=ON</parameter>: Use this switch if you don't
     243      want the server and would like to build the client only.
     244    </para>
     245
     246    <para>
     247      <parameter>-DWITH_EMBEDDED_SERVER=ON</parameter>: Use this switch to build
     248      the embedded server library.
     249    </para>
     250   
     251    <para>
     252      <parameter>-DWITH_SSL=system</parameter>: This switch is used to tell the
     253      build system to use system version of the
     254      <application>OpenSSL</application>. Remove it if you didn't install
     255      <application>OpenSSL</application>.
     256    </para>
    248257
    249258  </sect2>
    … …  
    255264      <title>Config Files</title>
    256265
    257       <para><filename>/etc/my.cnf</filename> and
    258       <filename>~/.my.cnf</filename></para>
     266      <para>
     267        <filename>/etc/mysql/my.cnf</filename> and
     268        <filename>~/.my.cnf</filename>
     269      </para>
    259270
    260271      <indexterm zone="mysql mysql-config">
    … …  
    263274
    264275      <indexterm zone="mysql mysql-config">
    265         <primary sortas="e-etc-my.cnf">/etc/my.cnf</primary>
     276        <primary sortas="e-etc-mysql-my.cnf">/etc/mysql/my.cnf</primary>
    266277      </indexterm>
    267278
    … …  
    271282      <title>Configuration Information</title>
    272283
    273       <para>There are several default configuration files available in
    274       <filename class="directory">/usr/share/mysql</filename> which you can
    275       use. When creating the file, ensure binary logs are disabled unless you
    276       are doing database replication.  Create <filename>/etc/my.cnf</filename>
    277       using the following commands as the <systemitem
    278       class="username">root</systemitem> user:</para>
    279 
    280 <screen role="root"><userinput>install -v -m644 /usr/share/mysql/support/my-medium.cnf /etc/my.cnf
    281 sed -i 's/^log-bin/#log-bin/' /etc/my.cnf</userinput></screen>
    282 
    283       <para>You can now install a database and change the ownership to the
    284       unprivileged user and group (perform as the <systemitem
    285       class="username">root</systemitem> user):</para>
     284      <para>
     285        There are several default configuration files available in
     286        <filename class="directory">/usr/share/mysql</filename> which you can
     287        use. When creating the file, ensure binary logs are disabled unless you
     288        are doing database replication. Create <filename>/etc/mysql/my.cnf</filename>
     289        using the following commands as the <systemitem
     290        class="username">root</systemitem> user:
     291      </para>
     292
     293<screen role="root"><userinput>install -v -Dm644 /usr/share/mysql/support/my-medium.cnf /etc/mysql/my.cnf &amp;&amp;
     294sed -i 's/^log-bin/#log-bin/' /etc/mysql/my.cnf &amp;&amp;
     295sed -i 's/^binlog/#binlog/' /etc/mysql/my.cnf</userinput></screen>
     296
     297      <para>
     298        You can now install a database and change the ownership to the
     299        unprivileged user and group (perform as the <systemitem
     300        class="username">root</systemitem> user):
     301      </para>
    286302
    287303<screen role="root"><userinput>mysql_install_db --basedir=/usr --datadir=/srv/mysql --user=mysql &amp;&amp;
    288 chgrp -v mysql /srv/mysql{,/test,/mysql}</userinput></screen>
    289 
    290       <para>Further configuration requires that the
    291       <application>MySQL</application> server is running. Start
    292       the server using the following commands as the <systemitem
    293       class="username">root</systemitem> user:</para>
     304chown -R mysql:mysql /srv/mysql</userinput></screen>
     305
     306      <para>
     307        Further configuration requires that the
     308        <application>MySQL</application> server is running. Start
     309        the server using the following commands as the <systemitem
     310        class="username">root</systemitem> user:
     311      </para>
    294312
    295313<screen role="root"><userinput>install -v -m755 -o mysql -g mysql -d /var/run/mysql &amp;&amp;
    296314mysqld_safe --user=mysql 2&gt;&amp;1 &gt;/dev/null &amp;</userinput></screen>
    297315
    298       <para>A default installation does not set up a password for the
    299       administrator, so use the following command as the <systemitem
    300       class="username">root</systemitem> user to set one. Replace
    301       <replaceable>&lt;new-password&gt;</replaceable> with your own.</para>
     316      <para>
     317        A default installation does not set up a password for the
     318        administrator, so use the following command as the <systemitem
     319        class="username">root</systemitem> user to set one. Replace
     320        <replaceable>&lt;new-password&gt;</replaceable> with your own.
     321      </para>
    302322
    303323<screen role="root"><userinput>mysqladmin -u root password <replaceable>&lt;new-password&gt;</replaceable></userinput></screen>
    304324
    305       <para>Configuration of the server is now finished. Shut the server
    306       down using the following command as the <systemitem
    307       class="username">root</systemitem> user:</para>
     325      <para>
     326        Configuration of the server is now finished. Shut the server
     327        down using the following command as the <systemitem
     328        class="username">root</systemitem> user:
     329      </para>
    308330
    309331<screen role="root"><userinput>mysqladmin -p shutdown</userinput></screen>
    … …  
    314336      <title>Boot Script</title>
    315337
    316       <para>Install the <filename>/etc/rc.d/init.d/mysql</filename> init script
    317       included in the <xref linkend="bootscripts"/> package as
    318       the <systemitem class="username">root</systemitem> user to start the
    319       <application>MySQL</application> server during system boot-up.</para>
     338      <para>
     339        Install the <filename>/etc/rc.d/init.d/mysql</filename> init script
     340        included in the <xref linkend="bootscripts"/> package as
     341        the <systemitem class="username">root</systemitem> user to start the
     342        <application>MySQL</application> server during system boot-up.
     343      </para>
    320344
    321345      <indexterm zone="mysql mysql-init">
    … …  
    338362
    339363      <seglistitem>
    340         <seg>innochecksum, msql2mysql, my_print_defaults, myisam_ftdump,
    341         myisamchk, myisamlog, myisampack, mysql, mysql_client_test,
    342         mysql_config, mysql_convert_table_format, mysql_find_rows,
    343         mysql_fix_extensions, mysql_install_db, mysql_plugin,
    344         mysql_secure_installation, mysql_setpermission, mysql_tzinfo_to_sql,
    345         mysql_upgrade, mysql_waitpid, mysql_zap, mysqlaccess, mysqladmin,
    346         mysqlbinlog, mysqlbug, mysqlcheck, mysqld, mysqld_multi, mysqld_safe,
    347         mysqldump, mysqldumpslow, mysqlhotcopy, mysqlimport, mysqlshow,
    348         mysqlslap, mysqltest, perror, replace, resolve_stack_dump and
    349         resolveip</seg>
    350         <seg>libmysqlclient.{so,a}, libmysqlclient_r.{so,a}, libmysqlservices.a
    351         and several in /usr/lib/mysql</seg>
    352         <seg>/srv/mysql, /usr/include/mysql, /usr/lib/mysql, /usr/share/mysql and
    353         /var/run/mysql</seg>
     364        <seg>
     365          innochecksum, msql2mysql, myisamchk, myisam_ftdump, myisamlog,
     366          myisampack, my_print_defaults, mysql, mysqlaccess, mysqlaccess.conf,
     367          mysqladmin, mysqlbinlog, mysqlbug, mysqlcheck, mysql_client_test,
     368          mysql_client_test_embedded, mysql_config, mysql_convert_table_format,
     369          mysqld, mysqld_multi, mysqld_safe, mysqldump, mysqldumpslow,
     370          mysql_embedded, mysql_find_rows, mysql_fix_extensions, mysqlhotcopy,
     371          mysqlimport, mysql_install_db, mysql_plugin, mysql_secure_installation,
     372          mysql_setpermission, mysqlshow, mysqlslap, mysqltest,
     373          mysqltest_embedded, mysql_tzinfo_to_sql, mysql_upgrade, mysql_waitpid,
     374          mysql_zap, perror, replace, resolveip and resolve_stack_dump
     375        </seg>
     376        <seg>
     377          libmysqlclient.{so,a}, libmysqlclient_r.{so,a}, libmysqld.{so,a},
     378          libmysqlservices.a and several in /usr/lib/mysql
     379        </seg>
     380        <seg>
     381          /etc/mysql,
     382          /srv/mysql,
     383          /usr/include/mysql,
     384          /usr/lib/mysql,
     385          /usr/share/doc/mysql and
     386          /usr/share/mysql
     387        </seg>
    354388      </seglistitem>
    355389    </segmentedlist>
    … …  
    357391    <bridgehead renderas="sect3">Short Descriptions</bridgehead>
    358392
    359     <para>Descriptions of all the programs and libraries would be several
    360     pages long. Instead, consult the <filename>mysql.info</filename>
    361     documentation or the on-line reference manual at <ulink
    362     url="http://dev.mysql.com/doc/refman/5.5/en/index.html"/>.</para>
    363 
    364     <para>The <application>Perl</application> DBI modules must be installed
    365     for some of the <application>MySQL</application> support programs to
    366     function properly.</para>
     393    <para>
     394      Descriptions of all the programs and libraries would be several
     395      pages long. Instead, consult the <filename>mysql.info</filename>
     396      documentation or the on-line reference manual at <ulink
     397      url="http://dev.mysql.com/doc/refman/5.5/en/index.html"/>.
     398    </para>
     399
     400    <para>
     401      The <application>Perl</application> DBI modules must be installed
     402      for some of the <application>MySQL</application> support programs to
     403      function properly.
     404    </para>
    367405
    368406  </sect2>

  • x/wm/sawfish.xml

    r4a29e2b rcd34755  
    6464    <para role="required">
    6565       <xref linkend="rep-gtk"/> and
     66       <xref linkend="which"/>
    6667    </para>
    6768
Note: See TracChangeset for help on using the changeset viewer.