1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
# #
# Variable Name: sha256_password_proxy_users #
# Scope: GLOBAL #
# Access Type: Dynamic #
# Creation Date: 2015-02-06 #
# Author: Horst Hunger #
# Description: Test of sha256_password_proxy_users on commandline #
# #
###############################################################################
--source include/not_windows.inc
SELECT @@global.sha256_password_proxy_users;
--echo '#----- 3.1.1 Valid values on cmd line -----------------------#'
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--enable_reconnect
--exec echo "restart:--sha256-password-proxy-users=1" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--source include/wait_until_connected_again.inc
SELECT @@global.sha256_password_proxy_users;
--echo '#----- 3.1.2 Valid values on cmd line -----------------------#'
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--enable_reconnect
--exec echo "restart:--sha256-password-proxy-users=TRUE" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--source include/wait_until_connected_again.inc
SELECT @@global.sha256_password_proxy_users;
--echo '#----- 3.1.3 Invalid values on cmd line -----------------------#'
CALL mtr.add_suppression("option 'sha256_password_proxy_users': boolean value '-1' was not recognized. Set to OFF.");
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--enable_reconnect
--exec echo "restart:--sha256-password-proxy-users=-1" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--source include/wait_until_connected_again.inc
SELECT @@global.sha256_password_proxy_users;
CALL mtr.add_suppression("option 'sha256_password_proxy_users': boolean value '43698' was not recognized. Set to OFF.");
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--enable_reconnect
--exec echo "restart:--sha256-password-proxy-users=43698" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--source include/wait_until_connected_again.inc
SELECT @@global.sha256_password_proxy_users;
CALL mtr.add_suppression("option 'sha256_password_proxy_users': boolean value 'TEST' was not recognized. Set to OFF.");
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--enable_reconnect
--exec echo "restart:--sha256-password-proxy-users=TEST" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--source include/wait_until_connected_again.inc
SELECT @@global.sha256_password_proxy_users;
--echo '#----- 3.1.4 Invalid values on cmd line -----------------------#'
CALL mtr.add_suppression("option 'sha256_password_proxy_users': boolean value ''test'' was not recognized. Set to OFF.");
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--enable_reconnect
--exec echo "restart:--sha256-password-proxy-users='test'" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--source include/wait_until_connected_again.inc
SELECT @@global.sha256_password_proxy_users;
--echo '#----- 3.1.5 empty values on cmd line -----------------------#'
CALL mtr.add_suppression("option 'sha256_password_proxy_users': boolean value '' was not recognized. Set to OFF.");
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--enable_reconnect
--exec echo "restart:--sha256-password-proxy-users=" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--source include/wait_until_connected_again.inc
SELECT @@global.sha256_password_proxy_users;
# Restore settings
let $restart_parameters = restart:;
source include/restart_mysqld.inc;
|
