Overview

File _service:obs_scm:mysql-1682173607.33a98cb.obscpio of Package mysql

07070100000000000081A40000000000000000000000016443EEA700000A0B000000000000000000000000000000000000002200000000mysql-1682173607.33a98cb/.SRCINFOpkgbase = mysql
	pkgdesc = Fast SQL database server, community edition
	pkgver = 8.0.33
	pkgrel = 1
	url = https://www.mysql.com/products/community/
	arch = x86_64
	license = GPL
	makedepends = openssl
	makedepends = zlib
	makedepends = cmake
	makedepends = systemd-tools
	makedepends = systemd-libs
	makedepends = libaio
	makedepends = jemalloc
	makedepends = rpcsvc-proto
	makedepends = libtirpc
	makedepends = icu
	makedepends = libedit
	makedepends = libevent
	makedepends = libfido2
	makedepends = re2
	makedepends = rapidjson
	source = https://cdn.mysql.com/Downloads/MySQL-8.0/mysql-boost-8.0.33.tar.gz
	source = my-default.cnf
	source = mysql-ld.so.conf
	source = mysql.sysconfig
	source = mysqld_service.patch
	source = systemd-tmpfiles.patch
	source = systemd-sysusers.conf
	sha256sums = ae31e6368617776b43c82436c3736900067fada1289032f3ac3392f7380bcb58
	sha256sums = 6bc24ae510f6b6bbad6b3edda2d0028b29292937b482274a4c2fae335f4de328
	sha256sums = e1c23fa0971a13d998f2790379b68c475438d05b6d6f2691b99051dbf497567f
	sha256sums = 203dcd22fea668477ac7123dbd9909fae72d3d07f8855417a669a9c94db072ae
	sha256sums = 8fbedfc2c5fe271ed13217feeceeac00202d2cb135e4283eeee2f9a13d6251af
	sha256sums = 270074dc0a01e0f959590ad95e5bbaaac3f821bb44eba32d039a6aee506b9c6a
	sha256sums = 200a992eb41c95efa99845d017439ddd4018a3e51f57ffca8cb802b0d25123f1

pkgname = mysql
	pkgdesc = Fast SQL database server, community edition
	install = mysql.install
	depends = mysql-clients
	depends = libsasl
	depends = zlib
	depends = jemalloc
	depends = libaio
	depends = libtirpc
	depends = icu
	depends = lz4
	depends = libevent
	depends = systemd-libs
	depends = zstd
	depends = bash
	optdepends = perl-dbd-mysql: for mysqlhotcopy, mysql_convert_table_format, mysql_setpermission, mysqldumpslow
	provides = mariadb=8.0.33
	provides = mysql=8.0.33
	conflicts = mariadb
	options = emptydirs
	backup = etc/mysql/my.cnf
	backup = etc/mysqlrouter/mysqlrouter.conf
	backup = etc/logrotate.d/mysqlrouter
	backup = etc/conf.d/mysql.conf

pkgname = libmysqlclient
	pkgdesc = MySQL client libraries
	depends = libsasl
	depends = zlib
	depends = zstd
	provides = libmariadbclient=8.0.33
	provides = libmysqlclient=8.0.33
	provides = mariadb-libs=8.0.33
	conflicts = libmariadbclient
	conflicts = mariadb-libs

pkgname = mysql-clients
	pkgdesc = MySQL client tools
	depends = libmysqlclient
	depends = zlib
	depends = openssl
	depends = jemalloc
	depends = libedit
	depends = lz4
	depends = zstd
	depends = bash
	provides = mariadb-clients=8.0.33
	provides = mysql-clients=8.0.33
	conflicts = mariadb-clients
07070100000001000081A40000000000000000000000016443EEA7000022BA000000000000000000000000000000000000002200000000mysql-1682173607.33a98cb/PKGBUILD# Maintainer: Muflone http://www.muflone.com/contacts/english/
# Contributor: Francois Menning <f.menning@pm.me>
# Contributor: Rustam Tsurik <rustam.tsurik@gmail.com>
# Contributor: Andrea Scarpino <andrea@archlinux.org>
# Contributor: Douglas Soares de Andrade <douglas@archlinux.org>

pkgname=('mysql' 'libmysqlclient' 'mysql-clients')
pkgbase=mysql
pkgver=8.0.33
pkgrel=1
pkgdesc="Fast SQL database server, community edition"
arch=('x86_64')
makedepends=('openssl' 'zlib' 'cmake' 'systemd-tools' 'systemd-libs' 'libaio'
             'jemalloc' 'rpcsvc-proto' 'libtirpc' 'icu' 'libedit' 'libevent'
             'libfido2' 're2' 'rapidjson')
license=('GPL')
url="https://www.mysql.com/products/community/"
source=("https://cdn.mysql.com/Downloads/MySQL-8.0/${pkgbase}-boost-${pkgver}.tar.gz"
        "my-default.cnf"
        "mysql-ld.so.conf"
        "mysql.sysconfig"
        "mysqld_service.patch"
        "systemd-tmpfiles.patch"
        "systemd-sysusers.conf")
sha256sums=('ae31e6368617776b43c82436c3736900067fada1289032f3ac3392f7380bcb58'
            '6bc24ae510f6b6bbad6b3edda2d0028b29292937b482274a4c2fae335f4de328'
            'e1c23fa0971a13d998f2790379b68c475438d05b6d6f2691b99051dbf497567f'
            '203dcd22fea668477ac7123dbd9909fae72d3d07f8855417a669a9c94db072ae'
            '8fbedfc2c5fe271ed13217feeceeac00202d2cb135e4283eeee2f9a13d6251af'
            '270074dc0a01e0f959590ad95e5bbaaac3f821bb44eba32d039a6aee506b9c6a'
            '200a992eb41c95efa99845d017439ddd4018a3e51f57ffca8cb802b0d25123f1')

build() {
  rm -rf build
  mkdir build
  cd build

  cmake "../${pkgbase}-${pkgver}" \
    -DCMAKE_AR=/usr/bin/gcc-ar \
    -DCMAKE_RANLIB=/usr/bin/gcc-ranlib \
    -DBUILD_CONFIG=mysql_release \
    -DCMAKE_BUILD_TYPE=RelWithDebInfo \
    -DCMAKE_INSTALL_PREFIX=/usr \
    -DSYSCONFDIR=/etc/mysql \
    -DMYSQL_DATADIR=/var/lib/mysql \
    -DMYSQL_UNIX_ADDR=/run/mysqld/mysqld.sock \
    -DENABLED_LOCAL_INFILE=ON \
    -DINSTALL_INFODIR=share/mysql/docs \
    -DINSTALL_MANDIR=share/man \
    -DINSTALL_PLUGINDIR=lib/mysql/plugin \
    -DINSTALL_SCRIPTDIR=bin \
    -DINSTALL_INCLUDEDIR=include/mysql \
    -DINSTALL_DOCREADMEDIR=share/mysql \
    -DINSTALL_SUPPORTFILESDIR=share/mysql \
    -DINSTALL_MYSQLSHAREDIR=share/mysql \
    -DINSTALL_DOCDIR=share/mysql/docs \
    -DINSTALL_SHAREDIR=share/mysql \
    -DROUTER_INSTALL_CONFIGDIR=../etc/mysqlrouter \
    -DROUTER_INSTALL_DATADIR=/var/lib/mysqlrouter \
    -DROUTER_INSTALL_RUNTIMEDIR=/run \
    -DROUTER_INSTALL_LOGDIR=/var/log/mysqlrouter \
    -DWITH_SYSTEM_LIBS=ON \
    -DWITH_FIDO=system \
    -DWITH_SSL=system \
    -DWITH_LIBWRAP=OFF \
    -DWITH_LTO=ON \
    -DWITH_JEMALLOC=ON \
    -DWITH_READLINE=ON \
    -DWITH_SYSTEMD=yes \
    -DWITH_PROTOBUF=bundled \
    -DWITH_UNIT_TESTS=OFF \
    -DPLUGIN_EXAMPLE=NO \
    -DWITHOUT_EXAMPLE_STORAGE_ENGINE=ON \
    -DPLUGIN_FEDERATED=NO \
    -DWITHOUT_FEDERATED_STORAGE_ENGINE=ON \
    -DPLUGIN_FEEDBACK=NO \
    -DCMAKE_C_FLAGS="${CFLAGS}" \
    -DCMAKE_C_LINK_FLAGS="${LDFLAGS}" \
    -DCMAKE_CXX_FLAGS="${CXXFLAGS} -DU_DEFINE_FALSE_AND_TRUE=1" \
    -DCMAKE_CXX_LINK_FLAGS="${LDFLAGS}" \
    -DDEFAULT_CHARSET=utf8mb4 \
    -DDEFAULT_COLLATION=utf8mb4_unicode_ci \
    -DWITH_BOOST="../${pkgname}-${pkgver}/boost"
  make
}

check() {
  cd build/mysql-test

  # Takes *really* long, so disabled by default.
  # ./mtr --parallel=5 --mem --force --max-test-fail=0
}

package_libmysqlclient(){
  pkgdesc="MySQL client libraries"
  depends=('libsasl' 'zlib' 'zstd')
  conflicts=('libmariadbclient' 'mariadb-libs')
  provides=("libmariadbclient=${pkgver}" "libmysqlclient=${pkgver}" "mariadb-libs=${pkgver}")

  cd build
  for dir in include libmysql libservices
  do
    make -C "${dir}" DESTDIR="${pkgdir}" install
  done

  install -m 700 -d "${pkgdir}/var/lib/mysql"
  install -m 644 -D "${srcdir}/my-default.cnf" "${pkgdir}/etc/mysql/my.cnf.default"
  install -m 644 -D "${srcdir}/${pkgbase}-${pkgver}/support-files/mysql.m4" "${pkgdir}/usr/share/aclocal/mysql.m4"
}

package_mysql-clients(){
  pkgdesc="MySQL client tools"
  depends=('libmysqlclient' 'zlib' 'openssl' 'jemalloc' 'libedit' 'lz4' 'zstd' 'bash')
  conflicts=('mariadb-clients')
  provides=("mariadb-clients=${pkgver}" "mysql-clients=${pkgver}")

  cd build
  make -C "client" DESTDIR="${pkgdir}" install

  install -m 755 -d "${pkgdir}/usr/bin"
  install -m 755 "runtime_output_directory/mysql_client_test" "${pkgdir}/usr/bin"
  install -m 755 "scripts/mysql_config" "${pkgdir}/usr/bin"

  # install man pages
  install -m 755 -d "${pkgdir}/usr/share/man/man1"
  for man in mysql mysqladmin mysqlcheck mysqldump mysqlimport mysqlshow mysqlslap mysql_config mysql_config_editor
  do
    install -m 644 "${srcdir}/${pkgbase}-${pkgver}/man/${man}.1" "${pkgdir}/usr/share/man/man1/${man}.1"
  done

  # install pkgconfig
  install -m 644 -D "${srcdir}/build/scripts/mysqlclient.pc" "${pkgdir}/usr/lib/pkgconfig/mysqlclient.pc"

  # provided by mysql
  rm "${pkgdir}/usr/bin/mysql_upgrade"
  rm "${pkgdir}/usr/bin/mysqlbinlog"
  rm "${pkgdir}/usr/bin/mysql_migrate_keyring"
  rm "${pkgdir}/usr/bin/mysqlpump"
  rm "${pkgdir}/usr/bin/mysql_secure_installation"
  rm "${pkgdir}/usr/bin/mysql_ssl_rsa_setup"
  rm "${pkgdir}/usr/bin/mysqltest"
}

package_mysql(){
  pkgdesc="Fast SQL database server, community edition"
  backup=("etc/mysql/my.cnf"
          "etc/mysqlrouter/mysqlrouter.conf"
          "etc/logrotate.d/mysqlrouter"
          "etc/conf.d/${pkgname}.conf")
  install="${pkgbase}.install"
  depends=('mysql-clients' 'libsasl' 'zlib' 'jemalloc' 'libaio' 'libtirpc' 'icu'
           'lz4' 'libevent' 'systemd-libs' 'zstd' 'bash')
  conflicts=('mariadb')
  provides=("mariadb=${pkgver}" "mysql=${pkgver}")
  optdepends=('perl-dbd-mysql: for mysqlhotcopy, mysql_convert_table_format, mysql_setpermission, mysqldumpslow')
  options=('emptydirs')

  cd build
  make DESTDIR="${pkgdir}" install

  install -m 644 -D "${srcdir}/my-default.cnf" "${pkgdir}/etc/mysql/my.cnf"
  install -m 755 -d "${pkgdir}/etc/ld.so.conf.d"
  install -m 644 -D "${srcdir}/mysql-ld.so.conf" "${pkgdir}/etc/ld.so.conf.d/${pkgname}.conf"
  install -m 644 -D "${srcdir}/build/packaging/rpm-common/mysqlrouter.conf" "${pkgdir}/etc/mysqlrouter/mysqlrouter.conf"

  # provided by libmysqlclient
  rm "${pkgdir}/usr/bin/mysql_config"
  rm "${pkgdir}/usr/lib/libmysqlclient.a"
  rm "${pkgdir}/usr/lib/libmysqlclient.so"
  rm "${pkgdir}/usr/lib/libmysqlclient.so.21"
  rm "${pkgdir}/usr/lib/libmysqlclient.so.21.2.33"
  rm "${pkgdir}/usr/lib/libmysqlservices.a"
  rm "${pkgdir}/usr/lib/pkgconfig/mysqlclient.pc"
  rmdir "${pkgdir}/usr/lib/pkgconfig"
  rm -r "${pkgdir}/usr/include"
  rm "${pkgdir}/usr/share/mysql/aclocal/mysql.m4"
  rmdir "${pkgdir}/usr/share/mysql/aclocal"

  # provided by mysql-clients
  rm "${pkgdir}/usr/bin/mysql"
  rm "${pkgdir}/usr/bin/mysqladmin"
  rm "${pkgdir}/usr/bin/mysqlcheck"
  rm "${pkgdir}/usr/bin/mysqldump"
  rm "${pkgdir}/usr/bin/mysqlimport"
  rm "${pkgdir}/usr/bin/mysqlshow"
  rm "${pkgdir}/usr/bin/mysqlslap"
  rm "${pkgdir}/usr/bin/mysql_client_test"
  rm "${pkgdir}/usr/bin/mysql_config_editor"
  rm "${pkgdir}/usr/share/man/man1/mysql.1"
  rm "${pkgdir}/usr/share/man/man1/mysqladmin.1"
  rm "${pkgdir}/usr/share/man/man1/mysqlcheck.1"
  rm "${pkgdir}/usr/share/man/man1/mysql_config.1"
  rm "${pkgdir}/usr/share/man/man1/mysql_config_editor.1"
  rm "${pkgdir}/usr/share/man/man1/mysqldump.1"
  rm "${pkgdir}/usr/share/man/man1/mysqlimport.1"
  rm "${pkgdir}/usr/share/man/man1/mysqlshow.1"
  rm "${pkgdir}/usr/share/man/man1/mysqlslap.1"

  # not needed
  rm -r "${pkgdir}/usr/mysql-test"

  # Move somewhere else
  mv "${pkgdir}/usr/LICENSE.router" "${pkgdir}/usr/share/mysql/docs"
  mv "${pkgdir}/usr/README.router" "${pkgdir}/usr/share/mysql/docs"

  # Create environment file
  install -m 644 -D "${srcdir}/mysql.sysconfig" "${pkgdir}/etc/conf.d/${pkgname}.conf"

  # Fix permissions
  chmod 755 "${pkgdir}/usr"

  # Move systemd files
  mv "${pkgdir}/usr/usr/lib/systemd" "${pkgdir}/usr/lib"
  mv "${pkgdir}/usr/usr/lib/tmpfiles.d" "${pkgdir}/usr/lib"
  install -m 755 -d "${pkgdir}/usr/lib/sysusers.d"
  install -m 644 "${srcdir}/systemd-sysusers.conf" "${pkgdir}/usr/lib/sysusers.d/${pkgname}.conf"

  # Move logrotate files
  install -d -m 755 "${pkgdir}/etc/logrotate.d/"
  mv "${pkgdir}/usr/mysqlrouter-log-rotate" "${pkgdir}/etc/logrotate.d/mysqlrouter"

  # Move docs files
  mv "${pkgdir}/usr/docs/sample_mysqlrouter.conf" "${pkgdir}/usr/share/mysql/docs"
  rmdir "${pkgdir}/usr/docs"

  # Cleanup
  rmdir "${pkgdir}/usr/usr/lib"
  rmdir "${pkgdir}/usr/usr"

  # Arch Linux specific patches:
  #  * enable PrivateTmp for a little bit more security
  #  * force preloading jemalloc for memory management
  #  * fix path to our config
  cd "${pkgdir}"
  patch -Np1 -i "${srcdir}/mysqld_service.patch"
  patch -Np1 -i "${srcdir}/systemd-tmpfiles.patch"
}

07070100000002000081A40000000000000000000000016443EEA70000049C000000000000000000000000000000000000002800000000mysql-1682173607.33a98cb/my-default.cnf# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

datadir=/var/lib/mysql
socket=/run/mysqld/mysqld.sock

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
07070100000003000081A40000000000000000000000016443EEA700000015000000000000000000000000000000000000002A00000000mysql-1682173607.33a98cb/mysql-ld.so.conf/usr/lib/mysqlrouter
07070100000004000081A40000000000000000000000016443EEA7000001A1000000000000000000000000000000000000002700000000mysql-1682173607.33a98cb/mysql.installpost_install(){
  echo ":: You need to initialize the MySQL data directory prior to starting"
  echo "   the service. This can be done with mysqld --initialize command, e.g.:"
  echo "   mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql"
  echo ":: Additionally you should secure your MySQL installation using"
  echo "   mysql_secure_installation command after starting the mysqld service"
}

07070100000005000081A40000000000000000000000016443EEA700000023000000000000000000000000000000000000002900000000mysql-1682173607.33a98cb/mysql.sysconfigLD_PRELOAD=/usr/lib/libjemalloc.so
07070100000006000081A40000000000000000000000016443EEA7000003DD000000000000000000000000000000000000002E00000000mysql-1682173607.33a98cb/mysqld_service.patch--- a/usr/lib/systemd/system/mysqld.service
+++ b/usr/lib/systemd/system/mysqld.service
@@ -52,7 +52,7 @@
 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS
 
 # Use this to switch malloc implementation
-EnvironmentFile=-/etc/sysconfig/mysql
+EnvironmentFile=-/etc/conf.d/mysql
 
 # Sets open_files_limit
 LimitNOFILE = 10000
@@ -64,4 +64,4 @@
 # Set enviroment variable MYSQLD_PARENT_PID. This is required for restart.
 Environment=MYSQLD_PARENT_PID=1
 
-PrivateTmp=false
+PrivateTmp=true

--- a/usr/lib/systemd/system/mysqld@.service
+++ b/usr/lib/systemd/system/mysqld@.service
@@ -52,7 +52,7 @@
 ExecStart=/usr/bin/mysqld --defaults-group-suffix=@%I $MYSQLD_OPTS
 
 # Use this to switch malloc implementation
-EnvironmentFile=-/etc/sysconfig/mysql
+EnvironmentFile=-/etc/conf.d/mysql
 
 # Sets open_files_limit
 LimitNOFILE = 10000
@@ -64,4 +64,4 @@
 # Set enviroment variable MYSQLD_PARENT_PID. This is required for restart.
 Environment=MYSQLD_PARENT_PID=1
 
-PrivateTmp=false
+PrivateTmp=true
07070100000007000081A40000000000000000000000016443EEA700000051000000000000000000000000000000000000002F00000000mysql-1682173607.33a98cb/systemd-sysusers.confu mysqlrouter 88 "MySQL" /var/lib/mysqlrouter
u mysql 89 "MySQL" /var/lib/mysql

07070100000008000081A40000000000000000000000016443EEA7000003E6000000000000000000000000000000000000003000000000mysql-1682173607.33a98cb/systemd-tmpfiles.patchdiff -Naur a/usr/lib/tmpfiles.d/mysql.conf b/usr/lib/tmpfiles.d/mysql.conf
--- a/usr/lib/tmpfiles.d/mysql.conf	2022-01-29 17:27:06.996635977 +0100
+++ b/usr/lib/tmpfiles.d/mysql.conf	2022-01-29 17:28:52.839503490 +0100
@@ -21,3 +21,4 @@
 # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA
 
 d /run/mysqld 0755 mysql mysql  -
+d /var/lib/mysql 0700 mysql mysql  -
diff -Naur a/usr/lib/tmpfiles.d/mysqlrouter.conf b/usr/lib/tmpfiles.d/mysqlrouter.conf
--- a/usr/lib/tmpfiles.d/mysqlrouter.conf	2022-01-29 17:47:51.586650998 +0100
+++ b/usr/lib/tmpfiles.d/mysqlrouter.conf	2022-01-29 17:48:27.181437880 +0100
@@ -20,4 +20,7 @@
 # along with this program; if not, write to the Free Software
 # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA
 
-d /run 0755 mysqlrouter mysqlrouter  -
+d /run/mysqlrouter 0755 mysqlrouter mysqlrouter  -
+d /var/lib/mysqlrouter 0700 mysqlrouter mysqlrouter  -
+d /var/log/mysqlrouter 0750 mysqlrouter mysqlrouter  -
+
07070100000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000B00000000TRAILER!!!33 blocks
openSUSE Build Service is sponsored by
Places