Debian Codegraph @

mysql-test/suite/group_replication/r/gr_start_gr_with_credentials_2.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 # 1. Bootstrap M1.
8 # Install test authentication plugin.
9 # Create new users.
10 [connection server1]
11 INSTALL PLUGIN test_plugin_server SONAME 'PLUGIN_AUTH';
12 include/start_and_bootstrap_group_replication.inc
13 SET SQL_LOG_BIN=0;
14 CREATE USER 'plug_user_p' IDENTIFIED WITH 'test_plugin_server' AS 'proxy_user_p';
15 CREATE USER 'plug_user_wp' IDENTIFIED WITH 'test_plugin_server' AS 'proxy_user_wp';
16 CREATE USER 'proxy_user_p' IDENTIFIED BY 'password';
17 CREATE USER 'proxy_user_wp' IDENTIFIED BY '';
18 GRANT ALL PRIVILEGES ON *.* TO 'proxy_user_p';
19 GRANT ALL PRIVILEGES ON *.* TO 'proxy_user_wp';
20 GRANT PROXY ON 'proxy_user_p' to 'plug_user_p';
21 GRANT PROXY ON 'proxy_user_wp' to 'plug_user_wp';
22 GRANT REPLICATION SLAVE ON *.* TO 'plug_user_p';
23 GRANT REPLICATION SLAVE ON *.* TO 'plug_user_wp';
24 SET SQL_LOG_BIN=1;
25
26 # 2. Reset recovery interval to 1 and count to 2 for M2.
27 [connection server2]
28 SET @old_log_output= @@log_output;
29 SET GLOBAL log_output= 'TABLE,FILE';
30 RESET SLAVE ALL FOR CHANNEL 'group_replication_recovery';
31 Warnings:
32 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
33 INSTALL PLUGIN test_plugin_server SONAME 'PLUGIN_AUTH';
34 SET @saved_group_replication_recovery_reconnect_interval = @@GLOBAL.group_replication_recovery_reconnect_interval;
35 SET @saved_gr_recovery_retry_count = @@GLOBAL.group_replication_recovery_retry_count;
36 SET GLOBAL group_replication_recovery_reconnect_interval= 1;
37 SET GLOBAL group_replication_recovery_retry_count= 2;
38 SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
39
40 # 3. Test credentials as parameter START GR.
41 # Confirm password is not logged.
42 SET GLOBAL super_read_only= FALSE;
43 SET SQL_LOG_BIN=0;
44 TRUNCATE mysql.general_log;
45 SET SQL_LOG_BIN=1;
46 START GROUP_REPLICATION USER= 'plug_user_p' , PASSWORD= 'proxy_user_p';
47 include/gr_wait_for_member_state.inc
48 include/stop_group_replication.inc
49 include/assert.inc [Password is not logged.]
50 include/assert.inc [Password is logged as secret.]
51 SET GLOBAL super_read_only= FALSE;
52 SET SQL_LOG_BIN=0;
53 TRUNCATE mysql.general_log;
54 SET SQL_LOG_BIN=1;
55 START GROUP_REPLICATION USER= 'plug_user_wp' , PASSWORD= 'proxy_user_wp';
56 include/gr_wait_for_member_state.inc
57 include/stop_group_replication.inc
58 include/assert.inc [Password is not logged.]
59 include/assert.inc [Password is logged as secret.]
60 SET GLOBAL super_read_only= FALSE;
61 SET SQL_LOG_BIN=0;
62 TRUNCATE mysql.general_log;
63 SET SQL_LOG_BIN=1;
64 START GROUP_REPLICATION USER= 'plug_user_p' , PASSWORD= 'proxy_user_p' , DEFAULT_AUTH= 'auth_test_plugin';
65 include/gr_wait_for_member_state.inc
66 include/stop_group_replication.inc
67 include/assert.inc [Password is not logged.]
68 include/assert.inc [Password is logged as secret.]
69 SET GLOBAL super_read_only= FALSE;
70 SET SQL_LOG_BIN=0;
71 TRUNCATE mysql.general_log;
72 SET SQL_LOG_BIN=1;
73 START GROUP_REPLICATION USER= 'plug_user_wp' , PASSWORD= 'proxy_user_wp' , DEFAULT_AUTH= 'auth_test_plugin';
74 include/gr_wait_for_member_state.inc
75 include/stop_group_replication.inc
76 include/assert.inc [Password is not logged.]
77 include/assert.inc [Password is logged as secret.]
78 SET GLOBAL super_read_only= FALSE;
79 SET SQL_LOG_BIN=0;
80 TRUNCATE mysql.general_log;
81 SET SQL_LOG_BIN=1;
82 START GROUP_REPLICATION USER= 'plug_user_wp' , PASSWORD= 'proxy_user_wp' , DEFAULT_AUTH= 'auth_test_plugin';
83 include/gr_wait_for_member_state.inc
84 include/stop_group_replication.inc
85 include/assert.inc [Password is not logged.]
86 include/assert.inc [Password is logged as secret.]
87
88 # 4. SSL - Test credentials as parameter START GR.
89 # Confirm password is not logged.
90 SET @group_replication_recovery_use_ssl_save= @@GLOBAL.group_replication_recovery_use_ssl;
91 SET GLOBAL group_replication_recovery_use_ssl= ON;
92 SET GLOBAL super_read_only= FALSE;
93 SET SQL_LOG_BIN=0;
94 TRUNCATE mysql.general_log;
95 SET SQL_LOG_BIN=1;
96 START GROUP_REPLICATION USER= 'plug_user_p' , PASSWORD= 'proxy_user_p';
97 include/gr_wait_for_member_state.inc
98 include/stop_group_replication.inc
99 include/assert.inc [Password is not logged.]
100 include/assert.inc [Password is logged as secret.]
101 SET GLOBAL super_read_only= FALSE;
102 SET SQL_LOG_BIN=0;
103 TRUNCATE mysql.general_log;
104 SET SQL_LOG_BIN=1;
105 START GROUP_REPLICATION USER= 'plug_user_p' , PASSWORD= 'proxy_user_p' , DEFAULT_AUTH= 'auth_test_plugin';
106 include/gr_wait_for_member_state.inc
107 include/stop_group_replication.inc
108 include/assert.inc [Password is not logged.]
109 include/assert.inc [Password is logged as secret.]
110 SET GLOBAL super_read_only= FALSE;
111 SET SQL_LOG_BIN=0;
112 TRUNCATE mysql.general_log;
113 SET SQL_LOG_BIN=1;
114 START GROUP_REPLICATION USER= 'plug_user_wp' , PASSWORD= 'proxy_user_wp' , DEFAULT_AUTH= 'auth_test_plugin';
115 include/gr_wait_for_member_state.inc
116 include/stop_group_replication.inc
117 include/assert.inc [Password is not logged.]
118 include/assert.inc [Password is logged as secret.]
119 SET @@GLOBAL.group_replication_recovery_use_ssl= @group_replication_recovery_use_ssl_save;
120
121 # 5. Test wrong credentials.
122 # Confirm password is not logged.
123 SET GLOBAL super_read_only= FALSE;
124 SET SQL_LOG_BIN=0;
125 TRUNCATE mysql.general_log;
126 SET SQL_LOG_BIN=1;
127 START GROUP_REPLICATION USER='plug_user_p',PASSWORD='WRONG';
128 include/gr_wait_for_member_state.inc
129 include/stop_group_replication.inc
130 include/assert.inc [Password is not logged.]
131 include/assert.inc [Password is logged as secret.]
132 SET GLOBAL super_read_only= FALSE;
133 SET SQL_LOG_BIN=0;
134 TRUNCATE mysql.general_log;
135 SET SQL_LOG_BIN=1;
136 START GROUP_REPLICATION USER='plug_user_wp';
137 include/gr_wait_for_member_state.inc
138 include/stop_group_replication.inc
139 include/assert.inc [Password is not logged.]
140 include/assert.inc [Password is NOT LOGGED not even secret.]
141 SET GLOBAL super_read_only= FALSE;
142 SET SQL_LOG_BIN=0;
143 TRUNCATE mysql.general_log;
144 SET SQL_LOG_BIN=1;
145 START GROUP_REPLICATION PASSWORD='wrong';
146 ERROR HY000: The START GROUP_REPLICATION command failed since the USER option was not provided with PASSWORD for recovery channel.
147 include/assert.inc [Password is not logged.]
148 include/assert.inc [Password is logged as secret.]
149 SET GLOBAL super_read_only= FALSE;
150 SET SQL_LOG_BIN=0;
151 TRUNCATE mysql.general_log;
152 SET SQL_LOG_BIN=1;
153 START GROUP_REPLICATION USER='plug_user_p' , PASSWORD='proxy_user_p' , DEFAULT_AUTH='wrong_auth';;
154 include/gr_wait_for_member_state.inc
155 include/stop_group_replication.inc
156 include/assert.inc [Password is not logged.]
157 include/assert.inc [Password is logged as secret.]
158
159 # 6. Cleanup.
160 CHANGE REPLICATION SOURCE TO SOURCE_USER='root' , SOURCE_PASSWORD='' FOR CHANNEL 'group_replication_recovery';
161 Warnings:
162 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
163 Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
164 include/start_group_replication.inc
165 SET SESSION sql_log_bin = 0;
166 call mtr.add_suppression("Replica I/O for channel 'group_replication_recovery': Fatal error: Invalid .* username when attempting to connect to the source server.*");
167 call mtr.add_suppression("There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.");
168 call mtr.add_suppression("For details please check performance_schema.replication_connection_status table and error log messages of Replica I/O for channel group_replication_recovery.");
169 call mtr.add_suppression("There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.");
170 call mtr.add_suppression("Maximum number of retries when trying to connect to a donor reached. Aborting group replication incremental recovery.");
171 call mtr.add_suppression("Fatal error during the incremental recovery process of Group Replication. The server will leave the group.");
172 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
173 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
174 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
175 SET SESSION sql_log_bin = 1;
176 SET @@GLOBAL.group_replication_recovery_reconnect_interval = @saved_group_replication_recovery_reconnect_interval;
177 SET @@GLOBAL.group_replication_recovery_retry_count = @saved_gr_recovery_retry_count;
178 SET GLOBAL log_output= @old_log_output;
179 UNINSTALL PLUGIN test_plugin_server;
180 [connection server1]
181 SET SESSION sql_log_bin = 0;
182 call mtr.add_suppression("Wrong password supplied for proxy_user_p");
183 call mtr.add_suppression("Wrong password supplied for proxy_user_wp");
184 DROP USER 'plug_user_p';
185 DROP USER 'plug_user_wp';
186 DROP USER 'proxy_user_p';
187 DROP USER 'proxy_user_wp';
188 SET SESSION sql_log_bin = 1;
189 UNINSTALL PLUGIN test_plugin_server;
190 TRUNCATE mysql.general_log;
191 include/group_replication_end.inc