# Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; version 2 of the License. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; see the file COPYING. If not, write to the # Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston # MA 02110-1301 USA. ############################################################################## # Some common macro definitions ############################################################################## # NOTE: "vendor" is used in upgrade/downgrade check, so you can't # change these, has to be exactly as is. %define mysql_old_vendor MySQL AB %define mysql_vendor_2 Sun Microsystems, Inc. %define mysql_vendor Oracle and/or its affiliates %define mysql_version 5.1.53 %define mysqld_user mysql %define mysqld_group mysql %define mysqldatadir /var/lib/mysql %define see_base For a description of MySQL see the base MySQL RPM or http://www.mysql.com # ------------------------------------------------------------------------------ # On SuSE 9 no separate "debuginfo" package is built. To enable basic # debugging on that platform, we don't strip binaries on SuSE 9. We # disable the strip of binaries by redefining the RPM macro # "__os_install_post" leaving out the script calls that normally does # this. We do this in all cases, as on platforms where "debuginfo" is # created, a script "find-debuginfo.sh" will be called that will do # the strip anyway, part of separating the executable and debug # information into separate files put into separate packages. # # Some references (shows more advanced conditional usage): # http://www.redhat.com/archives/rpm-list/2001-November/msg00257.html # http://www.redhat.com/archives/rpm-list/2003-February/msg00275.html # http://www.redhat.com/archives/rhl-devel-list/2004-January/msg01546.html # http://lists.opensuse.org/archive/opensuse-commit/2006-May/1171.html # ------------------------------------------------------------------------------ %define __os_install_post /usr/lib/rpm/brp-compress # ------------------------------------------------------------------------------ # We don't package all files installed into the build root by intention - # See BUG#998 for details. # ------------------------------------------------------------------------------ %define _unpackaged_files_terminate_build 0 # ------------------------------------------------------------------------------ # RPM build tools now automatically detects Perl module dependencies. This # detection gives problems as it is broken in some versions, and it also # give unwanted dependencies from mandatory scripts in our package. # Might not be possible to disable in all RPM tool versions, but here we # try. We keep the "AutoReqProv: no" for the "test" sub package, as disabling # here might fail, and that package has the most problems. # See http://fedoraproject.org/wiki/Packaging/Perl#Filtering_Requires:_and_Provides # http://www.wideopen.com/archives/rpm-list/2002-October/msg00343.html # ------------------------------------------------------------------------------ %undefine __perl_provides %undefine __perl_requires ############################################################################## # Command line handling ############################################################################## # ---------------------------------------------------------------------- # use "rpmbuild --with yassl" or "rpm --define '_with_yassl 1'" (for RPM 3.x) # to build with yaSSL support (off by default) # ---------------------------------------------------------------------- %{?_with_yassl:%define YASSL_BUILD 1} %{!?_with_yassl:%define YASSL_BUILD 0} # ---------------------------------------------------------------------- # use "rpmbuild --without bundled_zlib" or "rpm --define '_without_bundled_zlib 1'" # (for RPM 3.x) to not build using the bundled zlib (on by default) # ---------------------------------------------------------------------- %{!?_with_bundled_zlib: %{!?_without_bundled_zlib: %define WITH_BUNDLED_ZLIB 1}} %{?_with_bundled_zlib:%define WITH_BUNDLED_ZLIB 1} %{?_without_bundled_zlib:%define WITH_BUNDLED_ZLIB 0} # ---------------------------------------------------------------------- # use "rpmbuild --without innodb_plugin" or "rpm --define '_without_innodb_plugin 1'" # (for RPM 3.x) to not build the innodb plugin (on by default with innodb builds) # ---------------------------------------------------------------------- %{!?_with_innodb_plugin: %{!?_without_innodb_plugin: %define WITH_INNODB_PLUGIN 1}} %{?_with_innodb_plugin:%define WITH_INNODB_PLUGIN 1} %{?_without_innodb_plugin:%define WITH_INNODB_PLUGIN 0} # ---------------------------------------------------------------------- # use "rpmbuild --with cluster" or "rpm --define '_with_cluster 1'" (for RPM 3.x) # to build with cluster support (off by default) # ---------------------------------------------------------------------- %{?_with_cluster:%define CLUSTER_BUILD 1} %{!?_with_cluster:%define CLUSTER_BUILD 0} ############################################################################## # Product definitions - set for a "community" package ############################################################################## %define server_suffix -community %define package_suffix -community %define ndbug_comment MySQL Community Server (GPL) %define debug_comment MySQL Community Server - Debug (GPL) %define commercial 0 %define EMBEDDED_BUILD 1 %define PARTITION_BUILD 1 # Default for CLUSTER_BUILD is "0", but command line option may override it %define COMMUNITY_BUILD 1 %define INNODB_BUILD 1 %define NORMAL_TEST_MODE test-bt %define DEBUG_TEST_MODE test-bt-debug %define release 1.glibc23 %define mysql_license GPL %define src_dir mysql-%{mysql_version} ############################################################################## # Main spec file section ############################################################################## Name: MySQL Summary: MySQL: a very fast and reliable SQL database server Group: Applications/Databases Version: 5.1.53 Release: %{release} License: Copyright 2000-2008 MySQL AB, 2010 %{mysql_vendor} All rights reserved. Use is subject to license terms. Under %{mysql_license} license as shown in the Description field. Source: http://www.mysql.com/Downloads/MySQL-5.1/%{src_dir}.tar.gz URL: http://www.mysql.com/ Packager: %{mysql_vendor} Product Engineering Team Vendor: %{mysql_vendor} Provides: msqlormysql MySQL-server mysql BuildRequires: ncurses-devel Obsoletes: mysql # Think about what you use here since the first step is to # run a rm -rf BuildRoot: %{_tmppath}/%{name}-%{version}-build # From the manual %description The MySQL(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. MySQL is a trademark of %{mysql_vendor} Copyright 2000-2008 MySQL AB, 2010 %{mysql_vendor} All rights reserved. Use is subject to license terms. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license. The MySQL web site (http://www.mysql.com/) provides the latest news and information about the MySQL software. Also please see the documentation and the manual for more information. ############################################################################## # Sub package definition ############################################################################## %package server Summary: MySQL: a very fast and reliable SQL database server Group: Applications/Databases Requires: coreutils grep procps /usr/sbin/useradd /usr/sbin/groupadd /sbin/chkconfig Provides: msqlormysql mysql-server mysql MySQL Obsoletes: MySQL mysql mysql-server %description server The MySQL(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. MySQL is a trademark of %{mysql_vendor} Copyright 2000-2008 MySQL AB, 2010 %{mysql_vendor} All rights reserved. Use is subject to license terms. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license. The MySQL web site (http://www.mysql.com/) provides the latest news and information about the MySQL software. Also please see the documentation and the manual for more information. This package includes the MySQL server binary %if %{INNODB_BUILD} (configured including InnoDB) %endif as well as related utilities to run and administer a MySQL server. If you want to access and work with the database, you have to install package "MySQL-client" as well! # ------------------------------------------------------------------------------ %package client Summary: MySQL - Client Group: Applications/Databases Obsoletes: mysql-client Provides: mysql-client %description client This package contains the standard MySQL clients and administration tools. %{see_base} # ------------------------------------------------------------------------------ %if %{CLUSTER_BUILD} %package ndb-storage Summary: MySQL - ndbcluster storage engine Group: Applications/Databases %description ndb-storage This package contains the ndbcluster storage engine. It is necessary to have this package installed on all computers that should store ndbcluster table data. %{see_base} # ------------------------------------------------------------------------------ %package ndb-management Summary: MySQL - ndbcluster storage engine management Group: Applications/Databases %description ndb-management This package contains ndbcluster storage engine management. It is necessary to have this package installed on at least one computer in the cluster. %{see_base} # ------------------------------------------------------------------------------ %package ndb-tools Summary: MySQL - ndbcluster storage engine basic tools Group: Applications/Databases %description ndb-tools This package contains ndbcluster storage engine basic tools. %{see_base} # ------------------------------------------------------------------------------ %package ndb-extra Summary: MySQL - ndbcluster storage engine extra tools Group: Applications/Databases %description ndb-extra This package contains some extra ndbcluster storage engine tools for the advanced user. They should be used with caution. %{see_base} %endif # ------------------------------------------------------------------------------ %package test Requires: %{name}-client perl Summary: MySQL - Test suite Group: Applications/Databases Provides: mysql-test Obsoletes: mysql-bench mysql-test AutoReqProv: no %description test This package contains the MySQL regression test suite. %{see_base} # ------------------------------------------------------------------------------ %package devel Summary: MySQL - Development header files and libraries Group: Applications/Databases Provides: mysql-devel Obsoletes: mysql-devel %description devel This package contains the development header files and libraries necessary to develop MySQL client applications. %{see_base} # ------------------------------------------------------------------------------ %package shared Summary: MySQL - Shared libraries Group: Applications/Databases %description shared This package contains the shared libraries (*.so*) which certain languages and applications need to dynamically load and use MySQL. # ------------------------------------------------------------------------------ %if %{EMBEDDED_BUILD} %package embedded Requires: %{name}-devel Summary: MySQL - embedded library Group: Applications/Databases Obsoletes: mysql-embedded %description embedded This package contains the MySQL server as an embedded library. The embedded MySQL server library makes it possible to run a full-featured MySQL server inside the client application. The main benefits are increased speed and more simple management for embedded applications. The API is identical for the embedded MySQL version and the client/server version. %{see_base} %endif ############################################################################## # ############################################################################## %prep # We unpack the source two times, for 'debug' and 'release' build. %setup -T -a 0 -c -n mysql-%{mysql_version} mv mysql-%{mysql_version} mysql-debug-%{mysql_version} %setup -D -T -a 0 -n mysql-%{mysql_version} mv mysql-%{mysql_version} mysql-release-%{mysql_version} ############################################################################## # The actual build ############################################################################## %build BuildMySQL() { # Let "MYSQL_BUILD_*FLAGS" take precedence. CFLAGS=${MYSQL_BUILD_CFLAGS:-$CFLAGS} CXXFLAGS=${MYSQL_BUILD_CXXFLAGS:-$CXXFLAGS} LDFLAGS=${MYSQL_BUILD_LDFLAGS:-$LDFLAGS} # Fall back on RPM_OPT_FLAGS (part of RPM environment) if no flags are given. CFLAGS=${CFLAGS:-$RPM_OPT_FLAGS} CXXFLAGS=${CXXFLAGS:-$RPM_OPT_FLAGS -felide-constructors -fno-exceptions -fno-rtti } # Evaluate current setting of $DEBUG if [ $DEBUG -gt 0 ] ; then OPT_COMMENT='--with-comment="%{debug_comment}"' OPT_DEBUG='--with-debug' CFLAGS=`echo " $CFLAGS " | \ sed -e 's/ -O[0-9]* / /' -e 's/ -unroll2 / /' -e 's/ -ip / /' \ -e 's/^ //' -e 's/ $//'` CXXFLAGS=`echo " $CXXFLAGS " | \ sed -e 's/ -O[0-9]* / /' -e 's/ -unroll2 / /' -e 's/ -ip / /' \ -e 's/^ //' -e 's/ $//'` else OPT_COMMENT='--with-comment="%{ndbug_comment}"' OPT_DEBUG='' fi # The --enable-assembler simply does nothing on systems that does not # support assembler speedups. sh -c "PATH=\"${MYSQL_BUILD_PATH:-$PATH}\" \ CC=\"${MYSQL_BUILD_CC:-$CC}\" \ CXX=\"${MYSQL_BUILD_CXX:-$CXX}\" \ CFLAGS=\"$CFLAGS\" \ CXXFLAGS=\"$CXXFLAGS\" \ LDFLAGS=\"$LDFLAGS\" \ ./configure \ $* \ --with-mysqld-ldflags='-static' \ --with-client-ldflags='-static' \ --enable-assembler \ --enable-local-infile \ --with-fast-mutexes \ --with-mysqld-user=%{mysqld_user} \ --with-unix-socket-path=/var/lib/mysql/mysql.sock \ --with-pic \ --prefix=/ \ %if %{CLUSTER_BUILD} --with-extra-charsets=all \ %else --with-extra-charsets=complex \ %endif %if %{YASSL_BUILD} --with-ssl \ %else --without-ssl \ %endif --exec-prefix=%{_exec_prefix} \ --libexecdir=%{_sbindir} \ --libdir=%{_libdir} \ --sysconfdir=%{_sysconfdir} \ --datadir=%{_datadir} \ --localstatedir=%{mysqldatadir} \ --infodir=%{_infodir} \ --includedir=%{_includedir} \ --mandir=%{_mandir} \ --enable-thread-safe-client \ $OPT_COMMENT \ $OPT_DEBUG \ --with-readline \ %if %{WITH_BUNDLED_ZLIB} --with-zlib-dir=bundled \ %endif %if %{CLUSTER_BUILD} --with-plugin-ndbcluster \ %else --without-plugin-ndbcluster \ %endif %if %{INNODB_BUILD} --with-plugin-innobase \ %if %{WITH_INNODB_PLUGIN} %else --without-plugin-innodb_plugin \ %endif %else --without-plugin-innobase \ --without-plugin-innodb_plugin \ %endif %if %{PARTITION_BUILD} --with-plugin-partition \ %else --without-plugin-partition \ %endif --with-plugin-csv \ --with-plugin-archive \ --with-plugin-blackhole \ --with-plugin-federated \ --without-plugin-daemon_example \ --without-plugin-ftexample \ %if %{EMBEDDED_BUILD} --with-embedded-server \ %else --without-embedded-server \ %endif --with-big-tables \ --enable-shared \ " make } # end of function definition "BuildMySQL" # Use our own copy of glibc OTHER_LIBC_DIR=/usr/local/mysql-glibc USE_OTHER_LIBC_DIR="" if test -d "$OTHER_LIBC_DIR" then USE_OTHER_LIBC_DIR="--with-other-libc=$OTHER_LIBC_DIR" fi # Use the build root for temporary storage of the shared libraries. RBR=$RPM_BUILD_ROOT # Clean up the BuildRoot first [ "$RBR" != "/" ] && [ -d $RBR ] && rm -rf $RBR; mkdir -p $RBR%{_libdir}/mysql # # Use MYSQL_BUILD_PATH so that we can use a dedicated version of gcc # PATH=${MYSQL_BUILD_PATH:-/bin:/usr/bin} export PATH # Build the Debug binary. # Use gcc for C and C++ code (to avoid a dependency on libstdc++ and # including exceptions into the code if [ -z "$CXX" -a -z "$CC" ] ; then export CC="gcc" CXX="gcc" fi ############################################################################## # # Build the debug version # ############################################################################## ( # We are in a subshell, so we can modify variables just for one run. # Add -g and --with-debug. DEBUG=1 cd mysql-debug-%{mysql_version} && CFLAGS="$CFLAGS" \ CXXFLAGS="$CXXFLAGS" \ BuildMySQL ) # We might want to save the config log file if test -n "$MYSQL_DEBUGCONFLOG_DEST" then cp -fp mysql-debug-%{mysql_version}/config.log "$MYSQL_DEBUGCONFLOG_DEST" fi (cd mysql-debug-%{mysql_version} ; make test-bt-debug) ############################################################################## # # Build the release binary # ############################################################################## DEBUG=0 (cd mysql-release-%{mysql_version} && CFLAGS="$CFLAGS" \ CXXFLAGS="$CXXFLAGS" \ BuildMySQL ) # We might want to save the config log file if test -n "$MYSQL_CONFLOG_DEST" then cp -fp mysql-release-%{mysql_version}/config.log "$MYSQL_CONFLOG_DEST" fi (cd mysql-release-%{mysql_version} ; make test-bt) ############################################################################## # For gcc builds, include libgcc.a in the devel subpackage (BUG 4921) # Some "icc" calls may have "gcc" in the argument string, so we should first # check for "icc". (If we don't check, the "--print-libgcc-file" call will fail.) if expr "$CC" : ".*icc.*" > /dev/null ; then %define WITH_LIBGCC 0 : elif expr "$CC" : ".*gcc.*" > /dev/null ; then libgcc=`$CC $CFLAGS --print-libgcc-file` if [ -f $libgcc ] then %define WITH_LIBGCC 1 install -m 644 $libgcc $RBR%{_libdir}/mysql/libmygcc.a else %define WITH_LIBGCC 0 : fi else %define WITH_LIBGCC 0 : fi ############################################################################## %install RBR=$RPM_BUILD_ROOT MBD=$RPM_BUILD_DIR/mysql-%{mysql_version}/mysql-release-%{mysql_version} # Ensure that needed directories exists install -d $RBR%{_sysconfdir}/{logrotate.d,init.d} install -d $RBR%{mysqldatadir}/mysql install -d $RBR%{_datadir}/mysql-test install -d $RBR%{_includedir} install -d $RBR%{_libdir} install -d $RBR%{_mandir} install -d $RBR%{_sbindir} # Install all binaries (cd $MBD && make install DESTDIR=$RBR testroot=%{_datadir}) # Old packages put shared libs in %{_libdir}/ (not %{_libdir}/mysql), so do # the same here. mv $RBR/%{_libdir}/mysql/*.so* $RBR/%{_libdir}/ # install "mysqld-debug" $MBD/libtool --mode=execute install -m 755 \ $RPM_BUILD_DIR/mysql-%{mysql_version}/mysql-debug-%{mysql_version}/sql/mysqld \ $RBR%{_sbindir}/mysqld-debug # install saved perror binary with NDB support (BUG#13740) install -m 755 $MBD/extra/perror $RBR%{_bindir}/perror # Install logrotate and autostart install -m 644 $MBD/support-files/mysql-log-rotate $RBR%{_sysconfdir}/logrotate.d/mysql install -m 755 $MBD/support-files/mysql.server $RBR%{_sysconfdir}/init.d/mysql %if %{EMBEDDED_BUILD} # Install embedded server library in the build root install -m 644 $MBD/libmysqld/libmysqld.a $RBR%{_libdir}/mysql/ %endif # in RPMs, it is unlikely that anybody should use "sql-bench" rm -fr $RBR%{_datadir}/sql-bench # Create a symlink "rcmysql", pointing to the init.script. SuSE users # will appreciate that, as all services usually offer this. ln -s %{_sysconfdir}/init.d/mysql $RBR%{_sbindir}/rcmysql # Touch the place where the my.cnf config file and mysqlmanager.passwd # (MySQL Instance Manager password file) might be located # Just to make sure it's in the file list and marked as a config file touch $RBR%{_sysconfdir}/my.cnf touch $RBR%{_sysconfdir}/mysqlmanager.passwd ############################################################################## # Post processing actions, i.e. when installed ############################################################################## %pre server mysql_datadir=%{mysqldatadir} # Check if we can safely upgrade. An upgrade is only safe if it's from one # of our RPMs in the same version family. installed=`rpm -q --whatprovides mysql-server 2> /dev/null` if [ $? -eq 0 -a -n "$installed" ]; then vendor=`rpm -q --queryformat='%{VENDOR}' "$installed" 2>&1` version=`rpm -q --queryformat='%{VERSION}' "$installed" 2>&1` myoldvendor='%{mysql_old_vendor}' myvendor_2='%{mysql_vendor_2}' myvendor='%{mysql_vendor}' myversion='%{mysql_version}' old_family=`echo $version | sed -n -e 's,^\([1-9][0-9]*\.[0-9][0-9]*\)\..*$,\1,p'` new_family=`echo $myversion | sed -n -e 's,^\([1-9][0-9]*\.[0-9][0-9]*\)\..*$,\1,p'` [ -z "$vendor" ] && vendor='' [ -z "$old_family" ] && old_family="" [ -z "$new_family" ] && new_family="" error_text= if [ "$vendor" != "$myoldvendor" -a "$vendor" != "$myvendor_2" -a "$vendor" != "$myvendor" ]; then error_text="$error_text The current MySQL server package is provided by a different vendor ($vendor) than $myoldvendor, $myvendor_2, or $myvendor. Some files may be installed to different locations, including log files and the service startup script in %{_sysconfdir}/init.d/. " fi if [ "$old_family" != "$new_family" ]; then error_text="$error_text Upgrading directly from MySQL $old_family to MySQL $new_family may not be safe in all cases. A manual dump and restore using mysqldump is recommended. It is important to review the MySQL manual's Upgrading section for version-specific incompatibilities. " fi if [ -n "$error_text" ]; then cat <&2 ****************************************************************** A MySQL server package ($installed) is installed. $error_text A manual upgrade is required. - Ensure that you have a complete, working backup of your data and my.cnf files - Shut down the MySQL server cleanly - Remove the existing MySQL packages. Usually this command will list the packages you should remove: rpm -qa | grep -i '^mysql-' You may choose to use 'rpm --nodeps -ev ' to remove the package which contains the mysqlclient shared library. The library will be reinstalled by the MySQL-shared-compat package. - Install the new MySQL packages supplied by $myvendor - Ensure that the MySQL server is started - Run the 'mysql_upgrade' program This is a brief description of the upgrade process. Important details can be found in the MySQL manual, in the Upgrading section. ****************************************************************** HERE exit 1 fi fi # We assume that if there is exactly one ".pid" file, # it contains the valid PID of a running MySQL server. NR_PID_FILES=`ls $mysql_datadir/*.pid 2>/dev/null | wc -l` case $NR_PID_FILES in 0 ) SERVER_TO_START='' ;; # No "*.pid" file == no running server 1 ) SERVER_TO_START='true' ;; * ) SERVER_TO_START='' # Situation not clear SEVERAL_PID_FILES=true ;; esac # That logic may be debated: We might check whether it is non-empty, # contains exactly one number (possibly a PID), and whether "ps" finds it. # OTOH, if there is no such process, it means a crash without a cleanup - # is that a reason not to start a new server after upgrade? STATUS_FILE=$mysql_datadir/RPM_UPGRADE_MARKER if [ -f $STATUS_FILE ]; then echo "Some previous upgrade was not finished:" ls -ld $STATUS_FILE echo "Please check its status, then do" echo " rm $STATUS_FILE" echo "before repeating the MySQL upgrade." exit 1 elif [ -n "$SEVERAL_PID_FILES" ] ; then echo "Your MySQL directory '$mysql_datadir' has more than one PID file:" ls -ld $mysql_datadir/*.pid echo "Please check which one (if any) corresponds to a running server" echo "and delete all others before repeating the MySQL upgrade." exit 1 fi NEW_VERSION=%{mysql_version}-%{release} # The "pre" section code is also run on a first installation, # when there is no data directory yet. Protect against error messages. if [ -d $mysql_datadir ] ; then echo "MySQL RPM upgrade to version $NEW_VERSION" > $STATUS_FILE echo "'pre' step running at `date`" >> $STATUS_FILE echo >> $STATUS_FILE echo "ERR file(s):" >> $STATUS_FILE ls -ltr $mysql_datadir/*.err >> $STATUS_FILE echo >> $STATUS_FILE echo "Latest 'Version' line in latest file:" >> $STATUS_FILE grep '^Version' `ls -tr $mysql_datadir/*.err | tail -1` | \ tail -1 >> $STATUS_FILE echo >> $STATUS_FILE if [ -n "$SERVER_TO_START" ] ; then # There is only one PID file, race possibility ignored echo "PID file:" >> $STATUS_FILE ls -l $mysql_datadir/*.pid >> $STATUS_FILE cat $mysql_datadir/*.pid >> $STATUS_FILE echo >> $STATUS_FILE echo "Server process:" >> $STATUS_FILE ps -fp `cat $mysql_datadir/*.pid` >> $STATUS_FILE echo >> $STATUS_FILE echo "SERVER_TO_START=$SERVER_TO_START" >> $STATUS_FILE else # Take a note we checked it ... echo "PID file:" >> $STATUS_FILE ls -l $mysql_datadir/*.pid >> $STATUS_FILE 2>&1 fi fi # Shut down a previously installed server first # Note we *could* make that depend on $SERVER_TO_START, but we rather don't, # so a "stop" is attempted even if there is no PID file. # (Maybe the "stop" doesn't work then, but we might fix that in itself.) if [ -x %{_sysconfdir}/init.d/mysql ] ; then %{_sysconfdir}/init.d/mysql stop > /dev/null 2>&1 echo "Giving mysqld 5 seconds to exit nicely" sleep 5 fi %post server mysql_datadir=%{mysqldatadir} NEW_VERSION=%{mysql_version}-%{release} STATUS_FILE=$mysql_datadir/RPM_UPGRADE_MARKER # ---------------------------------------------------------------------- # Create data directory if needed, check whether upgrade or install # ---------------------------------------------------------------------- if [ ! -d $mysql_datadir ] ; then mkdir -m 755 $mysql_datadir; fi if [ -f $STATUS_FILE ] ; then SERVER_TO_START=`grep '^SERVER_TO_START=' $STATUS_FILE | cut -c17-` else SERVER_TO_START='true' # This is for 5.1 only, to not change behavior fi # echo "Analyzed: SERVER_TO_START=$SERVER_TO_START" if [ ! -d $mysql_datadir/mysql ] ; then mkdir $mysql_datadir/mysql; echo "MySQL RPM installation of version $NEW_VERSION" >> $STATUS_FILE else # If the directory exists, we may assume it is an upgrade. echo "MySQL RPM upgrade to version $NEW_VERSION" >> $STATUS_FILE fi if [ ! -d $mysql_datadir/test ] ; then mkdir $mysql_datadir/test; fi # ---------------------------------------------------------------------- # Make MySQL start/shutdown automatically when the machine does it. # ---------------------------------------------------------------------- # NOTE: This still needs to be debated. Should we check whether these links # for the other run levels exist(ed) before the upgrade? # use insserv for older SuSE Linux versions if [ -x /sbin/insserv ] ; then /sbin/insserv %{_sysconfdir}/init.d/mysql # use chkconfig on Red Hat and newer SuSE releases elif [ -x /sbin/chkconfig ] ; then /sbin/chkconfig --add mysql fi # ---------------------------------------------------------------------- # Create a MySQL user and group. Do not report any problems if it already # exists. # ---------------------------------------------------------------------- groupadd -r %{mysqld_group} 2> /dev/null || true useradd -M -r -d $mysql_datadir -s /bin/bash -c "MySQL server" -g %{mysqld_group} %{mysqld_user} 2> /dev/null || true # The user may already exist, make sure it has the proper group nevertheless (BUG#12823) usermod -g %{mysqld_group} %{mysqld_user} 2> /dev/null || true # ---------------------------------------------------------------------- # Change permissions so that the user that will run the MySQL daemon # owns all database files. # ---------------------------------------------------------------------- chown -R %{mysqld_user}:%{mysqld_group} $mysql_datadir # ---------------------------------------------------------------------- # Initiate databases if needed # ---------------------------------------------------------------------- %{_bindir}/mysql_install_db --rpm --user=%{mysqld_user} # ---------------------------------------------------------------------- # Upgrade databases if needed would go here - but it cannot be automated yet # ---------------------------------------------------------------------- # ---------------------------------------------------------------------- # Change permissions again to fix any new files. # ---------------------------------------------------------------------- chown -R %{mysqld_user}:%{mysqld_group} $mysql_datadir # ---------------------------------------------------------------------- # Fix permissions for the permission database so that only the user # can read them. # ---------------------------------------------------------------------- chmod -R og-rw $mysql_datadir/mysql # Was the server running before the upgrade? If so, restart the new one. if [ "$SERVER_TO_START" = "true" ] ; then # Restart in the same way that mysqld will be started normally. %{_sysconfdir}/init.d/mysql start # Allow mysqld_safe to start mysqld and print a message before we exit sleep 2 fi #echo "Thank you for installing the MySQL Community Server! For Production #systems, we recommend MySQL Enterprise, which contains enterprise-ready #software, intelligent advisory services, and full production support with #scheduled service packs and more. Visit www.mysql.com/enterprise for more #information." # Collect an upgrade history ... echo "Upgrade/install finished at `date`" >> $STATUS_FILE echo >> $STATUS_FILE echo "=====" >> $STATUS_FILE STATUS_HISTORY=$mysql_datadir/RPM_UPGRADE_HISTORY cat $STATUS_FILE >> $STATUS_HISTORY rm $STATUS_FILE %if %{CLUSTER_BUILD} %post ndb-storage mysql_clusterdir=/var/lib/mysql-cluster # Create cluster directory if needed if test ! -d $mysql_clusterdir; then mkdir -m 755 $mysql_clusterdir; fi %endif %preun server if [ $1 = 0 ] ; then # Stop MySQL before uninstalling it if [ -x %{_sysconfdir}/init.d/mysql ] ; then %{_sysconfdir}/init.d/mysql stop > /dev/null # Remove autostart of MySQL # For older SuSE Linux versions if [ -x /sbin/insserv ] ; then /sbin/insserv -r %{_sysconfdir}/init.d/mysql # use chkconfig on Red Hat and newer SuSE releases elif [ -x /sbin/chkconfig ] ; then /sbin/chkconfig --del mysql fi fi fi # We do not remove the mysql user since it may still own a lot of # database files. # ---------------------------------------------------------------------- # Clean up the BuildRoot after build is done # ---------------------------------------------------------------------- %clean [ "$RPM_BUILD_ROOT" != "/" ] && [ -d $RPM_BUILD_ROOT ] && rm -rf $RPM_BUILD_ROOT; ############################################################################## # Files section ############################################################################## %files server %defattr(-,root,root,0755) %doc mysql-release-%{mysql_version}/COPYING mysql-release-%{mysql_version}/README %doc mysql-release-%{mysql_version}/support-files/my-*.cnf %if %{CLUSTER_BUILD} %doc mysql-release-%{mysql_version}/support-files/ndb-*.ini %endif %doc %attr(644, root, root) %{_infodir}/mysql.info* %if %{INNODB_BUILD} %doc %attr(644, root, man) %{_mandir}/man1/innochecksum.1* %endif %doc %attr(644, root, man) %{_mandir}/man1/my_print_defaults.1* %doc %attr(644, root, man) %{_mandir}/man1/myisam_ftdump.1* %doc %attr(644, root, man) %{_mandir}/man1/myisamchk.1* %doc %attr(644, root, man) %{_mandir}/man1/myisamlog.1* %doc %attr(644, root, man) %{_mandir}/man1/myisampack.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_convert_table_format.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_fix_extensions.1* %doc %attr(644, root, man) %{_mandir}/man8/mysqld.8* %doc %attr(644, root, man) %{_mandir}/man1/mysqld_multi.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqld_safe.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqldumpslow.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_fix_privilege_tables.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_install_db.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_secure_installation.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_setpermission.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_upgrade.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlhotcopy.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlman.1* %doc %attr(644, root, man) %{_mandir}/man8/mysqlmanager.8* %doc %attr(644, root, man) %{_mandir}/man1/mysql.server.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqltest.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_tzinfo_to_sql.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_zap.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlbug.1* %doc %attr(644, root, man) %{_mandir}/man1/perror.1* %doc %attr(644, root, man) %{_mandir}/man1/replace.1* %doc %attr(644, root, man) %{_mandir}/man1/resolve_stack_dump.1* %doc %attr(644, root, man) %{_mandir}/man1/resolveip.1* %ghost %config(noreplace,missingok) %{_sysconfdir}/my.cnf %ghost %config(noreplace,missingok) %{_sysconfdir}/mysqlmanager.passwd %if %{INNODB_BUILD} %attr(755, root, root) %{_bindir}/innochecksum %endif %attr(755, root, root) %{_bindir}/my_print_defaults %attr(755, root, root) %{_bindir}/myisam_ftdump %attr(755, root, root) %{_bindir}/myisamchk %attr(755, root, root) %{_bindir}/myisamlog %attr(755, root, root) %{_bindir}/myisampack %attr(755, root, root) %{_bindir}/mysql_convert_table_format %attr(755, root, root) %{_bindir}/mysql_fix_extensions %attr(755, root, root) %{_bindir}/mysql_fix_privilege_tables %attr(755, root, root) %{_bindir}/mysql_install_db %attr(755, root, root) %{_bindir}/mysql_secure_installation %attr(755, root, root) %{_bindir}/mysql_setpermission %attr(755, root, root) %{_bindir}/mysql_tzinfo_to_sql %attr(755, root, root) %{_bindir}/mysql_upgrade %attr(755, root, root) %{_bindir}/mysql_zap %attr(755, root, root) %{_bindir}/mysqlbug %attr(755, root, root) %{_bindir}/mysqld_multi %attr(755, root, root) %{_bindir}/mysqld_safe %attr(755, root, root) %{_bindir}/mysqldumpslow %attr(755, root, root) %{_bindir}/mysqlhotcopy %attr(755, root, root) %{_bindir}/mysqltest %attr(755, root, root) %{_bindir}/perror %attr(755, root, root) %{_bindir}/replace %attr(755, root, root) %{_bindir}/resolve_stack_dump %attr(755, root, root) %{_bindir}/resolveip %attr(755, root, root) %{_sbindir}/mysqld %attr(755, root, root) %{_sbindir}/mysqld-debug %attr(755, root, root) %{_sbindir}/mysqlmanager %attr(755, root, root) %{_sbindir}/rcmysql %if %{INNODB_BUILD} %if %{WITH_INNODB_PLUGIN} %attr(755, root, root) %{_libdir}/mysql/plugin/ha_innodb_plugin.so* %endif %endif %attr(755, root, root) %{_libdir}/mysql/plugin/ha_example.so* %attr(644, root, root) %config(noreplace,missingok) %{_sysconfdir}/logrotate.d/mysql %attr(755, root, root) %{_sysconfdir}/init.d/mysql %attr(755, root, root) %{_datadir}/mysql/ %files client %defattr(-, root, root, 0755) %attr(755, root, root) %{_bindir}/msql2mysql %attr(755, root, root) %{_bindir}/mysql %attr(755, root, root) %{_bindir}/mysql_find_rows %attr(755, root, root) %{_bindir}/mysql_waitpid %attr(755, root, root) %{_bindir}/mysqlaccess %attr(755, root, root) %{_bindir}/mysqladmin %attr(755, root, root) %{_bindir}/mysqlbinlog %attr(755, root, root) %{_bindir}/mysqlcheck %attr(755, root, root) %{_bindir}/mysqldump %attr(755, root, root) %{_bindir}/mysqlimport %attr(755, root, root) %{_bindir}/mysqlshow %attr(755, root, root) %{_bindir}/mysqlslap %doc %attr(644, root, man) %{_mandir}/man1/msql2mysql.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql_find_rows.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlaccess.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqladmin.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlbinlog.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlcheck.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqldump.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlimport.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlshow.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqlslap.1* %post shared /sbin/ldconfig %postun shared /sbin/ldconfig %if %{CLUSTER_BUILD} %files ndb-storage %defattr(-,root,root,0755) %attr(755, root, root) %{_sbindir}/ndbd %doc %attr(644, root, man) %{_mandir}/man8/ndbd.8* %files ndb-management %defattr(-,root,root,0755) %attr(755, root, root) %{_sbindir}/ndb_mgmd %doc %attr(644, root, man) %{_mandir}/man8/ndb_mgmd.8* %files ndb-tools %defattr(-,root,root,0755) %attr(755, root, root) %{_bindir}/ndb_config %attr(755, root, root) %{_bindir}/ndb_desc %attr(755, root, root) %{_bindir}/ndb_error_reporter %attr(755, root, root) %{_bindir}/ndb_mgm %attr(755, root, root) %{_bindir}/ndb_print_backup_file %attr(755, root, root) %{_bindir}/ndb_print_schema_file %attr(755, root, root) %{_bindir}/ndb_print_sys_file %attr(755, root, root) %{_bindir}/ndb_restore %attr(755, root, root) %{_bindir}/ndb_select_all %attr(755, root, root) %{_bindir}/ndb_select_count %attr(755, root, root) %{_bindir}/ndb_show_tables %attr(755, root, root) %{_bindir}/ndb_size.pl %attr(755, root, root) %{_bindir}/ndb_test_platform %attr(755, root, root) %{_bindir}/ndb_waiter %doc %attr(644, root, man) %{_mandir}/man1/ndb_config.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_desc.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_error_reporter.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_mgm.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_restore.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_print_backup_file.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_print_schema_file.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_print_sys_file.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_select_all.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_select_count.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_show_tables.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_size.pl.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_waiter.1* %files ndb-extra %defattr(-,root,root,0755) %attr(755, root, root) %{_bindir}/ndb_delete_all %attr(755, root, root) %{_bindir}/ndb_drop_index %attr(755, root, root) %{_bindir}/ndb_drop_table %attr(755, root, root) %{_sbindir}/ndb_cpcd %doc %attr(644, root, man) %{_mandir}/man1/ndb_delete_all.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_drop_index.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_drop_table.1* %doc %attr(644, root, man) %{_mandir}/man1/ndb_cpcd.1* %endif %files devel %defattr(-, root, root, 0755) %doc mysql-release-%{mysql_version}/EXCEPTIONS-CLIENT %doc %attr(644, root, man) %{_mandir}/man1/mysql_config.1* %attr(755, root, root) %{_bindir}/mysql_config %dir %attr(755, root, root) %{_includedir}/mysql %dir %attr(755, root, root) %{_libdir}/mysql %{_includedir}/mysql/* %{_datadir}/aclocal/mysql.m4 %{_libdir}/mysql/libdbug.a %{_libdir}/mysql/libheap.a %if %{WITH_LIBGCC} %{_libdir}/mysql/libmygcc.a %endif %{_libdir}/mysql/libmyisam.a %{_libdir}/mysql/libmyisammrg.a %{_libdir}/mysql/libmysqlclient.a %{_libdir}/mysql/libmysqlclient.la %{_libdir}/mysql/libmysqlclient_r.a %{_libdir}/mysql/libmysqlclient_r.la %{_libdir}/mysql/libmystrings.a %{_libdir}/mysql/libmysys.a %if %{CLUSTER_BUILD} %{_libdir}/mysql/libndbclient.a %{_libdir}/mysql/libndbclient.la %endif %{_libdir}/mysql/libvio.a %{_libdir}/mysql/libz.a %{_libdir}/mysql/libz.la %{_libdir}/mysql/plugin/ha_example.a %{_libdir}/mysql/plugin/ha_example.la %if %{INNODB_BUILD} %if %{WITH_INNODB_PLUGIN} %{_libdir}/mysql/plugin/ha_innodb_plugin.a %{_libdir}/mysql/plugin/ha_innodb_plugin.la %endif %endif %files shared %defattr(-, root, root, 0755) # Shared libraries (omit for architectures that don't support them) %{_libdir}/libmysql*.so* %if %{CLUSTER_BUILD} %{_libdir}/libndb*.so* %endif %files test %defattr(-, root, root, 0755) %attr(-, root, root) %{_datadir}/mysql-test %attr(755, root, root) %{_bindir}/mysql_client_test %doc %attr(644, root, man) %{_mandir}/man1/mysql_client_test.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql-stress-test.pl.1* %doc %attr(644, root, man) %{_mandir}/man1/mysql-test-run.pl.1* %if %{EMBEDDED_BUILD} %attr(755, root, root) %{_bindir}/mysql_client_test_embedded %attr(755, root, root) %{_bindir}/mysqltest_embedded %doc %attr(644, root, man) %{_mandir}/man1/mysql_client_test_embedded.1* %doc %attr(644, root, man) %{_mandir}/man1/mysqltest_embedded.1* %endif %if %{EMBEDDED_BUILD} %files embedded %defattr(-, root, root, 0755) %attr(644, root, root) %{_libdir}/mysql/libmysqld.a %endif ############################################################################## # The spec file changelog only includes changes made to the spec file # itself - note that they must be ordered by date (important when # merging BK trees) ############################################################################## %changelog * Tue Jun 15 2010 Joerg Bruehe - Change the behaviour on upgrade: *Iff* the server was stopped before the upgrade is started, this is taken as a sign the administrator is handling that manually, and so the new server will not be started automatically at the end of the upgrade. The start/stop scripts will still be installed, so the server will be started on the next machine boot. This is the 5.1 version of fixing bug#27072 (RPM autostarting the server). * Mon Mar 01 2010 Joerg Bruehe - Set "Oracle and/or its affiliates" as the vendor and copyright owner, accept upgrading from packages showing MySQL or Sun as vendor. * Fri Feb 05 2010 Joerg Bruehe - Formatting changes: Have a consistent structure of separator lines and of indentation (8 leading blanks => tab). - Introduce the variable "src_dir". - Give the environment variables "MYSQL_BUILD_CC(CXX)" precedence over "CC" ("CXX"). - Drop the old "with_static" argument analysis, this is not supported in 5.1 since ages. - Introduce variables to control the handlers individually, as well as other options. - Handle the InnoDB plugin using a positive logic: "WITH_INNODB_PLUGIN", the old negative logic ("WITHOUT_INNODB_PLUGIN") was obfuscating. - Use the new "--with-plugin" notation for the table handlers. - Drop handling "/etc/rc.d/init.d/mysql", the switch to "/etc/init.d/mysql" was done back in 2002 already. - Make "--with-zlib-dir=bundled" the default, add an option to disable it. - Add missing manual pages to the file list. - Improve the runtime check for "libgcc.a", protect it against being tried with the Intel compiler "icc". * Mon Jan 11 2010 Joerg Bruehe - Change RPM file naming: - Suffix like "-m2", "-rc" becomes part of version as "_m2", "_rc". - Release counts from 1, not 0. * Mon Aug 24 2009 Jonathan Perkin - Add conditionals for bundled zlib and innodb plugin * Fri Aug 21 2009 Jonathan Perkin - Install plugin libraries in appropriate packages. - Disable libdaemon_example and ftexample plugins. * Thu Aug 20 2009 Jonathan Perkin - Update variable used for mysql-test suite location to match source. * Fri Nov 07 2008 Joerg Bruehe - Correct yesterday's fix, so that it also works for the last flag, and fix a wrong quoting: un-quoted quote marks must not be escaped. * Thu Nov 06 2008 Kent Boortz - Removed "mysql_upgrade_shell" - Removed some copy/paste between debug and normal build * Thu Nov 06 2008 Joerg Bruehe - Modify CFLAGS and CXXFLAGS such that a debug build is not optimized. This should cover both gcc and icc flags. Fixes bug#40546. * Fri Aug 29 2008 Kent Boortz - Removed the "Federated" storage engine option, and enabled in all * Tue Aug 26 2008 Joerg Bruehe - Get rid of the "warning: Installed (but unpackaged) file(s) found:" Some generated files aren't needed in RPMs: - the "sql-bench/" subdirectory Some files were missing: - /usr/share/aclocal/mysql.m4 ("devel" subpackage) - Manual "mysqlbug" ("server" subpackage) - Program "innochecksum" and its manual ("server" subpackage) - Manual "mysql_find_rows" ("client" subpackage) - Script "mysql_upgrade_shell" ("client" subpackage) - Program "ndb_cpcd" and its manual ("ndb-extra" subpackage) - Manuals "ndb_mgm" + "ndb_restore" ("ndb-tools" subpackage) * Mon Mar 31 2008 Kent Boortz - Made the "Federated" storage engine an option - Made the "Cluster" storage engine and sub packages an option * Wed Mar 19 2008 Joerg Bruehe - Add the man pages for "ndbd" and "ndb_mgmd". * Mon Feb 18 2008 Timothy Smith - Require a manual upgrade if the alread-installed mysql-server is from another vendor, or is of a different major version. * Wed May 02 2007 Joerg Bruehe - "ndb_size.tmpl" is not needed any more, "man1/mysql_install_db.1" lacked the trailing '*'. * Sat Apr 07 2007 Kent Boortz - Removed man page for "mysql_create_system_tables" * Wed Mar 21 2007 Daniel Fischer - Add debug server. * Mon Mar 19 2007 Daniel Fischer - Remove Max RPMs; the server RPMs contain a mysqld compiled with all features that previously only were built into Max. * Fri Mar 02 2007 Joerg Bruehe - Add several man pages for NDB which are now created. * Fri Jan 05 2007 Kent Boortz - Put back "libmygcc.a", found no real reason it was removed. - Add CFLAGS to gcc call with --print-libgcc-file, to make sure the correct "libgcc.a" path is returned for the 32/64 bit architecture. * Mon Dec 18 2006 Joerg Bruehe - Fix the move of "mysqlmanager" to section 8: Directory name was wrong. * Thu Dec 14 2006 Joerg Bruehe - Include the new man pages for "my_print_defaults" and "mysql_tzinfo_to_sql" in the server RPM. - The "mysqlmanager" man page got moved from section 1 to 8. * Thu Nov 30 2006 Joerg Bruehe - Call "make install" using "benchdir_root=%{_datadir}", because that is affecting the regression test suite as well. * Thu Nov 16 2006 Joerg Bruehe - Explicitly note that the "MySQL-shared" RPMs (as built by MySQL AB) replace "mysql-shared" (as distributed by SuSE) to allow easy upgrading (bug#22081). * Mon Nov 13 2006 Joerg Bruehe - Add "--with-partition" to all server builds. - Use "--report-features" in one test run per server build. * Tue Aug 15 2006 Joerg Bruehe - The "max" server is removed from packages, effective from 5.1.12-beta. Delete all steps to build, package, or install it. * Mon Jul 10 2006 Joerg Bruehe - Fix a typing error in the "make" target for the Perl script to run the tests. * Tue Jul 04 2006 Joerg Bruehe - Use the Perl script to run the tests, because it will automatically check whether the server is configured with SSL. * Tue Jun 27 2006 Joerg Bruehe - move "mysqldumpslow" from the client RPM to the server RPM (bug#20216) - Revert all previous attempts to call "mysql_upgrade" during RPM upgrade, there are some more aspects which need to be solved before this is possible. For now, just ensure the binary "mysql_upgrade" is delivered and installed. * Thu Jun 22 2006 Joerg Bruehe - Close a gap of the previous version by explicitly using a newly created temporary directory for the socket to be used in the "mysql_upgrade" operation, overriding any local setting. * Tue Jun 20 2006 Joerg Bruehe - To run "mysql_upgrade", we need a running server; start it in isolation and skip password checks. * Sat May 20 2006 Kent Boortz - Always compile for PIC, position independent code. * Wed May 10 2006 Kent Boortz - Use character set "all" when compiling with Cluster, to make Cluster nodes independent on the character set directory, and the problem that two RPM sub packages both wants to install this directory. * Mon May 01 2006 Kent Boortz - Use "./libtool --mode=execute" instead of searching for the executable in current directory and ".libs". * Fri Apr 28 2006 Kent Boortz - Install and run "mysql_upgrade" * Wed Apr 12 2006 Jim Winstead - Remove sql-bench, and MySQL-bench RPM (will be built as an independent project from the mysql-bench repository) * Tue Apr 11 2006 Jim Winstead - Remove old mysqltestmanager and related programs * Sat Apr 01 2006 Kent Boortz - Set $LDFLAGS from $MYSQL_BUILD_LDFLAGS * Wed Mar 07 2006 Kent Boortz - Changed product name from "Community Edition" to "Community Server" * Mon Mar 06 2006 Kent Boortz - Fast mutexes is now disabled by default, but should be used in Linux builds. * Mon Feb 20 2006 Kent Boortz - Reintroduced a max build - Limited testing of 'debug' and 'max' servers - Berkeley DB only in 'max' * Mon Feb 13 2006 Joerg Bruehe - Use "-i" on "make test-force"; this is essential for later evaluation of this log file. * Thu Feb 09 2006 Kent Boortz - Pass '-static' to libtool, link static with our own libraries, dynamic with system libraries. Link with the bundled zlib. * Wed Feb 08 2006 Kristian Nielsen - Modified RPM spec to match new 5.1 debug+max combined community packaging. * Sun Dec 18 2005 Kent Boortz - Added "client/mysqlslap" * Mon Dec 12 2005 Rodrigo Novo - Added zlib to the list of (static) libraries installed - Added check against libtool wierdness (WRT: sql/mysqld || sql/.libs/mysqld) - Compile MySQL with bundled zlib - Fixed %packager name to "MySQL Production Engineering Team" * Mon Dec 05 2005 Joerg Bruehe - Avoid using the "bundled" zlib on "shared" builds: As it is not installed (on the build system), this gives dependency problems with "libtool" causing the build to fail. (Change was done on Nov 11, but left uncommented.) * Tue Nov 22 2005 Joerg Bruehe - Extend the file existence check for "init.d/mysql" on un-install to also guard the call to "insserv"/"chkconfig". * Thu Oct 27 2005 Lenz Grimmer - added more man pages * Wed Oct 19 2005 Kent Boortz - Made yaSSL support an option (off by default) * Wed Oct 19 2005 Kent Boortz - Enabled yaSSL support * Sat Oct 15 2005 Kent Boortz - Give mode arguments the same way in all places - Moved copy of mysqld.a to "standard" build, but disabled it as we don't do embedded yet in 5.0 * Fri Oct 14 2005 Kent Boortz - For 5.x, always compile with --with-big-tables - Copy the config.log file to location outside the build tree * Fri Oct 14 2005 Kent Boortz - Removed unneeded/obsolete configure options - Added archive engine to standard server - Removed the embedded server from experimental server - Changed suffix "-Max" => "-max" - Changed comment string "Max" => "Experimental" * Thu Oct 13 2005 Lenz Grimmer - added a usermod call to assign a potential existing mysql user to the correct user group (BUG#12823) - Save the perror binary built during Max build so it supports the NDB error codes (BUG#13740) - added a separate macro "mysqld_group" to be able to define the user group of the mysql user seperately, if desired. * Thu Sep 29 2005 Lenz Grimmer - fixed the removing of the RPM_BUILD_ROOT in the %clean section (the $RBR variable did not get expanded, thus leaving old build roots behind) * Thu Aug 04 2005 Lenz Grimmer - Fixed the creation of the mysql user group account in the postinstall section (BUG 12348) - Fixed enabling the Archive storage engine in the Max binary * Tue Aug 02 2005 Lenz Grimmer - Fixed the Requires: tag for the server RPM (BUG 12233) * Fri Jul 15 2005 Lenz Grimmer - create a "mysql" user group and assign the mysql user account to that group in the server postinstall section. (BUG 10984) * Tue Jun 14 2005 Lenz Grimmer - Do not build statically on i386 by default, only when adding either "--with static" or "--define '_with_static 1'" to the RPM build options. Static linking really only makes sense when linking against the specially patched glibc 2.2.5. * Mon Jun 06 2005 Lenz Grimmer - added mysql_client_test to the "bench" subpackage (BUG 10676) - added the libndbclient static and shared libraries (BUG 10676) * Wed Jun 01 2005 Lenz Grimmer - use "mysqldatadir" variable instead of hard-coding the path multiple times - use the "mysqld_user" variable on all occasions a user name is referenced - removed (incomplete) Brazilian translations - removed redundant release tags from the subpackage descriptions * Wed May 25 2005 Joerg Bruehe - Added a "make clean" between separate calls to "BuildMySQL". * Thu May 12 2005 Guilhem Bichot - Removed the mysql_tableinfo script made obsolete by the information schema * Wed Apr 20 2005 Lenz Grimmer - Enabled the "blackhole" storage engine for the Max RPM * Wed Apr 13 2005 Lenz Grimmer - removed the MySQL manual files (html/ps/texi) - they have been removed from the MySQL sources and are now available seperately. * Mon Apr 4 2005 Petr Chardin - old mysqlmanager, mysqlmanagerc and mysqlmanager-pwger renamed into mysqltestmanager, mysqltestmanager and mysqltestmanager-pwgen respectively * Fri Mar 18 2005 Lenz Grimmer - Disabled RAID in the Max binaries once and for all (it has finally been removed from the source tree) * Sun Feb 20 2005 Petr Chardin - Install MySQL Instance Manager together with mysqld, touch mysqlmanager password file * Mon Feb 14 2005 Lenz Grimmer - Fixed the compilation comments and moved them into the separate build sections for Max and Standard * Mon Feb 7 2005 Tomas Ulin - enabled the "Ndbcluster" storage engine for the max binary - added extra make install in ndb subdir after Max build to get ndb binaries - added packages for ndbcluster storage engine * Fri Jan 14 2005 Lenz Grimmer - replaced obsoleted "BuildPrereq" with "BuildRequires" instead * Thu Jan 13 2005 Lenz Grimmer - enabled the "Federated" storage engine for the max binary * Tue Jan 04 2005 Petr Chardin - ISAM and merge storage engines were purged. As well as appropriate tools and manpages (isamchk and isamlog) * Thu Dec 31 2004 Lenz Grimmer - enabled the "Archive" storage engine for the max binary - enabled the "CSV" storage engine for the max binary - enabled the "Example" storage engine for the max binary * Thu Aug 26 2004 Lenz Grimmer - MySQL-Max now requires MySQL-server instead of MySQL (BUG 3860) * Fri Aug 20 2004 Lenz Grimmer - do not link statically on IA64/AMD64 as these systems do not have a patched glibc installed * Tue Aug 10 2004 Lenz Grimmer - Added libmygcc.a to the devel subpackage (required to link applications against the the embedded server libmysqld.a) (BUG 4921) * Mon Aug 09 2004 Lenz Grimmer - Added EXCEPTIONS-CLIENT to the "devel" package * Thu Jul 29 2004 Lenz Grimmer - disabled OpenSSL in the Max binaries again (the RPM packages were the only exception to this anyway) (BUG 1043) * Wed Jun 30 2004 Lenz Grimmer - fixed server postinstall (mysql_install_db was called with the wrong parameter) * Thu Jun 24 2004 Lenz Grimmer - added mysql_tzinfo_to_sql to the server subpackage - run "make clean" instead of "make distclean" * Mon Apr 05 2004 Lenz Grimmer - added ncurses-devel to the build prerequisites (BUG 3377) * Thu Feb 12 2004 Lenz Grimmer - when using gcc, _always_ use CXX=gcc - replaced Copyright with License field (Copyright is obsolete) * Tue Feb 03 2004 Lenz Grimmer - added myisam_ftdump to the Server package * Tue Jan 13 2004 Lenz Grimmer - link the mysql client against libreadline instead of libedit (BUG 2289) * Mon Dec 22 2003 Lenz Grimmer - marked /etc/logrotate.d/mysql as a config file (BUG 2156) * Fri Dec 13 2003 Lenz Grimmer - fixed file permissions (BUG 1672) * Thu Dec 11 2003 Lenz Grimmer - made testing for gcc3 a bit more robust * Fri Dec 05 2003 Lenz Grimmer - added missing file mysql_create_system_tables to the server subpackage * Fri Nov 21 2003 Lenz Grimmer - removed dependency on MySQL-client from the MySQL-devel subpackage as it is not really required. (BUG 1610) * Fri Aug 29 2003 Lenz Grimmer - Fixed BUG 1162 (removed macro names from the changelog) - Really fixed BUG 998 (disable the checking for installed but unpackaged files) * Tue Aug 05 2003 Lenz Grimmer - Fixed BUG 959 (libmysqld not being compiled properly) - Fixed BUG 998 (RPM build errors): added missing files to the distribution (mysql_fix_extensions, mysql_tableinfo, mysqldumpslow, mysql_fix_privilege_tables.1), removed "-n" from install section. * Wed Jul 09 2003 Lenz Grimmer - removed the GIF Icon (file was not included in the sources anyway) - removed unused variable shared_lib_version - do not run automake before building the standard binary (should not be necessary) - add server suffix '-standard' to standard binary (to be in line with the binary tarball distributions) - Use more RPM macros (_exec_prefix, _sbindir, _libdir, _sysconfdir, _datadir, _includedir) throughout the spec file. - allow overriding CC and CXX (required when building with other compilers) * Fri May 16 2003 Lenz Grimmer - re-enabled RAID again * Wed Apr 30 2003 Lenz Grimmer - disabled MyISAM RAID (--with-raid) - it throws an assertion which needs to be investigated first. * Mon Mar 10 2003 Lenz Grimmer - added missing file mysql_secure_installation to server subpackage (BUG 141) * Tue Feb 11 2003 Lenz Grimmer - re-added missing pre- and post(un)install scripts to server subpackage - added config file /etc/my.cnf to the file list (just for completeness) - make sure to create the datadir with 755 permissions * Mon Jan 27 2003 Lenz Grimmer - removed unused CC and CXX variables - CFLAGS and CXXFLAGS should honor RPM_OPT_FLAGS * Fri Jan 24 2003 Lenz Grimmer - renamed package "MySQL" to "MySQL-server" - fixed Copyright tag - added mysql_waitpid to client subpackage (required for mysql-test-run) * Wed Nov 27 2002 Lenz Grimmer - moved init script from /etc/rc.d/init.d to /etc/init.d (the majority of Linux distributions now support this scheme as proposed by the LSB either directly or via a compatibility symlink) - Use new "restart" init script action instead of starting and stopping separately - Be more flexible in activating the automatic bootup - use insserv (on older SuSE versions) or chkconfig (Red Hat, newer SuSE versions and others) to create the respective symlinks * Wed Sep 25 2002 Lenz Grimmer - MySQL-Max now requires MySQL >= 4.0 to avoid version mismatches (mixing 3.23 and 4.0 packages) * Fri Aug 09 2002 Lenz Grimmer - Turn off OpenSSL in MySQL-Max for now until it works properly again - enable RAID for the Max binary instead - added compatibility link: safe_mysqld -> mysqld_safe to ease the transition from 3.23 * Thu Jul 18 2002 Lenz Grimmer - Reworked the build steps a little bit: the Max binary is supposed to include OpenSSL, which cannot be linked statically, thus trying to statically link against a special glibc is futile anyway - because of this, it is not required to make yet another build run just to compile the shared libs (saves a lot of time) - updated package description of the Max subpackage - clean up the BuildRoot directory afterwards * Mon Jul 15 2002 Lenz Grimmer - Updated Packager information - Fixed the build options: the regular package is supposed to include InnoDB and linked statically, while the Max package should include BDB and SSL support * Fri May 03 2002 Lenz Grimmer - Use more RPM macros (e.g. infodir, mandir) to make the spec file more portable - reorganized the installation of documentation files: let RPM take care of this - reorganized the file list: actually install man pages along with the binaries of the respective subpackage - do not include libmysqld.a in the devel subpackage as well, if we have a special "embedded" subpackage - reworked the package descriptions * Mon Oct 8 2001 Monty - Added embedded server as a separate RPM * Fri Apr 13 2001 Monty - Added mysqld-max to the distribution * Tue Jan 2 2001 Monty - Added mysql-test to the bench package * Fri Aug 18 2000 Tim Smith - Added separate libmysql_r directory; now both a threaded and non-threaded library is shipped. * Wed Sep 28 1999 David Axmark - Added the support-files/my-example.cnf to the docs directory. - Removed devel dependency on base since it is about client development. * Wed Sep 8 1999 David Axmark - Cleaned up some for 3.23. * Thu Jul 1 1999 David Axmark - Added support for shared libraries in a separate sub package. Original fix by David Fox (dsfox@cogsci.ucsd.edu) - The --enable-assembler switch is now automatically disables on platforms there assembler code is unavailable. This should allow building this RPM on non i386 systems. * Mon Feb 22 1999 David Axmark - Removed unportable cc switches from the spec file. The defaults can now be overridden with environment variables. This feature is used to compile the official RPM with optimal (but compiler version specific) switches. - Removed the repetitive description parts for the sub rpms. Maybe add again if RPM gets a multiline macro capability. - Added support for a pt_BR translation. Translation contributed by Jorge Godoy . * Wed Nov 4 1998 David Axmark - A lot of changes in all the rpm and install scripts. This may even be a working RPM :-) * Sun Aug 16 1998 David Axmark - A developers changelog for MySQL is available in the source RPM. And there is a history of major user visible changed in the Reference Manual. Only RPM specific changes will be documented here.