diff options
Diffstat (limited to 'databases/mariadb118-server/files')
9 files changed, 366 insertions, 0 deletions
diff --git a/databases/mariadb118-server/files/client.cnf.sample.in b/databases/mariadb118-server/files/client.cnf.sample.in new file mode 100644 index 000000000000..2513f6a04fb2 --- /dev/null +++ b/databases/mariadb118-server/files/client.cnf.sample.in @@ -0,0 +1,52 @@ +# Options specific to client applications, see +# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#client-option-groups + +# Options specific to all client programs +[client] +# port = 3306 # inherited from %%ETCDIR%%/my.cnf +# socket = %%MARIADB_RUNDIR%%/%%MARIADB_SOCK%% # inherited from %%ETCDIR%%/my.cnf + +# Options specific to MariaDB client programs +[client-mariadb] + +# +## Options for specific client Tools +# + +# Options read by `mysql` +# Renamed from [mysql] starting with MariaDB 10.4.6. +[mariadb-client] Options read by mysql. Available starting with MariaDB 10.4.6. +prompt = \u@\h [\d]>\_ +no_auto_rehash + +# Options read by `mysqldump` +# Renamed from [mysqldump] starting with MariaDB 10.4.6. +[mariadb-dump] +max_allowed_packet = 256M +quote_names +quick + +# Options read by `mysqladmin` +# Renamed from [mysqladmin] starting with MariaDB 10.4.6. +[mariadb-admin] + +# Options read by `mysqlbinlog` +# Renamed from [mysqlbinlog] starting with MariaDB 10.4.6. +[mariadb-binlog] + +# Options read by `mysqlcheck` +# Renamed from [mysqlcheck] starting with MariaDB 10.4.6. +[mariadb-check] + +# Options read by `mysqlimport` +# Renamed from [mysqlimport] starting with MariaDB 10.4.6. +[mariadb-import] + +# Options read by `mysqlshow` +# Renamed from [mysqlshow] starting with MariaDB 10.4.6. +[mariadb-show] + +# Options read by `mysqlslap` +# Renamed from [mysqlslap] starting with MariaDB 10.4.6. +[mariadb-slap] + diff --git a/databases/mariadb118-server/files/my.cnf.sample.in b/databases/mariadb118-server/files/my.cnf.sample.in new file mode 100644 index 000000000000..15dbc7e64da8 --- /dev/null +++ b/databases/mariadb118-server/files/my.cnf.sample.in @@ -0,0 +1,13 @@ +# +# This group is read both by the client and the server +# use it for options that affect everything, see +# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#option-groups +# +[client-server] +port = 3306 +socket = %%MARIADB_RUNDIR%%/%%MARIADB_SOCK%% + +# +# include *.cnf from the config directory +# +!includedir %%ETCDIR%%/conf.d/ diff --git a/databases/mariadb118-server/files/mysql-server.in b/databases/mariadb118-server/files/mysql-server.in new file mode 100644 index 000000000000..e494dee09e92 --- /dev/null +++ b/databases/mariadb118-server/files/mysql-server.in @@ -0,0 +1,149 @@ +#!/bin/sh + +# PROVIDE: mysql +# REQUIRE: LOGIN +# KEYWORD: shutdown +# +# Add the following line to /etc/rc.conf to enable mysql: +# mysql_(instance_)?enable (bool): Set to "NO" by default. +# Set it to "YES" to enable MySQL. +%%LEGACY_LIMITS%%# mysql_(instance_)?limits (bool): Set to "NO" by default. +%%LEGACY_LIMITS%%# Set it to yes to run `limits -e -U mysql` +%%LEGACY_LIMITS%%# just before mysql starts. +# mysql_(instance_)?dbdir (str): Default to "%%MARIADB_DBDIR%%" +# Base database directory. +# mysql_(instance_)?args (str): Custom additional arguments to be passed +# to mysqld_safe (default empty). +# mysql_(instance_)?pidfile (str): Custom PID file path and name. +# Default to "${mysql_dbdir}/${hostname}.pid". +# mysql_(instance_)?user (str): User to run mysqld as +# Default to "%%MARIADB_USER%%" created by the port +# mysql_(instance_)?optfile (str): Server-specific option file. +# Default to "${mysql_dbdir}/my.cnf". +# mysql_(instance)?rundir (str): Default to "%%MARIADB_RUNDIR%%" +# mysql_instances (str): Set to "" by default. +# If defined, list of instances to enable + +. /etc/rc.subr + +name="mysql" +rcvar=mysql_enable + +load_rc_config $name + +: ${mysql_enable="NO"} +%%LEGACY_LIMITS%%: ${mysql_limits="NO"} +: ${mysql_user="%%MARIADB_USER%%"} +%%LEGACY_LIMITS%%mysql_limits_args="-e -U ${mysql_user}" +: ${mysql_dbdir="%%MARIADB_DBDIR%%"} +: ${mysql_optfile="%%ETCDIR%%/my.cnf"} +: ${mysql_rundir="%%MARIADB_RUNDIR%%"} + +command="/usr/sbin/daemon" +procname="%%PREFIX%%/libexec/mariadbd" +start_precmd="${name}_prestart" +start_postcmd="${name}_poststart" + +if [ -n "$2" ]; then + instance="$2" + load_rc_config ${name}_${instance} + case "$mysql_instances" in + "$2 "*|*" $2 "*|*" $2"|"$2") + eval mysql_args="\${mysql_${instance}_args:-\"${mysql_args}\"}" + eval mysql_dbdir="\${mysql_${instance}_dbdir:-\"%%MARIADB_DBDIR%%_${instance}\"}" + %%LEGACY_LIMITS%%eval mysql_limits="\${mysql_${instance}_limits:-\"${mysql_limits}\"}" + eval mysql_user="\${mysql_${instance}_user:-\"${mysql_user}\"}" + %%LEGACY_LIMITS%%eval mysql_limits_args="\${mysql_${instance}_limits_args:-\"-e -U $mysql_user\"}" + eval mysql_socket="\${mysql_${instance}_socket:-\"%%MARIADB_RUNDIR%%_${instance}/%%MARIADB_SOCK%%\"}" + eval mysql_optfile="\${mysql_${instance}_optfile:-\"%%ETCDIR%%_${instance}/my.cnf\"}" + eval mysql_pidfile="\${mysql_${instance}_pidfile:-\"%%MARIADB_RUNDIR%%_${instance}/mysqld.pid\"}" + ;; + *) + err 1 "$2 not found in mysql_instances" ;; + esac +else + if [ -n "${mysql_instances}" -a -n "$1" ]; then + for instance in ${mysql_instances}; do + eval _enable="\${mysql_${instance}_enable}" + case "${_enable:-${mysql_enable}}" in + [Nn][Oo]|[Ff][Aa][Ll][Ss][Ee]|[Oo][Ff][Ff]|0) + continue + ;; + [Yy][Ee][Ss]|[Tt][Rr][Uu][Ee]|[Oo][Nn]|1) + ;; + *) + if [ -z "$_enable" ]; then + _var=mysql_enable + else + _var=mysql_${instance}_enable + fi + warn "Bad value" \ + "'${_enable:-${mysql_enable}}'" \ + "for ${_var}. " \ + "Instance ${instance} skipped." + continue + ;; + esac + echo "===> mysql instance: ${instance}" + if %%PREFIX%%/etc/rc.d/mysql-server $1 ${instance}; then + success="${instance} ${success}" + else + failed="${instance} (${retcode}) ${failed}" + fi + done + exit 0 + else + mysql_pidfile=${mysql_pidfile:-"%%MARIADB_RUNDIR%%/mysqld.pid"} + fi +fi + +pidfile=$mysql_pidfile +mysql_install_db="%%PREFIX%%/bin/mariadb-install-db" +mysql_install_db_args="--basedir=%%PREFIX%% --datadir=${mysql_dbdir} --force" +command_args="-c -f %%PREFIX%%/bin/mariadbd-safe --defaults-extra-file=${mysql_optfile} --user=${mysql_user} --datadir=${mysql_dbdir} --pid-file=${pidfile} ${mysql_socket:+--socket=${mysql_socket}} ${mysql_args}" + +mysql_create_auth_tables() +{ + eval $mysql_install_db $mysql_install_db_args + [ $? -eq 0 ] && chown -R ${mysql_user}:$(id -gn $mysql_user) ${mysql_dbdir} +} + +mysql_prestart() +{ + local dir + for dir in /etc /usr/local/etc /etc/mysql /var/db/mysql; do + if [ -f "${dir}/my.cnf" ]; then + echo "Please merge existing ${dir}/my.cnf file with %%ETCDIR%%/conf.d/server.cnf" + return 1 + fi + done + if [ ! -d "${mysql_dbdir}/mysql/." ]; then + mysql_create_auth_tables || return 1 + fi + mysql_group="`/usr/bin/id -gn ${mysql_user}`" + [ "${mysql_socket}" = "" ] && mysql_rundir="%%MARIADB_RUNDIR%%" || mysql_rundir="`/usr/bin/dirname ${mysql_socket}`" + if [ ! -d "${mysql_rundir}" ]; then + install -d -o ${mysql_user} -g ${mysql_group} "${mysql_rundir}" + fi +%%LEGACY_LIMITS%% if checkyesno mysql_limits; then +%%LEGACY_LIMITS%% eval `/usr/bin/limits ${mysql_limits_args}` 2>/dev/null +%%LEGACY_LIMITS%% else +%%LEGACY_LIMITS%% return 0 +%%LEGACY_LIMITS%% fi +%%MODERN_LIMITS%% return 0 + if [ ! -d "${mysql_rundir}" ]; then + install -d -u${mysql_user} -g$(id -gn $mysql_user) -m755 ${mysql_rundir} + fi +} + +mysql_poststart() +{ + local timeout=15 + while [ ! -f "${pidfile}" -a ${timeout} -gt 0 ]; do + timeout=$(( timeout - 1 )) + sleep 1 + done + return 0 +} + +run_rc_command "$1" diff --git a/databases/mariadb118-server/files/patch-FreeBSD15 b/databases/mariadb118-server/files/patch-FreeBSD15 new file mode 100644 index 000000000000..7fb744032638 --- /dev/null +++ b/databases/mariadb118-server/files/patch-FreeBSD15 @@ -0,0 +1,41 @@ +From 056494a7e62373f284d0779f75de90c2dea20794 Mon Sep 17 00:00:00 2001 +From: Florian Smeets <flo@FreeBSD.org> +Date: Mon, 9 Jun 2025 15:51:00 +0200 +Subject: [PATCH] Fix bootstrapping Galera nodes on FreeBSD 15.0 + +Commit https://github.com/MariaDB/server/commit/606c867e7fec4507bd1225f9abf2d0aa664b6ab6 +broke bootstrapping nodes on FreeBSD 15.0 with mariadb-backup. +We should not need LD_LIBRARY_PATH trickery on FreeBSD, so skip setting +it same as on Darwin. Alternatively putting /lib before /usr/lib also +fixes it. + +WSREP_SST: [INFO] Preparing the backup at /var/db/mysql/.sst (20250608 14:44:04.000) +WSREP_SST: [INFO] Evaluating /usr/local/bin/mariadb-backup --prepare --log-bin='/var/db/mysql-logs/mysql-bin' --use-memory=12G --target-dir='/var/db/mysql/.sst' --datadir='/var/db/mysql/.sst' --mysqld-args '--basedir=/usr/local' '--plugin-dir=/usr/local/lib/mysql/plugin' '--wsrep_provider=/usr/local/lib/libgalera_smm.so' '--wsrep_on=ON' '--wsrep_provider=/usr/local/lib/libgalera_smm.so' '--wsrep_on=ON' '--log-error=/var/db/mysql/db4.nexxtmobile.de.err' '--pid-file=/var/run/mysql/mysqld.pid' '--wsrep_start_position=00000000-0000-0000-0000-000000000000:-1,0-0-0' > '/var/db/mysql/mariabackup.prepare.log' 2>&1 (20250608 14:44:04.000) +WSREP_SST: [ERROR] Cleanup after exit with status: 1 (20250608 14:44:04.000) + +With the following error in /var/db/mysql/mariabackup.prepare.log: +ld-elf.so.1: /usr/local/bin/mariadb-backup: Undefined symbol "_ZNSt3__117bad_function_callD1Ev" + +I did not look for the root cause in FreeBSD 15.0 that changed this +behaviour. Calling mariadb-backup directly from the shell works fine on +FreeBSD 14.x and 15.x when LD_LIBRARY_PATH is not set (when using +FreeBSD packages or installing from FreeBSD ports). Setting +LD_LIBRARY_PATH manually like the script does, breaks mariadb-backup +with the "Undefined symbol" error on FreeBSD 15.0 but not on 14.x. +--- + scripts/wsrep_sst_common.sh | 2 +- + 1 file changed, 1 insertion(+), 1 deletion(-) + +diff --git a/scripts/wsrep_sst_common.sh b/scripts/wsrep_sst_common.sh +index 38aa18d5f6967..edde8328effe9 100644 +--- scripts/wsrep_sst_common.sh.orig ++++ scripts/wsrep_sst_common.sh +@@ -25,7 +25,7 @@ OS="$(uname)" + + # Setting the paths for some utilities on CentOS + export PATH="${PATH:+$PATH:}/usr/local/bin:/usr/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin" +-if [ "$OS" != 'Darwin' ]; then ++if [ "$OS" != 'Darwin' ] && [ "$OS" != 'FreeBSD' ]; then + export LD_LIBRARY_PATH="${LD_LIBRARY_PATH:+$LD_LIBRARY_PATH:}/usr/local/lib:/usr/lib:/lib:/opt/lib" + fi + diff --git a/databases/mariadb118-server/files/patch-scripts_mysql__config.sh b/databases/mariadb118-server/files/patch-scripts_mysql__config.sh new file mode 100644 index 000000000000..f8321be63ecc --- /dev/null +++ b/databases/mariadb118-server/files/patch-scripts_mysql__config.sh @@ -0,0 +1,10 @@ +--- scripts/mysql_config.sh.orig 2021-07-07 20:25:20 UTC ++++ scripts/mysql_config.sh +@@ -88,6 +88,7 @@ fi + # Create options + libs="-L$pkglibdir @RPATH_OPTION@ @LIBS_FOR_CLIENTS@" + embedded_libs="-L$pkglibdir @RPATH_OPTION@ @EMB_LIBS_FOR_CLIENTS@" ++embedded_libs="$embedded_libs -%%LOCALBASE%%/lib " + + include="-I$pkgincludedir" + if [ "$basedir" != "/usr" ]; then diff --git a/databases/mariadb118-server/files/patch-storage_rocksdb_rocksdb_port_jemalloc__helper.h b/databases/mariadb118-server/files/patch-storage_rocksdb_rocksdb_port_jemalloc__helper.h new file mode 100644 index 000000000000..dab7177b65b8 --- /dev/null +++ b/databases/mariadb118-server/files/patch-storage_rocksdb_rocksdb_port_jemalloc__helper.h @@ -0,0 +1,13 @@ +--- storage/rocksdb/rocksdb/port/jemalloc_helper.h.orig 2020-06-23 15:10:17 UTC ++++ storage/rocksdb/rocksdb/port/jemalloc_helper.h +@@ -26,6 +26,10 @@ + #include <jemalloc/jemalloc.h> + #endif + ++#ifdef __FreeBSD__ ++#define JEMALLOC_USABLE_SIZE_CONST const ++#endif ++ + #ifndef JEMALLOC_CXX_THROW + #define JEMALLOC_CXX_THROW + #endif diff --git a/databases/mariadb118-server/files/patch-tpool_CMakeLists.txt b/databases/mariadb118-server/files/patch-tpool_CMakeLists.txt new file mode 100644 index 000000000000..5ab7d5de3dd2 --- /dev/null +++ b/databases/mariadb118-server/files/patch-tpool_CMakeLists.txt @@ -0,0 +1,8 @@ +--- tpool/CMakeLists.txt.orig 2020-06-23 15:10:18 UTC ++++ tpool/CMakeLists.txt +@@ -1,4 +1,5 @@ + INCLUDE_DIRECTORIES(${CMAKE_CURRENT_SOURCE_DIR} ${PROJECT_SOURCE_DIR}/include) ++ADD_DEFINITIONS(-fPIC) + IF(WIN32) + SET(EXTRA_SOURCES tpool_win.cc aio_win.cc) + ELSEIF(CMAKE_SYSTEM_NAME STREQUAL "Linux") diff --git a/databases/mariadb118-server/files/pkg-message.in b/databases/mariadb118-server/files/pkg-message.in new file mode 100644 index 000000000000..60864ccebde0 --- /dev/null +++ b/databases/mariadb118-server/files/pkg-message.in @@ -0,0 +1,30 @@ +[ +{ type: install + message: <<EOM +MariaDB respects hier(7) and doesn't check /etc and /etc/mysql for +my.cnf. Please move existing my.cnf files from those paths to +%%PREFIX%%/etc/mysql or %%PREFIX%%/etc. Sample +configuration files are provided in %%PREFIX%%/etc/mysql +and %%PREFIX%%/etc/mysql/conf.d. +The rc(8) script no longer uses /var/db/mysql/my.cnf for configuration +nor /var/db/mysql for logs and PID-file. + +This port does NOT include the mytop perl script, this is included in +the MariaDB tarball but the most recent version can be found in the +databases/mytop port + +%%WSREP%%The Using wsrep clustering requires additional configuration. +%%WSREP%%Edit %%PREFIX%%/etc/mysql/conf.d/wsrep.cnf and change what you need there. + +The hashicorp_key_management, s3 and spider plugins must be enabled +before they can be used, check the specific .cnf files in %%PREFIX%%/etc/mysql/conf.d/ +EOM +} +{ type: upgrade + message: <<EOM +Remember to run mariadb-upgrade (with the optional --datadir=<dbdir> flag) +the first time you start the MySQL server after an upgrade from an +earlier version. +EOM +} +] diff --git a/databases/mariadb118-server/files/server.cnf.sample.in b/databases/mariadb118-server/files/server.cnf.sample.in new file mode 100644 index 000000000000..85b6bcbb016d --- /dev/null +++ b/databases/mariadb118-server/files/server.cnf.sample.in @@ -0,0 +1,50 @@ +# Options specific to server applications, see +# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#server-option-groups + +# Options specific to all server programs +[server] + +# Options specific to MariaDB server programs +[server-mariadb] + +# +# Options for specific server tools +# + +[mysqld] +user = %%MARIADB_USER%% +# port = 3306 # inherited from %%ETCDIR%%/my.cnf +# socket = %%MARIADB_RUNDIR%%/mysql.sock # inherited from %%ETCDIR%%/my.cnf +bind-address = 127.0.0.1 +basedir = %%PREFIX%% +# datadir = %%MARIADB_DBDIR%% # set with --db_dir from rc-script +net_retry_count = 16384 +log_error = %%MARIADB_LOGDIR%%/mysqld.err +# [mysqld] configuration for ZFS +# From https://www.percona.com/resources/technical-presentations/zfs-mysql-percona-technical-webinar +# Create separate datasets for data and logs, eg +# zroot/mysql compression=on recordsize=128k atime=off +# zroot/mysql/data recordsize=16k +# zroot/mysql/logs +# datadir = %%MARIADB_DBDIR%%/data +# innodb_log_group_home_dir = %%MARIADB_DBDIR%%/log +# audit_log_file = %%MARIADB_DBDIR%%/log/audit.log +# general_log_file = %%MARIADB_DBDIR%%/log/general.log +# log_bin = %%MARIADB_DBDIR%%/log/mysql-bin +# relay_log = %%MARIADB_DBDIR%%/log/relay-log +# slow_query_log_file = %%MARIADB_DBDIR%%/log/slow.log +# innodb_doublewrite = 0 +# innodb_flush_method = O_DSYNC + +# Options read by `mariadb-safe` (and `mysql_safe`) +[mariadb-safe] + +# Options read my `mariabackup` +[mariabackup] + +# Options read by mariadb-upgrade (and `mysql_upgrade`) +[mariadb-upgrade] + +# Specific options read by the mariabackup SST method +[sst] + |