You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
143 lines
5.6 KiB
143 lines
5.6 KiB
#
|
|
# Test "mysqladmin ping"
|
|
#
|
|
|
|
--exec $MYSQLADMIN --no-defaults --default-character-set=latin1 -S $MASTER_MYSOCK -P $MASTER_MYPORT -u root --password= ping 2>&1
|
|
|
|
#
|
|
# Bug#10608 mysqladmin breaks on "database" variable in my.cnf
|
|
#
|
|
|
|
# When mysqladmin finds database in .cnf file it shall fail
|
|
--write_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf
|
|
[client]
|
|
database=db1
|
|
EOF
|
|
|
|
# Error 7 is EXIT_UNKNOWN_VARIABLE.
|
|
--replace_regex /.*mysqladmin.*: unknown/mysqladmin: unknown/
|
|
--error 7
|
|
--exec $MYSQLADMIN --defaults-file=$MYSQLTEST_VARDIR/tmp/bug10608.cnf --default-character-set=latin1 -S $MASTER_MYSOCK -P $MASTER_MYPORT -u root --password= ping 2>&1
|
|
remove_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf;
|
|
|
|
# When mysqladmin finds "loose-database" in .cnf file it shall print
|
|
# a warning and continue
|
|
--write_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf
|
|
[client]
|
|
loose-database=db2
|
|
EOF
|
|
|
|
--replace_regex /Warning: .*mysqladmin.*: unknown/Warning: mysqladmin: unknown/
|
|
--exec $MYSQLADMIN --defaults-file=$MYSQLTEST_VARDIR/tmp/bug10608.cnf --default-character-set=latin1 -S $MASTER_MYSOCK -P $MASTER_MYPORT -u root --password= ping 2>&1
|
|
|
|
remove_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf;
|
|
|
|
#
|
|
# WL#3126 TCP address binding for mysql client library;
|
|
# - running mysqladmin --protcol=tcp --bind-address=127.0.0.1
|
|
#
|
|
--exec $MYSQLADMIN --no-defaults --protocol=tcp --bind-address=127.0.0.1 --host=127.0.0.1 -P $MASTER_MYPORT -u root ping 2>&1
|
|
--echo #
|
|
--echo # Bug#58221 : mysqladmin --sleep=x --count=x keeps looping
|
|
--echo #
|
|
|
|
--echo # Executing mysqladmin with --sleep=1 and --count=2.
|
|
--exec $MYSQLADMIN --no-defaults -u root -S $MASTER_MYSOCK -P $MASTER_MYPORT --sleep=1 --count=2 ping > $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
|
|
--echo # Done.
|
|
--echo # Displaying the output :
|
|
--cat_file $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
|
|
|
|
--remove_file $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
|
|
|
|
--echo #
|
|
--echo # BUG#11766184 - 59234: cmdline clients crash --defaults-extra-file
|
|
--echo # with no .cnf or .ini extension.
|
|
--echo #
|
|
|
|
--echo # Creating an empty file 'cnf_file'
|
|
--write_file $MYSQLTEST_VARDIR/tmp/cnf_file
|
|
EOF
|
|
|
|
--echo # Using --defaults-extra-file option with 'cnf_file'.
|
|
--exec $MYSQLADMIN --defaults-extra-file=$MYSQLTEST_VARDIR/tmp/cnf_file -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT ping 2>&1
|
|
|
|
# Testing with non-empty --defaults-extra-file with .cnf extension.
|
|
--write_file $MYSQLTEST_VARDIR/tmp/cnf_test.cnf
|
|
[client]
|
|
host = 127.0.0.1
|
|
EOF
|
|
|
|
--exec $MYSQLADMIN --defaults-extra-file=$MYSQLTEST_VARDIR/tmp/cnf_test.cnf -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT ping 2>&1
|
|
|
|
--remove_file $MYSQLTEST_VARDIR/tmp/cnf_test.cnf
|
|
|
|
# Uncomment the following scenarios after Bug#27406735 is fixed
|
|
# Testing with non-existing defaults-extra-file
|
|
#--error 1
|
|
#--exec $MYSQLADMIN --defaults-extra-file=$MYSQLTEST_VARDIR/tmp/nonexistent.cnf -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT ping < /dev/null > /dev/null 2>&1
|
|
|
|
# Testing with non-existing defaults-file
|
|
#--error 1
|
|
#--exec $MYSQLADMIN --defaults-file=$MYSQLTEST_VARDIR/tmp/nonexistent.cnf -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT --show-warnings ping < /dev/null > /dev/null 2>&1
|
|
|
|
# Testing defaults-file with with no .cnf or .ini extension
|
|
--exec $MYSQLADMIN --defaults-file=$MYSQLTEST_VARDIR/tmp/cnf_file -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT --show-warnings ping 2>&1
|
|
--remove_file $MYSQLTEST_VARDIR/tmp/cnf_file
|
|
|
|
# Testing with non-empty --defaults-file with .cnf extension
|
|
--write_file $MYSQLTEST_VARDIR/tmp/cnf_test_df.cnf
|
|
[client]
|
|
host = 127.0.0.1
|
|
EOF
|
|
|
|
--exec $MYSQLADMIN --defaults-file=$MYSQLTEST_VARDIR/tmp/cnf_test_df.cnf -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT ping 2>&1
|
|
--remove_file $MYSQLTEST_VARDIR/tmp/cnf_test_df.cnf
|
|
|
|
# Using option relative
|
|
--exec $MYSQLADMIN -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT --sleep=1 --count=2 extended status < /dev/null > /dev/null 2>&1
|
|
|
|
# Running mysqladmin with --compress
|
|
--exec $MYSQLADMIN -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT --compress --skip-verbose ping 2>&1
|
|
|
|
# Testing option --login-path
|
|
CREATE USER testadmin_user1;
|
|
FLUSH PRIVILEGES;
|
|
--exec $MYSQL_CONFIG_EDITOR set --login-path=test-login-path1 --user=testadmin_user1 --host=127.0.0.1 2>&1
|
|
--exec $MYSQLADMIN --no-defaults --login-path=test-login-path1 --port=$MASTER_MYPORT ping 2>&1
|
|
DROP USER testadmin_user1;
|
|
|
|
# Using --server-public-key-path and --get-server-public-key
|
|
CREATE USER tester@localhost IDENTIFIED WITH caching_sha2_password BY 'abcd';
|
|
--exec $MYSQLADMIN --host=127.0.0.1 -P $MASTER_MYPORT --ssl-mode=DISABLED -utester -pabcd --server-public-key-path=$MYSQL_TEST_DIR/std_data/rsa_public_key.pem ping
|
|
--exec $MYSQLADMIN --host=127.0.0.1 -P $MASTER_MYPORT --ssl-mode=DISABLED -utester -pabcd --get-server-public-key ping
|
|
DROP USER tester@localhost;
|
|
|
|
--echo #
|
|
--echo # Bug#12688860 : SECURITY RECOMMENDATION: PASSWORDS ON CLI
|
|
--echo #
|
|
|
|
--exec $MYSQLADMIN --no-defaults -uroot --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT ping 2>&1
|
|
|
|
|
|
--echo #
|
|
--echo # Bug#21796658: OLD-PASSWORD SUBCOMMAND IS STILL IN MYSQLADMIN --HELP IN 5.7
|
|
--echo #
|
|
|
|
--let $admin_outfile=$MYSQLTEST_VARDIR/tmp/bug21796658.output
|
|
|
|
--echo # execute mysqladmin --help
|
|
# Returns 1 on normal execution
|
|
--error 1
|
|
--exec $MYSQLADMIN --help 2>&1 > $admin_outfile
|
|
|
|
--echo # check the output of mysqladmin for old-password
|
|
--let $assert_text= check the output of mysqladmin for old-password
|
|
--let $assert_file= $admin_outfile
|
|
--let $assert_select=old-password
|
|
--let $assert_count=0
|
|
--source include/assert_grep.inc
|
|
|
|
--echo # cleanup
|
|
--remove_file $admin_outfile
|
|
|
|
--echo End of tests
|
|
|