Debian Codegraph @

mysql-test/suite/group_replication/r/gr_start_gr_with_credentials_mysql_connections.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. And create new users.
8 [connection server1]
9 include/start_and_bootstrap_group_replication.inc
10 SET SQL_LOG_BIN=0;
11 CREATE USER 'regular_user_p' IDENTIFIED BY 'password';
12 CREATE USER 'regular_user_wp' IDENTIFIED BY '';
13 GRANT REPLICATION SLAVE ON *.* TO "regular_user_p";
14 GRANT REPLICATION SLAVE ON *.* TO "regular_user_wp";
15 GRANT GROUP_REPLICATION_STREAM ON *.* TO "regular_user_p";
16 GRANT GROUP_REPLICATION_STREAM ON *.* TO "regular_user_wp";
17 SET SQL_LOG_BIN=1;
18
19 # 2. Reset recovery interval to 1 and count to 2 for M2.
20 [connection server2]
21 SET SQL_LOG_BIN=0;
22 CREATE USER 'regular_user_p' IDENTIFIED BY 'password';
23 CREATE USER 'regular_user_wp' IDENTIFIED BY '';
24 GRANT REPLICATION SLAVE ON *.* TO "regular_user_p";
25 GRANT REPLICATION SLAVE ON *.* TO "regular_user_wp";
26 GRANT GROUP_REPLICATION_STREAM ON *.* TO "regular_user_p";
27 GRANT GROUP_REPLICATION_STREAM ON *.* TO "regular_user_wp";
28 SET SQL_LOG_BIN=1;
29 SET @saved_group_replication_recovery_reconnect_interval = @@GLOBAL.group_replication_recovery_reconnect_interval;
30 SET @saved_gr_recovery_retry_count = @@GLOBAL.group_replication_recovery_retry_count;
31 SET GLOBAL group_replication_recovery_reconnect_interval= 1;
32 SET GLOBAL group_replication_recovery_retry_count= 2;
33 SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
34
35 # 3. Test START GR works without any option.
36 include/start_group_replication.inc
37 include/stop_group_replication.inc
38
39 # 4. Delete recovery channel and test START GR, it should fail.
40 RESET SLAVE ALL FOR CHANNEL 'group_replication_recovery';
41 Warnings:
42 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
43 START GROUP_REPLICATION;
44 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
45
46 # 5. Pass USER as root and test START GR, member should come ONLINE.
47 # START GR without parameter fails, credentials are removed on STOP.
48 START GROUP_REPLICATION USER='root';
49 include/gr_wait_for_member_state.inc
50 include/stop_group_replication.inc
51 START GROUP_REPLICATION;
52 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
53
54 # 6. Test wrong credentials do not connect with master.
55 START GROUP_REPLICATION USER='regular_user_p',PASSWORD='wrong';
56 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
57 START GROUP_REPLICATION USER='regular_user_p';
58 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
59 START GROUP_REPLICATION USER='regular_user_wp' , PASSWORD='password';
60 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
61
62 # 7. Test right credentials in START GR connect with master.
63 START GROUP_REPLICATION USER='regular_user_p' , PASSWORD='password';
64 include/gr_wait_for_member_state.inc
65 include/stop_group_replication.inc
66 START GROUP_REPLICATION USER='regular_user_p' , PASSWORD='password' , DEFAULT_AUTH= 'auth_test_plugin';
67 include/gr_wait_for_member_state.inc
68 include/stop_group_replication.inc
69 START GROUP_REPLICATION PASSWORD='password' , USER='regular_user_p', DEFAULT_AUTH='auth_test_plugin';
70 include/gr_wait_for_member_state.inc
71 include/stop_group_replication.inc
72 START GROUP_REPLICATION USER='regular_user_p' , DEFAULT_AUTH= '' , PASSWORD='password';
73 include/gr_wait_for_member_state.inc
74 include/stop_group_replication.inc
75 START GROUP_REPLICATION USER='regular_user_wp';
76 include/gr_wait_for_member_state.inc
77 include/stop_group_replication.inc
78 START GROUP_REPLICATION USER='regular_user_wp' , PASSWORD='';
79 include/gr_wait_for_member_state.inc
80 include/stop_group_replication.inc
81
82 # 8. Cleanup.
83 CHANGE REPLICATION SOURCE TO SOURCE_USER='root' , SOURCE_PASSWORD='' FOR CHANNEL 'group_replication_recovery';
84 Warnings:
85 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
86 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.
87 SET SESSION sql_log_bin = 0;
88 call mtr.add_suppression("Error while executing a group configuration operation: Could not extract the access credentials for XCom connections.*");
89 call mtr.add_suppression("\\[GCS\\] The group communication engine could not set up its internal event notification mechanism.*");
90 call mtr.add_suppression("\\[GCS\\] The group communication engine failed to test connectivity to the local group communication engine.*");
91 call mtr.add_suppression("Timeout on wait for view after joining group.");
92 SET SESSION sql_log_bin = 1;
93 SET @@GLOBAL.group_replication_recovery_reconnect_interval = @saved_group_replication_recovery_reconnect_interval;
94 SET @@GLOBAL.group_replication_recovery_retry_count = @saved_gr_recovery_retry_count;
95 SET SQL_LOG_BIN=0;
96 DROP USER 'regular_user_p';
97 DROP USER 'regular_user_wp';
98 SET SQL_LOG_BIN=1;
99 [connection server1]
100 SET SQL_LOG_BIN=0;
101 DROP USER 'regular_user_p';
102 DROP USER 'regular_user_wp';
103 SET SQL_LOG_BIN=1;
104 include/group_replication_end.inc