Go to:
Gentoo Home
Documentation
Forums
Lists
Bugs
Planet
Store
Wiki
Get Gentoo!
Gentoo's Bugzilla – Attachment 159309 Details for
Bug 230501
dev-db/mysql-init-scripts: add features from debian-start
Home
|
New
–
[Ex]
|
Browse
|
Search
|
Privacy Policy
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
the include used by debian-start
debian-start.inc.sh (text/plain), 2.26 KB, created by
Evert Meulie
on 2008-07-02 11:47:42 UTC
(
hide
)
Description:
the include used by debian-start
Filename:
MIME Type:
Creator:
Evert Meulie
Created:
2008-07-02 11:47:42 UTC
Size:
2.26 KB
patch
obsolete
>#!/bin/bash ># ># This file is included by /etc/mysql/debian-start ># > >## Check all 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 "Checking for crashed MySQL 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` > LC_ALL=C $MYCHECK $MYCHECK_PARAMS \ > 2>&1 \ > | perl -e '$_=join("", <>); s/^[^\n]+\n(error|note)\s+: The (handler|storage engine) for the table doesn.t support check\n//smg;print;' \ > > $tempfile > 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='';" | $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!" > fi >}
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 230501
:
159307
| 159309