Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
charsets	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
czech	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
danish	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
dutch	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
english	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
estonian	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
french	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
german	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
greek	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
hungarian	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
italian	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
japanese	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
korean	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
norwegian	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
norwegian-ny	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
policy	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
polish	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
portuguese	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
romanian	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
russian	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
serbian	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
slovak	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
spanish	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
swedish	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
ukrainian	[ DIR ]	drwxr-xr-x	2024-10-04 13:32
debian-start.inc.sh	2.85 KB	-rwxr-xr-x	2020-10-12 19:40
echo_stderr	27 B	-rwxr-xr-x	2020-10-12 19:40
errmsg-utf8.txt	489.32 KB	-rw-r--r--	2020-10-30 01:51
fill_help_tables.sql	570.14 KB	-rw-r--r--	2020-10-30 01:51
magic	1.3 KB	-rw-r--r--	2020-10-30 01:51
maria_add_gis_sp.sql	1.65 KB	-rw-r--r--	2021-03-22 19:49
maria_add_gis_sp_bootstrap.sql	1.63 KB	-rw-r--r--	2021-03-22 19:49
mysql_performance_tables.sql	1.91 KB	-rw-r--r--	2020-10-30 01:51
mysql_system_tables.sql	26.87 KB	-rw-r--r--	2020-10-30 01:51
mysql_system_tables_data.sql	3.76 KB	-rw-r--r--	2021-03-22 19:49
mysql_test_data_timezone.sql	10.17 KB	-rw-r--r--	2020-10-30 01:51
wsrep_notify	2.18 KB	-rwxr-xr-x	2021-03-22 19:49

Rename

#!/bin/bash
#
# This file is included by /etc/mysql/debian-start
#

## Check MyISAM and Aria unclosed tables.
# - Requires the server to be up.
# - Is supposed to run silently in background. 
function check_for_crashed_tables() {
  set -e
  set -u

# But do it in the background to not stall the boot process.
  logger -p daemon.info -i -t$0 "Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables"

# Checking for $? is unreliable so the size of the output is checked.
  # Some table handlers like HEAP do not support CHECK TABLE.
  tempfile=`tempfile`

# We have to use xargs in this case, because a for loop barfs on the
  # spaces in the thing to be looped over.

# If a crashed table is encountered, the "mysql" command will return with a status different from 0
  set +e

LC_ALL=C $MYSQL --skip-column-names --batch -e  '
      select concat('\''select count(*) into @discard from `'\'',
                    TABLE_SCHEMA, '\''`.`'\'', TABLE_NAME, '\''`'\'') 
      from information_schema.TABLES where TABLE_SCHEMA<>'\''INFORMATION_SCHEMA'\'' and TABLE_SCHEMA<>'\''PERFORMANCE_SCHEMA'\'' and ( ENGINE='\''MyISAM'\'' or ENGINE='\''Aria'\'' )' | \
    xargs -i $MYSQL --skip-column-names --silent --batch \
                    --force -e "{}" &>$tempfile
  set -e

if [ -s "$tempfile" ]; then
    (
      /bin/echo -e "\n" \
        "Improperly closed tables are also reported if clients are accessing\n" \
 	"the tables *now*. A list of current connections is below.\n";
       $MYADMIN processlist status
    ) >> $tempfile
    # Check for presence as a dependency on mailx would require an MTA.
    if [ -x /usr/bin/mailx ]; then 
      mailx -e -s"$MYCHECK_SUBJECT" $MYCHECK_RCPT < $tempfile 
    fi
    (echo "$MYCHECK_SUBJECT"; cat $tempfile) | logger -p daemon.warn -i -t$0
  fi
  rm $tempfile
}

## Check for tables needing an upgrade.
# - Requires the server to be up.
# - Is supposed to run silently in background. 
function upgrade_system_tables_if_necessary() {
  set -e
  set -u

logger -p daemon.info -i -t$0 "Upgrading MySQL tables if necessary."

# Filter all "duplicate column", "duplicate key" and "unknown column"
  # errors as the script is designed to be idempotent.
  LC_ALL=C $MYUPGRADE \
    2>&1 \
    | egrep -v '^(1|@had|ERROR (1054|1060|1061))' \
    | logger -p daemon.warn -i -t$0
}

## Check for the presence of both, root accounts with and without password.
# This might have been caused by a bug related to mysql_install_db (#418672).
function check_root_accounts() {
  set -e
  set -u
  
  logger -p daemon.info -i -t$0 "Checking for insecure root accounts."

ret=$( echo "SELECT count(*) FROM mysql.user WHERE user='root' and password='' and plugin='';" | $MYSQL --skip-column-names )
  if [ "$ret" -ne "0" ]; then
    logger -p daemon.warn -i -t$0 "WARNING: mysql.user contains $ret root accounts without password or plugin!"
  fi
}