[packages/mysql.git] / mysql.spec

# Conditional build:
%bcond_without  innodb          # InnoDB storage engine support
%bcond_without  big_tables      # Support tables with more than 4G rows even on 32 bit platforms
%bcond_without  federated       # Federated storage engine support
%bcond_without  raid            # RAID support
%bcond_without  ssl             # OpenSSL support
%bcond_with     systemtap       # systemtap/dtrace probes
%bcond_without  tcpd            # libwrap (tcp_wrappers) support
%bcond_with     sphinx          # Sphinx storage engine support
# mysql needs boost 1.77.0 and doesn't support newer/older boost versions
%bcond_with     system_boost
%bcond_with     tests           # run test suite
%bcond_with     ndb             # NDB is now a separate product, this here is broken, so disable it
%bcond_without  ldap            # LDAP auth support (requires MIT Kerberos)

%define mysqlversion 8.0
%define mysqlpriority 80

Summary:        MySQL: a very fast and reliable SQL database engine
Summary(de.UTF-8):      MySQL: ist eine SQL-Datenbank
Summary(fr.UTF-8):      MySQL: un serveur SQL rapide et fiable
Summary(pl.UTF-8):      MySQL: bardzo szybka i niezawodna baza danych (SQL)
Summary(pt_BR.UTF-8):   MySQL: Um servidor SQL rápido e confiável
Summary(ru.UTF-8):      MySQL - быстрый SQL-сервер
Summary(uk.UTF-8):      MySQL - швидкий SQL-сервер
Summary(zh_CN.UTF-8):   MySQL数据库服务器
Name:           mysql-%{mysqlversion}
Version:        8.0.36
Release:        1
License:        GPL v2 + MySQL FOSS License Exception
Group:          Applications/Databases
Source0:        http://cdn.mysql.com/Downloads/MySQL-%{mysqlversion}/mysql-%{version}.tar.gz
# Source0-md5:  08bc8e4307246e77d013267e2cd8fa49
Source100:      http://www.sphinxsearch.com/files/sphinx-2.2.11-release.tar.gz
# Source100-md5:        5cac34f3d78a9d612ca4301abfcbd666
%if %{without system_boost}
Source101:      http://downloads.sourceforge.net/boost/boost_1_77_0.tar.bz2
# Source101-md5:        09dc857466718f27237144c6f2432d86
%endif
Source1:        mysql.init
Source2:        mysql.sysconfig
Source3:        mysql.logrotate
Source4:        mysqld.conf
Source5:        mysql-clusters.conf
Source7:        mysql-ndb.init
Source8:        mysql-ndb.sysconfig
Source9:        mysql-ndb-mgm.init
Source10:       mysql-ndb-mgm.sysconfig
Source11:       mysql-ndb-cpc.init
Source12:       mysql-ndb-cpc.sysconfig
Source13:       mysql-client.conf
Source14:       my.cnf
Patch0:         no_relative_paths.patch
Patch1:         mysql-system-xxhash.patch

Patch17:        mysql-5.7-sphinx.patch
Patch18:        mysql-sphinx.patch

Patch24:        mysql-cmake.patch
Patch25:        mysql-readline.patch

URL:            http://www.mysql.com/products/community/
BuildRequires:  bison >= 1.875
%{?with_system_boost:BuildRequires:     boost-devel >= 1.77.0}
BuildRequires:  cmake >= 2.8.2
%{?with_ldap:BuildRequires:     cyrus-sasl-devel}
# for configure and tests
%{?with_ldap:BuildRequires:     cyrus-sasl-scram}
BuildRequires:  libaio-devel
BuildRequires:  libevent-devel
BuildRequires:  libhsclient-devel
BuildRequires:  libstdc++-devel >= 5:7.1
%{?with_tcpd:BuildRequires:     libwrap-devel}
BuildRequires:  lz4-devel
BuildRequires:  mecab-devel
BuildRequires:  ncurses-devel >= 4.2
%{?with_ssl:BuildRequires:      openssl-devel >= 1.1.1}
%{?with_ldap:BuildRequires:     openldap-devel}
BuildRequires:  pam-devel
BuildRequires:  perl-devel >= 1:5.6.1
BuildRequires:  protobuf-devel >= 2.5
BuildRequires:  python3-modules
BuildRequires:  readline-devel >= 6.2
BuildRequires:  rpcsvc-proto
BuildRequires:  rpm-build >= 4.6
BuildRequires:  rpm-perlprov >= 4.1-13
BuildRequires:  rpmbuild(macros) >= 1.605
BuildRequires:  sed >= 4.0
%{?with_systemtap:BuildRequires:        systemtap-sdt-devel}
BuildRequires:  xxHash-devel
BuildRequires:  zlib-devel >= 1.2.12
BuildRequires:  zstd-devel
Requires(post): sed >= 4.0
Requires(post,preun):   /sbin/chkconfig
Requires(postun):       /usr/sbin/groupdel
Requires(postun):       /usr/sbin/userdel
Requires(pre):  /bin/id
Requires(pre):  /usr/bin/getgid
Requires(pre):  /usr/sbin/groupadd
Requires(pre):  /usr/sbin/useradd
Requires:       alternatives
Requires:       %{name}-charsets = %{version}-%{release}
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       %{name}-libs = %{version}-%{release}
Requires:       /usr/bin/setsid
Requires:       rc-scripts >= 0.2.0
Suggests:       %{name}-client
%{?with_tcpd:Suggests:  tcp_wrappers}
Suggests:       vim-syntax-mycnf
Provides:       MySQL-server
Provides:       group(mysql)
Provides:       msqlormysql
Provides:       user(mysql)
Obsoletes:      MySQL < 3.22.27
Obsoletes:      mysql-server < 4
Conflicts:      logrotate < 3.8.0
BuildRoot:      %{tmpdir}/mysql-%{version}-root-%(id -u -n)

%define         _libexecdir     %{_sbindir}
%define         _localstatedir  /var/lib/%{name}

%define         mysqldatadir    share/mysql/%{mysqlversion}
%define         mysqllibdir     %{_lib}/mysql/%{mysqlversion}

%description
MySQL is a true multi-user, multi-threaded SQL (Structured Query
Language) database server. 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/libraries.

The main goals of MySQL are speed, robustness and easy to use. MySQL
was originally developed because we at Tcx needed a SQL server that
could handle very big databases with magnitude higher speed than what
any database vendor could offer to us. We have now been using MySQL
since 1996 in a environment with more than 40 databases, 10,000
tables, of which more than 500 have more than 7 million rows. This is
about 50G 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.

%description -l fr.UTF-8
MySQL est un serveur de bases de donnees SQL vraiment multi-usagers et
multi-taches. Le langage SQL est le langage de bases de donnees le
plus populaire au monde. MySQL est une implementation client/serveur
qui consiste en un serveur (mysqld) et differents
programmes/bibliotheques clientes.

Les objectifs principaux de MySQL sont: vitesse, robustesse et
facilite d'utilisation. MySQL fut originalement developpe parce que
nous, chez Tcx, avions besoin d'un serveur SQL qui pouvait gerer de
tres grandes bases de donnees avec une vitesse d'un ordre de magnitude
superieur a ce que n'importe quel vendeur pouvait nous offrir. Nous
utilisons MySQL depuis 1996 dans un environnement avec plus de 40
bases de donnees, 10000 tables, desquelles plus de 500 ont plus de 7
millions de lignes. Ceci represente environ 50G de donnees critiques.

A la base de la conception de MySQL, on retrouve une serie de routines
qui ont ete utilisees dans un environnement de production pendant
plusieurs annees. Meme si MySQL est encore en developpement, il offre
deja une riche et utile serie de fonctions.

%description -l pl.UTF-8
MySQL to prawdziwie wieloużytkownikowy, wielowątkowy serwer baz danych
SQL. SQL jest najpopularniejszym na świecie językiem używanym do baz
danych. MySQL to implementacja klient/serwer składająca się z demona
mysqld i wielu różnych programów i bibliotek klienckich.

Głównymi celami MySQL-a są szybkość, potęga i łatwość użytkowania.
MySQL oryginalnie był tworzony, ponieważ autorzy w Tcx potrzebowali
serwera SQL do obsługi bardzo dużych baz danych z szybkością o wiele
większą, niż mogli zaoferować inni producenci baz danych. Używają go
od 1996 roku w środowisku z ponad 40 bazami danych, 10 000 tabel, z
których ponad 500 zawiera ponad 7 milionów rekordów - w sumie około
50GB krytycznych danych.

Baza, na której oparty jest MySQL, składa się ze zbioru procedur,
które były używane w bardzo wymagającym środowisku produkcyjnym przez
wiele lat. Pomimo, że MySQL jest ciągle rozwijany, już oferuje bogaty
i użyteczny zbiór funkcji.

%description -l de.UTF-8
MySQL ist eine SQL-Datenbank. Allerdings ist sie im Gegensatz zu
Oracle, DB2 oder PostgreSQL keine relationale Datenbank. Die Daten
werden zwar in zweidimensionalen Tabellen gespeichert und können mit
einem Primärschlüssel versehen werden. Es ist aber keine Definition
eines Fremdschlüssels möglich. Der Benutzer ist somit bei einer
MySQL-Datenbank völlig allein für die (referenzielle) Integrität der
Daten verantwortlich. Allein durch die Nutzung externer
Tabellenformate, wie InnoDB bzw Berkeley DB wird eine Relationalität
ermöglicht. Diese Projekte sind aber getrennt von MySQL zu betrachten.

%description -l pt_BR.UTF-8
O MySQL é um servidor de banco de dados SQL realmente multiusuário e
multi-tarefa. A linguagem SQL é a mais popular linguagem para banco de
dados no mundo. O MySQL é uma implementação cliente/servidor que
consiste de um servidor chamado mysqld e diversos
programas/bibliotecas clientes. Os principais objetivos do MySQL são:
velocidade, robustez e facilidade de uso. O MySQL foi originalmente
desenvolvido porque nós na Tcx precisávamos de um servidor SQL que
pudesse lidar com grandes bases de dados e com uma velocidade muito
maior do que a que qualquer vendedor podia nos oferecer. Estamos
usando o MySQL desde 1996 em um ambiente com mais de 40 bases de dados
com 10.000 tabelas, das quais mais de 500 têm mais de 7 milhões de
linhas. Isto é o equivalente a aproximadamente 50G de dados críticos.
A base da construção do MySQL é uma série de rotinas que foram usadas
em um ambiente de produção com alta demanda por muitos anos. Mesmo o
MySQL estando ainda em desenvolvimento, ele já oferece um conjunto de
funções muito ricas e úteis. Veja a documentação para maiores
informações.

%description -l ru.UTF-8
MySQL - это SQL (Structured Query Language) сервер базы данных. MySQL
была написана Michael'ом (monty) Widenius'ом. См. файл CREDITS в
дистрибутиве на предмет других участников проекта и прочей информации
о MySQL.

%description -l uk.UTF-8
MySQL - це SQL (Structured Query Language) сервер бази даних. MySQL
було написано Michael'ом (monty) Widenius'ом. Див. файл CREDITS в
дистрибутиві для інформації про інших учасників проекту та іншої
інформації.

%package charsets
Summary:        MySQL - character sets definitions
Summary(pl.UTF-8):      MySQL - definicje kodowań znaków
Group:          Applications/Databases
Requires:       %{name}-dirs = %{version}-%{release}
BuildArch:      noarch

%description charsets
This package contains character sets definitions needed by both client
and server.

%description charsets -l pl.UTF-8
Ten pakiet zawiera definicje kodowań znaków potrzebne dla serwera i
klienta.

%package -n mysql-common
Summary:        Common MySQL files and directories
Summary(pl.UTF-8):      MySQL - wspólne pliki i katalogi
Group:          Applicataion/Databases

%description -n mysql-common
Common MySQL files and directories.

%description -n mysql-common -l pl.UTF-8
MySQL - wspólne pliki i katalogi.

%package dirs
Summary:        Common directories for MysSQL %{mysqlversion}
Summary(pl.UTF-8):      Wspólne pliki i katalogi dla MySQL %{mysqlversion}
Group:          Applicataion/Databases
Requires:       mysql-common >= %{version}-%{release}

%description dirs
Common directories for MysSQL %{mysqlversion}

%description dirs -l pl.UTF-8
Wspólne pliki i katalogi dla MySQL %{mysqlversion}

%package extras
Summary:        MySQL additional utilities
Summary(pl.UTF-8):      Dodatkowe narzędzia do MySQL
Group:          Applications/Databases
Requires:       alternatives
Requires:       %{name}-client = %{version}-%{release}
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       %{name}-libs = %{version}-%{release}

%description extras
MySQL additional utilities except Perl scripts (they may be found in
%{name}-extras-perl package).

%description extras -l pl.UTF-8
Dodatkowe narzędzia do MySQL - z wyjątkiem skryptów Perla (które są w
pakiecie %{name}-extras-perl).

%package extras-perl
Summary:        MySQL additional utilities written in Perl
Summary(pl.UTF-8):      Dodatkowe narzędzia do MySQL napisane w Perlu
Group:          Applications/Databases
Requires:       alternatives
Requires:       %{name}-extras = %{version}-%{release}
Requires:       perl-DBD-mysql

%description extras-perl
MySQL additional utilities written in Perl.

%description extras-perl -l pl.UTF-8
Dodatkowe narzędzia do MySQL napisane w Perlu.

%package client
Summary:        MySQL - Client
Summary(pl.UTF-8):      MySQL - Klient
Summary(pt.UTF-8):      MySQL - Cliente
Summary(ru.UTF-8):      MySQL клиент
Summary(uk.UTF-8):      MySQL клієнт
Group:          Applications/Databases
Requires:       alternatives
Requires:       %{name}-charsets = %{version}-%{release}
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       %{name}-libs = %{version}-%{release}
Requires:       readline >= 6.2
Obsoletes:      MySQL-client < 3.22.27

%description client
This package contains the standard MySQL clients.

%description client -l fr.UTF-8
Ce package contient les clients MySQL standards.

%description client -l pl.UTF-8
Standardowe programy klienckie MySQL.

%description client -l pt_BR.UTF-8
Este pacote contém os clientes padrão para o MySQL.

%description client -l ru.UTF-8
Этот пакет содержит только клиент MySQL.

%description client -l uk.UTF-8
Цей пакет містить тільки клієнта MySQL.

%package libs
Summary:        Shared libraries for MySQL
Summary(pl.UTF-8):      Biblioteki współdzielone MySQL
Group:          Libraries
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       zlib >= 1.2.12
Provides:       mysql-libs = %{version}-%{release}
Obsoletes:      libmysql10 < 4
Obsoletes:      mysql-doc < 4.1.12

%description libs
Shared libraries for MySQL.

%description libs -l pl.UTF-8
Biblioteki współdzielone MySQL.

%package -n mysql-devel
Summary:        MySQL - development header files and other files
Summary(pl.UTF-8):      MySQL - Pliki nagłówkowe i inne dla programistów
Summary(pt.UTF-8):      MySQL - Medições de desempenho
Summary(ru.UTF-8):      MySQL - хедеры и библиотеки разработчика
Summary(uk.UTF-8):      MySQL - хедери та бібліотеки програміста
Group:          Development/Libraries
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       %{name}-libs = %{version}-%{release}
%{?with_ssl:Requires:   openssl-devel >= 1.1.1}
Requires:       zlib-devel >= 1.2.12
Obsoletes:      MySQL-devel < 3.22.27
Obsoletes:      libmysql10-devel < 4
Obsoletes:      webscalesql-devel

%description -n mysql-devel
This package contains the development header files and other files
necessary to develop MySQL client applications.

%description -n mysql-devel -l fr.UTF-8
Ce package contient les fichiers entetes et les librairies de
developpement necessaires pour developper des applications clientes
MySQL.

%description -n mysql-devel -l pl.UTF-8
Pliki nagłówkowe i inne pliki konieczne do kompilacji aplikacji
klienckich MySQL.

%description -n mysql-devel -l pt_BR.UTF-8
Este pacote contém os arquivos de cabeçalho (header files) e
bibliotecas necessárias para desenvolver aplicações clientes do MySQL.

%description -n mysql-devel -l ru.UTF-8
Этот пакет содержит хедеры и библиотеки разработчика, необходимые для
разработки клиентских приложений.

%description -n mysql-devel -l uk.UTF-8
Цей пакет містить хедери та бібліотеки програміста, необхідні для
розробки програм-клієнтів.

%package -n mysql-static
Summary:        MySQL static libraries
Summary(pl.UTF-8):      Biblioteki statyczne MySQL
Summary(ru.UTF-8):      MySQL - статические библиотеки
Summary(uk.UTF-8):      MySQL - статичні бібліотеки
Group:          Development/Libraries
Requires:       mysql-devel = %{version}-%{release}
Obsoletes:      MySQL-static < 3.22.27

%description -n mysql-static
MySQL static libraries.

%description -n mysql-static -l pl.UTF-8
Biblioteki statyczne MySQL.

%description -n mysql-static -l ru.UTF-8
Этот пакет содержит статические библиотеки разработчика, необходимые
для разработки клиентских приложений.

%description -n mysql-static -l uk.UTF-8
Цей пакет містить статичні бібліотеки програміста, необхідні для
розробки програм-клієнтів.

%package ndb
Summary:        MySQL - NDB Storage Engine Daemon
Summary(pl.UTF-8):      MySQL - demon silnika przechowywania danych NDB
Group:          Applications/Databases
Requires:       alternatives
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       %{name}-libs = %{version}-%{release}

%description ndb
This package contains the standard MySQL NDB Storage Engine Daemon.

%description ndb -l pl.UTF-8
Ten pakiet zawiera standardowego demona silnika przechowywania danych
NDB.

%package ndb-client
Summary:        MySQL - NDB Clients
Summary(pl.UTF-8):      MySQL - programy klienckie NDB
Group:          Applications/Databases
Requires:       alternatives
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       %{name}-libs = %{version}-%{release}

%description ndb-client
This package contains the standard MySQL NDB Clients.

%description ndb-client -l pl.UTF-8
Ten pakiet zawiera standardowe programy klienckie MySQL NDB.

%package ndb-mgm
Summary:        MySQL - NDB Management Daemon
Summary(pl.UTF-8):      MySQL - demon zarządzający NDB
Group:          Applications/Databases
Requires:       alternatives
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       %{name}-libs = %{version}-%{release}

%description ndb-mgm
This package contains the standard MySQL NDB Management Daemon.

%description ndb-mgm -l pl.UTF-8
Ten pakiet zawiera standardowego demona zarządzającego MySQL NDB.

%package ndb-cpc
Summary:        MySQL - NDB CPC Daemon
Summary(pl.UTF-8):      MySQL - demon NDB CPC
Group:          Applications/Databases
Requires:       alternatives
Requires:       %{name}-dirs = %{version}-%{release}
Requires:       %{name}-libs = %{version}-%{release}

%description ndb-cpc
This package contains the standard MySQL NDB CPC Daemon.

%description ndb-cpc -l pl.UTF-8
Ten pakiet zawiera standardowego demona MySQL NDB CPC.

%prep
%setup -q %{?with_sphinx:-a100} %{!?with_system_boost:-a101} -n mysql-%{version}

%patch0 -p1
%patch1 -p1

%if %{with sphinx}
# http://www.sphinxsearch.com/docs/manual-0.9.9.html#sphinxse-mysql51
%{__mv} sphinx-*/mysqlse storage/sphinx
%patch17 -p1
%patch18 -p1
%endif

%patch24 -p1
%patch25 -p1

# to get these files rebuild
[ -f sql/sql_yacc.cc ] && %{__rm} sql/sql_yacc.cc
[ -f sql/sql_yacc.h ] && %{__rm} sql/sql_yacc.h

# ensure sytstem lib
# need to keep xxhash.[ch]
%{__rm} -rv extra/lz4/lz4**

%build
install -d build
cd build
# NOTE that /var/lib/mysql/mysql.sock is symlink to real sock file
# (it defaults to first cluster but user may change it to whatever
# cluster it wants)

CPPFLAGS="%{rpmcppflags}" \
%cmake .. \
        -DCMAKE_BUILD_TYPE=%{!?debug:RelWithDebInfo}%{?debug:Debug} \
        -DCMAKE_C_FLAGS_RELWITHDEBINFO="%{rpmcflags} -DNDEBUG -fno-omit-frame-pointer -fno-strict-aliasing" \
        -DCMAKE_CXX_FLAGS_RELWITHDEBINFO="%{rpmcxxflags} -DNDEBUG -fno-omit-frame-pointer -fno-strict-aliasing" \
        -DCOMPILATION_COMMENT="TLD Linux MySQL RPM" \
        -DCURSES_INCLUDE_PATH=/usr/include/ncurses \
        %{?with_systemtap:-DENABLE_DTRACE=ON} \
        -DFEATURE_SET="community" \
        -DINSTALL_LAYOUT=RPM \
        -DINSTALL_BINDIR=%{mysqllibdir}/bin \
        -DINSTALL_SBINDIR=%{mysqllibdir}/sbin \
        -DINSTALL_MANDIR=%{mysqldatadir}/man \
        -DINSTALL_LIBDIR=%{_lib} \
        -DINSTALL_PRIV_LIBDIR=%{_libdir}/mysql/%{mysqlversion}/private \
        -DINSTALL_MYSQLTESTDIR_RPM="" \
        -DINSTALL_MYSQLDATADIR=/var/lib/mysql/%{mysqlversion} \
        -DINSTALL_PLUGINDIR=%{_lib}/mysql/%{mysqlversion}/plugin \
        -DINSTALL_SECURE_FILE_PRIVDIR=/var/lib/mysql-files/%{mysqlversion} \
        -DINSTALL_SQLBENCHDIR=%{_datadir} \
        -DINSTALL_SUPPORTFILESDIR=share/mysql/%{mysqlversion}/support \
        -DINSTALL_MYSQLSHAREDIR=share/mysql/%{mysqlversion}/lang \
        -DINSTALL_MYSQLTESTDIR=share/mysql/%{mysqlversion}/test \
        -DROUTER_INSTALL_LIBDIR=%{_libdir}/mysql/%{mysqlversion}/router/private \
        -DROUTER_INSTALL_PLUGINDIR=%{_libdir}/mysql/%{mysqlversion}/router \
        -DMYSQL_UNIX_ADDR=/var/lib/mysql/%{mysqlversion}/mysql.sock \
        %{?debug:-DWITH_DEBUG=ON} \
        -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
        %{!?with_ldap:-DWITH_AUTHENTICATION_LDAP=OFF} \
        -DWITH_LIBWRAP=%{?with_tcpd:ON}%{!?with_tcpd:OFF} \
        -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
        -DWITH_PIC=ON \
        %{?with_ldap:-DWITH_LDAP=system} \
        -DWITH_KERBEROS=system \
        -DWITH_LIBEVENT=system \
        -DWITH_LZ4=system \
        -DWITH_PROTOBUF=system \
        -DWITH_SASL=system \
        -DWITH_UNIT_TESTS=%{?with_tests:ON}%{!?with_tests:OFF} \
        -DWITH_SSL=%{?with_ssl:system}%{!?with_ssl:no} \
        %{!?with_system_boost:-DWITH_BOOST="$(pwd)/$(ls -1d ../boost_*)"} \
        -DWITH_ZLIB=system \
        -DWITH_EDITLINE=system \
        -DWITH_MECAB=system \
        -DTMPDIR=/var/tmp

%{__make}

%{?with_tests:%{__make} test}

%install
rm -rf $RPM_BUILD_ROOT
install -d $RPM_BUILD_ROOT/etc/{logrotate.d,rc.d/init.d,sysconfig,mysql/%{mysqlversion},skel} \
           $RPM_BUILD_ROOT/var/{log/{archive,}/mysql/%{mysqlversion},lib/{mysql,mysql-files}/%{mysqlversion}} \
           $RPM_BUILD_ROOT%{_libdir}

%{__make} -C build install \
        DESTDIR=$RPM_BUILD_ROOT

sed -e 's,@mysqlbindir@,%{_libdir}/mysql/%{mysqlversion}/bin,g; s,@mysqlsbindir@,%{_libdir}/mysql/%{mysqlversion}/sbin,g; s,@mysqlversion@,%{mysqlversion},g;' %{SOURCE1} >$RPM_BUILD_ROOT/etc/rc.d/init.d/mysql-%{mysqlversion}
sed -e 's,@mysqlversion@,%{mysqlversion},g;' %{SOURCE2} >$RPM_BUILD_ROOT/etc/sysconfig/mysql-%{mysqlversion}
sed -e 's,@mysqlversion@,%{mysqlversion},g;' %{SOURCE3} >$RPM_BUILD_ROOT/etc/logrotate.d/mysql-%{mysqlversion}
# This is template for configuration file which is created after 'service mysql init'
sed -e 's,@mysqlversion@,%{mysqlversion},g;' %{SOURCE4} >mysqld.conf
sed -e 's,@mysqlversion@,%{mysqlversion},g;' %{SOURCE5} >$RPM_BUILD_ROOT%{_sysconfdir}/mysql/%{mysqlversion}/clusters.conf
touch $RPM_BUILD_ROOT/var/log/mysql/%{mysqlversion}/{mysqld,query,slow}.log

mv $RPM_BUILD_ROOT/etc/logrotate.d/{mysqlrouter,%{name}-router}

# remove innodb directives from mysqld.conf if mysqld is configured without
%if %{without innodb}
        cp mysqld.conf mysqld.tmp
        awk 'BEGIN { RS="\n\n" } !/innodb/ { printf("%s\n\n", $0) }' < mysqld.tmp > mysqld.conf
%endif

# remove berkeley-db directives from mysqld.conf if mysqld is configured without
cp mysqld.conf mysqld.tmp
awk 'BEGIN { RS="\n\n" } !/bdb/ { printf("%s\n\n", $0) }' < mysqld.tmp > mysqld.conf

cp -a mysqld.conf $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/mysqld.conf
cp -a %{SOURCE13} $RPM_BUILD_ROOT%{_sysconfdir}/mysql/%{mysqlversion}/mysql-client.conf
ln -s mysql-client.conf $RPM_BUILD_ROOT%{_sysconfdir}/mysql/%{mysqlversion}/my.cnf
cp -a %{SOURCE14} $RPM_BUILD_ROOT/etc/skel/.my.cnf

# NDB
%if %{with ndb}
install -p %{SOURCE7} $RPM_BUILD_ROOT/etc/rc.d/init.d/%{name}-ndb
cp -a %{SOURCE8} $RPM_BUILD_ROOT/etc/sysconfig/%{name}-ndb
install -p %{SOURCE9} $RPM_BUILD_ROOT/etc/rc.d/init.d/%{name}-ndb-mgm
cp -a %{SOURCE10} $RPM_BUILD_ROOT/etc/sysconfig/%{name}-ndb-mgm
install -p %{SOURCE11} $RPM_BUILD_ROOT/etc/rc.d/init.d/%{name}-ndb-cpc
cp -a %{SOURCE12} $RPM_BUILD_ROOT/etc/sysconfig/%{name}-ndb-cpc
%endif

sed -i -e 's,/usr//usr,%{_prefix},g' $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/bin/mysql_config
sed -i -e '/libs/s/$ldflags//' $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/bin/mysql_config
sed -i -e '/libs/s/-lprobes_mysql//' $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/bin/mysql_config

# remove known unpackaged files
%{__rm} -r $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/support

# rename not to be so generic name

# not useful without -debug build
# generate symbols file, so one can generate backtrace using it
# mysql_resolve_stack_dump -s %{_datadir}/%{name}/mysqld.sym -n mysqld.stack.
# http://dev.mysql.com/doc/refman/5.0/en/using-stack-trace.html
%{?debug:nm -n $RPM_BUILD_ROOT%{_sbindir}/mysqld > $RPM_BUILD_ROOT%{_datadir}/%{name}/mysqld.sym}

# do not clobber users $PATH
%{__mv} $RPM_BUILD_ROOT{%{_libdir}/mysql/%{mysqlversion}/bin,%{_libdir}/mysql/%{mysqlversion}/sbin}/mysql_upgrade
%{__mv} $RPM_BUILD_ROOT{%{_libdir}/mysql/%{mysqlversion}/bin,%{_libdir}/mysql/%{mysqlversion}/sbin}/innochecksum
%{__mv} $RPM_BUILD_ROOT{%{_libdir}/mysql/%{mysqlversion}/bin,%{_libdir}/mysql/%{mysqlversion}/sbin}/myisamchk
%{__mv} $RPM_BUILD_ROOT{%{_libdir}/mysql/%{mysqlversion}/bin,%{_libdir}/mysql/%{mysqlversion}/sbin}/myisamlog
%{__mv} $RPM_BUILD_ROOT{%{_libdir}/mysql/%{mysqlversion}/bin,%{_libdir}/mysql/%{mysqlversion}/sbin}/myisampack
%{__mv} $RPM_BUILD_ROOT{%{_libdir}/mysql/%{mysqlversion}/bin,%{_libdir}/mysql/%{mysqlversion}/sbin}/my_print_defaults
%{__mv} $RPM_BUILD_ROOT{%{_libdir}/mysql/%{mysqlversion}/bin,%{_libdir}/mysql/%{mysqlversion}/sbin}/mysqlcheck

# delete - functionality in initscript / rpm
# note: mysql_install_db (and thus resolveip) are needed by digikam
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/bin/mysqld_safe
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/bin/mysqld_multi
%{__rm} $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqld_{multi,safe}*
%{__rm} $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/man/man1/mysql.server*

# man pages for removed commands
%{__rm} $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlman.1*
%{__rm} $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlslap.1*
%{__rm} $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/man/man1/comp_err.1*
%{__rm} $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/man/man1/lz4_decompress.1*
%{__rm} $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/man/man1/zlib_decompress.1*

# we don't package those (we have no -test or -testsuite pkg) and some of them just segfault
%{__rm} -r $RPM_BUILD_ROOT%{_datadir}/mysql/%{mysqlversion}/test
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/bin/{comp_err,mysql_client_test,mysql_keyring_encryption_test,mysqlslap,mysqltest,mysqltest_safe_process,mysqlxtest,zlib_decompress}
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/test_udf_services.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/component_example_*.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/component_log_sink_test.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/component_pfs_example*.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/component_test_*.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/test_services_*.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/libdaemon_example.*
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/daemon_example.ini
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/libtest*.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/pfs_example*.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/rewrite_example.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/udf_example.so
%{__rm} $RPM_BUILD_ROOT%{_libdir}/mysql/%{mysqlversion}/plugin/test_security_context.so

%clean
rm -rf $RPM_BUILD_ROOT

%post
/sbin/ldconfig
/sbin/chkconfig --add %{name}
%service %{name} restart

%preun
if [ "$1" = "0" ]; then
        %service -q %{name} stop
        /sbin/chkconfig --del %{name}
fi

%posttrans
update-alternatives \
        --install %{_bindir}/ibd2sdi ibd2sdi %{_libdir}/mysql/%{mysqlversion}/bin/ibd2sdi %{mysqlpriority} \
        --slave %{_mandir}/man1/ibd2sdi.1 ibd2sdi.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ibd2sdi.1* || :
update-alternatives \
        --install %{_bindir}/mysql_migrate_keyring mysql_migrate_keyring %{_libdir}/mysql/%{mysqlversion}/bin/mysql_migrate_keyring %{mysqlpriority} \
        --slave %{_mandir}/man1/mysql_migrate_keyring.1 mysql_migrate_keyring.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_migrate_keyring.1* || :
update-alternatives \
        --install %{_bindir}/mysqlrouter mysqlrouter %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlrouter.1 mysqlrouter.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlrouter.1* || :
update-alternatives \
        --install %{_bindir}/mysqlrouter_keyring mysqlrouter_keyring %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_keyring %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlrouter_keyring.1 mysqlrouter_keyring.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlrouter_keyring.1* || :
update-alternatives \
        --install %{_bindir}/mysqlrouter_passwd mysqlrouter_passwd %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_passwd %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlrouter_passwd.1 mysqlrouter_passwd.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlrouter_passwd.1* || :
update-alternatives \
        --install %{_bindir}/mysqlrouter_plugin_info mysqlrouter_plugin_info %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_plugin_info %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlrouter_plugin_info.1 mysqlrouter_plugin_info.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlrouter_plugin_info.1* || :
update-alternatives \
        --install %{_sbindir}/innochecksum innochecksum %{_libdir}/mysql/%{mysqlversion}/sbin/innochecksum %{mysqlpriority} \
        --slave %{_mandir}/man1/innochecksum.1 innochecksum.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/innochecksum.1* || :
update-alternatives \
        --install %{_sbindir}/my_print_defaults my_print_defaults %{_libdir}/mysql/%{mysqlversion}/sbin/my_print_defaults %{mysqlpriority} \
        --slave %{_mandir}/man1/my_print_defaults.1 my_print_defaults.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/my_print_defaults.1* || :
update-alternatives \
        --install %{_sbindir}/myisamchk myisamchk %{_libdir}/mysql/%{mysqlversion}/sbin/myisamchk %{mysqlpriority} \
        --slave %{_mandir}/man1/myisamchk.1 myisamchk.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/myisamchk.1* || :
update-alternatives \
        --install %{_sbindir}/myisamlog myisamlog %{_libdir}/mysql/%{mysqlversion}/sbin/myisamlog %{mysqlpriority} \
        --slave %{_mandir}/man1/myisamlog.1 myisamlog.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/myisamlog.1* || :
update-alternatives \
        --install %{_sbindir}/myisampack myisampack %{_libdir}/mysql/%{mysqlversion}/sbin/myisampack %{mysqlpriority} \
        --slave %{_mandir}/man1/myisampack.1 myisampack.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/myisampack.1* || :
update-alternatives \
        --install %{_sbindir}/mysql_upgrade mysql_upgrade %{_libdir}/mysql/%{mysqlversion}/sbin/mysql_upgrade %{mysqlpriority} \
        --slave %{_mandir}/man1/mysql_upgrade.1 mysql_upgrade.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_upgrade.1* || :
update-alternatives \
        --install %{_sbindir}/mysqlcheck mysqlcheck %{_libdir}/mysql/%{mysqlversion}/sbin/mysqlcheck %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlcheck.1 mysqlcheck.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlcheck.1* || :
update-alternatives \
        --install %{_sbindir}/mysqld mysqld %{_libdir}/mysql/%{mysqlversion}/sbin/mysqld %{mysqlpriority} \
        --slave %{_mandir}/man8/mysqld.8 mysqld.8 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqld.8* || :

%postun
/sbin/ldconfig
if [ "$1" = "0" ]; then
        update-alternatives --remove ibd2sdi %{_libdir}/mysql/%{mysqlversion}/bin/ibd2sdi || :
        update-alternatives --remove mysql_migrate_keyring %{_libdir}/mysql/%{mysqlversion}/bin/mysql_migrate_keyring || :
        update-alternatives --remove mysqlrouter %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter || :
        update-alternatives --remove mysqlrouter_keyring %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_keyring || :
        update-alternatives --remove mysqlrouter_passwd %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_passwd || :
        update-alternatives --remove mysqlrouter_plugin_info %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_plugin_info || :
        update-alternatives --remove innochecksum %{_libdir}/mysql/%{mysqlversion}/sbin/innochecksum || :
        update-alternatives --remove my_print_defaults %{_libdir}/mysql/%{mysqlversion}/sbin/my_print_defaults || :
        update-alternatives --remove myisamchk %{_libdir}/mysql/%{mysqlversion}/sbin/myisamchk || :
        update-alternatives --remove myisamlog %{_libdir}/mysql/%{mysqlversion}/sbin/myisamlog || :
        update-alternatives --remove myisampack %{_libdir}/mysql/%{mysqlversion}/sbin/myisampack || :
        update-alternatives --remove mysql_upgrade %{_libdir}/mysql/%{mysqlversion}/sbin/mysql_upgrade || :
        update-alternatives --remove mysqlcheck %{_libdir}/mysql/%{mysqlversion}/sbin/mysqlcheck || :
        update-alternatives --remove mysqld %{_libdir}/mysql/%{mysqlversion}/sbin/mysqld || :
fi

%pre -n mysql-common
%groupadd -g 89 mysql
%useradd -u 89 -d /var/lib/mysql -s /bin/false -g mysql -c "MySQL Server" mysql

%postun -n mysql-common
if [ "$1" = "0" ]; then
        %userremove mysql
        %groupremove mysql
fi

%posttrans client
update-alternatives \
        --install %{_bindir}/mysql mysql %{_libdir}/mysql/%{mysqlversion}/bin/mysql %{mysqlpriority} \
        --slave %{_mandir}/man1/mysql.1 mysql.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysql.1* || :
update-alternatives \
        --install %{_bindir}/mysqladmin mysqladmin %{_libdir}/mysql/%{mysqlversion}/bin/mysqladmin %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqladmin.1 mysqladmin.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqladmin.1* || :
update-alternatives \
        --install %{_bindir}/mysqlbinlog mysqlbinlog %{_libdir}/mysql/%{mysqlversion}/bin/mysqlbinlog %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlbinlog.1 mysqlbinlog.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlbinlog.1* || :
update-alternatives \
        --install %{_bindir}/mysql_config_editor mysql_config_editor %{_libdir}/mysql/%{mysqlversion}/bin/mysql_config_editor %{mysqlpriority} \
        --slave %{_mandir}/man1/mysql_config_editor.1 mysql_config_editor.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_config_editor.1* || :
update-alternatives \
        --install %{_bindir}/mysqldump mysqldump %{_libdir}/mysql/%{mysqlversion}/bin/mysqldump %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqldump.1 mysqldump.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqldump.1* || :
update-alternatives \
        --install %{_bindir}/mysqlimport mysqlimport %{_libdir}/mysql/%{mysqlversion}/bin/mysqlimport %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlimport.1 mysqlimport.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlimport.1* || :
update-alternatives \
        --install %{_bindir}/mysqlpump mysqlpump %{_libdir}/mysql/%{mysqlversion}/bin/mysqlpump %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlpump.1 mysqlpump.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlpump.1* || :
update-alternatives \
        --install %{_bindir}/mysqlshow mysqlshow %{_libdir}/mysql/%{mysqlversion}/bin/mysqlshow %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqlshow.1 mysqlshow.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlshow.1* || :

%postun client
if [ $1 -eq 0 ]; then
        update-alternatives --remove mysql %{_libdir}/mysql/%{mysqlversion}/bin/mysql || :
        update-alternatives --remove mysqladmin %{_libdir}/mysql/%{mysqlversion}/bin/mysqladmin || :
        update-alternatives --remove mysqlbinlog %{_libdir}/mysql/%{mysqlversion}/bin/mysqlbinlog || :
        update-alternatives --remove mysql_config_editor %{_libdir}/mysql/%{mysqlversion}/bin/mysql_config_editor || :
        update-alternatives --remove mysqldump %{_libdir}/mysql/%{mysqlversion}/bin/mysqldump || :
        update-alternatives --remove mysqlimport %{_libdir}/mysql/%{mysqlversion}/bin/mysqlimport || :
        update-alternatives --remove mysqlpump %{_libdir}/mysql/%{mysqlversion}/bin/mysqlpump || :
        update-alternatives --remove mysqlshow %{_libdir}/mysql/%{mysqlversion}/bin/mysqlshow || :
fi

%posttrans extras
update-alternatives \
        --install %{_bindir}/myisam_ftdump myisam_ftdump %{_libdir}/mysql/%{mysqlversion}/bin/myisam_ftdump %{mysqlpriority} \
        --slave %{_mandir}/man1/myisam_ftdump.1 myisam_ftdump.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/myisam_ftdump.1* || :
update-alternatives \
        --install %{_bindir}/mysql_secure_installation mysql_secure_installation %{_libdir}/mysql/%{mysqlversion}/bin/mysql_secure_installation %{mysqlpriority} \
        --slave %{_mandir}/man1/mysql_secure_installation.1 mysql_secure_installation.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_secure_installation.1* || :
update-alternatives \
        --install %{_bindir}/mysql_ssl_rsa_setup mysql_ssl_rsa_setup %{_libdir}/mysql/%{mysqlversion}/bin/mysql_ssl_rsa_setup %{mysqlpriority} \
        --slave %{_mandir}/man1/mysql_ssl_rsa_setup.1 mysql_ssl_rsa_setup.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_ssl_rsa_setup.1* || :
update-alternatives \
        --install %{_bindir}/mysql_tzinfo_to_sql mysql_tzinfo_to_sql %{_libdir}/mysql/%{mysqlversion}/bin/mysql_tzinfo_to_sql %{mysqlpriority} \
        --slave %{_mandir}/man1/mysql_tzinfo_to_sql.1 mysql_tzinfo_to_sql.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_tzinfo_to_sql.1* || :
update-alternatives \
        --install %{_bindir}/perror perror %{_libdir}/mysql/%{mysqlversion}/bin/perror %{mysqlpriority} \
        --slave %{_mandir}/man1/perror.1 perror.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/perror.1* || :

%postun extras
if [ $1 -eq 0 ]; then
        update-alternatives --remove myisam_ftdump %{_libdir}/mysql/%{mysqlversion}/bin/myisam_ftdump || :
        update-alternatives --remove mysql_secure_installation %{_libdir}/mysql/%{mysqlversion}/bin/mysql_secure_installation || :
        update-alternatives --remove mysql_ssl_rsa_setup %{_libdir}/mysql/%{mysqlversion}/bin/mysql_ssl_rsa_setup || :
        update-alternatives --remove mysql_tzinfo_to_sql %{_libdir}/mysql/%{mysqlversion}/bin/mysql_tzinfo_to_sql || :
        update-alternatives --remove perror %{_libdir}/mysql/%{mysqlversion}/bin/perror || :
fi

%posttrans extras-perl
update-alternatives \
        --install %{_bindir}/mysqldumpslow mysqldumpslow %{_libdir}/mysql/%{mysqlversion}/bin/mysqldumpslow %{mysqlpriority} \
        --slave %{_mandir}/man1/mysqldumpslow.1 mysqldumpslow.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysqldumpslow.1* || :

%postun extras-perl
if [ $1 -eq 0 ]; then
        update-alternatives --remove mysqldumpslow %{_libdir}/mysql/%{mysqlversion}/bin/mysqldumpslow || :
fi

%posttrans -n mysql-devel
update-alternatives \
        --install %{_bindir}/mysql_config mysql_config %{_libdir}/mysql/%{mysqlversion}/bin/mysql_config %{mysqlpriority} \
        --slave %{_mandir}/man1/mysql_config.1 mysql_config.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_config.1* || :

%postun -n mysql-devel
if [ $1 -eq 0 ]; then
        update-alternatives --remove mysql_config %{_libdir}/mysql/%{mysqlversion}/bin/mysql_config || :
fi

%post ndb
/sbin/chkconfig --add %{name}-ndb
%service %{name}-ndb restart "%{name} NDB engine"

%preun ndb
if [ "$1" = "0" ]; then
        %service %{name}-ndb stop
        /sbin/chkconfig --del %{name}-ndb
fi

%posttrans ndb
update-alternatives \
        --install %{_sbindir}/ndbd ndbd %{_libdir}/mysql/%{mysqlversion}/sbin/ndbd %{mysqlpriority} \
        --slave %{_mandir}/man1/ndbd.1 ndbd.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndbd.1* || :

%postun ndb
if [ "$1" = "0" ]; then
        update-alternatives --remove ndbd %{_libdir}/mysql/%{mysqlversion}/sbin/ndbd || :
fi

%posttrans ndb-client
update-alternatives \
        --install %{_bindir}/ndb_config ndb_config %{_libdir}/mysql/%{mysqlversion}/bin/ndb_config %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_config.1 ndb_config.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_config.1* || :
update-alternatives \
        --install %{_bindir}/ndb_delete_all ndb_delete_all %{_libdir}/mysql/%{mysqlversion}/bin/ndb_delete_all %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_delete_all.1 ndb_delete_all.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_delete_all.1* || :
update-alternatives \
        --install %{_bindir}/ndb_desc ndb_desc %{_libdir}/mysql/%{mysqlversion}/bin/ndb_desc %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_desc.1 ndb_desc.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_desc.1* || :
update-alternatives \
        --install %{_bindir}/ndb_drop_index ndb_drop_index %{_libdir}/mysql/%{mysqlversion}/bin/ndb_drop_index %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_drop_index.1 ndb_drop_index.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_drop_index.1* || :
update-alternatives \
        --install %{_bindir}/ndb_drop_table ndb_drop_table %{_libdir}/mysql/%{mysqlversion}/bin/ndb_drop_table %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_drop_table.1 ndb_drop_table.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_drop_table.1* || :
update-alternatives \
        --install %{_bindir}/ndb_error_reporter ndb_error_reporter %{_libdir}/mysql/%{mysqlversion}/bin/ndb_error_reporter %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_error_reporter.1 ndb_error_reporter.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_error_reporter.1* || :
update-alternatives \
        --install %{_bindir}/ndb_mgm ndb_mgm %{_libdir}/mysql/%{mysqlversion}/bin/ndb_mgm %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_mgm.1 ndb_mgm.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_mgm.1* || :
update-alternatives \
        --install %{_bindir}/ndb_print_backup_file ndb_print_backup_file %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_backup_file %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_print_backup_file.1 ndb_print_backup_file.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_print_backup_file.1* || :
update-alternatives \
        --install %{_bindir}/ndb_print_schema_file ndb_print_schema_file %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_schema_file %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_print_schema_file.1 ndb_print_schema_file.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_print_schema_file.1* || :
update-alternatives \
        --install %{_bindir}/ndb_print_sys_file ndb_print_sys_file %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_sys_file %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_print_sys_file.1 ndb_print_sys_file.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_print_sys_file.1* || :
update-alternatives \
        --install %{_bindir}/ndb_restore ndb_restore %{_libdir}/mysql/%{mysqlversion}/bin/ndb_restore %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_restore.1 ndb_restore.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_restore.1* || :
update-alternatives \
        --install %{_bindir}/ndb_select_all ndb_select_all %{_libdir}/mysql/%{mysqlversion}/bin/ndb_select_all %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_select_all.1 ndb_select_all.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_select_all.1* || :
update-alternatives \
        --install %{_bindir}/ndb_select_count ndb_select_count %{_libdir}/mysql/%{mysqlversion}/bin/ndb_select_count %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_select_count.1 ndb_select_count.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_select_count.1* || :
update-alternatives \
        --install %{_bindir}/ndb_show_tables ndb_show_tables %{_libdir}/mysql/%{mysqlversion}/bin/ndb_show_tables %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_show_tables.1 ndb_show_tables.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_show_tables.1* || :
update-alternatives \
        --install %{_bindir}/ndb_size.pl ndb_size.pl %{_libdir}/mysql/%{mysqlversion}/bin/ndb_size.pl %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_size.pl.1 ndb_size.pl.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_size.pl.1* || :
update-alternatives \
        --install %{_bindir}/ndb_test_platform ndb_test_platform %{_libdir}/mysql/%{mysqlversion}/bin/ndb_test_platform %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_test_platform.1 ndb_test_platform.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_test_platform.1* || :
update-alternatives \
        --install %{_bindir}/ndb_waiter ndb_waiter %{_libdir}/mysql/%{mysqlversion}/bin/ndb_waiter %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_waiter.1 ndb_waiter.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_waiter.1* || :

%postun ndb-client
if [ $1 -eq 0 ]; then
        update-alternatives --remove ndb_config %{_libdir}/mysql/%{mysqlversion}/bin/ndb_config || :
        update-alternatives --remove ndb_delete_all %{_libdir}/mysql/%{mysqlversion}/bin/ndb_delete_all || :
        update-alternatives --remove ndb_desc %{_libdir}/mysql/%{mysqlversion}/bin/ndb_desc || :
        update-alternatives --remove ndb_drop_index %{_libdir}/mysql/%{mysqlversion}/bin/ndb_drop_index || :
        update-alternatives --remove ndb_drop_table %{_libdir}/mysql/%{mysqlversion}/bin/ndb_drop_table || :
        update-alternatives --remove ndb_error_reporter %{_libdir}/mysql/%{mysqlversion}/bin/ndb_error_reporter || :
        update-alternatives --remove ndb_mgm %{_libdir}/mysql/%{mysqlversion}/bin/ndb_mgm || :
        update-alternatives --remove ndb_print_backup_file %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_backup_file || :
        update-alternatives --remove ndb_print_schema_file %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_schema_file || :
        update-alternatives --remove ndb_print_sys_file %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_sys_file || :
        update-alternatives --remove ndb_restore %{_libdir}/mysql/%{mysqlversion}/bin/ndb_restore || :
        update-alternatives --remove ndb_select_all %{_libdir}/mysql/%{mysqlversion}/bin/ndb_select_all || :
        update-alternatives --remove ndb_select_count %{_libdir}/mysql/%{mysqlversion}/bin/ndb_select_count || :
        update-alternatives --remove ndb_show_tables %{_libdir}/mysql/%{mysqlversion}/bin/ndb_show_tables || :
        update-alternatives --remove ndb_size.pl %{_libdir}/mysql/%{mysqlversion}/bin/ndb_size.pl || :
        update-alternatives --remove ndb_test_platform %{_libdir}/mysql/%{mysqlversion}/bin/ndb_test_platform || :
        update-alternatives --remove ndb_waiter %{_libdir}/mysql/%{mysqlversion}/bin/ndb_waiter || :
fi

%post ndb-mgm
/sbin/chkconfig --add %{name}-ndb-mgm
%service %{name}-ndb-mgm restart "%{name} NDB management node"

%preun ndb-mgm
if [ "$1" = "0" ]; then
        %service %{name}-ndb-mgm stop
        /sbin/chkconfig --del %{name}-ndb-mgm
fi

%posttrans ndb-mgm
update-alternatives \
        --install %{_sbindir}/ndb_mgmd ndb_mgmd %{_libdir}/mysql/%{mysqlversion}/sbin/ndb_mgmd %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_mgmd.1 ndb_mgmd.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_mgmd.1* || :

%postun ndb-mgm
if [ "$1" = "0" ]; then
        update-alternatives --remove ndb_mgmd %{_libdir}/mysql/%{mysqlversion}/sbin/ndb_mgmd || :
fi

%post ndb-cpc
/sbin/chkconfig --add %{name}-ndb-cpc
%service %{name}-ndb-cpc restart "%{name} NDB CPC"

%preun ndb-cpc
if [ "$1" = "0" ]; then
        %service %{name}-ndb-cpc stop
        /sbin/chkconfig --del %{name}-ndb-cpc
fi

%posttrans ndb-cpc
update-alternatives \
        --install %{_sbindir}/ndb_cpcd ndb_cpcd %{_libdir}/mysql/%{mysqlversion}/sbin/ndb_cpcd %{mysqlpriority} \
        --slave %{_mandir}/man1/ndb_cpcd.1 ndb_cpcd.1 %{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_cpcd.1* || :

%postun ndb-cpc
if [ "$1" = "0" ]; then
        update-alternatives --remove ndb_cpcd %{_libdir}/mysql/%{mysqlversion}/sbin/ndb_cpcd || :
fi

%post   libs -p /sbin/ldconfig
%postun libs -p /sbin/ldconfig

%files
%defattr(644,root,root,755)
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/logrotate.d/%{name}
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/logrotate.d/%{name}-router
%attr(754,root,root) /etc/rc.d/init.d/%{name}
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/%{name}
%attr(640,root,mysql) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/mysql/%{mysqlversion}/clusters.conf
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ibd2sdi
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysql_migrate_keyring
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_keyring
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_passwd
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqlrouter_plugin_info
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/innochecksum
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/my_print_defaults
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/myisamchk
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/myisamlog
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/myisampack
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/mysql_upgrade
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/mysqlcheck
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/mysqld
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/adt_null.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/auth.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/auth_socket.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/auth_test_plugin.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_audit_api_message_emit.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_keyring_file.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_log_filter_dragnet.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_log_sink_json.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_log_sink_syseventlog.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_mysqlbackup.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_mysqlx_global_reset.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_query_attributes.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_reference_cache.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_udf_*_func.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/component_validate_password.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/conflicting_variables.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/connection_control.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/ddl_rewriter.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/group_replication.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/ha_mock.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/keyring_file.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/keyring_udf.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/libpluginmecab.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/locking_service.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/mypluglib.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/mysql_clone.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/mysql_no_login.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/qa_auth_client.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/qa_auth_interface.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/qa_auth_server.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/replication_observers_example_plugin.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/rewriter.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/semisync_master.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/semisync_replica.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/semisync_slave.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/semisync_source.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/validate_password.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/version_token.so
%if %{with sphinx}
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/plugin/ha_sphinx.so
%endif
%{_libdir}/mysql/%{mysqlversion}/private/icudt*l
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/connection_pool.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/destination_status.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/http_auth_backend.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/http_auth_realm.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/http_server.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/io.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/keepalive.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/metadata_cache.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/rest_api.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/rest_connection_pool.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/rest_metadata_cache.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/rest_router.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/rest_routing.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/router_openssl.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/router_protobuf.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/routing.so
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/private/libmysqlharness*.so*
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/router/private/libmysqlrouter*.so*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ibd2sdi.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/innochecksum.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/my_print_defaults.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/myisamchk.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/myisamlog.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/myisampack.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_upgrade.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlcheck.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlrouter.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlrouter_passwd.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlrouter_plugin_info.1*
%{_datadir}/mysql/%{mysqlversion}/man/man8/mysqld.8*

%if %{?debug:1}0
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/*resolve_stack_dump
%{_datadir}/mysql/%{mysqlversion}/mysqld.sym
%{_datadir}/mysql/%{mysqlversion}/man/man1/*resolve_stack_dump.1*
%endif

%attr(640,mysql,mysql) %ghost /var/log/mysql/%{mysqlversion}/*

# This is template for configuration file which is created after 'service mysql init'
%{_datadir}/mysql/%{mysqlversion}/mysqld.conf

%{_datadir}/mysql/%{mysqlversion}/lang/english
%{_datadir}/mysql/%{mysqlversion}/lang/dictionary.txt
%{_datadir}/mysql/%{mysqlversion}/lang/messages_to_clients.txt
%{_datadir}/mysql/%{mysqlversion}/lang/messages_to_error_log.txt
%{_datadir}/mysql/%{mysqlversion}/lang/install_rewriter.sql
%{_datadir}/mysql/%{mysqlversion}/lang/uninstall_rewriter.sql
# Don't mark these with %%lang. These are used depending
# on database client settings.
%{_datadir}/mysql/%{mysqlversion}/lang/bulgarian
%{_datadir}/mysql/%{mysqlversion}/lang/czech
%{_datadir}/mysql/%{mysqlversion}/lang/danish
%{_datadir}/mysql/%{mysqlversion}/lang/german
%{_datadir}/mysql/%{mysqlversion}/lang/greek
%{_datadir}/mysql/%{mysqlversion}/lang/spanish
%{_datadir}/mysql/%{mysqlversion}/lang/estonian
%{_datadir}/mysql/%{mysqlversion}/lang/french
%{_datadir}/mysql/%{mysqlversion}/lang/hungarian
%{_datadir}/mysql/%{mysqlversion}/lang/italian
%{_datadir}/mysql/%{mysqlversion}/lang/japanese
%{_datadir}/mysql/%{mysqlversion}/lang/korean
%{_datadir}/mysql/%{mysqlversion}/lang/dutch
%{_datadir}/mysql/%{mysqlversion}/lang/norwegian
%{_datadir}/mysql/%{mysqlversion}/lang/norwegian-ny
%{_datadir}/mysql/%{mysqlversion}/lang/polish
%{_datadir}/mysql/%{mysqlversion}/lang/portuguese
%{_datadir}/mysql/%{mysqlversion}/lang/romanian
%{_datadir}/mysql/%{mysqlversion}/lang/russian
%{_datadir}/mysql/%{mysqlversion}/lang/serbian
%{_datadir}/mysql/%{mysqlversion}/lang/slovak
%{_datadir}/mysql/%{mysqlversion}/lang/swedish
%{_datadir}/mysql/%{mysqlversion}/lang/ukrainian

%files charsets
%defattr(644,root,root,755)
%{_datadir}/mysql/%{mysqlversion}/lang/charsets

%files -n mysql-common
%defattr(644,root,root,755)
%attr(751,root,root) %dir %{_sysconfdir}/mysql
%dir %{_libdir}/mysql
%dir %{_datadir}/mysql
%attr(751,root,root) %dir /var/lib/mysql
%attr(751,root,root) %dir /var/lib/mysql-files
%attr(751,root,root) %dir /var/log/mysql
%attr(751,root,root) %dir /var/log/archive/mysql

%files dirs
%defattr(644,root,root,755)
%attr(751,root,root) %dir %{_sysconfdir}/mysql/%{mysqlversion}
# root:root is proper here for mysql.rpm while mysql:mysql is potential security hole
%attr(751,root,root) %dir /var/lib/mysql/%{mysqlversion}
%attr(750,mysql,mysql) %dir /var/lib/mysql-files/%{mysqlversion}
%attr(750,mysql,mysql) %dir /var/log/mysql/%{mysqlversion}
%attr(750,mysql,mysql) %dir /var/log/archive/mysql/%{mysqlversion}
%dir %{_libdir}/mysql/%{mysqlversion}
%dir %{_libdir}/mysql/%{mysqlversion}/bin
%dir %{_libdir}/mysql/%{mysqlversion}/sbin
%dir %{_libdir}/mysql/%{mysqlversion}/plugin
%dir %{_libdir}/mysql/%{mysqlversion}/private
%dir %{_libdir}/mysql/%{mysqlversion}/router
%dir %{_libdir}/mysql/%{mysqlversion}/router/private
%dir %{_datadir}/mysql/%{mysqlversion}
%dir %{_datadir}/mysql/%{mysqlversion}/man
%dir %{_datadir}/mysql/%{mysqlversion}/man/man1
%dir %{_datadir}/mysql/%{mysqlversion}/man/man8
%dir %{_datadir}/mysql/%{mysqlversion}/lang

%files extras
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/myisam_ftdump
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysql_secure_installation
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysql_ssl_rsa_setup
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysql_tzinfo_to_sql
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/perror
%{_datadir}/mysql/%{mysqlversion}/man/man1/myisam_ftdump.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_ssl_rsa_setup.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_secure_installation.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_tzinfo_to_sql.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/perror.1*

%files extras-perl
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqldumpslow
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqldumpslow.1*

%files client
%defattr(644,root,root,755)
%attr(600,root,root) %config(noreplace,missingok) %verify(not md5 mtime size) /etc/skel/.my.cnf
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysql
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqladmin
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqlbinlog
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysql_config_editor
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqldump
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqlimport
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqlpump
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysqlshow
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysql.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqladmin.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlbinlog.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_config_editor.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqldump.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlimport.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlpump.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysqlshow.1*

%files libs
%defattr(644,root,root,755)
%config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/mysql/%{mysqlversion}/mysql-client.conf
%{_sysconfdir}/mysql/%{mysqlversion}/my.cnf
%attr(755,root,root) %{_libdir}/libmysqlclient.so.*.*.*
%attr(755,root,root) %ghost %{_libdir}/libmysqlclient.so.21
%if %{with ndb}
%attr(755,root,root) %{_libdir}/libndbclient.so.*.*.*
%attr(755,root,root) %ghost %{_libdir}/libndbclient.so.3
%endif

%files -n mysql-devel
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/mysql_config
%attr(755,root,root) %{_libdir}/libmysqlclient.so
%if %{with ndb}
%attr(755,root,root) %{_libdir}/libndbclient.so
%endif
%{_pkgconfigdir}/mysqlclient.pc
%{_libdir}/libmysqlservices.a
%{_includedir}/mysql
%{_aclocaldir}/mysql.m4
%{_datadir}/mysql/%{mysqlversion}/man/man1/mysql_config.1*

%files -n mysql-static
%defattr(644,root,root,755)
%{_libdir}/libmysqlclient.a
%if %{with ndb}
%{_libdir}/libndbclient.a
%endif

%if %{with ndb}
%files ndb
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/ndbd
%attr(754,root,root) /etc/rc.d/init.d/%{name}-ndb
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/mysql-ndb
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndbd_redo_log_reader.1*
%{_datadir}/mysql/%{mysqlversion}/man/man8/ndbd.8*

%files ndb-client
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_config
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_delete_all
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_desc
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_drop_index
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_drop_table
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_error_reporter
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_mgm
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_backup_file
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_schema_file
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_print_sys_file
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_restore
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_select_all
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_select_count
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_show_tables
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_size.pl
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_test_platform
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/bin/ndb_waiter
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_config.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_delete_all.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_desc.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_drop_index.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_drop_table.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_error_reporter.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_mgm.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_print_backup_file.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_print_schema_file.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_print_sys_file.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_restore.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_select_all.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_select_count.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_show_tables.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_size.pl.1*
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_waiter.1*

%files ndb-mgm
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/ndb_mgmd
%attr(754,root,root) /etc/rc.d/init.d/%{name}-ndb-mgm
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/mysql-ndb-mgm
%{_datadir}/mysql/%{mysqlversion}/man/man8/ndb_mgmd.8*

%files ndb-cpc
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/mysql/%{mysqlversion}/sbin/ndb_cpcd
%attr(754,root,root) /etc/rc.d/init.d/%{name}-ndb-cpc
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/mysql-ndb-cpc
%{_datadir}/mysql/%{mysqlversion}/man/man1/ndb_cpcd.1*
%endif