Debian Codegraph @

mysql-test/suite/galera/t/galera_ssl_cipher.test

raw
1 #
2 # Test upgrading the SSL chipher
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_ssl_communication.inc
7 --source include/have_openssl.inc
8 --source include/force_restart.inc
9
10 #
11 # Lowest supported Galera library version
12 #
13 --let $galera_version=26.4.21
14 source ../wsrep/include/check_galera_version.inc;
15
16 # Save original auto_increment_offset values.
17 --let $node_1=node_1
18 --let $node_2=node_2
19 --source include/auto_increment_offset_save.inc
20
21 # Setup galera ports
22 --connection node_1
23 --source suite/galera/include/galera_base_port.inc
24 --let $NODE_GALERAPORT_1 = $_NODE_GALERAPORT
25
26 --connection node_2
27 --source suite/galera/include/galera_base_port.inc
28 --let $NODE_GALERAPORT_2 = $_NODE_GALERAPORT
29
30 SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
31 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
32
33 # 2. Restart node #1 with a socket.ssl_cipher
34
35 --connection node_1
36 --source include/shutdown_mysqld.inc
37 --let $restart_noprint = 1
38 --let $start_mysqld_params = --wsrep-cluster-address=gcomm://127.0.0.1:$NODE_GALERAPORT_2 --wsrep_provider_options=base_port=$NODE_GALERAPORT_1;socket.ssl=yes;socket.ssl_ca=$MYSQL_TEST_DIR/std_data/cacert.pem;socket.ssl_cert=$MYSQL_TEST_DIR/std_data/server-cert.pem;socket.ssl_key=$MYSQL_TEST_DIR/std_data/server-key.pem;socket.ssl_cipher=AES256-SHA
39 --source include/start_mysqld.inc
40 --source include/wait_until_connected_again.inc
41
42 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
43 --source include/wait_condition.inc
44 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
45
46 # 3. Restart node #2 with the new socket.ssl_ca , socket.ssl_cert, socket.ssl_key and socket.ssl_cipher
47
48 --connection node_2
49 --source include/shutdown_mysqld.inc
50 --let $start_mysqld_params = --wsrep_provider_options=base_port=$NODE_GALERAPORT_2;socket.ssl=yes;socket.ssl_ca=$MYSQL_TEST_DIR/std_data/cacert.pem;socket.ssl_cert=$MYSQL_TEST_DIR/std_data/server-new-cert.pem;socket.ssl_key=$MYSQL_TEST_DIR/std_data/server-new-key.pem;socket.ssl_cipher=AES256-SHA
51 --source include/start_mysqld.inc
52 --source include/wait_until_connected_again.inc
53
54 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
55 --source include/wait_condition.inc
56 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
57
58 # 4. Restart node #1 with the new socket.ssl_ca , socket.ssl_cert, socket.ssl_key and socket.ssl_cipher
59
60 --connection node_1
61 --source include/shutdown_mysqld.inc
62 --let $start_mysqld_params = --wsrep-cluster-address=gcomm://127.0.0.1:$NODE_GALERAPORT_2 --wsrep_provider_options=base_port=$NODE_GALERAPORT_1;socket.ssl=yes;socket.ssl_ca=$MYSQL_TEST_DIR/std_data/cacert.pem;socket.ssl_cert=$MYSQL_TEST_DIR/std_data/server-new-cert.pem;socket.ssl_key=$MYSQL_TEST_DIR/std_data/server-new-key.pem;socket.ssl_cipher=AES256-SHA
63 --source include/start_mysqld.inc
64 --source include/wait_until_connected_again.inc
65
66 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
67 --source include/wait_condition.inc
68 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
69
70 # 5. Make sure node_2 is ready as well
71 --connection node_2
72 --source include/galera_wait_ready.inc
73
74 # Upgrade complete. Both nodes now use the new key and certificate
75
76 # Restore original auto_increment_offset values.
77 --source include/auto_increment_offset_restore.inc
78
79 --connection node_1
80 call mtr.add_suppression("WSREP: write_handler\\(\\)");
81 --connection node_2
82 call mtr.add_suppression("WSREP: write_handler\\(\\)");