File mysql-community-server.spec of Package mysql-community-server.1191
#
# spec file for package mysql-community-server
#
# Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany.
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
# upon. The license for this file, and modifications and additions to the
# file, is the same license as for the pristine package itself (unless the
# license for the pristine package is not an Open Source License, in which
# case the license is the MIT License). An "Open Source License" is a
# license that conforms to the Open Source Definition (Version 1.9)
# published by the Open Source Initiative.
# Please submit bugfixes or comments via http://bugs.opensuse.org/
#
# Few definitions which will alter build
%define prefered 1
%define use_cmake 1
%define cluster 0
%define builtin_plugins partition,csv,heap,myisam,innobase
%if %{?rel:0}%{!?rel:1}
%define rel 1
%endif
#Distribution: %dist
#Packager: %packager
#Vendor: %vendor
Name: mysql-community-server
Summary: A True Multiuser, Multithreaded SQL Database Server
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Servers
Version: 5.5.28
Release: 0
%define srv_vers 5.5.28
Url: http://www.mysql.com
# http://dev.mysql.com/get/Downloads/MySQL-5.5/%{name}-%{version}.tar.gz/from/pick
Source: mysql-%{version}.tar.bz2
Source2: baselibs.conf
Source3: README.debug
Source4: suse-test-run
Source5: mysql.SuSEfirewall2
Source7: rc.mysql-multi
Source8: README.SuSE
Source9: mysql-patches.tar.bz2
Source10: build.inc
Source11: install.inc
Source12: series
Source13: default_plugins.cnf
Source14: old-ssl.series
BuildRoot: %{_tmppath}/%{name}-%{version}-build
%if 0%{?suse_version}
PreReq: pwdutils
%else
PreReq: /usr/sbin/useradd /usr/sbin/usermod /usr/sbin/groupadd
%endif
PreReq: coreutils sed grep
%if 0%{?suse_version}
PreReq: %install_info_prereq %insserv_prereq
%endif
BuildRequires: cmake
BuildRequires: gcc-c++
BuildRequires: ncurses-devel
BuildRequires: openssl-devel
BuildRequires: procps
BuildRequires: readline-devel
BuildRequires: zlib-devel
%if 0%{?suse_version}
BuildRequires: pwdutils
BuildRequires: tcpd-devel
%endif
%if 0%{?suse_version} > 1030 || 0%{?fedora_version} > 8
BuildRequires: fdupes
%endif
%if 0%{?fedora_version} > 11
BuildRequires: sqlite
%endif
%if 0%{?suse_version} > 1030
Recommends: logrotate
%else
Requires: logrotate
%endif
# required by rcmysql
Requires: %{name}-client
Requires: %{name}-errormessages = %version
Requires: perl-base
Obsoletes: mysql-Max < %{srv_vers}
Provides: mysql-Max = %{srv_vers}
Obsoletes: mysql < %{srv_vers}
Provides: mysql = %{srv_vers}
Conflicts: otherproviders(mysql)
%description
SQL is the most popular database language in the world. MySQL is a
client/server implementation that consists of a server daemon (mysqld)
and many different client programs and libraries.
The main goals of MySQL are speed, robustness, and ease of use. MySQL
was originally developed because the developers at TcX needed an SQL
server that could handle very large databases an order of magnitude
faster than what any database vendor could offer them. They have now
been using MySQL since 1996 in an environment with more than 40
databases containing 10,000 tables, of which more than 500 have more
than 7 million rows. This is about 100 gigabytes of mission-critical
data.
The base upon which MySQL is built is a set of routines that have been
used in a highly demanding production environment for many years. While
MySQL is still in development, it already offers a rich and highly
useful function set.
The official way to pronounce MySQL is "My Ess Que Ell" (Not
MY-SEQUEL).
This package only contains the server-side programs.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
%if 0%{?prefered} > 0
#-------------------------------------------------------------------------------
%package -n libmysqlclient-devel
#-------------------------------------------------------------------------------
# mysql-devel was last used in openSUSE 10.2
Provides: mysql-devel = %srv_vers-%release
Obsoletes: mysql-devel < %srv_vers
Requires: glibc-devel
Requires: libmysqlclient18 = %version
Requires: libmysqlclient_r18 = %version
Requires: openssl-devel
Requires: zlib-devel
Summary: MySQL Development Header Files and Libraries
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Development/Libraries/C and C++
%description -n libmysqlclient-devel
This package contains the development header files and libraries
necessary to develop MySQL client applications.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
#-------------------------------------------------------------------------------
%package -n libmysqld18
#-------------------------------------------------------------------------------
Summary: MySQL embedded server development files
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Development/Libraries/C and C++
Requires: %{name}-errormessages = %version
%description -n libmysqld18
This package contains the development header files and libraries
for developing applications that embed the MySQL server.
#-------------------------------------------------------------------------------
%package -n libmysqld-devel
#-------------------------------------------------------------------------------
Summary: MySQL embedded server development files
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Development/Libraries/C and C++
# the headers files are the shared
Requires: libmysqlclient-devel = %version
Requires: libmysqld18 = %version
Requires: tcpd-devel
%description -n libmysqld-devel
This package contains the development header files and libraries
for developing applications that embed the MySQL server.
%endif
#-------------------------------------------------------------------------------
%package -n libmysqlclient18
#-------------------------------------------------------------------------------
Summary: MySQL Shared Libraries
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Development/Libraries/Other
%description -n libmysqlclient18
This package contains the shared libraries (.so) which certain
languages and applications need to dynamically load and use MySQL.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
#-------------------------------------------------------------------------------
%package -n libmysqlclient_r18
#-------------------------------------------------------------------------------
Summary: MySQL Shared Libraries
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Development/Libraries/Other
%description -n libmysqlclient_r18
This package contains the shared libraries (.so) which certain
languages and applications need to dynamically load and use MySQL.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
#-------------------------------------------------------------------------------
%package client
#-------------------------------------------------------------------------------
Summary: MySQL Client
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Clients
Provides: mysql-client = %{srv_vers}
Obsoletes: mysql-client < %{srv_vers}
Conflicts: otherproviders(mysql-client)
Requires: %{name}-errormessages = %version
%description client
This package contains the standard MySQL clients.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
#-------------------------------------------------------------------------------
%package errormessages
#-------------------------------------------------------------------------------
Summary: MySQL Community Server development header files and libraries
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Development/Libraries/C and C++
%description errormessages
This package provides the translated error messages for the standalone
server daemon as well as the embedded server
#-------------------------------------------------------------------------------
%package bench
#-------------------------------------------------------------------------------
Requires: %{name}-client
Requires: perl-DBD-mysql
Summary: MySQL - Benchmarks
License: LGPL-2.1
Group: Productivity/Databases/Tools
Provides: mysql-bench = %{srv_vers}
Obsoletes: mysql-bench < %{srv_vers}
Conflicts: otherproviders(mysql-bench)
%description bench
This package contains MySQL benchmark scripts and data.
To run these database benchmarks, start the script "run-all-tests" in
the directory /usr/share/sql-bench after starting MySQL.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
#-------------------------------------------------------------------------------
%if %{defined mdkversion}
%package debuging
%else
%package debug
%endif
#-------------------------------------------------------------------------------
Summary: MySQL server with debug options turned on
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Servers
Requires: %{name} = %{version}
Provides: mysql-debug = %{srv_vers}
Obsoletes: mysql-debug < %{srv_vers}
Conflicts: otherproviders(mysql-debug)
%if %{defined mdkversion}
%description debuging
%else
%description debug
%endif
A version of the mysql server that has some debug code turned on.
It should be only used to track down problems with the standard
servers. Note that merely installing this package won't replace the
standard server. Read /usr/share/doc/packages/mysql/README.debug for
information on how to use the debug server.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
#-------------------------------------------------------------------------------
%package test
#-------------------------------------------------------------------------------
Summary: MySQL testsuite
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Servers
Requires: %{name} = %{version}
Requires: %{name}-bench = %{version}
Requires: %{name}-client = %{version}
Requires: %{name}-tools = %{version}
Requires: perl-DBD-mysql
Provides: mysql-test = %{srv_vers}
Obsoletes: mysql-test < %{srv_vers}
Conflicts: otherproviders(mysql-test)
%description test
This package contains the MySQL test scripts and data.
To run the testsuite, run /usr/share/mysql-test/suse-test-run.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
#-------------------------------------------------------------------------------
%package tools
#-------------------------------------------------------------------------------
Summary: MySQL tools
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Servers
Requires: perl-DBD-mysql
# make sure this package is installed when updating from 10.2 and older
Provides: mysql-client:/usr/bin/perror
Provides: mysql-tools = %{srv_vers}
Provides: mysql:/usr/bin/mysqlhotcopy
Obsoletes: mysql-tools < %{srv_vers}
Conflicts: otherproviders(mysql-tools)
%description tools
A set of scripts for administering a MySQL server or developing
applications with MySQL.
Authors:
--------
Michael Widenius <monty@mysql.com>
David Axmark <davida@mysql.com>
%if 0%{?cluster} > 0
#-------------------------------------------------------------------------------
%package ndb-storage
#-------------------------------------------------------------------------------
Summary: MySQL - ndbcluster storage engine
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Servers
Provides: mysql-ndb-storage = %{srv_vers}
Obsoletes: mysql-ndb-storage < %{srv_vers}
Conflicts: otherproviders(mysql-ndb-storage)
%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.
#-------------------------------------------------------------------------------
%package ndb-management
#-------------------------------------------------------------------------------
Summary: MySQL - ndbcluster storage engine management
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Servers
Provides: mysql-ndb-management = %{srv_vers}
Obsoletes: mysql-ndb-management < %{srv_vers}
Conflicts: otherproviders(mysql-ndb-management)
%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.
#-------------------------------------------------------------------------------
%package ndb-tools
#-------------------------------------------------------------------------------
Summary: MySQL - ndbcluster storage engine basic tools
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Servers
Provides: mysql-ndb-tools = %{srv_vers}
Obsoletes: mysql-ndb-tools < %{srv_vers}
Conflicts: otherproviders(mysql-ndb-tools)
%description ndb-tools
This package contains ndbcluster storage engine basic tools.
#-------------------------------------------------------------------------------
%package ndb-extra
#-------------------------------------------------------------------------------
Summary: MySQL - ndbcluster storage engine extra tools
License: GPL-2.0 ; with additional permissions: EXCEPTIONS-CLIENT
Group: Productivity/Databases/Servers
Provides: mysql-ndb-extra = %{srv_vers}
Obsoletes: mysql-ndb-extra < %{srv_vers}
Conflicts: otherproviders(mysql-ndb-extra)
%description ndb-extra
This package contains some extra ndbcluster storage engine tools for the
advanced user. They should be used with caution.
%endif
#-------------------------------------------------------------------------------
%prep
#-------------------------------------------------------------------------------
%setup -q -n mysql-%version -D -a 9
cp %_sourcedir/README.SuSE .
cp %_sourcedir/suse-test-run .
# apply patches from series
mysql-patches/tools/quilt-setup.sh "%{S:12}"
mysql-patches/tools/apply-series.sh "%{S:12}"
# remove unneeded manpages ('make install' basically installs everything under
# man/*)
rm -f man/mysqlman.1 # dummy fallback manpage
rm -f man/mysql.server.1 # init script, not installed in our rpm
rm -f man/make_win_*.1 # windows build scripts
rm -f man/comp_err.1 # built-time utility
# 5.1 Carrier Grade Edition only / still under development as of 5.1.22
rm -f man/ndbd_redo_log_reader.1
# breaks VPATH builds when in sourcedir, is generated in the builddirs
rm -f sql/sql_builtin.cc
sed -i 's|@localstatedir@|/var/log|' support-files/mysql-log-rotate.sh
#-------------------------------------------------------------------------------
%build
#-------------------------------------------------------------------------------
%{expand:%(cat %_sourcedir/build.inc)}
#-------------------------------------------------------------------------------
%install
#-------------------------------------------------------------------------------
%{expand:%(cat %_sourcedir/install.inc)}
#-------------------------------------------------------------------------------
%pre
#-------------------------------------------------------------------------------
/usr/sbin/groupadd -r mysql >/dev/null 2>/dev/null || :
/usr/sbin/useradd -r -o -g mysql -u 60 -c "MySQL database admin" \
-s /bin/false -d /var/lib/mysql mysql 2> /dev/null || :
/usr/sbin/usermod -g mysql -s /bin/false mysql || :
#-------------------------------------------------------------------------------
%preun
#-------------------------------------------------------------------------------
[ $1 = 1 ] || /usr/sbin/rcmysql stop
%pretrans -p <lua>
if posix.access("/usr/sbin/rcmysql", "x") then
restart = os.execute("/usr/sbin/rcmysql status > /dev/null")
os.execute("/usr/sbin/rcmysql stop")
if restart == 0 then
os.execute("/bin/mkdir -p /var/run/mysql/restart")
end
end
dbfile="var/mysql/mysql/db.ISM"
olddir="var/mysql"
newdir="var/lib/mysql"
-- Do the database files still belong to root (very old installation)?
-- Change ownerships
if posix.stat(dbfile, "uid") == 0 then
os.execute("/bin/chown -Rv mysql:mysql var/mysql/")
end
%posttrans
#-------------------------------------------------------------------------------
%install_info --info-dir=%{_infodir} %{_infodir}/mysql.info.*
if [ -d /var/lib/mysql ]; then
touch /var/lib/mysql/.run-mysql_upgrade
chown -R mysql:mysql /var/lib/mysql
fi
for i in /var/lib/mysql/{.protected,.tmp}; do
( [ -d "$i" ] && rmdir "$i" ) || :
done
# start mysql again if it should run
if [ "`ls /etc/rc.d/rc*.d/S*mysql 2> /dev/null`" ] || [ -d /var/run/mysql/restart ]; then
[ -x /usr/sbin/rcmysql ] && /usr/sbin/rcmysql start
rmdir /var/run/mysql/restart || :
fi
%post -n libmysqlclient18 -p /sbin/ldconfig
%postun -n libmysqlclient18 -p /sbin/ldconfig
%post -n libmysqlclient_r18 -p /sbin/ldconfig
%postun -n libmysqlclient_r18 -p /sbin/ldconfig
%if 0%{prefered} > 0
%post -n libmysqld18 -p /sbin/ldconfig
%postun -n libmysqld18 -p /sbin/ldconfig
%endif
#-------------------------------------------------------------------------------
%postun
#-------------------------------------------------------------------------------
if [ $1 = 0 ]; then
%install_info_delete --info-dir=%{_infodir} %{_infodir}/mysql.info.*
%{insserv_cleanup}
fi
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%clean
#-------------------------------------------------------------------------------
[ "$RPM_BUILD_ROOT" != "/" ] && [ -d $RPM_BUILD_ROOT ] && %{__rm} -rf $RPM_BUILD_ROOT
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files -f mysql.files
#-------------------------------------------------------------------------------
%defattr(-, root, root)
%config(noreplace) %attr(0640, root, mysql) /etc/my.cnf
%dir %attr(0750, root, mysql) /etc/mysql
%config(noreplace) %attr(0640, root, mysql) /etc/mysql/*
%config /etc/logrotate.d/mysql
%doc %{_defaultdocdir}/%{name}
%doc %{_infodir}/mysql.info.*
/etc/init.d/mysql
/usr/sbin/rcmysql
/usr/share/mysql/
%ghost %dir %attr(755,mysql,mysql)/var/run/mysql
%dir %{_libdir}/mysql
%{_libdir}/mysql/mysqld.sym
%config /etc/sysconfig/SuSEfirewall2.d/services/mysql
%dir %_libdir/mysql/plugin
%_libdir/mysql/plugin/*.so
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files errormessages
#-------------------------------------------------------------------------------
%defattr(-, root, root)
/usr/share/mysql/*/errmsg.sys
%files client -f mysql-client.files
#-------------------------------------------------------------------------------
%defattr(-, root, root)
%config /etc/mysqlaccess.conf
#-------------------------------------------------------------------------------
%if 0%{prefered} > 0
#-------------------------------------------------------------------------------
%files -n libmysqlclient-devel -f libmysqlclient-devel.files
#-------------------------------------------------------------------------------
%defattr(-, root, root)
/usr/include/mysql
%{_libdir}/libmysqlclient.so
%{_libdir}/libmysqlclient_r.so
/usr/share/aclocal/mysql.m4
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files -n libmysqld-devel
#-------------------------------------------------------------------------------
%defattr(-,root,root)
%_libdir/libmysqld.a
%_libdir/libmysqld.so
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files -n libmysqld18
#-------------------------------------------------------------------------------
%defattr(-,root,root)
%_libdir/libmysqld.so.*
#-------------------------------------------------------------------------------
%endif
#-------------------------------------------------------------------------------
%files -n libmysqlclient18
#-------------------------------------------------------------------------------
%defattr(-, root, root)
%{_libdir}/libmysqlclient.so.*
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files -n libmysqlclient_r18
#-------------------------------------------------------------------------------
%defattr(-, root, root)
%{_libdir}/libmysqlclient_r.so.*
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files bench -f mysql-bench.files
#-------------------------------------------------------------------------------
%defattr(-, root, root)
/usr/share/sql-bench
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%if %{defined mdkversion}
%files debuging
%else
%files debug
%endif
#-------------------------------------------------------------------------------
%defattr(-, root, root)
/usr/sbin/mysqld-debug
%{_libdir}/mysql/mysqld-debug.sym
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files test -f mysql-test.files
#-------------------------------------------------------------------------------
%defattr(-, root, root)
%{_bindir}/my_safe_process
%_mandir/man1/mysql-test-run.pl.1*
%_mandir/man1/mysql-stress-test.pl.1*
/usr/share/mysql-test/valgrind.supp
%dir %attr(755, root, root)/usr/share/mysql-test
/usr/share/mysql-test/[^v]*
%dir %attr(755, mysql, mysql) /usr/share/mysql-test/var
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files tools -f mysql-tools.files
%defattr(-, root, root)
%_bindir/mysqlrepair
%_bindir/mysqlanalyze
%_bindir/mysqloptimize
#-------------------------------------------------------------------------------
%if 0%{cluster} > 0
#-------------------------------------------------------------------------------
%files ndb-storage -f mysql-ndb-storage.files
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files ndb-management -f mysql-ndb-management.files
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files ndb-tools -f mysql-ndb-tools.files
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
%files ndb-extra -f mysql-ndb-extra.files
#-------------------------------------------------------------------------------
%endif
%changelog
