Package mariadb
We have removed mariadb out of the reasoning of being not fully compliant to community-oriented software. Sharing now the removed data from the commit here: https://git.hyperbola.info:50100/~team/ … 1d9aede210
Perhaps there is interest to create further packages from and for the community in a separate repository.
PKGBUILD
# Maintainer (Arch): Bartłomiej Piotrowski <bpiotrowski@archlinux.org>
# Maintainer (Arch): Christian Hesse <mail@eworm.de>
# Maintainer: André Silva <emulatorman@hyperbola.info>
# Contributor: Tobias Dausend <throgh@hyperbola.info>
pkgbase=mariadb
pkgname=('mariadb-libs' 'mariadb-clients' 'mariadb' 'mytop')
pkgver=10.3.24
_debver=$pkgver
_debrel=2
pkgrel=9
arch=('i686' 'x86_64')
license=('GPL-2')
url='https://mariadb.org/'
makedepends=('boost' 'bzip2' 'cmake' 'jemalloc' 'libaio' 'libxcrypt' 'libressl' 'libxml2'
'lz4' 'lzo' 'zlib' 'quilt')
source=("https://archive.mariadb.org/mariadb-$pkgver/source/mariadb-$pkgver.tar.gz"{,.asc}
"https://repo.hyperbola.info:50000/sources/${pkgbase}/${pkgbase}-10.3_$_debver-$_debrel.debian.tar.xz"{,.sig}
"mariadb.initd"
"mariadb.run"
"mariadb_log.run"
"fix-cmake.patch")
sha512sums=('cfd0154d984ddc344554cd3df1d02b0811f8e35c90caf745532491688850736d079c67d40e9414daba83f2bd0c06569bfc99213d5280c63cf051c68abd7c56b5'
'SKIP'
'f406e0d7f85654ad33ef2f9722ca40b4763b882d83083b547aead7f6033813c424cdae9b986351edf415c4eaff8f6a43cd5039ad2d98b962395018b8702cf3fd'
'SKIP'
'5661610576977b87b5435a304d8409962c4451389d6cd6801666c507e871e9182c37b56daa37c580a62ccf60ebfff34a9c1dc85da62a2dac5a69b8776c218020'
'208f1246a3fc7478262e6a7d8e6d82d83377d8fd86ef7a7f3a03e2c2383367b9c0560e2ecbb4e686e4b6d64e48bb29f2b75780e4e449a4146fcb3d95e2e67c60'
'ceccc2ceae499524322ec99d3929e088aaed4f94e52274d8a1691a22c0a322781dc93ac00fb28a91f3d0d1541e95de95d588d91011c4b0293b322c5f49d5fd69'
'15179f2e10bd18612ad03d332cc27bde7751c29a7a0bd6661745f43370f93b947138618ab11f7c43831f47f1324538d563962d465b75e23b03f58eb558f194a3')
validpgpkeys=('199369E5404BD5FC7D2FE43BCBCB082A1BB943DB' # MariaDB Package Signing Key <package-signing-key@mariadb.org>
'C92BAA713B8D53D3CAE63FC9E6974752F9704456') # André Silva
prepare() {
cd $pkgbase-$pkgver/
if [[ ${pkgver%.*} = ${_debver%.*} ]]; then
# Debian patches
export QUILT_PATCHES=debian/patches
export QUILT_REFRESH_ARGS='-p ab --no-timestamps --no-index'
export QUILT_DIFF_ARGS='--no-timestamps'
rm -r debian
mv "$srcdir"/debian .
quilt push -av
fi
patch -Np1 -i ${srcdir}/fix-cmake.patch
}
build() {
local _cmake_options=(
# build options
-DCMAKE_BUILD_TYPE=RelWithDebInfo
-Wno-dev
# file paths
# /etc
-DINSTALL_SYSCONFDIR=/etc
-DINSTALL_SYSCONF2DIR=/etc/my.cnf.d
# /run
-DINSTALL_UNIX_ADDRDIR=/run/mysqld/mysqld.sock
# /usr
-DCMAKE_INSTALL_PREFIX=/usr
# /usr/bin /usr/include
-DINSTALL_SCRIPTDIR=bin
-DINSTALL_INCLUDEDIR=include/mysql
# /usr/lib
-DINSTALL_PLUGINDIR=lib/mysql/plugin
# /usr/share
-DINSTALL_SHAREDIR=share
-DINSTALL_SUPPORTFILESDIR=share/mysql
-DINSTALL_MYSQLSHAREDIR=share/mysql
-DINSTALL_DOCREADMEDIR=share/doc/mariadb
-DINSTALL_DOCDIR=share/doc/mariadb
-DINSTALL_MANDIR=share/man
# /var
-DMYSQL_DATADIR=/var/lib/mysql
# default settings
-DDEFAULT_CHARSET=utf8mb4
-DDEFAULT_COLLATION=utf8mb4_unicode_ci
# features
-DENABLED_LOCAL_INFILE=ON
-DPLUGIN_EXAMPLE=NO
-DPLUGIN_FEDERATED=NO
-DPLUGIN_FEEDBACK=NO
-DWITH_EMBEDDED_SERVER=ON
-DWITH_EXTRA_CHARSETS=complex
-DWITH_LIBWRAP=OFF
-DWITH_PCRE=bundled
-DWITH_READLINE=ON
-DWITH_JEMALLOC=system
-DWITH_SSL=system
-DWITH_SYSTEMD=no
-DWITH_UNIT_TESTS=OFF
-DWITH_ZLIB=system
)
mkdir build
cd build
cmake ../"$pkgbase-$pkgver" "${_cmake_options[@]}"
make
}
package_mariadb-libs() {
pkgdesc='MariaDB libraries'
depends=('bzip2' 'libaio' 'libxcrypt' 'libressl' 'lz4' 'lzo' 'xz' 'zlib')
conflicts=('libmysqlclient' 'libmariadbclient' 'mariadb-connector-c')
provides=('libmariadbclient' 'mariadb-connector-c')
replaces=('libmariadbclient')
cd build
for dir in libmariadb libmysqld libservices include; do
make -C $dir DESTDIR="$pkgdir" install
done
ln -s mariadb_config "$pkgdir"/usr/bin/mysql_config
install -D -m0644 "$srcdir"/$pkgbase-$pkgver/man/mysql_config.1 "$pkgdir"/usr/share/man/man1/mysql_config.1
install -D -m0644 support-files/mariadb.pc "$pkgdir"/usr/share/pkgconfig/mariadb.pc
install -D -m0644 "$srcdir"/$pkgbase-$pkgver/support-files/mysql.m4 "$pkgdir"/usr/share/aclocal/mysql.m4
# remove static libraries
rm "$pkgdir"/usr/lib/*.a
# install license files
install -dm0755 "$pkgdir"/usr/share/licenses/$pkgname
install -m0644 "$srcdir"/$pkgbase-$pkgver/COPYING* "$pkgdir"/usr/share/licenses/$pkgname
}
package_mariadb-clients() {
pkgdesc='MariaDB client tools'
depends=("mariadb-libs=${pkgver}" 'jemalloc')
conflicts=('mysql-clients')
provides=("mysql-clients=$pkgver")
cd build
make -C client DESTDIR="$pkgdir" install
# install man pages
for man in mysql mysql_plugin mysql_upgrade mysqladmin mysqlbinlog mysqlcheck mysqldump mysqlimport mysqlshow mysqlslap mysqltest; do
install -D -m0644 "$srcdir"/$pkgbase-$pkgver/man/$man.1 "$pkgdir"/usr/share/man/man1/$man.1
done
# install license files
install -dm0755 "$pkgdir"/usr/share/licenses/$pkgname
install -m0644 "$srcdir"/$pkgbase-$pkgver/COPYING* "$pkgdir"/usr/share/licenses/$pkgname
}
package_mariadb() {
pkgdesc='Fast SQL database server, drop-in replacement for MySQL'
backup=('etc/my.cnf'
'etc/my.cnf.d/client.cnf'
'etc/my.cnf.d/enable_encryption.preset'
'etc/my.cnf.d/mysql-clients.cnf'
'etc/my.cnf.d/server.cnf')
install=mariadb.install
depends=("mariadb-clients=${pkgver}" 'inetutils' 'libxml2')
optdepends=('perl-dbd-mysql: for mysqlhotcopy, mysql_convert_table_format and mysql_setpermission'
'logger: message logging support')
conflicts=('mysql')
provides=("mysql=$pkgver")
options=('emptydirs')
cd build
make DESTDIR="$pkgdir" install
cd "$pkgdir"
rm -r etc/init.d
rm usr/bin/rcmysql
rm usr/share/mysql/{binary-configure,mysql{,d_multi}.server}
install -Dm0755 "${srcdir}"/mariadb.initd etc/init.d/mariadb
install -Dm0755 "${srcdir}"/mariadb.run etc/sv/mariadb/run
install -Dm0755 "${srcdir}"/mariadb_log.run etc/sv/mariadb/log/run
install -dm0700 var/lib/mysql
chown -R 89:89 var/lib/mysql &>/dev/null
# move mysqld to /usr/sbin
install -dm0755 usr/sbin
mv usr/{,s}bin/mysqld
# install license files
install -dm0755 "$pkgdir"/usr/share/licenses/$pkgname
install -m0644 "$srcdir"/$pkgbase-$pkgver/COPYING* "$pkgdir"/usr/share/licenses/$pkgname
# move it where one might look for it
mv usr/share/{groonga{,-normalizer-mysql},doc/mariadb/}
# provided by mariadb-libs
rm usr/bin/mariadb_config
rm usr/bin/mysql_config
rm -r usr/include/
rm usr/share/man/man1/mysql_config.1
rm -r usr/share/aclocal
rm usr/lib/lib*
rm usr/lib/mysql/plugin/{auth_gssapi_client,caching_sha2_password,client_ed25519,dialog,mysql_clear_password,sha256_password}.so
rm -r usr/lib/pkgconfig/
# provided by mariadb-clients
rm usr/bin/{mysql,mysql_plugin,mysql_upgrade,mysqladmin,mysqlbinlog,mysqlcheck,mysqldump,mysqlimport,mysqlshow,mysqlslap,mysqltest}
rm usr/share/man/man1/{mysql,mysql_plugin,mysql_upgrade,mysqladmin,mysqlbinlog,mysqlcheck,mysqldump,mysqlimport,mysqlshow,mysqlslap,mysqltest}.1
# provided by mytop
rm usr/bin/mytop
# not needed
rm -r usr/{data,mysql-test,sql-bench}
rm usr/share/man/man1/mysql-test-run.pl.1
}
package_mytop() {
pkgdesc='Top clone for MariaDB'
depends=('perl' 'perl-dbd-mysql' 'perl-term-readkey')
cd build
install -Dm0755 scripts/mytop "$pkgdir"/usr/bin/mytop
# install license files
install -dm0755 "$pkgdir"/usr/share/licenses/$pkgname
install -m0644 "$srcdir"/$pkgbase-$pkgver/COPYING* "$pkgdir"/usr/share/licenses/$pkgname
}
fix-cmake.patch
--- a/libmariadb/cmake/ConnectorName.cmake 2020-08-06 17:15:46.000000000 +0200
+++ b/libmariadb/cmake/ConnectorName.cmake 2023-01-22 10:49:08.416903691 +0100
@@ -11,18 +11,22 @@
SET(IS64 1)
ENDIF()
-SET (PLAFORM_NAME CMAKE_SYSTEM_NAME)
-SET (MACHINE_NAME CMAKE_SYSTEM_PROCESSOR)
+SET (PLATFORM_NAME ${CMAKE_SYSTEM_NAME})
+SET (MACHINE_NAME ${CMAKE_SYSTEM_PROCESSOR})
SET (CONCAT_SIGN "-")
IF(CMAKE_SYSTEM_NAME MATCHES "Windows")
SET(PLATFORM_NAME "win")
SET(CONCAT_SIGN "")
IF(IS64)
- SET(MACHINE_NAME "x64")
+ IF(CMAKE_C_COMPILER_ARCHITECTURE_ID)
+ STRING(TOLOWER "${CMAKE_C_COMPILER_ARCHITECTURE_ID}" MACHINE_NAME)
+ ELSE()
+ SET(MACHINE_NAME x64)
+ ENDIF()
ELSE()
SET(MACHINE_NAME "32")
- END()
+ ENDIF()
ENDIF()
SET(product_name "mysql-connector-c-${CPACK_PACKAGE_VERSION}-${PLATFORM_NAME}${CONCAT_SIGN}${MACHINE_NAME}")
mariadb.initd
#!/sbin/openrc-run
# Copyright 2018 Hyperbola Project
# Distributed under the terms of the GNU General Public License v2
getconf() {
v=$(my_print_defaults --mysqld | grep ^--$1)
[ -z $v ] && echo $2 || echo ${v#*=}
}
retry="60"
command="/usr/bin/mysqld_safe"
command_args="--syslog --nowatch"
command_user="mysql"
depend() {
use logger net
need localmount
}
start_pre() {
pidfile=$(getconf pid-file "/run/mysqld/mysqld.pid")
command_args="$command_args --pid-file=$pidfile"
required_dirs=$(getconf datadir "/var/lib/mysql")
if [ ! -d $required_dirs/mysql ]; then
eerror "Datadir '$required_dirs' is empty or invalid."
eerror "Run 'mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql' to create a new database."
fi
checkpath --directory --owner mysql:mysql --mode 0755 /run/mysqld
}
start_post() {
ewaitfile 10 $(getconf socket "/run/mysqld/mysqld.sock")
}
stop_pre() {
pidfile=$(getconf pid-file "/run/mysqld/mysqld.pid")
}
mariadb.install
post_install(){
if ! getent group mysql &>/dev/null; then
groupadd -g 89 mysql >/dev/null
fi
if ! getent passwd mysql &>/dev/null; then
useradd -u 89 -g 89 -d /var/lib/mysql -s /bin/nologin mysql >/dev/null
fi
if ! groups mysql | grep adm &>/dev/null; then
gpasswd -a mysql adm >/dev/null
fi
mysql_shell=$(getent passwd mysql | cut -d: -f7)
if [ "$mysql_shell" != '/bin/nologin' ]; then
chsh -s /bin/nologin mysql &>/dev/null
fi
echo ":: You need to initialize the MariaDB data directory prior to starting"
echo " the service. This can be done with mysql_install_db command, e.g.:"
echo " mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql"
}
post_upgrade(){
if ! getent group mysql &>/dev/null; then
groupadd -g 89 mysql >/dev/null
fi
if ! getent passwd mysql &>/dev/null; then
useradd -u 89 -g 89 -d /var/lib/mysql -s /bin/nologin mysql >/dev/null
fi
if ! groups mysql | grep adm &>/dev/null; then
gpasswd -a mysql adm >/dev/null
fi
mysql_shell=$(getent passwd mysql | cut -d: -f7)
if [ "$mysql_shell" != '/bin/nologin' ]; then
chsh -s /bin/nologin mysql &>/dev/null
fi
if [[ "$(vercmp $2 5.5.25-4)" -lt 0 ]] && [[ -d /data ]]; then
for x in data/*; do
cp -r $x /var/lib/mysql
done
rm -rf data
fi
}
post_remove() {
if getent passwd mysql &>/dev/null; then
userdel mysql >/dev/null
fi
if getent group mysql &>/dev/null; then
groupdel mysql >/dev/null
fi
}
mariadb.run
#!/bin/sh
[ ! -d /run/mysqld ] && mkdir -p /run/mysqld
chown mysql:mysql /run/mysqld
exec chpst -U mysql:mysql mysqld --user=mysql 2>&1
Human being in favor with clear principles and so also for freedom in soft- and hardware!
Certainly anyone who has the power to make you believe absurdities has the power to make you commit injustices: For a life of every being full with peace and kindness, including diversity and freedom. Capitalism is destroying our minds, the planet itself and the universe in the end!
