Debian Codegraph @

mysql-test/suite/group_replication/t/gr_member_actions_udf_user_privilege.test

raw
1 ###############################################################################
2 # Validate that the UDFs:
3 # group_replication_enable_member_action
4 # group_replication_disable_member_action
5 # group_replication_reset_member_actions
6 # do require the GROUP_REPLICATION_ADMIN privilege.
7 #
8 # Test:
9 # 0. This test requires two servers
10 # 1. Try to enable, disable and reset member actions without
11 # GROUP_REPLICATION_ADMIN privilege.
12 # 2. Try to enable, disable and reset member actions with
13 # GROUP_REPLICATION_ADMIN privilege.
14 # 3. Assert log messages.
15 # include/assert_grep.inc requires more privileges, thence
16 # doing it on server1 connection.
17 # 4. Clean up
18 ###############################################################################
19 --source include/not_have_privilege_checks_user.inc
20 --source include/have_group_replication_plugin.inc
21 --let $rpl_skip_group_replication_start= 1
22 --source include/group_replication.inc
23
24
25 --echo
26 --echo ############################################################
27 --echo # 1. Try to enable, disable and reset member actions without
28 --echo # GROUP_REPLICATION_ADMIN privilege.
29 --let $rpl_connection_name= server1
30 --source include/rpl_connection.inc
31
32 CREATE USER 'group_rpl_user' IDENTIFIED BY '';
33 --connect (con_group_rpl_user,127.0.0.1,group_rpl_user,,test,$MASTER_MYPORT,,)
34
35 --let $rpl_connection_name= con_group_rpl_user
36 --source include/rpl_connection.inc
37
38 --error ER_CANT_INITIALIZE_UDF
39 SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
40
41 --error ER_CANT_INITIALIZE_UDF
42 SELECT group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
43
44 --error ER_CANT_INITIALIZE_UDF
45 SELECT group_replication_reset_member_actions();
46
47
48 --echo
49 --echo ############################################################
50 --echo # 2. Try to enable, disable and reset member actions with
51 --echo # GROUP_REPLICATION_ADMIN privilege.
52 --let $rpl_connection_name= server1
53 --source include/rpl_connection.inc
54 GRANT GROUP_REPLICATION_ADMIN ON *.* TO 'group_rpl_user';
55 GRANT SELECT ON performance_schema.* TO 'group_rpl_user';
56
57 --let $rpl_connection_name= con_group_rpl_user
58 --source include/rpl_connection.inc
59
60 SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
61
62 --let $assert_text= The action mysql_disable_super_read_only_if_primary must be disabled
63 --let $assert_cond= [SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_disable_super_read_only_if_primary\' AND event=\'AFTER_PRIMARY_ELECTION\', enabled, 1] = 0
64 --source include/assert.inc
65
66 --let $assert_text= The version of replication_group_member_actions must be 2
67 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_group_member_actions\', version, 1] = 2
68 --source include/assert.inc
69
70
71 SELECT group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
72
73 --let $assert_text= The action mysql_disable_super_read_only_if_primary must be enabled
74 --let $assert_cond= [SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_disable_super_read_only_if_primary\' AND event=\'AFTER_PRIMARY_ELECTION\', enabled, 1] = 1
75 --source include/assert.inc
76
77 --let $assert_text= The version of replication_group_member_actions must be 3
78 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_group_member_actions\', version, 1] = 3
79 --source include/assert.inc
80
81
82 SELECT group_replication_reset_member_actions();
83
84 --let $assert_text= The action mysql_disable_super_read_only_if_primary must be enabled
85 --let $assert_cond= [SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_disable_super_read_only_if_primary\' AND event=\'AFTER_PRIMARY_ELECTION\', enabled, 1] = 1
86 --source include/assert.inc
87
88 --let $assert_text= The version of replication_group_member_actions must be 1
89 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_group_member_actions\', version, 1] = 1
90 --source include/assert.inc
91
92
93 --echo
94 --echo ############################################################
95 --echo # 3. Assert log messages.
96 --echo # include/assert_grep.inc requires more privileges, thence
97 --echo # doing it on server1 connection.
98 --let $rpl_connection_name= server1
99 --source include/rpl_connection.inc
100
101 --let $assert_only_after = CURRENT_TEST: group_replication.gr_member_actions_udf_user_privilege
102 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
103 --let $assert_select= Member action disabled: "mysql_disable_super_read_only_if_primary", type: "INTERNAL", event: "AFTER_PRIMARY_ELECTION", priority: "1", error_handling: "IGNORE".
104 --let $assert_count= 1
105 --let $assert_text= Member action disabled: "mysql_disable_super_read_only_if_primary", type: "INTERNAL", event: "AFTER_PRIMARY_ELECTION", priority: "1", error_handling: "IGNORE".
106 --source include/assert_grep.inc
107
108 --let $assert_only_after = CURRENT_TEST: group_replication.gr_member_actions_udf_user_privilege
109 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
110 --let $assert_select= Member action enabled: "mysql_disable_super_read_only_if_primary", type: "INTERNAL", event: "AFTER_PRIMARY_ELECTION", priority: "1", error_handling: "IGNORE".
111 --let $assert_count= 1
112 --let $assert_text= Member action enabled: "mysql_disable_super_read_only_if_primary", type: "INTERNAL", event: "AFTER_PRIMARY_ELECTION", priority: "1", error_handling: "IGNORE".
113 --source include/assert_grep.inc
114
115 --let $assert_only_after = CURRENT_TEST: group_replication.gr_member_actions_udf_user_privilege
116 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
117 --let $assert_select= Member actions configuration was reset.
118 --let $assert_count= 1
119 --let $assert_text= Member actions configuration was reset.
120 --source include/assert_grep.inc
121
122
123 --echo
124 --echo ############################################################
125 --echo # 4. Clean up.
126 --let $rpl_connection_name= server1
127 --source include/rpl_connection.inc
128
129 --disconnect con_group_rpl_user
130 DROP USER group_rpl_user;
131
132 --source include/group_replication_end.inc