Debian Codegraph @

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

raw
1
2 # Purpose : ssl fips mode support.
3 # Author : Yashwant Kumar sahu
4 #############################################################
5
6 # Want to skip this test from daily Valgrind execution
7 --source include/no_valgrind_without_big.inc
8 --source include/have_fips.inc
9
10 # Save the initial number of concurrent sessions
11 --source include/count_sessions.inc
12
13 --echo #
14 --echo # fips support.
15 --echo #
16
17 --disable_query_log
18 call mtr.add_suppression("Resizing redo log");
19 call mtr.add_suppression("Starting to delete and rewrite");
20 call mtr.add_suppression("New redo log files created");
21
22 --enable_query_log
23
24 # We let our server restart attempts write to the file $error_log.
25 let $error_log= $MYSQLTEST_VARDIR/log/my_restart.err;
26
27 perl;
28 my $filetodelete = "$ENV{'MYSQLTEST_VARDIR'}/log/my_restart.err";
29 while (-e $filetodelete) {
30 unlink $filetodelete;
31 sleep 1;
32 }
33 EOF
34
35 let $MYSQLD_DATADIR= `SELECT @@datadir`;
36 let $MYSQL_SOCKET= `SELECT @@socket`;
37 let $MYSQL_PORT= `SELECT @@port`;
38
39 --echo ##Test: Default server fips mode.
40 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "SHOW VARIABLES LIKE 'ssl_fips%';"
41 --echo MD5 digest:
42 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
43
44 --echo ##Test: Restart server and provide ssl-fips-mode at server startup:
45 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
46 --shutdown_server
47 --source include/wait_until_disconnected.inc
48 --exec echo "restart:--ssl-fips-mode=OFF" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
49 --enable_reconnect
50 --source include/wait_until_connected_again.inc
51 --echo Server fips mode:
52 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "SHOW VARIABLES LIKE 'ssl_fips%';"
53 --echo MD5 digest:
54 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
55
56 --echo ##Test: Restart server and provide ssl-fips-mode at server startup: ON
57 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
58 --shutdown_server
59 --source include/wait_until_disconnected.inc
60 --exec echo "restart:--ssl-fips-mode=ON" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
61 --enable_reconnect
62 --source include/wait_until_connected_again.inc
63 --echo Server fips mode:
64 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "SHOW VARIABLES LIKE 'ssl_fips%';"
65 --echo MD5 digest:
66 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
67
68 --echo ##Test: Restart server and provide ssl-fips-mode at server startup: ON with skip ssl
69 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
70 --shutdown_server
71 --source include/wait_until_disconnected.inc
72 --exec echo "restart:--ssl-fips-mode=ON --skip-ssl" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
73 --enable_reconnect
74 --source include/wait_until_connected_again.inc
75 --echo Server fips mode:
76 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "SHOW VARIABLES LIKE 'ssl_fips%';"
77 --echo MD5 digest:
78 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
79
80 --echo ##Test: Restart server and provide ssl-fips-mode at server startup: STRICT
81 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
82 --shutdown_server
83 --source include/wait_until_disconnected.inc
84 --exec echo "restart:--ssl-fips-mode=STRICT" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
85 --enable_reconnect
86 --source include/wait_until_connected_again.inc
87 --echo Server fips mode:
88 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "SHOW VARIABLES LIKE 'ssl_fips%';"
89 --echo MD5 digest:
90 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
91
92 --echo ##Test: Restart server and provide weak cipher CAMELLIA256-SHA
93 --echo client will only able to connect with only FIPS mode OFF
94 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
95 --shutdown_server
96 --source include/wait_until_disconnected.inc
97 --exec echo "restart:--ssl-cipher=CAMELLIA256-SHA" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
98 --enable_reconnect
99 --source include/wait_until_connected_again.inc
100 --exec $MYSQL --host=127.0.0.1 --ssl-cipher=CAMELLIA256-SHA -P $MASTER_MYPORT -e "SHOW VARIABLES LIKE 'ssl_fips%';"
101 --exec $MYSQL --host=127.0.0.1 --ssl-cipher=CAMELLIA256-SHA --ssl-fips-mode=OFF -P $MASTER_MYPORT -e "SHOW VARIABLES LIKE 'ssl_fips%';"
102 --error 1
103 --exec $MYSQL --host=127.0.0.1 --ssl-cipher=CAMELLIA256-SHA --ssl-fips-mode=ON -P $MASTER_MYPORT
104 --error 1
105 --exec $MYSQL --host=127.0.0.1 --ssl-cipher=CAMELLIA256-SHA --ssl-fips-mode=STRICT -P $MASTER_MYPORT
106 --exec $MYSQLADMIN --no-defaults --host=127.0.0.1 -P $MASTER_MYPORT --ssl-cipher=CAMELLIA256-SHA --ssl-fips-mode=OFF -u root ping 2>&1
107 --replace_regex /.*mysqladmin.*: connect/mysqladmin: connect/
108 --error 1
109 --exec $MYSQLADMIN --no-defaults --host=127.0.0.1 -P $MASTER_MYPORT --ssl-cipher=CAMELLIA256-SHA --ssl-fips-mode=ON -u root status 2>&1
110 --replace_regex /.*mysqladmin.*: connect/mysqladmin: connect/
111 --error 1
112 --exec $MYSQLADMIN --no-defaults --host=127.0.0.1 -P $MASTER_MYPORT --ssl-cipher=CAMELLIA256-SHA --ssl-fips-mode=STRICT -u root status 2>&1
113
114 --echo # restart server using restart default values
115 --echo Restart server.
116 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
117 --shutdown_server
118 --source include/wait_until_disconnected.inc
119 --exec echo "restart: " > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
120 --enable_reconnect
121 --source include/wait_until_connected_again.inc
122
123 --echo ##Test: MySQL client, Set fips mode: Default
124 --exec $MYSQL --ssl-mode=REQUIRED --host=127.0.0.1 -P $MASTER_MYPORT --ssl-fips-mode=OFF -e "SHOW VARIABLES LIKE 'ssl_fips%';"
125 --echo MD5 digest:
126 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
127
128 --echo ##Test: MySQL client, Set fips mode: OFF
129 --exec $MYSQL --ssl-mode=REQUIRED --host=127.0.0.1 -P $MASTER_MYPORT --ssl-fips-mode=OFF -e "SHOW VARIABLES LIKE 'ssl_fips%';"
130 --echo MD5 digest:
131 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
132
133 --echo ##Test: MySQL client, Set fips mode: ON
134 --exec $MYSQL --ssl-mode=REQUIRED --host=127.0.0.1 -P $MASTER_MYPORT --ssl-fips-mode=ON -e "SHOW VARIABLES LIKE 'ssl_fips%';"
135 --echo MD5 digest:
136 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
137
138 --echo ##Test: MySQL client, Set fips mode: STRICT
139 --exec $MYSQL --ssl-mode=REQUIRED --host=127.0.0.1 -P $MASTER_MYPORT --ssl-fips-mode=STRICT -e "SHOW VARIABLES LIKE 'ssl_fips%';"
140 --echo MD5 digest:
141 --exec $MYSQL --host=127.0.0.1 -P $MASTER_MYPORT -e "select md5(8);show warnings;"
142
143 --echo ##Test: MySQL client, Set fips mode: INVALID
144 --error 1
145 --exec $MYSQL --ssl-mode=REQUIRED --host=127.0.0.1 -P $MASTER_MYPORT --ssl-fips-mode=INVALID -e "SHOW VARIABLES LIKE 'ssl_fips%';"