OpenPKG Specs: mysql/mysql.spec@3b08e6396b45 (annotated)

mysql/mysql.spec@3b08e6396b45 (annotated)

mysql/mysql.spec

Tue, 28 Aug 2012 18:28:45 +0200

author: Michael Schloh von Bennewitz <michael@schloh.com>
date: Tue, 28 Aug 2012 18:28:45 +0200
changeset 528: 3b08e6396b45
parent 527: 7b145ccff1e9
child 698: 31b10e374497
permissions: -rw-r--r--

Massively update from 5.1 to 5.5 release, completely changing from
autotools to cmake build configuration along with the corresponding
corrections. Correct some less important problems like typical german
english mistakes, as well as use parallel make for faster builds with
SMP and multicore architectures. Warning, the 5.5 releases of MySQL
seem to be equally bug ridden as the 5.1 are, for example building
the NDBCluster storage engine fails.

 ##
 ##  mysql.spec -- OpenPKG RPM Package Specification
 ##  Copyright (c) 2000-2012 OpenPKG Foundation e.V. <http://openpkg.net/>
 ##
 ##  Permission to use, copy, modify, and distribute this software for
 ##  any purpose with or without fee is hereby granted, provided that
 ##  the above copyright notice and this permission notice appear in all
 ##  copies.
 ##
 ##  THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
 ##  WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
 ##  MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
 ##  IN NO EVENT SHALL THE AUTHORS AND COPYRIGHT HOLDERS AND THEIR
 ##  CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 ##  SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 ##  LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
 ##  USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 ##  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
 ##  OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
 ##  OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
 ##  SUCH DAMAGE.
 ##
 #   package version
 %define       V_major   5.5
 %define       V_minor   27
 %define       V_mysql   %{V_major}.%{V_minor}
 %define       V_opkg    %{V_major}.%{V_minor}
 %define       V_jdbc    5.1.21
 #   package information
 Name:         mysql
 Summary:      Fast Relational Database Management System
 URL:          http://www.mysql.com/products/mysql/
 Vendor:       ORACLE
 Packager:     OpenPKG Foundation e.V.
 Distribution: OpenPKG Community
 Class:        BASE
 Group:        Database
 License:      GPL
 Version:      %{V_opkg}
 Release:      20120800
 #   package options
 %option       with_server      yes
 %option       with_innobase    yes
 %option       with_archive     no
 %option       with_blackhole   no
 %option       with_federated   no
 %option       with_ndbcluster  no
 %option       with_partition   no
 %option       with_perfschema  no
 %option       with_ssl         no
 %option       with_embedded    no
 %option       with_charset     utf8
 %option       with_collation   utf8_unicode_ci
 %option       with_jdbc        no
 #   fixing implicit interplugin dependencies and correlations
 %if "%{with_ndbcluster}" == "yes"
 %undefine     with_partition
 %define       with_partition   yes
 %endif
 #   list of sources
 Source0:      http://www.mysql.com/Downloads/MySQL-%{V_major}/mysql-%{V_mysql}.tar.gz
 Source1:      http://ftp.gwdg.de/pub/misc/mysql/Downloads/Connector-J/mysql-connector-java-%{V_jdbc}.tar.gz
 Source2:      my.cnf
 Source3:      my.pwd
 Source4:      rc.mysql
 Patch0:       mysql.patch
 #   build information
 BuildPreReq:  OpenPKG, openpkg >= 20100101, perl, make, gcc, gcc::with_cxx = yes
 PreReq:       OpenPKG, openpkg >= 20100101, perl
 BuildPreReq:  zlib, readline, ncurses
 PreReq:       zlib, readline, ncurses
 %if "%{with_ssl}" == "yes"
 BuildPreReq:  openssl
 PreReq:       openssl
 %endif
 %if "%{with_jdbc}" == "yes"
 PreReq:       java, JAVA-JDK
 %endif
 %description
     MySQL is a multiuser Relational Database Management System (RDBMS),
     which is controlled through Structured Query Language (SQL)
     operating in full multithreading mode. The main goals of MySQL are
     speed, robustness and ease of use. MySQL was originally developed
     because of the need for a SQL server that could handle very big
     databases with magnitude higher speed than what any database vendor
     could offer.
 %track
     prog mysql = {
         version   = %{V_mysql}
         url       = http://dev.mysql.com/downloads/mysql/%{V_major}.html
         regex     = mysql-(__VER__)\.tar\.gz
     }
     prog mysql:connector-jdbc = {
         version   = %{V_jdbc}
         url       = http://dev.mysql.com/downloads/connector/j/%{V_major}.html
         regex     = mysql-connector-java-(__VER__)\.tar\.gz
     }
 %prep
     %setup -q
 %if "%{with_jdbc}" == "yes"
     %setup -q -T -D -a 1
 %endif
     %patch -p0
     #   patch file search path
     %{l_shtool} subst %{l_value -s -a} \
         mysys/default.c
     #   fix shebang on supplemental Perl scripts
     rm -f scripts/*.orig
     %{l_shtool} subst \
         -e 's;^#!/usr/bin/perl;#!%{l_prefix}/bin/perl;' \
         scripts/*
 %build
     #   create build subdirectory
     %{l_shtool} mkdir -p objbld
     cd objbld
     #   configure environment
     export CC="%{l_cc}"
     export CXX="%{l_cxx}"
     export CFLAGS="%{l_cflags -O}"
     export CXXFLAGS="%{l_cxxflags -O} -felide-constructors -fno-exceptions -fno-rtti"
     export CPPFLAGS="%{l_cppflags ncurses}"
     export LDFLAGS="-L`pwd`/libmysql %{l_ldflags}"
     export LIBS="-lz"
     #   Configure source tree.
     #   Tips are in mysql_release.cmake
     #   or run cmake(1) -L for all opts
     #   Disable dtrace(1) to avoid 'mysqld_dtrace_all.o: file not recognized: Bad value'
     %{l_prefix}/bin/cmake \
         -DCMAKE_INSTALL_PREFIX="%{l_prefix}" \
         -DCMAKE_BUILD_TYPE="RelWithDebInfo" \
         -DINSTALL_DOCDIR="share/mysql/doc" \
         -DINSTALL_DOCREADMEDIR="share/mysql/doc" \
         -DINSTALL_INCLUDEDIR="include/mysql" \
         -DINSTALL_INFODIR:STRING="info" \
         -DINSTALL_MYSQLSHAREDIR="share/mysql" \
         -DINSTALL_SBINDIR="libexec/mysql" \
         -DINSTALL_SHAREDIR="share/mysql" \
         -DINSTALL_SCRIPTDIR="bin" \
         -DINSTALL_SUPPORTFILESDIR="share/mysql" \
         -DMYSQL_UNIX_ADDR="%{l_prefix}/var/mysql/mysql.sock" \
         -DFEATURE_SET="community" \
         -DCOMPILATION_COMMENT="%{l_openpkg_release}" \
         -DMANUFACTURER="Built from OpenPKG sources" \
         -DDEFAULT_CHARSET="%{with_charset}" \
         -DDEFAULT_COLLATION="%{with_collation}" \
         -DMYSQL_USER="%{l_musr}" \
         -DWITH_ZLIB=system \
         -DWITH_READLINE=YES \
         -DWITH_LIBEDIT=NO \
         -DWITH_LIBWRAP=NO \
         -DDISABLE_SHARED=YES \
         -DENABLE_DTRACE=NO \
         -DZLIB_INCLUDE_DIR=%{l_cppflags zlib} \
         -DPKG_CONFIG_EXECUTABLE="PKG_CONFIG_EXECUTABLE-NOTFOUND" \
 %if "%{with_server}" != "yes"
         -DWITHOUT_SERVER=YES \
 %endif
 %if "%{with_ssl}" == "yes"
         -DWITH_SSL=system \
         -DOPENSSL_INCLUDE_DIR="%{l_cppflags openssl}" \
         -DOPENSSL_SSL_LIBRARY="%{l_prefix}/lib/libssl.a" \
         -DOPENSSL_CRYPTO_LIBRARY="%{l_prefix}/lib/libcrypto.a" \
         -DCRYPTO_LIBRARY="%{l_prefix}/lib/libcrypto.a" \
 %else
         -DWITH_SSL=NO \
 %endif
 %if "%{with_innobase}" == "yes"
         -DWITH_INNOBASE_STORAGE_ENGINE=YES \
 %else
         -DWITH_INNOBASE_STORAGE_ENGINE=NO \
 %endif
 %if "%{with_archive}" == "yes"
         -DWITH_ARCHIVE_STORAGE_ENGINE=YES \
 %else
         -DWITH_ARCHIVE_STORAGE_ENGINE=NO \
 %endif
 %if "%{with_blackhole}" == "yes"
         -DWITH_BLACKHOLE_STORAGE_ENGINE=YES \
 %else
         -DWITH_BLACKHOLE_STORAGE_ENGINE=NO \
 %endif
 %if "%{with_federated}" == "yes"
         -DWITH_FEDERATED_STORAGE_ENGINE=YES \
 %else
         -DWITH_FEDERATED_STORAGE_ENGINE=NO \
 %endif
 %if "%{with_ndbcluster}" == "yes"
         -DWITH_NDBCLUSTER_STORAGE_ENGINE=YES \
 %else
         -DWITH_NDBCLUSTER_STORAGE_ENGINE=NO \
 %endif
 %if "%{with_partition}" == "yes"
         -DWITH_PARTITION_STORAGE_ENGINE=YES \
 %else
         -DWITH_PARTITION_STORAGE_ENGINE=NO \
 %endif
 %if "%{with_perfschema}" == "yes"
         -DWITH_PERFSCHEMA_STORAGE_ENGINE=YES \
 %else
         -DWITH_PERFSCHEMA_STORAGE_ENGINE=NO \
 %endif
 %if "%{with_embedded}" == "yes"
         -DWITH_EMBEDDED_SERVER=YES \
 %else
         -DWITH_EMBEDDED_SERVER=NO \
 %endif
         ..
     #   build source tree (VERBOSE=1)
     %{l_make} %{l_mflags -O}
 %install
     #   install from build subdirectory
     cd objbld
     ##   patch init script (this broken)
     #%{l_shtool} subst %{l_value -s -a} \
     #    bin/mysql_install_db.sh
     #   perform standard installation procedure
     %{l_make} %{l_mflags} install \
         DESTDIR=$RPM_BUILD_ROOT
     #   cleanup scripts
     %{l_shtool} subst \
         -e 's;^\(ldflags=.\).*\(.\)$;\1%{l_ldflags}\2;' \
         $RPM_BUILD_ROOT%{l_prefix}/bin/mysql_config
     #   move utilities, patched for new paths
     mv $RPM_BUILD_ROOT%{l_prefix}/bin/replace \
        $RPM_BUILD_ROOT%{l_prefix}/libexec/mysql/
     #   strip installation area
     rm -rf $RPM_BUILD_ROOT%{l_prefix}/data
     rm -rf $RPM_BUILD_ROOT%{l_prefix}/mysql-test
     rm -rf $RPM_BUILD_ROOT%{l_prefix}/sql-bench
     rm -f  $RPM_BUILD_ROOT%{l_prefix}/share/mysql/binary-configure
     rm -f  $RPM_BUILD_ROOT%{l_prefix}/share/mysql/ndb-config-2-node.ini
     strip  $RPM_BUILD_ROOT%{l_prefix}/bin/* 2>/dev/null || true
     strip  $RPM_BUILD_ROOT%{l_prefix}/libexec/mysql/* 2>/dev/null || true
 %if "%{with_ndbcluster}" == "yes"
     rm -f  $RPM_BUILD_ROOT%{l_prefix}/bin/ndb*
     rm -f  $RPM_BUILD_ROOT%{l_prefix}/man/man1/ndb*
     rm -f  $RPM_BUILD_ROOT%{l_prefix}/man/man8/ndb*
     rm -rf $RPM_BUILD_ROOT%{l_prefix}/include/mysql/storage/ndb
     rm -f  $RPM_BUILD_ROOT%{l_prefix}/lib/mysql/libndb*
     rm -f  $RPM_BUILD_ROOT%{l_prefix}/libexec/mysql/ndb*
 %endif
     #   install global configuration
     %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/etc/mysql
     sed <%{SOURCE my.cnf} >my.cnf \
 %if "%{with_innobase}" == "yes"
         -e '/<\/\{0,1\}with_innobase>/d'
 %else
         -e '/<with_innobase>/,/<\/with_innobase>/d'
 %endif
     %{l_shtool} install -c -m 644 %{l_value -s -a} \
         my.cnf \
         $RPM_BUILD_ROOT%{l_prefix}/etc/mysql/
     %{l_shtool} install -c -m 600 \
         %{SOURCE my.pwd} \
         $RPM_BUILD_ROOT%{l_prefix}/etc/mysql/
     #   install runcommand script
     %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d
     %{l_shtool} install -c -m 755 %{l_value -s -a} \
         %{SOURCE rc.mysql} $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d/
     #   mitigate complex buildconf
     %{l_shtool} install -c -m 644 \
         INSTALL-SOURCE $RPM_BUILD_ROOT%{l_prefix}/share/mysql/doc/
     #   make sure the database directory exists
     %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/var/mysql
     #   directory for temporary tables
     %{l_shtool} mkdir -f -p -m 700 $RPM_BUILD_ROOT%{l_prefix}/var/mysql/tmp
     #   optional client-only installation
 %if "%{with_server}" != "yes"
     rm -rf $RPM_BUILD_ROOT%{l_prefix}/libexec/mysql
     ( cd $RPM_BUILD_ROOT%{l_prefix}/bin
       for bin in *; do
           case "$bin" in
               mysql | mysql_config ) ;;
               * ) rm -f $bin ;;
           esac
       done
     ) || exit $?
     ( cd $RPM_BUILD_ROOT%{l_prefix}/man/man1
       for man in *; do
           case "$man" in
               mysql.1 | mysql_config.1 ) ;;
               * ) rm -f $man ;;
           esac
       done
     ) || exit $?
 %endif
     #   install JDBC driver
 %if "%{with_jdbc}" == "yes"
     ( cd mysql-connector-java-%{V_jdbc}
       %{l_shtool} install -c -m 644 \
           mysql-connector-java-%{V_jdbc}-bin.jar \
           $RPM_BUILD_ROOT%{l_prefix}/lib/mysql/mysql.jar
     ) || exit $?
 %endif
     #   determine the package files
     %{l_rpmtool} files -v -ofiles -r$RPM_BUILD_ROOT \
 %if "%{with_server}" == "yes"
         '%config %attr(644,%{l_musr},%{l_mgrp}) %{l_prefix}/etc/mysql/my.cnf' \
         '%config %attr(600,%{l_susr},%{l_mgrp}) %{l_prefix}/etc/mysql/my.pwd' \
         '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/mysql' \
         '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/mysql/tmp' \
 %endif
         %{l_files_std}
 %files -f objbld/files
 %clean
 %pre
 %if "%{with_server}" == "yes"
     #   before upgrade, save status and stop service
     [ $1 -eq 2 ] || exit 0
     eval `%{l_rc} mysql status 2>/dev/null | tee %{l_tmpfile}`
     %{l_rc} mysql stop 2>/dev/null
 %endif
     exit 0
 %post
 %if "%{with_server}" == "yes"
     if [ $1 -eq 1 ]; then
         #   after install, create initial database
         $RPM_INSTALL_PREFIX/bin/mysql_install_db \
             --defaults-file=$RPM_INSTALL_PREFIX/etc/mysql/my.cnf >/dev/null 2>&1
         chown -R %{l_rusr}:%{l_rgrp} $RPM_INSTALL_PREFIX/var/mysql/*
         ( echo "An initial MySQL DB was created. The owner of the database"
           echo "is the DB user 'root'. Its initial password is empty."
           echo "After starting MySQL with..."
           echo ""
           echo "  \$ $RPM_INSTALL_PREFIX/bin/openpkg rc mysql start"
           echo ""
           echo "...you should change the password as soon as possible with:"
           echo ""
           echo "  \$ $RPM_INSTALL_PREFIX/bin/mysqladmin \\ "
           echo "    -u root password '<new-password>'"
           echo ""
           echo "Additionally, because the MySQL package includes automated"
           echo "maintenance procedures that require administrator access to"
           echo "the database, you must maintain a (plain text) copy of the"
           echo "administrator account name and password:"
           echo ""
           echo "  \$ vi $RPM_INSTALL_PREFIX/etc/mysql/my.pwd"
         ) | %{l_rpmtool} msg -b -t notice
     fi
     if [ $1 -eq 2 ]; then
         #   after upgrade, restore status
         { eval `cat %{l_tmpfile}`; rm -f %{l_tmpfile}; true; } >/dev/null 2>&1
         [ ".$mysql_active" = .yes ] && %{l_rc} mysql start
     fi
 %endif
     exit 0
 %preun
 %if "%{with_server}" == "yes"
     #   before erase, stop service and remove log files
     [ $1 -eq 0 ] || exit 0
     %{l_rc} mysql stop 2>/dev/null
     rm -f $RPM_INSTALL_PREFIX/var/mysql/*.log* >/dev/null 2>&1 || true
     rm -f $RPM_INSTALL_PREFIX/var/mysql/*.err* >/dev/null 2>&1 || true
 %endif
     exit 0

OpenPKG Specs / annotate

mysql/mysql.spec@3b08e6396b45 (annotated)

mysql/mysql.spec