Debian Codegraph @

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

raw
1 --source include/have_group_replication_plugin.inc
2 --let $rpl_skip_group_replication_start= 1
3 --let $rpl_group_replication_single_primary_mode=1
4 --source include/group_replication.inc
5 --echo
6 --echo #-------------------------------------------------
7 --echo # 1. Bootstrap start GR on server1 (Primary).
8 --echo # Start GR on server2 (Secondary).
9 --let $rpl_connection_name= server1
10 --source include/rpl_connection.inc
11 --let $server1_uuid= `SELECT @@server_uuid`
12 --source include/start_and_bootstrap_group_replication.inc
13 --let $rpl_connection_name= server2
14 --source include/rpl_connection.inc
15 --source include/start_group_replication.inc
16 --echo
17 # Make sure server1 is the primary
18 --let $assert_text= Verify group_replication_primary_member is SERVER_UUID
19 --let $assert_cond= "[SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME= \'group_replication_primary_member\', VARIABLE_VALUE, 1]" = "$server1_uuid"
20 --source include/assert.inc
21 --echo
22 --echo #-- On Server1
23 --let $rpl_connection_name= server1
24 --source include/rpl_connection.inc
25 --echo
26 # Set variable generated_random_password_length
27 SELECT @@GLOBAL.generated_random_password_length;
28 SELECT @@SESSION.generated_random_password_length;
29
30 SET @@GLOBAL.generated_random_password_length = 25;
31 SELECT @@GLOBAL.generated_random_password_length;
32 SELECT @@SESSION.generated_random_password_length;
33
34 # Create user on server1
35 --echo #-- CREATE user usr1 with RANDOM PASSWORD
36 let $qry= CREATE USER usr1@localhost IDENTIFIED BY RANDOM PASSWORD;
37 let $pswd = query_get_value($qry, "generated password", 1);
38 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO usr1@localhost;
39 GRANT GROUP_REPLICATION_ADMIN ON *.* TO usr1@localhost;
40 GRANT REPLICATION_SLAVE_ADMIN ON *.* TO usr1@localhost;
41 FLUSH PRIVILEGES;
42
43 --source include/rpl_sync.inc
44 --echo
45 --echo #-- Connect to usr1 on server1
46 --echo [connection usr1]
47 connect(con1, localhost, usr1, $pswd,*NO-ONE*);
48 # Execution of commands should be successful.
49 SELECT CURRENT_USER;
50 SELECT @@GLOBAL.generated_random_password_length;
51 SELECT @@SESSION.generated_random_password_length;
52 --disconnect con1
53 --echo
54
55 --echo #-- On Server2
56 --let $rpl_connection_name= server2
57 --source include/rpl_connection.inc
58 SELECT user FROM mysql.user WHERE user LIKE '%usr%';
59 SELECT @@GLOBAL.generated_random_password_length;
60 SELECT @@SESSION.generated_random_password_length;
61 --echo
62
63 --echo #-- On Server1
64 --let $rpl_connection_name= server1
65 --source include/rpl_connection.inc
66 SET @@SESSION.generated_random_password_length = 30;
67 --echo #-- CREATE user usr2 with RANDOM PASSWORD
68 --replace_column 3 #####
69 CREATE USER usr2@localhost IDENTIFIED BY RANDOM PASSWORD;
70 --echo #-- ALTER with RANDOM PASSWORD
71 let $qry= ALTER USER usr2@localhost IDENTIFIED BY RANDOM PASSWORD;
72 let $pswd = query_get_value($qry, "generated password", 1);
73 SELECT @@GLOBAL.generated_random_password_length;
74 SELECT @@SESSION.generated_random_password_length;
75 --echo
76
77 --source include/rpl_sync.inc
78 --echo
79 --echo #-- Connect to usr2 on server1
80 --echo [connection usr2]
81 connect(con1, localhost, usr2, $pswd,*NO-ONE*);
82 # Execution of commands should be successful.
83 SELECT CURRENT_USER;
84 SELECT @@GLOBAL.generated_random_password_length;
85 SELECT @@SESSION.generated_random_password_length;
86 --disconnect con1
87 --echo
88
89 --echo #-- On Server2
90 --let $rpl_connection_name= server2
91 --source include/rpl_connection.inc
92 SELECT user FROM mysql.user WHERE user LIKE '%usr%';
93 SELECT @@GLOBAL.generated_random_password_length;
94 SELECT @@SESSION.generated_random_password_length;
95 --echo
96
97 --echo #-- On Server1
98 --let $rpl_connection_name= server1
99 --source include/rpl_connection.inc
100 SET @@GLOBAL.generated_random_password_length = 15;
101 --echo #-- CREATE user usr3 with RANDOM PASSWORD
102 --replace_column 3 #####
103 CREATE USER usr3@localhost IDENTIFIED BY RANDOM PASSWORD;
104 --echo #-- SET PASSWORD with RANDOM PASSWORD
105 let $qry= SET PASSWORD FOR usr3@localhost TO RANDOM;
106 let $pswd = query_get_value($qry, "generated password", 1);
107 SELECT @@GLOBAL.generated_random_password_length;
108 SELECT @@SESSION.generated_random_password_length;
109 --echo
110
111 --source include/rpl_sync.inc
112 --echo
113 --echo #-- Connect to usr3 on server1
114 --echo [connection usr3]
115 connect(con1, localhost, usr3, $pswd,*NO-ONE*);
116 # Execution of commands should be successful.
117 SELECT CURRENT_USER;
118 SELECT @@GLOBAL.generated_random_password_length;
119 SELECT @@SESSION.generated_random_password_length;
120 --disconnect con1
121
122 --echo
123 --let $rpl_connection_name= server2
124 --source include/rpl_connection.inc
125 SELECT user FROM mysql.user WHERE user LIKE '%usr%';
126 SELECT @@GLOBAL.generated_random_password_length;
127 SELECT @@SESSION.generated_random_password_length;
128 # Cleanup
129 --let $rpl_connection_name= server1
130 --source include/rpl_connection.inc
131 --echo
132
133 SET @@SESSION.generated_random_password_length = DEFAULT;
134 SET @@GLOBAL.generated_random_password_length = DEFAULT;
135
136 DROP USER usr1@localhost;
137 DROP USER usr2@localhost;
138 DROP USER usr3@localhost;
139
140 --source include/rpl_sync.inc
141 --source include/group_replication_end.inc