OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	10/02/2024 09:00:29 PM	rwxr-xr-x
📄 aria_chk	5.51 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 aria_dump_log	5.3 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 aria_ftdump	5.31 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 aria_pack	5.34 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 aria_read_log	5.46 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 galera_new_cluster	921 bytes	10/29/2024 02:56:07 PM	rwxr-xr-x
📄 galera_recovery	3.29 KB	10/29/2024 02:56:07 PM	rwxr-xr-x
📄 innochecksum	4.57 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 mariadb	5.07 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-access	109.34 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-admin	4.85 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-binlog	5.13 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-check	4.84 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-config	15.79 KB	10/29/2024 04:05:02 PM	rwxr-xr-x
📄 mariadb-conv	4.56 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-convert-table-format	4.12 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-dump	4.93 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-dumpslow	8.05 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-embedded	24.19 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-find-rows	3.21 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-fix-extensions	1.22 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-hotcopy	34.52 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-import	4.84 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-install-db	22.11 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-ldb	5.29 MB	10/29/2024 04:33:49 PM	rwxr-xr-x
📄 mariadb-plugin	4.53 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-secure-installation	13.49 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-service-convert	2.45 KB	10/29/2024 02:32:33 PM	rwxr-xr-x
📄 mariadb-setpermission	17.56 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadb-show	4.83 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-slap	4.85 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-tzinfo-to-sql	4.53 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb-upgrade	4.97 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 mariadb-waitpid	4.52 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mariadb_config	15.79 KB	10/29/2024 04:05:02 PM	rwxr-xr-x
📄 mariadbd	26.23 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 mariadbd-multi	26.71 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadbd-safe	30.43 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mariadbd-safe-helper	4.5 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 msql2mysql	1.42 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 my_print_defaults	4.53 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 myisam_ftdump	4.86 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 myisamchk	4.98 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 myisamlog	4.84 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 myisampack	4.89 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 myrocks_hotbackup	24.46 KB	10/29/2024 02:55:50 PM	rwxr-xr-x
📄 mysql	5.07 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysql_config	4.57 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mysql_embedded	24.19 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysql_find_rows	3.21 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mysql_fix_extensions	1.22 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mysql_install_db	22.11 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mysql_ldb	5.29 MB	10/29/2024 04:33:49 PM	rwxr-xr-x
📄 mysql_plugin	4.53 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysql_tzinfo_to_sql	4.53 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysql_upgrade	4.97 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 mysql_waitpid	4.52 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysqlaccess	109.34 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mysqladmin	4.85 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysqlbinlog	5.13 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysqlcheck	4.84 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysqld	26.23 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 mysqld_multi	26.71 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mysqld_safe	30.43 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 mysqld_safe_helper	4.5 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 mysqldump	4.93 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysqlimport	4.84 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysqlshow	4.83 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mysqlslap	4.85 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 mytop	71.95 KB	10/29/2024 02:56:06 PM	rwxr-xr-x
📄 perror	4.72 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 rcmysql	0 bytes	01/01/1970 12:00:00 AM	---------
📄 replace	4.5 MB	10/29/2024 04:02:47 PM	rwxr-xr-x
📄 resolve_stack_dump	4.53 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 resolveip	4.52 MB	10/29/2024 04:08:32 PM	rwxr-xr-x
📄 sst_dump	5.3 MB	10/29/2024 04:33:50 PM	rwxr-xr-x
📄 wsrep_sst_backup	2.39 KB	10/29/2024 02:56:07 PM	rwxr-xr-x
📄 wsrep_sst_common	65.72 KB	10/29/2024 02:56:06 PM	rw-r--r--
📄 wsrep_sst_mariabackup	48.1 KB	10/29/2024 02:56:07 PM	rwxr-xr-x
📄 wsrep_sst_mysqldump	8.03 KB	10/29/2024 02:56:07 PM	rwxr-xr-x
📄 wsrep_sst_rsync	29.69 KB	10/29/2024 02:56:07 PM	rwxr-xr-x
📄 wsrep_sst_rsync_wan	29.69 KB	10/29/2024 02:56:07 PM	rwxr-xr-x

Editing: wsrep_sst_mysqldump

#!/usr/bin/bash

set -ue

# Copyright (C) 2009-2015 Codership Oy
# Copyright (C) 2017-2024 MariaDB
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; see the file COPYING. If not, write to the
# Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston
# MA  02110-1335  USA.

# This is a reference script for mariadb-dump-based state snapshot tansfer.

. $(dirname "$0")/wsrep_sst_common

CLIENT_DIR="$SCRIPTS_DIR/../client"

if [ -x "$CLIENT_DIR/mariadb" ]; then
    MYSQL_CLIENT="$CLIENT_DIR/mariadb"
else
    MYSQL_CLIENT=$(commandex 'mariadb')
fi

if [ -x "$CLIENT_DIR/mariadb-dump" ]; then
    MYSQLDUMP="$CLIENT_DIR/mariadb-dump"
else
    MYSQLDUMP=$(commandex 'mariadb-dump')
fi

wait_previous_sst

EINVAL=22

if test -z "$WSREP_SST_OPT_HOST";  then wsrep_log_error "HOST cannot be nil";  exit $EINVAL; fi
if test -z "$WSREP_SST_OPT_PORT";  then wsrep_log_error "PORT cannot be nil";  exit $EINVAL; fi
if test -z "$WSREP_SST_OPT_LPORT"; then wsrep_log_error "LPORT cannot be nil"; exit $EINVAL; fi
if test -z "$WSREP_SST_OPT_SOCKET";then wsrep_log_error "SOCKET cannot be nil";exit $EINVAL; fi
if test -z "$WSREP_SST_OPT_GTID";  then wsrep_log_error "GTID cannot be nil";  exit $EINVAL; fi

if is_local_ip "$WSREP_SST_OPT_HOST_UNESCAPED" && \
   [ "$WSREP_SST_OPT_PORT" = "$WSREP_SST_OPT_LPORT" ]
then
    wsrep_log_error \
        "destination address '$WSREP_SST_OPT_HOST:$WSREP_SST_OPT_PORT'" \
        "matches source address."
    exit $EINVAL
fi

# Check client version
if ! $MYSQL_CLIENT --version | grep -q -E '(Distrib 10\.[1-9])|( from 1[1-9]\.)'; then
    $MYSQL_CLIENT --version >&2
    wsrep_log_error "this operation requires MySQL client version 10.1 or newer"
    exit $EINVAL
fi

AUTH=""
if [ -n "$WSREP_SST_OPT_USER" ]; then
    AUTH="-u$WSREP_SST_OPT_USER"
fi

# Refs https://github.com/codership/mysql-wsrep/issues/141
# Passing password in MYSQL_PWD environment variable is considered
# "extremely insecure" by MySQL Guidelines for Password Security
# (https://dev.mysql.com/doc/refman/5.6/en/password-security-user.html)
# that is even less secure than passing it on a command line! It is doubtful:
# the whole command line is easily observable by any unprivileged user via ps,
# whereas (at least on Linux) unprivileged user can't see process environment
# that he does not own. So while it may be not secure in the NSA sense of the
# word, it is arguably more secure than passing password on the command line.
if [ -n "$WSREP_SST_OPT_PSWD" ]; then
    export MYSQL_PWD="$WSREP_SST_OPT_PSWD"
elif [ -n "$WSREP_SST_OPT_USER" ]; then
    # Empty password, used for testing, debugging etc.
    unset MYSQL_PWD
fi

STOP_WSREP='SET wsrep_on=OFF;'

# mysqldump cannot restore CSV tables, fix this issue
CSV_TABLES_FIX="
set sql_mode='';

USE mysql;

SET @cond = (SELECT (SUPPORT = 'YES' or SUPPORT = 'DEFAULT') FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE = 'csv');

SET @stmt = IF (@cond = '1', 'CREATE TABLE IF NOT EXISTS general_log ( event_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), user_host mediumtext NOT NULL, thread_id bigint(21) unsigned NOT NULL, server_id int(10) unsigned NOT NULL, command_type varchar(64) NOT NULL, argument mediumtext NOT NULL) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT=\"General log\"', 'SET @dummy = 0');

PREPARE stmt FROM @stmt;
EXECUTE stmt;
DROP PREPARE stmt;

SET @stmt = IF (@cond = '1', 'CREATE TABLE IF NOT EXISTS slow_log ( start_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), user_host mediumtext NOT NULL, query_time time(6) NOT NULL, lock_time time(6) NOT NULL, rows_sent bigint(20) UNSIGNED NOT NULL, rows_examined bigint(20) UNSIGNED NOT NULL, db varchar(512) NOT NULL, last_insert_id int(11) NOT NULL, insert_id int(11) NOT NULL, server_id int(10) unsigned NOT NULL, sql_text mediumtext NOT NULL, thread_id bigint(21) unsigned NOT NULL) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT=\"Slow log\"', 'SET @dummy = 0');

PREPARE stmt FROM @stmt;
EXECUTE stmt;
DROP PREPARE stmt;"

SET_START_POSITION="SET GLOBAL wsrep_start_position='$WSREP_SST_OPT_GTID';"

SET_WSREP_GTID_DOMAIN_ID=""
if [ -n "$WSREP_SST_OPT_GTID_DOMAIN_ID" ]; then
    SET_WSREP_GTID_DOMAIN_ID="
    SET @val = (SELECT GLOBAL_VALUE FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES WHERE VARIABLE_NAME = 'WSREP_GTID_STRICT_MODE' AND GLOBAL_VALUE > 0);
    SET @stmt = IF (@val IS NOT NULL, 'SET GLOBAL WSREP_GTID_DOMAIN_ID=$WSREP_SST_OPT_GTID_DOMAIN_ID', 'SET @dummy = 0');
    PREPARE stmt FROM @stmt;
    EXECUTE stmt;
    DROP PREPARE stmt;"
fi

MYSQL="$MYSQL_CLIENT$WSREP_SST_OPT_CONF_UNQUOTED "\
"$AUTH -h$WSREP_SST_OPT_HOST_UNESCAPED "\
"-P$WSREP_SST_OPT_PORT --disable-reconnect --connect_timeout=10"

# Check if binary logging is enabled on the joiner node.
# Note: SELECT cannot be used at this point.
LOG_BIN=$(echo "set statement wsrep_sync_wait=0 for SHOW VARIABLES LIKE 'log_bin'" | $MYSQL | \
tail -1 | awk -F ' ' '{ print $2 }')

# Check the joiner node's server version.
SERVER_VERSION=$(echo "set statement wsrep_sync_wait=0 for SHOW VARIABLES LIKE 'version'" | $MYSQL | \
tail -1 | awk -F ' ' '{ print $2 }')

# Retrieve the donor's @@global.gtid_binlog_state.
GTID_BINLOG_STATE=$(echo "SHOW GLOBAL VARIABLES LIKE 'gtid_binlog_state'" | $MYSQL | \
tail -1 | awk -F ' ' '{ print $2 }')

RESET_MASTER=""
SET_GTID_BINLOG_STATE=""
SQL_LOG_BIN_OFF=""

# Safety check
if [ ${SERVER_VERSION%%.*} -gt 5 ]; then
    # If binary logging is enabled on the joiner node, we need to copy donor's
    # gtid_binlog_state to joiner. In order to do that, a RESET MASTER must be
    # executed to erase binary logs (if any). Binary logging should also be
    # turned off for the session so that gtid state does not get altered while
    # the dump gets replayed on joiner.
    if [ "$LOG_BIN" = 'ON' ]; then
        RESET_MASTER="SET GLOBAL wsrep_on=OFF; RESET MASTER; SET GLOBAL wsrep_on=ON;"
        SET_GTID_BINLOG_STATE="SET GLOBAL wsrep_on=OFF; SET @@global.gtid_binlog_state='$GTID_BINLOG_STATE'; SET GLOBAL wsrep_on=ON;"
        SQL_LOG_BIN_OFF="SET @@session.sql_log_bin=OFF;"
    fi
fi

# NOTE: we don't use --routines here because we're dumping mysql.proc table
MYSQLDUMP="$MYSQLDUMP$WSREP_SST_OPT_CONF_UNQUOTED $AUTH -S$WSREP_SST_OPT_SOCKET \
--add-drop-database --add-drop-table --skip-add-locks --create-options \
--disable-keys --extended-insert --skip-lock-tables --quick --set-charset \
--skip-comments --flush-privileges --all-databases --events"

if [ $WSREP_SST_OPT_BYPASS -eq 0 ]
then
    # need to disable logging when loading the dump
    # reason is that dump contains ALTER TABLE for log tables, and
    # this causes an error if logging is enabled
    GENERAL_LOG_OPT=$($MYSQL --skip-column-names -e "$STOP_WSREP SELECT @@GENERAL_LOG")
    SLOW_LOG_OPT=$($MYSQL --skip-column-names -e "$STOP_WSREP SELECT @@LOG_SLOW_QUERY")

LOG_OFF="SET GLOBAL GENERAL_LOG=OFF; SET GLOBAL LOG_SLOW_QUERY=OFF;"

# commands to restore log settings
    RESTORE_GENERAL_LOG="SET GLOBAL GENERAL_LOG=$GENERAL_LOG_OPT;"
    RESTORE_SLOW_QUERY_LOG="SET GLOBAL LOG_SLOW_QUERY=$SLOW_LOG_OPT;"

(echo "$STOP_WSREP" && echo "$LOG_OFF" && echo "$RESET_MASTER" && \
     echo "$SET_GTID_BINLOG_STATE" && echo "$SQL_LOG_BIN_OFF" && \
     echo "$STOP_WSREP" && $MYSQLDUMP && echo "$CSV_TABLES_FIX" && \
     echo "$RESTORE_GENERAL_LOG" && echo "$RESTORE_SLOW_QUERY_LOG" && \
     echo "$SET_START_POSITION" && echo "$SET_WSREP_GTID_DOMAIN_ID" \
     || echo "SST failed to complete;") | $MYSQL || exit $?
else
    wsrep_log_info "Bypassing state dump."
    echo "$SET_START_POSITION" | $MYSQL || exit $?
fi

wsrep_log_info "$WSREP_METHOD $WSREP_TRANSFER_TYPE completed on $WSREP_SST_OPT_ROLE"
exit 0