##
##  mysql.spec -- OpenPKG RPM Specification
##  Copyright (c) 2000-2003 The OpenPKG Project <http://www.openpkg.org/>
##  Copyright (c) 2000-2003 Ralf S. Engelschall <rse@engelschall.com>
##  Copyright (c) 2000-2003 Cable & Wireless <http://www.cw.com/>
##
##  Permission to use, copy, modify, and distribute this software for
##  any purpose with or without fee is hereby granted, provided that
##  the above copyright notice and this permission notice appear in all
##  copies.
##
##  THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
##  WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
##  MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
##  IN NO EVENT SHALL THE AUTHORS AND COPYRIGHT HOLDERS AND THEIR
##  CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
##  SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
##  LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
##  USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
##  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
##  OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
##  OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
##  SUCH DAMAGE.
##

#   package version
%define       V_major   4.0
%define       V_minor   14
%define       V_mysql   %{V_major}.%{V_minor}
%define       V_opkg    %{V_major}.%{V_minor}

#   package information
Name:         mysql
Summary:      Fast Relational Database Management System
URL:          http://www.mysql.com/
Vendor:       MySQL AB
Packager:     The OpenPKG Project
Distribution: OpenPKG [BASE]
Group:        Database
License:      GPL
Version:      %{V_opkg}
Release:      20030805

#   package options
%option       with_berkeleydb  yes
%option       with_innobase    no

#   list of sources
Source0:      http://sunsite.informatik.rwth-aachen.de/mysql/Downloads/MySQL-%{V_major}/mysql-%{V_mysql}.tar.gz
Source1:      my.cnf
Source2:      my.pwd
Source3:      rc.mysql
Patch0:       mysql.patch

#   build information
Prefix:       %{l_prefix}
BuildRoot:    %{l_buildroot}
BuildPreReq:  OpenPKG, openpkg >= 20030718, perl, gcc
PreReq:       OpenPKG, openpkg >= 20030718, perl
BuildPreReq:  zlib
PreReq:       zlib
AutoReq:      no
AutoReqProv:  no

%description
    MySQL is a multi-user Relational Database Management System (RDBMS),
    which is controlled through Structured Query Language (SQL) operating in
    full multi-threading mode. The main goals of MySQL are speed, robustness
    and ease of use. MySQL was originally developed because of the need for
    a SQL server that could handle very big databases with magnitude higher
    speed than what any database vendor could offer.

%prep
    %setup -q
    %patch -p0

%build
    #   patch file search path
    %{l_shtool} subst %{l_value -s -a} \
        mysys/default.c

    #   determine additional configure options
    case "%{l_target}" in
        *-freebsd* ) opt="--with-client-ldflags=-static --with-mysqld-ldflags=-static" ;;
        *-linux*   ) opt="--with-client-ldflags=-static --with-mysqld-ldflags=-static" ;;
        *-solaris* ) opt="--with-client-ldflags=-static --with-mysqld-ldflags=-static" ;;
    esac

    #   configure source tree
    CC="%{l_cc}" \
    CXX="%{l_cxx}" \
    CFLAGS="%{l_cflags -O}" \
    CXXFLAGS="%{l_cxxflags -O}" \
    ./configure \
        --prefix=%{l_prefix} \
        --sysconfdir=%{l_prefix}/etc/mysql \
        --localstatedir=%{l_prefix}/var/mysql \
        --libexecdir=%{l_prefix}/libexec/mysql \
        --with-unix-socket-path=%{l_prefix}/var/mysql/mysql.sock \
        --with-mysqld-user=%{l_musr} \
        --enable-thread-safe-client \
%if "%{with_berkeleydb}" == "yes"
        --with-berkeley-db \
%endif
%if "%{with_innobase}" == "no"
        --without-innodb \
%endif
        --with-low-memory \
        --disable-shared \
        $opt

    #   build source tree
    %{l_make} %{l_mflags}

%install
    rm -rf $RPM_BUILD_ROOT

    #   patch init script
    %{l_shtool} subst %{l_value -s -a} \
        scripts/mysql_install_db.sh

    #   perform standard installation procedure
    %{l_make} %{l_mflags} install \
        AM_MAKEFLAGS="DESTDIR=$RPM_BUILD_ROOT" \
        DESTDIR=$RPM_BUILD_ROOT

    #   move utility 'replace', msql2mysql is patched for new path
    mv $RPM_BUILD_ROOT%{l_prefix}/bin/replace \
       $RPM_BUILD_ROOT%{l_prefix}/libexec/mysql/

    #   strip installation area
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/mysql-test
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/sql-bench
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/info/dir
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/share/mysql/mysql-%{V_mysql}.spec
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/share/mysql/binary-configure
    strip  $RPM_BUILD_ROOT%{l_prefix}/bin/* 2>/dev/null || true
    strip  $RPM_BUILD_ROOT%{l_prefix}/libexec/mysql/* 2>/dev/null || true

    #   determine default parameters
%if "%{with_berkeleydb}" == "yes"
    l_mysql_bdb_cache_size=8M
    l_mysql_bdb_log_buffer_size=32k
    l_mysql_bdb_max_lock=10000
%else
    l_mysql_bdb_cache_size=0
    l_mysql_bdb_log_buffer_size=0
    l_mysql_bdb_max_lock=0
%endif
%if "%{with_berkeleydb}" == "yes" || "%{with_innobase}" == "yes"
    l_mysqld=mysqld
%else
    l_mysqld=mysqld-max
%endif

    #   install global configuration
    %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/etc/mysql
    %{l_shtool} install -c -m 644 %{l_value -s -a} \
        -e "s;@l_mysql_bdb_cache_size@;${l_mysql_bdb_cache_size};g" \
        -e "s;@l_mysql_bdb_log_buffer_size@;${l_mysql_bdb_log_buffer_size};g" \
        -e "s;@l_mysql_bdb_max_lock@;${l_mysql_bdb_max_lock};g" \
        %{SOURCE my.cnf} \
        $RPM_BUILD_ROOT%{l_prefix}/etc/mysql/
    %{l_shtool} install -c -m 600 \
        %{SOURCE my.pwd} \
        $RPM_BUILD_ROOT%{l_prefix}/etc/mysql/

    #   install run-command script
    %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d
    %{l_shtool} install -c -m 755 %{l_value -s -a} \
        -e "s;@l_mysqld@;${l_mysqld};g" \
        %{SOURCE rc.mysql} $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d/

    #   make sure the database directory exists
    %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/var/mysql

    #   determine the package files
    %{l_rpmtool} files -v -ofiles -r$RPM_BUILD_ROOT \
        %{l_files_std} \
        '%config %{l_prefix}/etc/mysql/my.cnf' \
        '%config %{l_prefix}/etc/mysql/my.pwd' \
        '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/mysql'

%files -f files

%clean
    rm -rf $RPM_BUILD_ROOT

%pre
    #   before upgrade, save status and stop service
    [ $1 -eq 2 ] || exit 0
    eval `%{l_rc} mysql status 2>/dev/null | tee %{l_tmpfile}`
    %{l_rc} mysql stop 2>/dev/null
    exit 0

%post
    if [ $1 -eq 1 ]; then
        #   after install, create initial database
        $RPM_INSTALL_PREFIX/bin/mysql_install_db \
            --defaults-file=$RPM_INSTALL_PREFIX/etc/mysql/my.cnf
        chown %{l_rusr}:%{l_rgrp} \
            $RPM_INSTALL_PREFIX/etc/mysql/my.cnf \
            $RPM_INSTALL_PREFIX/etc/mysql/my.pwd
        chown -R %{l_rusr}:%{l_rgrp} $RPM_INSTALL_PREFIX/var/mysql/*
        ( echo "The MySQL package includes automated maintenance procedures"
          echo "that require administrator access to the database. For this"
          echo "to work you must keep a copy (plain text) of the administrator"
          echo "account in '$RPM_INSTALL_PREFIX/etc/mysql/my.pwd'."
        ) | %{l_rpmtool} msg -b -t notice
    fi
    if [ $1 -eq 2 ]; then
        #   after upgrade, restore status
        { eval `cat %{l_tmpfile}`; rm -f %{l_tmpfile}; true; } >/dev/null 2>&1
        [ ".$mysql_active" = .yes ] && %{l_rc} mysql start
    fi
    exit 0

%preun
    #   before erase, stop service and remove log files
    [ $1 -eq 0 ] || exit 0
    %{l_rc} mysql stop 2>/dev/null
    rm -f $RPM_INSTALL_PREFIX/var/mysql/*.log* >/dev/null 2>&1 || true
    rm -f $RPM_INSTALL_PREFIX/var/mysql/*.err* >/dev/null 2>&1 || true
    exit 0