Debian Codegraph @

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

raw
1 -- echo #
2 -- echo # Bug#21087159 : AUTO-GENERATED SSL CERTS HAVE NO CN
3 -- echo #
4
5 --echo # Setup
6
7 call mtr.add_suppression("Failed to setup SSL");
8 call mtr.add_suppression("SSL error: SSL_CTX_set_default_verify_paths failed");
9 # We let our server restart attempts write to the file $server_log.
10 let server_log= $MYSQLTEST_VARDIR/log/openssl_cert_generation_subject;
11 let X509_SUBJECT_LOG= $MYSQLTEST_VARDIR/log/x509_subjects.log;
12
13 --echo # Stop the server and cleanup all .pem files.
14 let $restart_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect;
15 --exec echo "wait" > $restart_file
16 --shutdown_server
17 --source include/wait_until_disconnected.inc
18
19 --error 0, 1
20 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/ca.pem
21 --error 0, 1
22 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/ca-key.pem
23 --error 0, 1
24 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/server-cert.pem
25 --error 0, 1
26 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/server-key.pem
27 --error 0, 1
28 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/client-cert.pem
29 --error 0, 1
30 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/client-key.pem
31 --error 0, 1
32 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/private_key.pem
33 --error 0, 1
34 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/public_key.pem
35 --error 0, 1
36 --remove_file $X509_SUBJECT_LOG
37
38 --echo # Restart server with --auto_generate_certs
39 --exec echo "restart:--log-error=$server_log --auto_generate_certs --skip-sha256_password_auto_generate_rsa_keys" > $restart_file
40 --enable_reconnect
41 --source include/wait_until_connected_again.inc
42 --disable_reconnect
43 --echo # Restart completed.
44
45 # Fetch subjects from X509 certificates
46 --exec $OPENSSL_EXECUTABLE x509 -in $MYSQLTEST_VARDIR/mysqld.1/data/ca.pem -noout -subject > $X509_SUBJECT_LOG
47 --exec $OPENSSL_EXECUTABLE x509 -in $MYSQLTEST_VARDIR/mysqld.1/data/server-cert.pem -noout -subject >> $X509_SUBJECT_LOG
48 --exec $OPENSSL_EXECUTABLE x509 -in $MYSQLTEST_VARDIR/mysqld.1/data/client-cert.pem -noout -subject >> $X509_SUBJECT_LOG
49
50 perl;
51 use strict;
52 my $search_file= $ENV{'X509_SUBJECT_LOG'};
53 my $ca_subject_pattern= "MySQL_Server_.*Auto_Generated_CA_Certificate";
54 my $server_subject_pattern= "MySQL_Server_.*Auto_Generated_Server_Certificate";
55 my $client_subject_pattern= "MySQL_Server_.*Auto_Generated_Client_Certificate";
56 my $content="";
57 open(FILE, "$search_file") or die("Unable to open '$search_file' : $!\n");
58 read(FILE, $content, 256, 0);
59 close(FILE);
60
61 if ( ($content =~ m{$ca_subject_pattern}) &&
62 ($content =~ m{$server_subject_pattern}) &&
63 ($content =~ m{$client_subject_pattern}) ) {
64 print "Auto generated certificates have valid CNs with pattern _Auto_Generated_<cert_type>_Certificate as certificate subject\n";
65 }
66 else {
67 print "One or more auto generated certificate does not contain valid CN.";
68 }
69 EOF
70
71 --echo # cleanup
72
73 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/ca.pem
74 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/ca-key.pem
75 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/server-cert.pem
76 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/server-key.pem
77 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/client-cert.pem
78 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/client-key.pem
79 --remove_file $X509_SUBJECT_LOG
80
81 # Restore default settings in opt file and clean up
82 --let $restart_parameters = restart:
83 --source include/restart_mysqld.inc