Debian Codegraph @

mysql-test/suite/auth_sec/t/ssl_mode.test

raw
1
2 # Purpose : To check cases related to the client option -ssl-mode
3 # Author : Prabeen Pradhan
4 # Date : 29th Dec 2015
5 #############################################################
6
7 CREATE USER 'user1'@'%' require ssl;
8 grant all on *.* to 'user1'@'%' ;
9
10 --error 2
11 --exec $MYSQL_CHECK --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=DISABLED mysql user
12 --error 1
13 --exec $MYSQL_SHOW --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=DISABLED mysql user user
14 --error 1
15 --exec $MYSQL_SLAP --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=DISABLED --create-schema=mysql
16
17 # Verification of mysqlimport
18 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=REQUIRED -e "create table mysql.test(a int)"
19 --exec echo "" > $MYSQL_TMP_DIR/test.txt
20 --error 1
21 --exec $MYSQL_IMPORT --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=DISABLED --local mysql $MYSQL_TMP_DIR/test.txt
22
23 --echo # Testing of all clients with ssl mode PREFERRED
24 --exec $MYSQL_CHECK --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=PREFERRED mysql user
25 --exec $MYSQL_SHOW --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=PREFERRED mysql user user
26 --exec $MYSQL_SLAP --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=PREFERRED --create-schema=mysql > $MYSQL_TMP_DIR/mysql_slap_output.txt
27
28 # Verification of mysqlimport
29 --exec $MYSQL_IMPORT --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=PREFERRED --local mysql $MYSQL_TMP_DIR/test.txt
30
31 --echo # Testing of all clients with ssl mode REQUIRED
32 --exec $MYSQL_CHECK --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=REQUIRED mysql user
33 --exec $MYSQL_SHOW --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=REQUIRED mysql user user
34 --exec $MYSQL_SLAP --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=REQUIRED --create-schema=mysql > $MYSQL_TMP_DIR/mysql_slap_output.txt
35
36 # Verification of mysqlimport
37 --exec $MYSQL_IMPORT --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=REQUIRED --local mysql $MYSQL_TMP_DIR/test.txt
38
39
40 --echo # Testing of all clients with ssl mode VERIFY_CA
41 --exec $MYSQL_CHECK --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem mysql user
42 --exec $MYSQL_SHOW --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem mysql user user
43 --exec $MYSQL_SLAP --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --create-schema=mysql > $MYSQL_TMP_DIR/mysql_slap_output.txt
44
45 # Verification of mysqlimport
46 --exec $MYSQL_IMPORT --host=127.0.0.1 -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --local mysql $MYSQL_TMP_DIR/test.txt
47
48 --echo # Testing of all clients with ssl mode VERIFY_IDENTITY
49 --exec $MYSQL_CHECK --host=localhost -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_IDENTITY --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem mysql user
50 --exec $MYSQL_SHOW --host=localhost -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_IDENTITY --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem mysql user user
51 --exec $MYSQL_SLAP --host=localhost -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_IDENTITY --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --create-schema=mysql > $MYSQL_TMP_DIR/mysql_slap_output.txt
52
53 # Verification of mysqlimport
54 --exec $MYSQL_IMPORT --host=localhost -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_IDENTITY --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --local mysql $MYSQL_TMP_DIR/test.txt
55
56 --echo # Tests related to deprecation of ssl options
57 --error 2
58 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_IDENTITY --ssl --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
59
60 --error 2
61 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_IDENTITY --skip-ssl --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
62
63 --error 2
64 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=user1 --ssl-mode=VERIFY_IDENTITY --ssl-verify-server-cert --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
65
66 --echo # Tests related to invalid option of --ssl-mode
67 --error 1
68 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=user1 --ssl-mode=HelloWorld --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
69
70 --echo # Tests related to valid values of --ssl-mode
71 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=root --ssl-mode=DISABLED --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
72
73 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT --user=root --ssl-mode=PREFERRED --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
74
75 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=root --ssl-mode=REQUIRED --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
76
77 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=root --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
78
79 --error 1
80 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=root --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert1.pem --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
81
82 --error 1
83 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=root --ssl-mode=VERIFY_CA --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
84
85 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=root --ssl-mode=VERIFY_IDENTITY --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
86
87 --echo # Check behavior when --ssl-mode is not passed explicitly
88 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT --user=root --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
89
90 --echo # Check behavior when multiple times --ssl-mode is passed
91 --exec $MYSQL --host=localhost -P $MASTER_MYPORT --user=root --ssl-mode=REQUIRED --ssl-mode=DISABLEd --ssl-mode=REQUireD --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 -e "SHOW STATUS LIKE 'ssl_cipher'"
92
93 --echo # Check the legacy options
94 --error 7
95 exec $MYSQL --user=root --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 --ssl-mode=REQUIRED --ssl=0 -e "SHOW STATUS LIKE 'ssl_cipher'";
96 --error 7
97 exec $MYSQL --user=user1 --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 --ssl-mode=DISABLED --ssl=1 -e "SHOW STATUS LIKE 'ssl_cipher'";
98 --error 7
99 exec $MYSQL --user=user1 --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert1.pem --ssl=1 -e "SHOW STATUS LIKE 'ssl_cipher'";
100 --error 7
101 exec $MYSQL --user=user1 --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 --ssl-mode=REQUIRED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert1.pem --ssl-verify_server_cert=0 -e "SHOW STATUS LIKE 'ssl_cipher'";
102 --error 7
103 exec $MYSQL --user=root --tls_version=TLSv1.2 --ssl-cipher=ECDHE-RSA-AES128-GCM-SHA256 --ssl-mode=REQUIRED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert1.pem --ssl-verify_server_cert=1 -e "SHOW STATUS LIKE 'ssl_cipher'";
104
105 --echo # Cleanup
106 DROP USER 'user1'@'%';
107 DROP TABLE mysql.test;
108 --remove_file $MYSQL_TMP_DIR/mysql_slap_output.txt
109 --remove_file $MYSQL_TMP_DIR/test.txt