Debian Codegraph @

mysql-test/suite/auth_sec/r/ssl_auto_detect.result

raw
1 # Global Setup
2 call mtr.add_suppression("Failed to initialize TLS for channel: mysql_main");
3 call mtr.add_suppression("Failed to setup SSL");
4 call mtr.add_suppression(".*SSL_CTX_set_default_verify_paths failed");
5 # Case 1 : Enable SSL automatically if ca.pem, server-cert.pem and
6 # sever-key.pem are present in data directory
7 # Copy SSL certificates before restarting.
8 # They should be picked up automatically by server.
9 # Restart completed.
10 # Search for : Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
11 Pattern "Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them." found
12 # Search for : CA certificate is self signed.;
13 Pattern "CA certificate .* is self signed." found
14 # Try to establish SSL connection : This must succeed.
15 SHOW STATUS LIKE 'Ssl_cipher';
16 Variable_name Value
17 Ssl_cipher SSL_CIPHER
18 SHOW VARIABLES LIKE 'have_ssl';
19 Variable_name Value
20 have_ssl YES
21 # Check values of ssl_ca, ssl_cert and ssl_key.
22 # They should refer to certificate/key files in data directory.
23 SHOW VARIABLES LIKE 'ssl_ca';
24 Variable_name Value
25 ssl_ca ca.pem
26 SHOW VARIABLES LIKE 'ssl_cert';
27 Variable_name Value
28 ssl_cert server-cert.pem
29 SHOW VARIABLES LIKE 'ssl_key';
30 Variable_name Value
31 ssl_key server-key.pem
32 # Connect using mysql client : This must succeed.
33 Variable_name Value
34 Ssl_cipher SSL_CIPHER
35 # Case 2 : Remove server-key.pem and observe that server starts
36 # without SSL capability
37 # Remove one of the certificates/keys.
38 # Restart completed.
39 # Check value of have_ssl. It must be DISABLED.
40 SHOW VARIABLES LIKE 'have_ssl';
41 Variable_name Value
42 have_ssl DISABLED
43 # Try creating SSL connection using mysql connection. It should fail.
44 #
45 # Bug#21108296 : --SSL-CIPHER OPTION CAUSES SSL INITIALIZATION FAILURE
46 #
47 # Restart completed.
48 # Search for : Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
49 Pattern "Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them." found
50 # Search for : CA certificate is self signed.;
51 Pattern "CA certificate .* is self signed." found
52 # Try creating SSL connection
53 Variable_name Value
54 Ssl_cipher SSL_CIPHER
55 # Global Cleanup
56 # restart: