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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
# ==== Purpose ====
#
# Verify that --show-replica-auth-info works as expected
#
# ==== Requiremets ====
#
# R1. When source server is started without --show-replica-auth-info or
# --show-slave-auth-info:
# R1.1. Server should not write deprecation warning to the error log.
# R1.2. SHOW REPLICAS should not include USER and PASSWORD columns.
# R1.3. SHOW SLAVE HOSTS should not include USER and PASSWORD columns.
#
# R2. When source server is started with --show-replica-auth-info:
# R2.1. Server should not write deprecation warning to the error log.
# R2.2. SHOW REPLICAS should include USER and PASSWORD columns.
# R2.3. SHOW SLAVE HOSTS should include USER and PASSWORD columns.
#
# R3. When source server is started with --show-slave-auth-info:
# R3.1. Server should write deprecation warning to the error log.
# R3.2. SHOW REPLICAS should include USER and PASSWORD columns.
# R3.3. SHOW SLAVE HOSTS should include USER and PASSWORD columns.
# Test is binlog_format-agnostic
--source include/have_binlog_format_row.inc
--source include/master-slave.inc
--echo ==== Init ====
# Un-suppress this message
--let $suppress_mode = IGNORE_GLOBAL_SUPPRESSIONS
--let $messages = The syntax.*show-.*-auth-info.*is deprecated
--source include/suppress_messages.inc
--let $restart = $MYSQL_TMP_DIR/restart.inc
--write_file $restart END_OF_PROCEDURE
--source include/rpl_connection_slave.inc
--source include/stop_slave.inc
--let $rpl_server_number = 1
--source include/rpl_restart_server.inc
--source include/rpl_connection_slave.inc
--source include/start_slave.inc
--source include/rpl_connection_master.inc
END_OF_PROCEDURE
--source include/save_error_log_position.inc
--echo ==== R2: show-replica-auth-info ====
--let $rpl_server_parameters = --show-replica-auth-info
--source $restart
--echo * R2.1: No deprecation warning
--let $error_pattern = NONE
--source include/assert_error_log.inc
--echo * R2.1, R2.2: Have columns
--replace_result $server_2_uuid REPLICA_UUID $SLAVE_MYPORT REPLICA_PORT
SHOW REPLICAS;
--replace_result $server_2_uuid REPLICA_UUID $SLAVE_MYPORT REPLICA_PORT
SHOW SLAVE HOSTS;
--echo ==== R3: show-slave-auth-info ====
# Make sure that the following warnings were generated by the restart
# and not at some other point in time.
--let $error_pattern = NONE
--source include/assert_error_log.inc
--let $rpl_server_parameters = --show-slave-auth-info
--source $restart
--echo * R3.1: Deprecation warning
--let $error_pattern = The syntax 'show-slave-auth-info' is deprecated and will be removed in a future release. Please use show-replica-auth-info instead.
--source include/assert_error_log.inc
--echo * R3.2, R3.3: Have columns
--replace_result $server_2_uuid REPLICA_UUID $SLAVE_MYPORT REPLICA_PORT
SHOW REPLICAS;
--replace_result $server_2_uuid REPLICA_UUID $SLAVE_MYPORT REPLICA_PORT
SHOW SLAVE HOSTS;
--echo ==== R1: no command-line options ====
--let $rpl_server_parameters =
--source $restart
--echo * R1.1: No deprecation warning
--let $error_pattern = NONE
--source include/assert_error_log.inc
--echo * R1.2, R1.3: No columns
--replace_result $server_2_uuid REPLICA_UUID $SLAVE_MYPORT REPLICA_PORT
SHOW REPLICAS;
--replace_result $server_2_uuid REPLICA_UUID $SLAVE_MYPORT REPLICA_PORT
SHOW SLAVE HOSTS;
--echo ==== Clean up ====
--remove_file $restart
--source include/rpl_end.inc
|
