Debian Codegraph @

mysql-test/suite/rpl/r/rpl_master_connection.result

raw
1 include/master-slave.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 master]
6 SET SQL_LOG_BIN=0;
7 SELECT user, plugin FROM mysql.user WHERE user NOT IN ('root', 'mysql.sys','mysql.session', 'mysql.infoschema');
8 user plugin
9 CREATE USER 'plug_user_p' IDENTIFIED WITH 'test_plugin_server' AS 'proxy_user_p';
10 CREATE USER 'plug_user_wp' IDENTIFIED WITH 'test_plugin_server' AS 'proxy_user_wp';
11 CREATE USER 'proxy_user_p' IDENTIFIED BY 'password';
12 CREATE USER 'proxy_user_wp' IDENTIFIED BY '';
13 CREATE USER 'regular_user_p' IDENTIFIED BY 'password';
14 CREATE USER 'regular_user_wp' IDENTIFIED BY '';
15 SELECT user, plugin FROM mysql.user WHERE user NOT IN ('root', 'mysql.sys','mysql.session', 'mysql.infoschema');
16 user plugin
17 plug_user_p test_plugin_server
18 plug_user_wp test_plugin_server
19 proxy_user_p caching_sha2_password
20 proxy_user_wp caching_sha2_password
21 regular_user_p caching_sha2_password
22 regular_user_wp caching_sha2_password
23 GRANT PROXY ON proxy_user_p to plug_user_p;
24 GRANT PROXY ON proxy_user_wp to plug_user_wp;
25 GRANT REPLICATION SLAVE ON *.* TO proxy_user_p;
26 GRANT REPLICATION SLAVE ON *.* TO proxy_user_wp;
27 GRANT REPLICATION SLAVE ON *.* TO regular_user_p;
28 GRANT REPLICATION SLAVE ON *.* TO regular_user_wp;
29 SET SQL_LOG_BIN=1;
30 include/stop_slave.inc
31 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST', SOURCE_SSL = 1;
32 Warnings:
33 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
34 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.
35 START REPLICA SQL_THREAD USER= 'regular_user_p' PASSWORD= 'password';
36 ERROR HY000: Setting authentication options is not possible when only the Replica SQL Thread is being started.
37 START REPLICA SQL_THREAD USER= 'regular_user_p' PASSWORD= 'password' DEFAULT_AUTH= 'auth_test_plugin';
38 ERROR HY000: Setting authentication options is not possible when only the Replica SQL Thread is being started.
39 START REPLICA SQL_THREAD USER= 'regular_user_p' PASSWORD= 'password' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
40 ERROR HY000: Setting authentication options is not possible when only the Replica SQL Thread is being started.
41 START REPLICA IO_THREAD USER= 'regular_user_p' PASSWORD= 'password';
42 Warnings:
43 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
44 include/wait_for_slave_io_to_start.inc
45 include/stop_slave_io.inc
46 START REPLICA IO_THREAD USER= 'regular_user_p' PASSWORD= 'password' DEFAULT_AUTH= 'auth_test_plugin';
47 Warnings:
48 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
49 include/wait_for_slave_io_to_start.inc
50 include/stop_slave_io.inc
51 START REPLICA IO_THREAD USER= 'regular_user_p' PASSWORD= 'password' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
52 Warnings:
53 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
54 include/wait_for_slave_io_to_start.inc
55 include/stop_slave_io.inc
56 START REPLICA IO_THREAD, SQL_THREAD USER= 'regular_user_p' PASSWORD= 'password';
57 Warnings:
58 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
59 include/wait_for_slave_io_to_start.inc
60 include/stop_slave_io.inc
61 START REPLICA IO_THREAD, SQL_THREAD USER= 'regular_user_p' PASSWORD= 'password' DEFAULT_AUTH= 'auth_test_plugin';
62 Warnings:
63 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
64 include/wait_for_slave_io_to_start.inc
65 include/stop_slave_io.inc
66 START REPLICA IO_THREAD, SQL_THREAD USER= 'regular_user_p' PASSWORD= 'password' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
67 Warnings:
68 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
69 include/wait_for_slave_io_to_start.inc
70 include/stop_slave_io.inc
71 include/stop_slave.inc
72 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
73 Warnings:
74 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
75 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.
76 START REPLICA USER= 'regular_user_p' PASSWORD= 'password';
77 Warnings:
78 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
79 include/wait_for_slave_to_start.inc
80 include/check_slave_is_running.inc
81 include/stop_slave.inc
82 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
83 Warnings:
84 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
85 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.
86 START REPLICA USER= 'regular_user_wp' PASSWORD= '';
87 Warnings:
88 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
89 include/wait_for_slave_to_start.inc
90 include/check_slave_is_running.inc
91 include/stop_slave.inc
92 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
93 Warnings:
94 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
95 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.
96 START REPLICA USER= 'regular_user_p' PASSWORD= 'password';
97 Warnings:
98 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
99 include/wait_for_slave_to_start.inc
100 include/check_slave_is_running.inc
101 include/stop_slave.inc
102 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
103 Warnings:
104 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
105 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.
106 START REPLICA USER= 'regular_user_wp' PASSWORD= '';
107 Warnings:
108 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
109 include/wait_for_slave_to_start.inc
110 include/check_slave_is_running.inc
111 include/stop_slave.inc
112 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
113 Warnings:
114 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
115 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.
116 START REPLICA USER= 'regular_user_wp';
117 Warnings:
118 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
119 include/wait_for_slave_to_start.inc
120 include/check_slave_is_running.inc
121 include/stop_slave.inc
122 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
123 Warnings:
124 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
125 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.
126 START REPLICA USER= 'plug_user_p' PASSWORD= 'proxy_user_p';
127 Warnings:
128 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
129 include/wait_for_slave_to_start.inc
130 include/check_slave_is_running.inc
131 include/stop_slave.inc
132 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
133 Warnings:
134 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
135 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.
136 START REPLICA USER= 'plug_user_wp' PASSWORD= 'proxy_user_wp';
137 Warnings:
138 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
139 include/wait_for_slave_to_start.inc
140 include/check_slave_is_running.inc
141 include/stop_slave.inc
142 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
143 Warnings:
144 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
145 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.
146 START REPLICA USER= 'plug_user_p' PASSWORD= 'proxy_user_p' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
147 Warnings:
148 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
149 include/wait_for_slave_to_start.inc
150 include/check_slave_is_running.inc
151 include/stop_slave.inc
152 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
153 Warnings:
154 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
155 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.
156 START REPLICA USER= 'plug_user_wp' PASSWORD= 'proxy_user_wp' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
157 Warnings:
158 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
159 include/wait_for_slave_to_start.inc
160 include/check_slave_is_running.inc
161 include/stop_slave.inc
162 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
163 Warnings:
164 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
165 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.
166 START REPLICA USER= 'plug_user_p' PASSWORD= 'proxy_user_p' DEFAULT_AUTH= 'auth_test_plugin';
167 Warnings:
168 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
169 include/wait_for_slave_to_start.inc
170 include/check_slave_is_running.inc
171 include/stop_slave.inc
172 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
173 Warnings:
174 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
175 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.
176 START REPLICA USER= 'plug_user_wp' PASSWORD= 'proxy_user_wp' DEFAULT_AUTH= 'auth_test_plugin';
177 Warnings:
178 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
179 include/wait_for_slave_to_start.inc
180 include/check_slave_is_running.inc
181 include/stop_slave.inc
182 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
183 Warnings:
184 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
185 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.
186 START REPLICA USER= 'plug_user_p' PASSWORD= 'proxy_user_p' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
187 Warnings:
188 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
189 include/wait_for_slave_to_start.inc
190 include/check_slave_is_running.inc
191 include/stop_slave.inc
192 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'DOES NOT EXIST', SOURCE_PASSWORD = 'DOES NOT EXIST';
193 Warnings:
194 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
195 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.
196 START REPLICA USER= 'plug_user_wp' PASSWORD= 'proxy_user_wp' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
197 Warnings:
198 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
199 include/wait_for_slave_to_start.inc
200 include/check_slave_is_running.inc
201 include/stop_slave.inc
202 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'plug_user_p', SOURCE_PASSWORD= 'proxy_user_p', SOURCE_SSL = 1;
203 Warnings:
204 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
205 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.
206 include/start_slave.inc
207 include/check_slave_is_running.inc
208 include/stop_slave.inc
209 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'plug_user_wp', SOURCE_PASSWORD= 'proxy_user_wp';
210 Warnings:
211 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
212 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.
213 include/start_slave.inc
214 include/check_slave_is_running.inc
215 CREATE USER 'ssl_user' IDENTIFIED BY '' REQUIRE SSL;
216 GRANT ALL ON *.* TO ssl_user;
217 include/stop_slave.inc
218 CHANGE REPLICATION SOURCE TO SOURCE_USER= 'root', SOURCE_PASSWORD = '' , SOURCE_SSL = 0;
219 Warnings:
220 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.
221 include/start_slave.inc
222 include/stop_slave.inc
223 START REPLICA USER= 'root' PASSWORD= '';
224 include/wait_for_slave_to_start.inc
225 include/check_slave_is_running.inc
226 SET @old_log_output= @@log_output;
227 SET GLOBAL log_output= 'TABLE,FILE';
228 call mtr.add_suppression(".*Invalid .* username when attempting to connect to the source server.*");
229 include/stop_slave.inc
230 TRUNCATE mysql.general_log;
231 START REPLICA PASSWORD='secret';
232 include/wait_for_slave_io_error.inc [errno=13117]
233 include/stop_slave.inc
234 TRUNCATE mysql.general_log;
235 START REPLICA USER='root' PASSWORD='secret';
236 include/wait_for_slave_io_error.inc [errno=2061]
237 include/stop_slave_sql.inc
238 START REPLICA USER = 'root' PASSWORD = '<secret>';
239 include/wait_for_slave_io_error.inc [errno=2061]
240 include/stop_slave_sql.inc
241 TRUNCATE mysql.general_log;
242 START REPLICA IO_THREAD USER='root' PASSWORD='secret' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
243 include/wait_for_slave_io_error.inc [errno=2061]
244 include/stop_slave_sql.inc
245 START REPLICA IO_THREAD USER = 'root' PASSWORD = '<secret>' DEFAULT_AUTH = 'auth_test_plugin' PLUGIN_DIR = 'PLUGIN_AUTH_DIR';
246 include/wait_for_slave_io_error.inc [errno=2061]
247 include/stop_slave_sql.inc
248 TRUNCATE mysql.general_log;
249 START REPLICA IO_THREAD, SQL_THREAD USER='root' PASSWORD='secret' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
250 include/wait_for_slave_io_error.inc [errno=2061]
251 include/stop_slave_sql.inc
252 START REPLICA IO_THREAD, SQL_THREAD USER = 'root' PASSWORD = '<secret>' DEFAULT_AUTH = 'auth_test_plugin' PLUGIN_DIR = 'PLUGIN_AUTH_DIR';
253 include/wait_for_slave_io_error.inc [errno=2061]
254 include/stop_slave_sql.inc
255 TRUNCATE mysql.general_log;
256 START REPLICA IO_THREAD, SQL_THREAD UNTIL SOURCE_LOG_FILE='dummy-log.000001', SOURCE_LOG_POS=116 USER='root' PASSWORD='secret' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
257 include/wait_for_slave_io_error.inc [errno=2061]
258 include/stop_slave_sql.inc
259 START REPLICA IO_THREAD, SQL_THREAD UNTIL SOURCE_LOG_FILE = 'dummy-log.000001', SOURCE_LOG_POS = 116 USER = 'root' PASSWORD = '<secret>' DEFAULT_AUTH = 'auth_test_plugin' PLUGIN_DIR = 'PLUGIN_AUTH_DIR';
260 include/wait_for_slave_io_error.inc [errno=2061]
261 include/stop_slave_sql.inc
262 TRUNCATE mysql.general_log;
263 START REPLICA IO_THREAD, SQL_THREAD UNTIL RELAY_LOG_FILE='dummy-log.000001', RELAY_LOG_POS=116 USER='root' PASSWORD='secret' DEFAULT_AUTH= 'auth_test_plugin' PLUGIN_DIR= 'PLUGIN_AUTH_DIR';
264 include/wait_for_slave_io_error.inc [errno=2061]
265 include/stop_slave_sql.inc
266 START REPLICA IO_THREAD, SQL_THREAD UNTIL RELAY_LOG_FILE = 'dummy-log.000001', RELAY_LOG_POS = 116 USER = 'root' PASSWORD = '<secret>' DEFAULT_AUTH = 'auth_test_plugin' PLUGIN_DIR = 'PLUGIN_AUTH_DIR';
267 include/wait_for_slave_io_error.inc [errno=2061]
268 include/stop_slave_sql.inc
269 SET GLOBAL log_output= @old_log_output;
270 TRUNCATE mysql.general_log;
271 include/start_slave.inc
272 SET SQL_LOG_BIN=0;
273 DROP USER plug_user_p, plug_user_wp, regular_user_p, regular_user_wp, proxy_user_p, proxy_user_wp;
274 SET SQL_LOG_BIN=1;
275 DROP USER ssl_user;
276 include/rpl_end.inc