From 3d74e7552a27d6bc6cfa1a2d83de6ec4e9516643 Mon Sep 17 00:00:00 2001 From: Heinz Wiesinger Date: Wed, 20 Oct 2010 01:54:52 -0500 Subject: system/mariadb: Added (Drop-in replacement for MySQL) Signed-off-by: Robby Workman --- system/mariadb/README | 9 ++ system/mariadb/doinst.sh | 26 ++++++ system/mariadb/mariadb.SlackBuild | 183 ++++++++++++++++++++++++++++++++++++++ system/mariadb/mariadb.info | 10 +++ system/mariadb/rc.mysqld | 85 ++++++++++++++++++ system/mariadb/slack-desc | 19 ++++ 6 files changed, 332 insertions(+) create mode 100644 system/mariadb/README create mode 100644 system/mariadb/doinst.sh create mode 100644 system/mariadb/mariadb.SlackBuild create mode 100644 system/mariadb/mariadb.info create mode 100644 system/mariadb/rc.mysqld create mode 100644 system/mariadb/slack-desc diff --git a/system/mariadb/README b/system/mariadb/README new file mode 100644 index 0000000000..82cbe95847 --- /dev/null +++ b/system/mariadb/README @@ -0,0 +1,9 @@ +MariaDB is a backward compatible, drop-in replacement branch of the +MySQL(R) Database Server. It includes all major open source storage +engines, including the Aria storage engine. + +This conflicts with Slackware's mysql package. Do NOT install both! + +If you want to build the embedded mysql server (libmysqld), which +you will need if you plan to (re)build amarok, then run the script +with EMBEDDED=yes in the environment. diff --git a/system/mariadb/doinst.sh b/system/mariadb/doinst.sh new file mode 100644 index 0000000000..30509fa0d9 --- /dev/null +++ b/system/mariadb/doinst.sh @@ -0,0 +1,26 @@ +config() { + NEW="$1" + OLD="$(dirname $NEW)/$(basename $NEW .new)" + # If there's no config file by that name, mv it over: + if [ ! -r $OLD ]; then + mv $NEW $OLD + elif [ "$(cat $OLD | md5sum)" = "$(cat $NEW | md5sum)" ]; then + # toss the redundant copy + rm $NEW + fi + # Otherwise, we leave the .new copy for the admin to consider... +} + +preserve_perms() { + NEW="$1" + OLD="$(dirname $NEW)/$(basename $NEW .new)" + if [ -e $OLD ]; then + cp -a $OLD ${NEW}.incoming + cat $NEW > ${NEW}.incoming + mv ${NEW}.incoming $NEW + fi + config $NEW +} + +preserve_perms etc/rc.d/rc.mysqld.new + diff --git a/system/mariadb/mariadb.SlackBuild b/system/mariadb/mariadb.SlackBuild new file mode 100644 index 0000000000..9e667de4e5 --- /dev/null +++ b/system/mariadb/mariadb.SlackBuild @@ -0,0 +1,183 @@ +#!/bin/sh + +# Copyright 2008, 2009, 2010 Patrick J. Volkerding, Sebeka, Minnesota, USA +# Copyright 2010 Heinz Wiesinger, Amsterdam, The Netherlands +# All rights reserved. +# +# Redistribution and use of this script, with or without modification, is +# permitted provided that the following conditions are met: +# +# 1. Redistributions of this script must retain the above copyright +# notice, this list of conditions and the following disclaimer. +# +# THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS 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 AUTHOR 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. + +# Build and install MySQL on Slackware +# by: David Cantrell +# MySQL version maintained by: Patrick Volkerding +# MariaDB version maintained by: Heinz Wiesinger + +PRGNAM=mariadb +SRCVER=5.2.2-gamma +VERSION=5.2.2gamma +BUILD=${BUILD:-1} +TAG=${TAG:-_SBo} + +if [ -z "$ARCH" ]; then + case "$( uname -m )" in + i?86) ARCH=i486 ;; + arm*) ARCH=arm ;; + *) ARCH=$( uname -m ) ;; + esac +fi + +CWD=$(pwd) +TMP=${TMP:-/tmp/SBo} +PKG=$TMP/package-$PRGNAM +OUTPUT=${OUTPUT:-/tmp} + +if [ "${EMBEDDED:-no}" = "" ]; then + embed="" +else + embed="--with-embedded-server" +fi + +if [ "$ARCH" = "i486" ]; then + SLKCFLAGS="-O2 -march=i486 -mtune=i686" + LIBDIRSUFFIX="" +elif [ "$ARCH" = "i686" ]; then + SLKCFLAGS="-O2 -march=i686 -mtune=i686" + LIBDIRSUFFIX="" +elif [ "$ARCH" = "x86_64" ]; then + SLKCFLAGS="-O2 -fPIC" + LIBDIRSUFFIX="64" +fi + +set -e + +rm -rf $PKG +mkdir -p $TMP $PKG +cd $TMP +rm -rf $PRGNAM-$SRCVER +tar xvf $CWD/$PRGNAM-$SRCVER.tar.gz +cd $PRGNAM-$SRCVER +chown -R root:root . +find . \ + \( -perm 777 -o -perm 775 -o -perm 711 -o -perm 555 -o -perm 511 \) \ + -exec chmod 755 {} \; -o \ + \( -perm 666 -o -perm 664 -o -perm 600 -o -perm 444 -o -perm 440 -o -perm 400 \) \ + -exec chmod 644 {} \; + +#./BUILD/autorun.sh + +CFLAGS="$SLKCFLAGS" \ +CXXFLAGS="$SLKCFLAGS -felide-constructors -fno-exceptions -fno-rtti" \ +CXX=g++ \ +./configure \ + --prefix=/usr \ + --libdir=/usr/lib${LIBDIRSUFFIX} \ + --with-mysqld-user=mysql \ + --with-unix-socket-path=/var/run/mysql/mysql.sock \ + --localstatedir=/var/lib/mysql \ + --mandir=/usr/man \ + --infodir=/usr/info \ + --enable-assembler \ + --without-debug \ + --enable-thread-safe-client \ + --with-extra-charsets=complex \ + --with-ssl=/usr \ + --with-aria-tmp-tables \ + --with-libevent \ + --enable-largefile \ + --with-readline \ + --with-big-tables \ + --enable-local-infile \ + --with-plugins=max \ + --without-plugin-innodb_plugin \ + --build=$ARCH-slackware-linux \ + $embed + +make +make install DESTDIR=$PKG + +# install additional headers needed for building external engine plugins +for i in sql include regex; do + for j in $i/*.h; do + install -m 0644 $j $PKG/usr/include/mysql/ + done +done + +mkdir -p $PKG/usr/include/mysql/atomic +for i in include/atomic/*.h; do + install -m 0644 $i $PKG/usr/include/mysql/atomic/ +done + +install -m 0644 storage/maria/ma_{pagecache,loghandler_lsn}.h \ + $PKG/usr/include/mysql/ +sed -i "s|../storage/maria/ma_pagecache.h|ma_pagecache.h|" \ + $PKG/usr/include/mysql/maria.h + +cd $PKG/usr/lib${LIBDIRSUFFIX} + for i in libmysqlclient libmysqlclient_r; do + rm -f $i.so $i.so.16 + ln -sf mysql/$i.so $i.so + ln -sf mysql/$i.so.16 $i.so.16 + done +cd - + +# The ./configure option to omit this has gone away, so we'll omit it +# the old-fashioned way. It's all in the source tarball if you need it. +rm -rf $PKG/usr/sql-bench + +# Do not include the test suite: +rm -rf $PKG/usr/mysql-test + +# Install support files +mkdir -p $PKG/etc +cp support-files/my-{huge,large,medium,small}.cnf $PKG/etc + +# This is the directory where databases are stored +mkdir -p $PKG/var/lib/mysql +chown mysql.mysql $PKG/var/lib/mysql +chmod 0750 $PKG/var/lib/mysql + +# This is where the socket is stored +mkdir -p $PKG/var/run/mysql +chown mysql.mysql $PKG/var/run/mysql +chmod 0755 $PKG/var/run/mysql + +# Add init script: +mkdir -p $PKG/etc/rc.d +# This is intentionally chmod 644. +cat $CWD/rc.mysqld > $PKG/etc/rc.d/rc.mysqld.new + +find $PKG | xargs file | grep -e "executable" -e "shared object" | grep ELF \ + | cut -f 1 -d : | xargs strip --strip-unneeded 2> /dev/null + +rm -f $PKG/usr/info/dir +gzip -9 $PKG/usr/info/* + +find $PKG/usr/man -type f -exec gzip -9 {} \; +for i in $( find $PKG/usr/man -type l ) ; do ln -s $( readlink $i ).gz $i.gz ; rm $i ; done + +mkdir -p $PKG/usr/doc/$PRGNAM-$VERSION +cp -a \ + COPYING* EXCEPTIONS* INSTALL-SOURCE README* Docs/INSTALL-BINARY \ + $PKG/usr/doc/$PRGNAM-$VERSION +find $PKG/usr/doc/$PRGNAM-$VERSION -type f -exec chmod 0644 {} \; + +mkdir -p $PKG/install +cat $CWD/doinst.sh > $PKG/install/doinst.sh +cat $CWD/slack-desc > $PKG/install/slack-desc + +cd $PKG +/sbin/makepkg -l y -c n $OUTPUT/$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.${PKGTYPE:-tgz} diff --git a/system/mariadb/mariadb.info b/system/mariadb/mariadb.info new file mode 100644 index 0000000000..1d8505f96c --- /dev/null +++ b/system/mariadb/mariadb.info @@ -0,0 +1,10 @@ +PRGNAM="mariadb" +VERSION="5.2.2gamma" +HOMEPAGE="http://askmonty.org/wiki/index.php/MariaDB" +DOWNLOAD="http://ftp-stud.hs-esslingen.de/pub/Mirrors/mariadb/mariadb-5.2.2-gamma/kvm-tarbake-jaunty-x86/mariadb-5.2.2-gamma.tar.gz" +MD5SUM="cbc82d35198ba21c07b192489d41e899" +DOWNLOAD_x86_64="" +MD5SUM_x86_64="" +MAINTAINER="Heinz Wiesinger" +EMAIL="pprkut@liwjatan.at" +APPROVED="rworkman" diff --git a/system/mariadb/rc.mysqld b/system/mariadb/rc.mysqld new file mode 100644 index 0000000000..753a175fc1 --- /dev/null +++ b/system/mariadb/rc.mysqld @@ -0,0 +1,85 @@ +#!/bin/sh +# Start/stop/restart mysqld. +# +# Copyright 2003 Patrick J. Volkerding, Concord, CA +# Copyright 2003 Slackware Linux, Inc., Concord, CA +# Copyright 2008 Patrick J. Volkerding, Sebeka, MN +# +# This program comes with NO WARRANTY, to the extent permitted by law. +# You may redistribute copies of this program under the terms of the +# GNU General Public License. + +# To start MySQL automatically at boot, be sure this script is executable: +# chmod 755 /etc/rc.d/rc.mysqld + +# Before you can run MySQL, you must have a database. To install an initial +# database, do this as root: +# +# mysql_install_db --user=mysql +# +# Note that the mysql user must exist in /etc/passwd, and the created files +# will be owned by this dedicated user. This is important, or else mysql +# (which runs as user "mysql") will not be able to write to the database +# later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql'). +# +# To increase system security, consider using "mysql_secure_installation" +# as well. For more information on this tool, please read: +# man mysql_secure_installation + +# To allow outside connections to the database comment out the next line. +# If you don't need incoming network connections, then leave the line +# uncommented to improve system security. +SKIP="--skip-networking" + +# Start mysqld: +mysqld_start() { + if [ -x /usr/bin/mysqld_safe ]; then + # If there is an old PID file (no mysqld running), clean it up: + if [ -r /var/run/mysql/mysql.pid ]; then + if ! ps axc | grep mysqld 1> /dev/null 2> /dev/null ; then + echo "Cleaning up old /var/run/mysql/mysql.pid." + rm -f /var/run/mysql/mysql.pid + fi + fi + /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid $SKIP & + fi +} + +# Stop mysqld: +mysqld_stop() { + # If there is no PID file, ignore this request... + if [ -r /var/run/mysql/mysql.pid ]; then + killall mysqld + # Wait at least one minute for it to exit, as we don't know how big the DB is... + for second in $(seq 0 60) ; do + if [ ! -r /var/run/mysql/mysql.pid ]; then + break; + fi + sleep 1 + done + if [ "$second" = "60" ]; then + echo "WARNING: Gave up waiting for mysqld to exit!" + sleep 15 + fi + fi +} + +# Restart mysqld: +mysqld_restart() { + mysqld_stop + mysqld_start +} + +case "$1" in +'start') + mysqld_start + ;; +'stop') + mysqld_stop + ;; +'restart') + mysqld_restart + ;; +*) + echo "usage $0 start|stop|restart" +esac diff --git a/system/mariadb/slack-desc b/system/mariadb/slack-desc new file mode 100644 index 0000000000..cb92965dfa --- /dev/null +++ b/system/mariadb/slack-desc @@ -0,0 +1,19 @@ +# HOW TO EDIT THIS FILE: +# The "handy ruler" below makes it easier to edit a package description. Line +# up the first '|' above the ':' following the base package name, and the '|' +# on the right side marks the last column you can put a character in. You must +# make exactly 11 lines for the formatting to be correct. It's also +# customary to leave one space after the ':'. + + |-----handy-ruler------------------------------------------------------| +mariadb: mariadb (Drop-in replacement for the MySQL Database Server) +mariadb: +mariadb: MariaDB is a backward compatible, drop-in replacement branch of the +mariadb: MySQL(R) Database Server. It includes all major open source storage +mariadb: engines, including the Maria storage engine. +mariadb: +mariadb: Homepage: http://askmonty.org/wiki/index.php/MariaDB +mariadb: +mariadb: +mariadb: +mariadb: -- cgit v1.2.3