mysql.spec.sh

# Copyright (c) 2000, 2014, 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.
%global mysql_old_vendor MySQL AB
%global mysql_vendor_2 Sun Microsystems, Inc.
%global mysql_vendor Oracle and/or its affiliates

%global mysql_version @VERSION@

%global mysqld_user mysql
%global mysqld_group mysql
%global mysqldatadir /var/lib/mysql

%global release 1 


#
# Macros we use which are not available in all supported versions of RPM
#
# - defined/undefined are missing on RHEL4
#
%if %{expand:%{?defined:0}%{!?defined:1}}
%define defined() %{expand:%%{?%{1}:1}%%{!?%{1}:0}}
%endif
%if %{expand:%{?undefined:0}%{!?undefined:1}}
%define undefined() %{expand:%%{?%{1}:0}%%{!?%{1}:1}}
%endif

# ----------------------------------------------------------------------------
# RPM build tools now automatically detect Perl module dependencies. This
# detection causes problems as it is broken in some versions, and it also
# provides unwanted dependencies from mandatory scripts in our package.
# It might not be possible to disable this in all versions of RPM, but here we
# try anyway. 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
##############################################################################
#
# To set options:
#
# $ rpmbuild --define="option <x>" ...
#

# ----------------------------------------------------------------------------
# Commercial builds
# ----------------------------------------------------------------------------
%if %{undefined commercial}
%define commercial 0
%endif

# ----------------------------------------------------------------------------
# Source name
# ----------------------------------------------------------------------------
%if %{undefined src_base}
%define src_base mysql
%endif
%define src_dir %{src_base}-%{mysql_version}

# ----------------------------------------------------------------------------
# Feature set (storage engines, options). Default to community (everything)
# ----------------------------------------------------------------------------
%if %{undefined feature_set}
%define feature_set community
%endif

# ----------------------------------------------------------------------------
# Server comment strings
# ----------------------------------------------------------------------------
%if %{undefined compilation_comment_debug}
%define compilation_comment_debug MySQL Community Server - Debug (GPL)
%endif
%if %{undefined compilation_comment_release}
%define compilation_comment_release MySQL Community Server (GPL)
%endif

# ----------------------------------------------------------------------------
# Product and server suffixes
# ----------------------------------------------------------------------------
%if %{undefined product_suffix}
 %if %{defined short_product_tag}
 %define product_suffix -%{short_product_tag}
 %else
 %define product_suffix %{nil}
 %endif
%endif

%if %{undefined server_suffix}
%define server_suffix %{nil}
%endif

# ----------------------------------------------------------------------------
# Distribution support
# ----------------------------------------------------------------------------
%if %{undefined distro_specific}
%define distro_specific 0
%endif
%if %{distro_specific}
 %if %(test -f /etc/enterprise-release &&echo 1 ||echo 0)
 %define oelver %(rpm -qf --qf '%%{version}\\n' /etc/enterprise-release | sed -e 's/^\\([0-9]*\\).*/\\1/g')
 %if "%oelver" == "4"
 %define distro_description Oracle Enterprise Linux 4
 %define distro_releasetag oel4
 %define distro_buildreq gcc-c++ gperf ncurses-devel perl time zlib-devel cmake libaio-devel
 %define distro_requires chkconfig coreutils grep procps shadow-utils net-tools
 %else
 %if "%oelver" == "5"
 %define distro_description Oracle Enterprise Linux 5
 %define distro_releasetag oel5
 %define distro_buildreq gcc-c++ gperf ncurses-devel perl time zlib-devel cmake libaio-devel
 %define distro_requires chkconfig coreutils grep procps shadow-utils net-tools
 %else
 %{error:Oracle Enterprise Linux %{oelver} is unsupported}
 %endif
 %endif
 %else
 %if %(test -f /etc/oracle-release &&echo 1 ||echo 0)
 %define elver %(rpm -qf --qf '%%{version}\\n' /etc/oracle-release | sed -e 's/^\\([0-9]*\\).*/\\1/g')
 %if "%elver" == "6"||"%elver" == "7"
 %define distro_description Oracle Linux %elver
 %define distro_releasetag el%elver
 %define distro_buildreq gcc-c++ ncurses-devel perl time zlib-devel cmake libaio-devel
 %define distro_requires chkconfig coreutils grep procps shadow-utils net-tools
 %else
 %{error:Oracle Linux %{elver} is unsupported}
 %endif
 %else
 %if %(test -f /etc/redhat-release &&echo 1 ||echo 0)
 %define rhelver %(rpm -qf --qf '%%{version}\\n' /etc/redhat-release | sed -e 's/^\\([0-9]*\\).*/\\1/g')
 %if "%rhelver" == "4"
 %define distro_description Red Hat Enterprise Linux 4
 %define distro_releasetag rhel4
 %define distro_buildreq gcc-c++ gperf ncurses-devel perl time zlib-devel cmake libaio-devel
 %define distro_requires chkconfig coreutils grep procps shadow-utils net-tools
 %else
 %if "%rhelver" == "5"
 %define distro_description Red Hat Enterprise Linux 5
 %define distro_releasetag rhel5
 %define distro_buildreq gcc-c++ gperf ncurses-devel perl time zlib-devel cmake libaio-devel
 %define distro_requires chkconfig coreutils grep procps shadow-utils net-tools
 %else
 %if "%rhelver" == "6"
 %define distro_description Red Hat Enterprise Linux 6
 %define distro_releasetag rhel6
 %define distro_buildreq gcc-c++ ncurses-devel perl time zlib-devel cmake libaio-devel
 %define distro_requires chkconfig coreutils grep procps shadow-utils net-tools
 %else
 %{error:Red Hat Enterprise Linux %{rhelver} is unsupported}
 %endif
 %endif
 %endif
 %else
 %if %(test -f /etc/SuSE-release &&echo 1 ||echo 0)
 %define susever %(rpm -qf --qf '%%{version}\\n' /etc/SuSE-release | cut -d. -f1)
 %if "%susever" == "10"
 %define distro_description SUSE Linux Enterprise Server 10
 %define distro_releasetag sles10
 %define distro_buildreq gcc-c++ gdbm-devel gperf ncurses-devel openldap2-client zlib-devel cmake libaio-devel
 %define distro_requires aaa_base coreutils grep procps pwdutils
 %else
 %if "%susever" == "11"
 %define distro_description SUSE Linux Enterprise Server 11
 %define distro_releasetag sles11
 %define distro_buildreq gcc-c++ gdbm-devel gperf ncurses-devel openldap2-client procps pwdutils zlib-devel cmake libaio-devel
 %define distro_requires aaa_base coreutils grep procps pwdutils
 %else
 %{error:SuSE %{susever} is unsupported}
 %endif
 %endif
 %else
 %{error:Unsupported distribution}
 %endif
 %endif
 %endif
 %endif
%else
 %define glibc_version %(/lib/libc.so.6 | grep stable | cut -d, -f1 | cut -c38-)
 %define distro_description Generic Linux (glibc %{glibc_version})
 %define distro_releasetag linux_glibc%{glibc_version}
 %define distro_buildreq gcc-c++ gperf ncurses-devel perl time zlib-devel
 %define distro_requires coreutils grep procps /sbin/chkconfig /usr/sbin/useradd /usr/sbin/groupadd
%endif

# Avoid debuginfo RPMs, leaves binaries unstripped
%define debug_package %{nil}

# Hack to work around bug in RHEL5 __os_install_post macro, wrong inverted
# test for __debug_package
%define __strip /bin/true

# ----------------------------------------------------------------------------
# Support optional "tcmalloc" library (experimental)
# ----------------------------------------------------------------------------
%if %{defined malloc_lib_target}
%define WITH_TCMALLOC 1
%else
%define WITH_TCMALLOC 0
%endif

##############################################################################
# Configuration based upon above user input, not to be set directly
##############################################################################

%if 0%{?commercial}
%define license_files_server %{src_dir}/LICENSE.mysql
%define license_type Commercial
%else
%define license_files_server %{src_dir}/COPYING %{src_dir}/README
%define license_type GPL
%endif

##############################################################################
# Main spec file section
##############################################################################

Name: MySQL%{product_suffix}
Summary: MySQL: a very fast and reliable SQL database server
Group: Applications/Databases
Version: @MYSQL_RPM_VERSION@
Release: %{release}%{?distro_releasetag:.%{distro_releasetag}}
Distribution: %{distro_description}
License: Copyright (c) 2000, @MYSQL_COPYRIGHT_YEAR@, %{mysql_vendor}. All rights reserved. Under %{license_type} license as shown in the Description field.
Source: http://www.mysql.com/Downloads/MySQL-@MYSQL_BASE_VERSION@/%{src_dir}.tar.gz
URL: http://www.mysql.com/
Packager: MySQL Release Engineering <mysql-build@oss.oracle.com>
Vendor: %{mysql_vendor}
BuildRequires: %{distro_buildreq}

# Regression tests may take a long time, override the default to skip them 
%{!?runselftest:%global runselftest 1}

# 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}

The MySQL software has Dual Licensing, which means you can use the MySQL
software free of charge under the GNU General Public License
(http://www.gnu.org/licenses/). You can also purchase commercial MySQL
licenses from %{mysql_vendor} if you do not wish to be bound by the terms of
the GPL. See the chapter "Licensing and Support"in the manual for
further info.

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 -n MySQL-server%{product_suffix}
Summary: MySQL: a very fast and reliable SQL database server
Group: Applications/Databases
Requires: %{distro_requires}
%if 0%{?commercial}
Obsoletes: MySQL-server
%else
Obsoletes: MySQL-server-advanced
%endif
Obsoletes: mysql-server < %{version}-%{release}
Obsoletes: mysql-server-advanced
Obsoletes: MySQL-server-classic MySQL-server-community MySQL-server-enterprise
Obsoletes: MySQL-server-advanced-gpl MySQL-server-enterprise-gpl
Provides: mysql-server = %{version}-%{release}
Provides: mysql-server%{?_isa} = %{version}-%{release}

%description -n MySQL-server%{product_suffix}
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}

The MySQL software has Dual Licensing, which means you can use the MySQL
software free of charge under the GNU General Public License
(http://www.gnu.org/licenses/). You can also purchase commercial MySQL
licenses from %{mysql_vendor} if you do not wish to be bound by the terms of
the GPL. See the chapter "Licensing and Support"in the manual for
further info.

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 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%{product_suffix}" as well!

# ----------------------------------------------------------------------------
%package -n MySQL-client%{product_suffix}
Summary: MySQL - Client
Group: Applications/Databases
%if 0%{?commercial}
Obsoletes: MySQL-client
%else
Obsoletes: MySQL-client-advanced
%endif
Obsoletes: mysql < %{version}-%{release}
Obsoletes: mysql-advanced < %{version}-%{release}
Obsoletes: MySQL-client-classic MySQL-client-community MySQL-client-enterprise
Obsoletes: MySQL-client-advanced-gpl MySQL-client-enterprise-gpl
Provides: mysql = %{version}-%{release} 
Provides: mysql%{?_isa} = %{version}-%{release}

%description -n MySQL-client%{product_suffix}
This package contains the standard MySQL clients and administration tools.

For a description of MySQL see the base MySQL RPM or http://www.mysql.com/

# ----------------------------------------------------------------------------
%package -n MySQL-test%{product_suffix}
Summary: MySQL - Test suite
Group: Applications/Databases
%if 0%{?commercial}
Requires: MySQL-client-advanced perl
Obsoletes: MySQL-test
%else
Requires: MySQL-client perl
Obsoletes: MySQL-test-advanced
%endif
Obsoletes: mysql-test < %{version}-%{release}
Obsoletes: mysql-test-advanced
Obsoletes: MySQL-test-classic MySQL-test-community MySQL-test-enterprise
Obsoletes: MySQL-test-advanced-gpl MySQL-test-enterprise-gpl
Provides: mysql-test = %{version}-%{release}
Provides: mysql-test%{?_isa} = %{version}-%{release}
AutoReqProv: no

%description -n MySQL-test%{product_suffix}
This package contains the MySQL regression test suite.

For a description of MySQL see the base MySQL RPM or http://www.mysql.com/

# ----------------------------------------------------------------------------
%package -n MySQL-devel%{product_suffix}
Summary: MySQL - Development header files and libraries
Group: Applications/Databases
%if 0%{?commercial}
Obsoletes: MySQL-devel
%else
Obsoletes: MySQL-devel-advanced
%endif
Obsoletes: mysql-devel < %{version}-%{release}
Obsoletes: mysql-embedded-devel mysql-devel-advanced mysql-embedded-devel-advanced
Obsoletes: MySQL-devel-classic MySQL-devel-community MySQL-devel-enterprise
Obsoletes: MySQL-devel-advanced-gpl MySQL-devel-enterprise-gpl
Provides: mysql-devel = %{version}-%{release}
Provides: mysql-devel%{?_isa} = %{version}-%{release}

%description -n MySQL-devel%{product_suffix}
This package contains the development header files and libraries necessary
to develop MySQL client applications.

For a description of MySQL see the base MySQL RPM or http://www.mysql.com/

# ----------------------------------------------------------------------------
%package -n MySQL-shared%{product_suffix}
Summary: MySQL - Shared libraries
Group: Applications/Databases
%if 0%{?commercial}
Obsoletes: MySQL-shared
%else
Obsoletes: MySQL-shared-advanced
%endif
Obsoletes: MySQL-shared-standard MySQL-shared-pro
Obsoletes: MySQL-shared-pro-cert MySQL-shared-pro-gpl
Obsoletes: MySQL-shared-pro-gpl-cert
Obsoletes: MySQL-shared-classic MySQL-shared-community MySQL-shared-enterprise
Obsoletes: MySQL-shared-advanced-gpl MySQL-shared-enterprise-gpl

%description -n MySQL-shared%{product_suffix}
This package contains the shared libraries (*.so*) which certain languages
and applications need to dynamically load and use MySQL.

# ----------------------------------------------------------------------------
%package -n MySQL-embedded%{product_suffix}
Summary: MySQL - Embedded library
Group: Applications/Databases
%if 0%{?commercial}
Requires: MySQL-devel-advanced
Obsoletes: MySQL-embedded
%else
Requires: MySQL-devel
Obsoletes: MySQL-embedded-advanced
%endif
Obsoletes: mysql-embedded < %{version}-%{release}
Obsoletes: mysql-embedded-advanced
Obsoletes: MySQL-embedded-pro
Obsoletes: MySQL-embedded-classic MySQL-embedded-community MySQL-embedded-enterprise
Obsoletes: MySQL-embedded-advanced-gpl MySQL-embedded-enterprise-gpl
Provides: mysql-embedded = %{version}-%{release}
Provides: mysql-emdedded%{?_isa} = %{version}-%{release}

%description -n MySQL-embedded%{product_suffix}
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.

For a description of MySQL see the base MySQL RPM or http://www.mysql.com/

##############################################################################
%prep
%setup -T -a 0 -c -n %{src_dir}
##############################################################################
%build

# Fail quickly and obviously if user tries to build as root
%if %runselftest
if [ x"`id -u`"= x0 ];then
echo"The MySQL regression tests may fail if run as root."
echo"If you really need to build the RPM as root, use"
echo"--define='runselftest 0' to skip the regression tests."
exit 1
fi
%endif

# Be strict about variables, bail at earliest opportunity, etc.
set -eu

# Optional package files
touch optional-files-devel

#
# Set environment in order of preference, MYSQL_BUILD_* first, then variable
# name, finally a default. RPM_OPT_FLAGS is assumed to be a part of the
# default RPM build environment.
#

# This is a hack, $RPM_OPT_FLAGS on ia64 hosts contains flags which break
# the compile in cmd-line-utils/libedit - needs investigation, but for now
# we simply unset it and use those specified directly in cmake.
%if "%{_arch}" == "ia64"
RPM_OPT_FLAGS=
%endif

export PATH=${MYSQL_BUILD_PATH:-$PATH}
export CC=${MYSQL_BUILD_CC:-${CC:-gcc}}
export CXX=${MYSQL_BUILD_CXX:-${CXX:-g++}}
export CFLAGS=${MYSQL_BUILD_CFLAGS:-${CFLAGS:-$RPM_OPT_FLAGS}}
export CXXFLAGS=${MYSQL_BUILD_CXXFLAGS:-${CXXFLAGS:-$RPM_OPT_FLAGS -felide-constructors}}
export LDFLAGS=${MYSQL_BUILD_LDFLAGS:-${LDFLAGS:-}}
export CMAKE=${MYSQL_BUILD_CMAKE:-${CMAKE:-cmake}}
export MAKE_JFLAG=${MYSQL_BUILD_MAKE_JFLAG:-}

# By default, a build will include the bundeled "yaSSL" library for SSL.
# However, there may be a need to override.
# Protect against undefined variables if there is no override option.
%if %{undefined with_ssl}
%define ssl_option %{nil}
%else
%define ssl_option -DWITH_SSL=%{with_ssl}
%endif

# Build debug mysqld and libmysqld.a
mkdir debug
(
cd debug
# Attempt to remove any optimisation flags from the debug build
 CFLAGS=`echo "${CFLAGS}"| \
 sed -e 's/ -O[0-9]* / /' \
 -e 's/-Wp,-D_FORTIFY_SOURCE=2/ /' \
 -e 's/ -unroll2 / /' \
 -e 's/ -ip / /' \
 -e 's/^ //' \
 -e 's/ $//'`
 CXXFLAGS=`echo "${CXXFLAGS}"| \
 sed -e 's/ -O[0-9]* / /' \
 -e 's/-Wp,-D_FORTIFY_SOURCE=2/ /' \
 -e 's/ -unroll2 / /' \
 -e 's/ -ip / /' \
 -e 's/^ //' \
 -e 's/ $//'`
# XXX: MYSQL_UNIX_ADDR should be in cmake/* but mysql_version is included before
# XXX: install_layout so we can't just set it based on INSTALL_LAYOUT=RPM
${CMAKE} ../%{src_dir} -DBUILD_CONFIG=mysql_release -DINSTALL_LAYOUT=RPM \
 -DCMAKE_BUILD_TYPE=Debug \
 -DMYSQL_UNIX_ADDR="%{mysqldatadir}/mysql.sock" \
 -DFEATURE_SET="%{feature_set}" \
 %{ssl_option} \
 -DCOMPILATION_COMMENT="%{compilation_comment_debug}" \
 -DMYSQL_SERVER_SUFFIX="%{server_suffix}"
echo BEGIN_DEBUG_CONFIG ; egrep '^#define' include/config.h ;echo END_DEBUG_CONFIG
 make ${MAKE_JFLAG} VERBOSE=1
)
# Build full release
mkdir release
(
cd release
# XXX: MYSQL_UNIX_ADDR should be in cmake/* but mysql_version is included before
# XXX: install_layout so we can't just set it based on INSTALL_LAYOUT=RPM
${CMAKE} ../%{src_dir} -DBUILD_CONFIG=mysql_release -DINSTALL_LAYOUT=RPM \
 -DCMAKE_BUILD_TYPE=RelWithDebInfo \
 -DMYSQL_UNIX_ADDR="%{mysqldatadir}/mysql.sock" \
 -DFEATURE_SET="%{feature_set}" \
 %{ssl_option} \
 -DCOMPILATION_COMMENT="%{compilation_comment_release}" \
 -DMYSQL_SERVER_SUFFIX="%{server_suffix}"
echo BEGIN_NORMAL_CONFIG ; egrep '^#define' include/config.h ;echo END_NORMAL_CONFIG
 make ${MAKE_JFLAG} VERBOSE=1
)

%if %runselftest
 MTR_BUILD_THREAD=auto
export MTR_BUILD_THREAD

 (cd release && make test-bt-fast || true)
%endif

##############################################################################
%install

RBR=$RPM_BUILD_ROOT
MBD=$RPM_BUILD_DIR/%{src_dir}

# 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%{_datadir}/mysql/SELinux/RHEL4
install -d $RBR%{_includedir}
install -d $RBR%{_libdir}
install -d $RBR%{_mandir}
install -d $RBR%{_sbindir}

mkdir -p $RBR%{_sysconfdir}/my.cnf.d

# Install all binaries
(
cd$MBD/release
 make DESTDIR=$RBR install
)

# FIXME: at some point we should stop doing this and just install everything
# FIXME: directly into %{_libdir}/mysql - perhaps at the same time as renaming
# FIXME: the shared libraries to use libmysql*-$major.$minor.so syntax
mv -v $RBR/%{_libdir}/*.a $RBR/%{_libdir}/mysql/

# Install logrotate and autostart
install -m 644 $MBD/release/support-files/mysql-log-rotate $RBR%{_sysconfdir}/logrotate.d/mysql
install -m 755 $MBD/release/support-files/mysql.server $RBR%{_sysconfdir}/init.d/mysql

# 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 might be located
# Just to make sure it's in the file list and marked as a config file
touch $RBR%{_sysconfdir}/my.cnf

# Install SELinux files in datadir
install -m 600 $MBD/%{src_dir}/support-files/RHEL4-SElinux/mysql.{fc,te} \
$RBR%{_datadir}/mysql/SELinux/RHEL4

%if %{WITH_TCMALLOC}
# Even though this is a shared library, put it under /usr/lib*/mysql, so it
# doesn't conflict with possible shared lib by the same name in /usr/lib*. See
# `mysql_config --variable=pkglibdir` and mysqld_safe for how this is used.
install -m 644 "%{malloc_lib_source}" \
"$RBR%{_libdir}/mysql/%{malloc_lib_target}"
%endif

# Remove man pages we explicitly do not want to package, avoids 'unpackaged
# files' warning.
# This has become obsolete: rm -f $RBR%{_mandir}/man1/make_win_bin_dist.1*

##############################################################################
# Post processing actions, i.e. when installed
##############################################################################

%pre -n MySQL-server%{product_suffix}
# This is the code running at the beginning of a RPM upgrade action,
# before replacing the old files with the new ones.

# ATTENTION: Parts of this are duplicated in the "triggerpostun" !

# There are users who deviate from the default file system layout.
# Check local settings to support them.
if [ -x %{_bindir}/my_print_defaults ]
then
 mysql_datadir=`%{_bindir}/my_print_defaults server mysqld | grep '^--datadir='| sed -n 's/--datadir=//p'`
 PID_FILE_PATT=`%{_bindir}/my_print_defaults server mysqld | grep '^--pid-file='| sed -n 's/--pid-file=//p'`
fi
if [ -z"$mysql_datadir" ]
then
 mysql_datadir=%{mysqldatadir}
fi
if [ -z"$PID_FILE_PATT" ]
then
 PID_FILE_PATT="$mysql_datadir/*.pid"
fi

# Check if we can safely upgrade. An upgrade is only safe if it's from one
# of our RPMs in the same version family.

# Handle both ways of spelling the capability.
installed=`rpm -q --whatprovides mysql-server 2> /dev/null`
if [ $?-ne 0 -o-z"$installed" ];then
 installed=`rpm -q --whatprovides MySQL-server 2> /dev/null`
fi
if [ $?-eq 0 -a-n"$installed" ];then
 installed=`echo $installed| sed 's/\([^ ]*\) .*/\1/'`# Tests have shown duplicated package names
 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='<unknown>'
 [ -z"$old_family" ] && old_family="<unrecognized version $version>"
 [ -z"$new_family" ] && new_family="<bad package specification: version $myversion>"

 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 <<HERE >&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 <package-name>' 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 -1 $PID_FILE_PATT2>/dev/null | wc -l`
case$NR_PID_FILESin
 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"You have more than one PID file:"
 ls -ld $PID_FILE_PATT
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.
# Check for the existence of subdirectory "mysql/", the database of system
# tables like "mysql.user".
if [ -d$mysql_datadir/mysql ] ;then
echo"MySQL RPM upgrade to version $NEW_VERSION">$STATUS_FILE
echo"'pre' step running at `date`">>$STATUS_FILE
echo>>$STATUS_FILE
 fcount=`ls -ltr $mysql_datadir/*.err 2>/dev/null | wc -l`
if [ $fcount-gt 0 ] ;then
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
fi

if [ -n"$SERVER_TO_START" ] ;then
# There is only one PID file, race possibility ignored
echo"PID file:">>$STATUS_FILE
 ls -l $PID_FILE_PATT>>$STATUS_FILE
 cat $PID_FILE_PATT>>$STATUS_FILE
echo>>$STATUS_FILE
echo"Server process:">>$STATUS_FILE
 ps -fp `cat $PID_FILE_PATT`>>$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 $PID_FILE_PATT>>$STATUS_FILE2>&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 -n MySQL-server%{product_suffix}
# This is the code running at the end of a RPM install or upgrade action,
# after the (new) files have been written.

# ATTENTION: Parts of this are duplicated in the "triggerpostun" !

# There are users who deviate from the default file system layout.
# Check local settings to support them.
if [ -x %{_bindir}/my_print_defaults ]
then
 mysql_datadir=`%{_bindir}/my_print_defaults server mysqld | grep '^--datadir='| sed -n 's/--datadir=//p'`
fi
if [ -z"$mysql_datadir" ]
then
 mysql_datadir=%{mysqldatadir}
fi

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=''
fi
# echo "Analyzed: SERVER_TO_START=$SERVER_TO_START"
if [ !-d$mysql_datadir/mysql ] ;then
 mkdir $mysql_datadir/mysql $mysql_datadir/test
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

# ----------------------------------------------------------------------
# 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 chkconfig on Enterprise Linux and newer SuSE releases
if [ -x /sbin/chkconfig ] ;then
 /sbin/chkconfig --add mysql
# use insserv for older SuSE Linux versions
elif [ -x /sbin/insserv ] ;then
 /sbin/insserv %{_sysconfdir}/init.d/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
# ----------------------------------------------------------------------
if! grep '^MySQL RPM upgrade'$STATUS_FILE>/dev/null 2>&1;then
# Fix bug#45415: no "mysql_install_db" on an upgrade
# Do this as a negative to err towards more "install" runs
# rather than to miss one.
 %{_bindir}/mysql_install_db --rpm --user=%{mysqld_user} --random-passwords

# Attention: Now 'root' is the only database user,
# its password is a random value found in ~/.mysql_secret,
# and the "password expired" flag is set:
# Any client needs that password, and the first command
# executed must be a new "set password"!
fi

# ----------------------------------------------------------------------
# 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

# ----------------------------------------------------------------------
# install SELinux files - but don't override existing ones
# ----------------------------------------------------------------------
SETARGETDIR=/etc/selinux/targeted/src/policy
SEDOMPROG=$SETARGETDIR/domains/program
SECONPROG=$SETARGETDIR/file_contexts/program
if [ -f /etc/redhat-release ] \
&& (grep -q "Red Hat Enterprise Linux .. release 4" /etc/redhat-release \
|| grep -q "CentOS release 4" /etc/redhat-release) ;then
echo
echo
echo'Notes regarding SELinux on this platform:'
echo'========================================='
echo
echo'The default policy might cause server startup to fail because it is'
echo'not allowed to access critical files. In this case, please update'
echo'your installation.'
echo
echo'The default policy might also cause inavailability of SSL related'
echo'features because the server is not allowed to access /dev/random'
echo'and /dev/urandom. If this is a problem, please do the following:'
echo
echo' 1) install selinux-policy-targeted-sources from your OS vendor'
echo' 2) add the following two lines to '$SEDOMPROG/mysqld.te':'
echo' allow mysqld_t random_device_t:chr_file read;'
echo' allow mysqld_t urandom_device_t:chr_file read;'
echo' 3) cd to '$SETARGETDIR' and issue the following command:'
echo' make load'
echo
echo
fi

if [ -x sbin/restorecon ] ;then
 sbin/restorecon -R var/lib/mysql
fi

# 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.
if [ -x %{_sysconfdir}/init.d/mysql ] ;then
 %{_sysconfdir}/init.d/mysql start
echo"Giving mysqld 5 seconds to start"
 sleep 5
fi
fi

# 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
mv -f $STATUS_FILE${STATUS_FILE}-LAST # for "triggerpostun"


#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."

%preun -n MySQL-server%{product_suffix}

# Which '$1' does this refer to? Fedora docs have info:
# " ... a count of the number of versions of the package that are installed.
# Action Count
# Install the first time 1
# Upgrade 2 or higher (depending on the number of versions installed)
# Remove last version of package 0 "
#
# http://docs.fedoraproject.org/en-US/Fedora_Draft_Documentation/0.1/html/RPM_Guide/ch09s04s05.html

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
# use chkconfig on Enterprise Linux and newer SuSE releases
if [ -x /sbin/chkconfig ] ;then
 /sbin/chkconfig --del mysql
# For older SuSE Linux versions
elif [ -x /sbin/insserv ] ;then
 /sbin/insserv -r %{_sysconfdir}/init.d/mysql
fi
fi
fi

# We do not remove the mysql user since it may still own a lot of
# database files.

%triggerpostun -n MySQL-server%{product_suffix} --MySQL-server-community

# Setup: We renamed this package, so any existing "server-community"
# package will be removed when this "server" is installed.
# Problem: RPM will first run the "pre" and "post" sections of this script,
# and only then the "preun" of that old community server.
# But this "preun" includes stopping the server and uninstalling the service,
# "chkconfig --del mysql" which removes the symlinks to the start script.
# Solution: *After* the community server got removed, restart this server
# and re-install the service.
#
# For information about triggers in spec files, see the Fedora docs:
# http://docs.fedoraproject.org/en-US/Fedora_Draft_Documentation/0.1/html/RPM_Guide/ch10s02.html
# For all details of this code, see the "pre" and "post" sections.

# There are users who deviate from the default file system layout.
# Check local settings to support them.
if [ -x %{_bindir}/my_print_defaults ]
then
 mysql_datadir=`%{_bindir}/my_print_defaults server mysqld | grep '^--datadir='| sed -n 's/--datadir=//p'`
fi
if [ -z"$mysql_datadir" ]
then