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
|
# ==== Purpose ====
#
# This script tests that the `PRIVILEGE_CHECKS_USER` user info is included in
# the message issued upon slave starting.
#
# ==== Requirements ====
#
# R1. Issuing `START SLAVE` for a channel with `PRIVILEGE_CHECKS_USER` will log
# an informational message about slave stating that includes the applier
# user information.
#
# R2. Starting the server that has a channel with `PRIVILEGE_CHECKS_USER`
# configuration persisted will log an informational message about slave
# stating that includes the applier user information.
#
# ==== Implementation ====
#
# TC1. `START SLAVE` issues an info message that includes applier user info
# -------------------------------------------------------------------------
# 1) Set `PRIVELEGE_CHECKS_USER` to a user with `REPLICATION_APPLIER`
# privilege.
# 2) Start the slave.
# 3) Ensure that the message in the log contains the user info.
#
# TC2. Start server with a channel configured issues message with applier user
# info
# ----------------------------------------------------------------------------
# 1) Set `PRIVELEGE_CHECKS_USER` to a user with `REPLICATION_APPLIER`
# privilege.
# 2) Start the server.
# 3) Ensure that the message in the log contains the user info.
#
# ==== References ====
#
# WL#12966 Replication with privilege checks
#
--source include/have_binlog_format_row.inc
--echo #
--echo # TC1. `START SLAVE` issues an info message that includes applier user
--echo # info
--echo # --------------------------------------------------------------------
--echo #
# 1) Set `PRIVELEGE_CHECKS_USER` to a user with `REPLICATION_APPLIER`
# privilege.
--let $rpl_privilege_checks_user= *:'u1'@'localhost'
--source include/master-slave.inc
# 2) Start the slave.
--source include/rpl_connection_slave.inc
--source include/wait_for_slave_to_start.inc
# 3) Ensure that the message in the log contains the user info.
--let $assert_file = $MYSQLTEST_VARDIR/tmp/rpl_priv_checks_user_start_info.2.err
--let $assert_count = 1
--let $assert_select = .*Replica SQL thread.*user: 'u1'@'localhost'.*
--let $assert_text = Start slave message found in log contains applier user info
--source include/assert_grep.inc
--echo #
--echo # TC2. Start server with a channel configured issues message with applier
--echo # user info
--echo # -----------------------------------------------------------------------
--echo #
# 1) Set `PRIVELEGE_CHECKS_USER` to a user with `REPLICATION_APPLIER`
# privilege.
# -> Already done, keeping the same user from previous test-case
# 2) Start the server.
--let $rpl_server_number = 2
--let $rpl_force_stop = 1
--let $rpl_server_parameters = --skip_replica_start=FALSE
--source include/rpl_restart_server.inc
--source include/wait_for_slave_to_start.inc
# 3) Ensure that the message in the log contains the user info.
--let $assert_file = $MYSQLTEST_VARDIR/tmp/rpl_priv_checks_user_start_info.2.err
--let $assert_count = 2
--let $assert_select = .*Replica SQL thread.*user: 'u1'@'localhost'.*
--let $assert_text = Start slave message with user info found twice in log, after restart
--source include/assert_grep.inc
# Cleanup
--let $rpl_server_number = 2
--let $rpl_server_parameters =
--source include/rpl_restart_server.inc
--source include/start_slave.inc
--source include/rpl_end.inc
|
