Skip to content

Commit efa8bd1

Browse files
gkodinovgkodinov
committed
Bug #14006448: SSL_CRL AND SSL_CRL_CLRPATH ARE NOT RUN FOR YASSL AND DOES NOT
WORK FOR OPENSSL Regenerated the test cryptography files. Renamed mysql-client-valid-[cert|key].pem to mysql-client-[cert|key].pem Renamed mysql-client-[cert|key].pem to mysql-client-invalid-[cert|key].pem Added an instruction on how to regenerate the cryptography files if needed.
1 parent fbfeb73 commit efa8bd1

18 files changed

+272
-163
lines changed

‎mysql-test/r/ssl_crl_clients_valid.result‎

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -6,11 +6,12 @@ have_openssl YES
66
have_ssl YES
77
ssl_ca MYSQL_TEST_DIR/std_data/crl-ca-cert.pem
88
ssl_capath
9-
ssl_cert MYSQL_TEST_DIR/std_data/crl-client-valid-cert.pem
9+
ssl_cert MYSQL_TEST_DIR/std_data/crl-client-cert.pem
1010
ssl_cipher
1111
ssl_crl MYSQL_TEST_DIR/std_data/crl-client-revoked.crl
1212
ssl_crlpath
13-
ssl_key MYSQL_TEST_DIR/std_data/crl-client-valid-key.pem
13+
ssl_key MYSQL_TEST_DIR/std_data/crl-client-key.pem
1414
############ Test mysqladmin ##############
1515
# Test mysqladmin connecting to a server with an empty crl
16+
Warning: Using a password on the command line interface can be insecure.
1617
mysqld is alive

mysql-test/r/ssl_crl_clrpath.result renamed to mysql-test/r/ssl_crl_crlpath.result

File renamed without changes.

‎mysql-test/std_data/crl-ca-cert.pem‎

Lines changed: 34 additions & 34 deletions
Original file line numberDiff line numberDiff line change
@@ -2,62 +2,62 @@ Certificate:
22
Data:
33
Version: 3 (0x2)
44
Serial Number:
5-
a5:85:ec:60:b1:68:44:22
5+
f9:e2:f3:98:0e:2b:05:7c
66
Signature Algorithm: sha1WithRSAEncryption
77
Issuer: C=BG, ST=Plovdiv, O=Oracle, OU=MySQL, CN=MySQL CRL test CA certificate
88
Validity
9-
Not Before: Jun 17 07:27:51 2011 GMT
10-
Not After : Jun 15 07:27:51 2016 GMT
9+
Not Before: May 17 15:08:00 2012 GMT
10+
Not After : May 10 15:08:00 2042 GMT
1111
Subject: C=BG, ST=Plovdiv, O=Oracle, OU=MySQL, CN=MySQL CRL test CA certificate
1212
Subject Public Key Info:
1313
Public Key Algorithm: rsaEncryption
1414
RSA Public Key: (1024 bit)
1515
Modulus (1024 bit):
16-
00:9b:08:0b:96:19:57:fb:21:79:f4:16:c9:b8:2c:
17-
13:2e:e1:fe:5f:6b:18:7d:d4:c4:d7:cd:66:a6:62:
18-
0e:b7:28:b1:39:76:62:6e:5a:4a:80:f6:0e:8e:84:
19-
3e:cf:2f:91:0d:36:6d:8b:b5:f9:78:96:f0:5f:82:
20-
a2:b2:d8:fc:b3:46:b5:30:24:b3:a8:77:60:6c:05:
21-
c9:8f:82:fd:ad:9f:26:23:29:56:5b:02:6f:f2:00:
22-
31:86:60:b7:8c:56:b3:95:a8:8d:a9:bb:6b:91:fd:
23-
5d:f5:6a:21:45:85:63:78:0e:0f:0e:03:6d:53:73:
24-
0d:6c:aa:5b:f9:fc:fa:fd:f7
16+
00:ed:ec:45:e0:22:d7:d0:d5:91:87:74:5f:ee:17:
17+
b5:c7:07:c2:4b:b3:e7:13:93:46:95:1f:5d:09:54:
18+
14:98:40:3d:0e:e6:14:5c:5e:39:c5:75:87:4e:73:
19+
24:62:d9:85:4a:69:c4:35:7d:6b:76:6c:1c:8e:56:
20+
a8:fe:9e:fe:22:ae:c9:41:14:67:d4:11:37:8d:d3:
21+
18:02:9d:8a:36:64:b1:8b:2f:a0:ba:2d:d5:fd:c0:
22+
cd:6a:7d:a5:c0:6b:6b:60:64:2f:24:45:bb:a8:ad:
23+
1c:95:a0:d5:40:79:28:5f:b1:17:97:63:a1:d5:1e:
24+
42:d4:10:70:5d:8f:2e:34:45
2525
Exponent: 65537 (0x10001)
2626
X509v3 extensions:
2727
X509v3 Subject Key Identifier:
28-
C4:1D:2C:68:3F:5F:29:51:EC:C5:54:61:CE:16:13:D2:72:5D:63:E8
28+
85:AB:E6:A7:57:88:7D:8D:BE:EB:64:53:73:94:64:CD:4B:8D:29:12
2929
X509v3 Authority Key Identifier:
30-
keyid:C4:1D:2C:68:3F:5F:29:51:EC:C5:54:61:CE:16:13:D2:72:5D:63:E8
30+
keyid:85:AB:E6:A7:57:88:7D:8D:BE:EB:64:53:73:94:64:CD:4B:8D:29:12
3131
DirName:/C=BG/ST=Plovdiv/O=Oracle/OU=MySQL/CN=MySQL CRL test CA certificate
32-
serial:A5:85:EC:60:B1:68:44:22
32+
serial:F9:E2:F3:98:0E:2B:05:7C
3333

3434
X509v3 Basic Constraints:
3535
CA:TRUE
3636
Signature Algorithm: sha1WithRSAEncryption
37-
73:dd:2e:76:71:25:c2:fe:7a:c5:46:ca:f2:c7:a0:43:f0:c7:
38-
3c:24:8d:a6:bd:8d:f2:7c:db:03:1b:2b:8a:c8:23:ae:ef:71:
39-
25:33:5b:10:61:e7:7d:89:30:a8:67:25:2e:e0:06:30:77:da:
40-
b8:87:e5:91:cd:c7:8f:c9:7b:3d:9e:86:80:44:02:6b:d1:06:
41-
85:5d:28:78:cc:a7:a8:35:ac:f7:77:6d:e2:c7:a3:37:bc:9f:
42-
d3:bf:4a:ca:09:dc:d0:78:0c:59:c7:db:4b:67:f1:09:6d:a9:
43-
7a:50:2f:1d:2c:a6:b8:81:0e:e6:4b:ee:d9:be:ae:a5:6a:d7:
44-
56:c4
37+
90:f7:9b:56:14:df:c4:db:46:a4:67:f5:83:68:e9:70:45:4c:
38+
5d:97:07:06:fd:2c:68:0b:9a:ed:6d:7a:d1:18:be:b8:dd:08:
39+
bc:ff:10:5b:d9:b2:50:1f:98:b0:5d:be:6d:0b:88:bb:30:93:
40+
fa:04:34:f1:3b:f6:56:d5:86:bb:1c:31:f3:7f:7b:38:0b:d1:
41+
f9:fd:87:b5:c4:63:a0:b8:46:59:95:a8:b5:ec:4f:d0:ad:df:
42+
42:ed:74:4f:2f:fd:7c:65:aa:d7:60:d1:70:55:41:8b:0b:c2:
43+
3b:f1:f3:2f:6b:a5:d9:48:b1:2d:84:e9:07:63:92:f0:36:04:
44+
cf:5d
4545
-----BEGIN CERTIFICATE-----
46-
MIIDHDCCAoWgAwIBAgIJAKWF7GCxaEQiMA0GCSqGSIb3DQEBBQUAMGgxCzAJBgNV
46+
MIIDHDCCAoWgAwIBAgIJAPni85gOKwV8MA0GCSqGSIb3DQEBBQUAMGgxCzAJBgNV
4747
BAYTAkJHMRAwDgYDVQQIEwdQbG92ZGl2MQ8wDQYDVQQKEwZPcmFjbGUxDjAMBgNV
4848
BAsTBU15U1FMMSYwJAYDVQQDEx1NeVNRTCBDUkwgdGVzdCBDQSBjZXJ0aWZpY2F0
49-
ZTAeFw0xMTA2MTcwNzI3NTFaFw0xNjA2MTUwNzI3NTFaMGgxCzAJBgNVBAYTAkJH
49+
ZTAeFw0xMjA1MTcxNTA4MDBaFw00MjA1MTAxNTA4MDBaMGgxCzAJBgNVBAYTAkJH
5050
MRAwDgYDVQQIEwdQbG92ZGl2MQ8wDQYDVQQKEwZPcmFjbGUxDjAMBgNVBAsTBU15
5151
U1FMMSYwJAYDVQQDEx1NeVNRTCBDUkwgdGVzdCBDQSBjZXJ0aWZpY2F0ZTCBnzAN
52-
BgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAmwgLlhlX+yF59BbJuCwTLuH+X2sYfdTE
53-
181mpmIOtyixOXZiblpKgPYOjoQ+zy+RDTZti7X5eJbwX4Kistj8s0a1MCSzqHdg
54-
bAXJj4L9rZ8mIylWWwJv8gAxhmC3jFazlaiNqbtrkf1d9WohRYVjeA4PDgNtU3MN
55-
bKpb+fz6/fcCAwEAAaOBzTCByjAdBgNVHQ4EFgQUxB0saD9fKVHsxVRhzhYT0nJd
56-
Y+gwgZoGA1UdIwSBkjCBj4AUxB0saD9fKVHsxVRhzhYT0nJdY+ihbKRqMGgxCzAJ
52+
BgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA7exF4CLX0NWRh3Rf7he1xwfCS7PnE5NG
53+
lR9dCVQUmEA9DuYUXF45xXWHTnMkYtmFSmnENX1rdmwcjlao/p7+Iq7JQRRn1BE3
54+
jdMYAp2KNmSxiy+gui3V/cDNan2lwGtrYGQvJEW7qK0claDVQHkoX7EXl2Oh1R5C
55+
1BBwXY8uNEUCAwEAAaOBzTCByjAdBgNVHQ4EFgQUhavmp1eIfY2+62RTc5RkzUuN
56+
KRIwgZoGA1UdIwSBkjCBj4AUhavmp1eIfY2+62RTc5RkzUuNKRKhbKRqMGgxCzAJ
5757
BgNVBAYTAkJHMRAwDgYDVQQIEwdQbG92ZGl2MQ8wDQYDVQQKEwZPcmFjbGUxDjAM
5858
BgNVBAsTBU15U1FMMSYwJAYDVQQDEx1NeVNRTCBDUkwgdGVzdCBDQSBjZXJ0aWZp
59-
Y2F0ZYIJAKWF7GCxaEQiMAwGA1UdEwQFMAMBAf8wDQYJKoZIhvcNAQEFBQADgYEA
60-
c90udnElwv56xUbK8segQ/DHPCSNpr2N8nzbAxsrisgjru9xJTNbEGHnfYkwqGcl
61-
LuAGMHfauIflkc3Hj8l7PZ6GgEQCa9EGhV0oeMynqDWs93dt4sejN7yf079Kygnc
62-
0HgMWcfbS2fxCW2pelAvHSymuIEO5kvu2b6upWrXVsQ=
59+
Y2F0ZYIJAPni85gOKwV8MAwGA1UdEwQFMAMBAf8wDQYJKoZIhvcNAQEFBQADgYEA
60+
kPebVhTfxNtGpGf1g2jpcEVMXZcHBv0saAua7W160Ri+uN0IvP8QW9myUB+YsF2+
61+
bQuIuzCT+gQ08Tv2VtWGuxwx8397OAvR+f2HtcRjoLhGWZWotexP0K3fQu10Ty/9
62+
fGWq12DRcFVBiwvCO/HzL2ul2UixLYTpB2OS8DYEz10=
6363
-----END CERTIFICATE-----

‎mysql-test/std_data/crl-certificate-readme.txt‎

Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,31 @@
1+
These are the instructions on how to generate test files for the CRL tests
2+
using openSSL.
3+
4+
1. Make sure you have the right validity periods in CA.pl and openssl.cnf
5+
2. Create a new certification authority : CA.pl -newca
6+
3. Copy demoCA/cacert.pem to crl-ca-cert.pem
7+
4. Create one server certificate request : CA.pl -newreq
8+
5. Sign the server certificate request : CA.pl -signreq
9+
6. Copy demoCA/newcert.pem to crl-server-cert.pem
10+
7. Remove the key from server's certificate key while copying it :
11+
openssl rsa -in newkey.pem -out crl-server-key.pem
12+
8. Create one client certificate request : CA.pl -newreq
13+
9. Sign the client certificate request : CA.pl -signreq
14+
10. Copy demoCA/newcert.pem to crl-client-cert.pem
15+
11. Remove the key from client's certificate key while copying it :
16+
openssl rsa -in newkey.pem -out crl-client-key.pem
17+
12. Create one to-be-revoked client certificate request : CA.pl -newreq
18+
13. Sign the to-be-revoked client certificate request : CA.pl -signreq
19+
14. Copy demoCA/newcert.pem to crl-client-invalid-cert.pem
20+
15. Remove the key from the to-be-revoked client's certificate
21+
key while copying it :
22+
openssl rsa -in newkey.pem -out crl-client-invalid-key.pem
23+
16. Revoke the crl-client-invalid-cert.pem :
24+
openssl ca -revoke crl-client-invalid-key.pem
25+
17. Generate a CRL file :
26+
openssl ca -gencrl -crldays=3650 -out crl-client-revoked.crl
27+
18. Clean up all the files in the crldir directory
28+
19. Copy the CA certificate into it :
29+
cp crl-ca-cert.pem `openssl -in crl-ca-cert.pem -noout -hash`.0
30+
20. Copy the CRL file into it :
31+
cp crl-client-revoked.crl `openssl -in crl-ca-cert.pem -noout -hash`.r0

‎mysql-test/std_data/crl-client-cert.pem‎

Lines changed: 37 additions & 37 deletions
Original file line numberDiff line numberDiff line change
@@ -2,61 +2,61 @@ Certificate:
22
Data:
33
Version: 3 (0x2)
44
Serial Number:
5-
a5:85:ec:60:b1:68:44:24
5+
f9:e2:f3:98:0e:2b:05:7e
66
Signature Algorithm: sha1WithRSAEncryption
77
Issuer: C=BG, ST=Plovdiv, O=Oracle, OU=MySQL, CN=MySQL CRL test CA certificate
88
Validity
9-
Not Before: Jun 17 07:32:32 2011 GMT
10-
Not After : Jun 16 07:32:32 2014 GMT
11-
Subject: C=BG, ST=Plovdiv, L=Plovdiv, O=Oracle, OU=MySQL, CN=MySQL CRL test client certificate
9+
Not Before: May 17 15:18:14 2012 GMT
10+
Not After : May 15 15:18:14 2022 GMT
11+
Subject: C=BG, ST=Plovdiv, O=Oracle, OU=MySQL, CN=MySQL CRL test client certificate
1212
Subject Public Key Info:
1313
Public Key Algorithm: rsaEncryption
1414
RSA Public Key: (1024 bit)
1515
Modulus (1024 bit):
16-
00:bd:18:bf:c5:37:7e:f7:8a:1d:22:c0:4f:5a:70:
17-
51:ea:df:56:4f:29:e9:c7:a5:8a:ab:5a:48:b5:f9:
18-
bf:cd:2a:73:f8:fa:13:20:fd:33:17:11:93:51:f0:
19-
4f:fa:a5:6a:bc:37:94:92:de:7d:c1:09:c6:43:c0:
20-
f7:cd:dd:ac:06:bf:fe:0c:9f:fc:ec:5b:83:a1:1e:
21-
34:d8:af:50:17:4d:84:51:20:44:76:81:d1:12:76:
22-
06:fb:05:29:59:47:0f:9d:97:f1:41:2f:92:0d:e4:
23-
b6:c1:fb:cf:75:95:a9:0f:cf:b3:4f:69:a3:d1:14:
24-
e9:6b:cf:be:53:bd:4e:3f:5d
16+
00:d8:03:97:99:2f:54:86:ec:b5:79:4f:8f:ff:bb:
17+
b8:23:e0:9b:d3:d4:ba:40:2e:34:dd:ad:8c:2c:43:
18+
f9:7b:d5:4f:5c:ef:47:bd:e3:b2:ac:76:ea:b2:d5:
19+
97:dc:99:4e:fa:d8:13:48:a2:cb:ee:3f:40:7a:fe:
20+
af:f1:d8:cd:c8:5b:1f:f7:7c:a4:7f:cf:fe:02:91:
21+
e6:d8:39:ef:e8:4f:a8:ff:b6:78:29:78:72:24:a4:
22+
f0:e4:67:8a:41:50:5e:9d:6b:a8:4f:06:f2:b4:8e:
23+
22:f9:05:e6:31:03:f9:1b:a8:29:16:6d:7c:5d:bd:
24+
60:81:ac:6e:9c:63:5b:a4:41
2525
Exponent: 65537 (0x10001)
2626
X509v3 extensions:
2727
X509v3 Basic Constraints:
2828
CA:FALSE
2929
Netscape Comment:
3030
OpenSSL Generated Certificate
3131
X509v3 Subject Key Identifier:
32-
39:37:9C:0B:9F:E4:8E:48:48:71:23:2B:CA:F0:C1:F9:0B:F2:0A:D0
32+
7A:9B:4D:5A:CD:9A:CB:14:B2:A5:D3:B0:89:24:6E:BC:8E:1E:99:1D
3333
X509v3 Authority Key Identifier:
34-
keyid:C4:1D:2C:68:3F:5F:29:51:EC:C5:54:61:CE:16:13:D2:72:5D:63:E8
34+
keyid:85:AB:E6:A7:57:88:7D:8D:BE:EB:64:53:73:94:64:CD:4B:8D:29:12
3535

3636
Signature Algorithm: sha1WithRSAEncryption
37-
18:03:42:13:af:86:c3:eb:9c:40:4a:d8:9e:e7:25:e1:43:7b:
38-
2f:55:1b:e6:ec:bf:9b:56:b3:c7:cb:78:cd:d2:00:46:39:96:
39-
d8:f8:cd:9d:0e:e7:97:51:93:f8:5b:ed:4f:5a:16:6b:56:fb:
40-
c0:d1:58:3c:7f:e9:64:aa:11:03:ff:3b:5e:9d:6d:c8:53:a8:
41-
4a:30:f7:a6:ae:7c:e0:ed:16:c4:a0:07:9c:75:1a:23:58:13:
42-
70:9e:aa:cc:b8:1d:70:26:85:ad:e1:f3:34:83:1b:e0:72:44:
43-
c4:28:d5:c5:6a:43:83:47:fe:8b:ab:ac:07:55:ff:2c:d9:0f:
44-
5f:c7
37+
ba:04:f4:20:39:e3:94:2b:5b:a4:18:2b:8a:0b:12:bd:58:7d:
38+
0b:0c:cd:ab:b2:7c:7a:57:2f:8b:31:06:ce:6d:26:7c:50:5c:
39+
74:fd:3c:21:8c:20:04:ef:55:e9:2a:fe:f5:35:2d:86:d0:1c:
40+
9f:05:96:91:9e:2f:74:a7:50:db:55:dd:ba:ff:8a:9b:ce:50:
41+
03:5d:e1:10:5b:a3:4b:d5:46:73:6f:52:e8:e5:0c:b6:23:7a:
42+
22:1e:30:86:9f:34:d2:3e:66:2c:dc:b6:96:0d:ee:21:59:5c:
43+
17:50:23:a5:9a:2d:37:d8:ef:85:23:c0:e8:84:14:df:95:35:
44+
1a:18
4545
-----BEGIN CERTIFICATE-----
46-
MIIC3zCCAkigAwIBAgIJAKWF7GCxaEQkMA0GCSqGSIb3DQEBBQUAMGgxCzAJBgNV
46+
MIICzTCCAjagAwIBAgIJAPni85gOKwV+MA0GCSqGSIb3DQEBBQUAMGgxCzAJBgNV
4747
BAYTAkJHMRAwDgYDVQQIEwdQbG92ZGl2MQ8wDQYDVQQKEwZPcmFjbGUxDjAMBgNV
4848
BAsTBU15U1FMMSYwJAYDVQQDEx1NeVNRTCBDUkwgdGVzdCBDQSBjZXJ0aWZpY2F0
49-
ZTAeFw0xMTA2MTcwNzMyMzJaFw0xNDA2MTYwNzMyMzJaMH4xCzAJBgNVBAYTAkJH
50-
MRAwDgYDVQQIEwdQbG92ZGl2MRAwDgYDVQQHEwdQbG92ZGl2MQ8wDQYDVQQKEwZP
51-
cmFjbGUxDjAMBgNVBAsTBU15U1FMMSowKAYDVQQDEyFNeVNRTCBDUkwgdGVzdCBj
52-
bGllbnQgY2VydGlmaWNhdGUwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAL0Y
53-
v8U3fveKHSLAT1pwUerfVk8p6celiqtaSLX5v80qc/j6EyD9MxcRk1HwT/qlarw3
54-
lJLefcEJxkPA983drAa//gyf/Oxbg6EeNNivUBdNhFEgRHaB0RJ2BvsFKVlHD52X
55-
8UEvkg3ktsH7z3WVqQ/Ps09po9EU6WvPvlO9Tj9dAgMBAAGjezB5MAkGA1UdEwQC
56-
MAAwLAYJYIZIAYb4QgENBB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmljYXRl
57-
MB0GA1UdDgQWBBQ5N5wLn+SOSEhxIyvK8MH5C/IK0DAfBgNVHSMEGDAWgBTEHSxo
58-
P18pUezFVGHOFhPScl1j6DANBgkqhkiG9w0BAQUFAAOBgQAYA0ITr4bD65xAStie
59-
5yXhQ3svVRvm7L+bVrPHy3jN0gBGOZbY+M2dDueXUZP4W+1PWhZrVvvA0Vg8f+lk
60-
qhED/ztenW3IU6hKMPemrnzg7RbEoAecdRojWBNwnqrMuB1wJoWt4fM0gxvgckTE
61-
KNXFakODR/6Lq6wHVf8s2Q9fxw==
49+
ZTAeFw0xMjA1MTcxNTE4MTRaFw0yMjA1MTUxNTE4MTRaMGwxCzAJBgNVBAYTAkJH
50+
MRAwDgYDVQQIEwdQbG92ZGl2MQ8wDQYDVQQKEwZPcmFjbGUxDjAMBgNVBAsTBU15
51+
U1FMMSowKAYDVQQDEyFNeVNRTCBDUkwgdGVzdCBjbGllbnQgY2VydGlmaWNhdGUw
52+
gZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANgDl5kvVIbstXlPj/+7uCPgm9PU
53+
ukAuNN2tjCxD+XvVT1zvR73jsqx26rLVl9yZTvrYE0iiy+4/QHr+r/HYzchbH/d8
54+
pH/P/gKR5tg57+hPqP+2eCl4ciSk8ORnikFQXp1rqE8G8rSOIvkF5jED+RuoKRZt
55+
fF29YIGsbpxjW6RBAgMBAAGjezB5MAkGA1UdEwQCMAAwLAYJYIZIAYb4QgENBB8W
56+
HU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmljYXRlMB0GA1UdDgQWBBR6m01azZrL
57+
FLKl07CJJG68jh6ZHTAfBgNVHSMEGDAWgBSFq+anV4h9jb7rZFNzlGTNS40pEjAN
58+
BgkqhkiG9w0BAQUFAAOBgQC6BPQgOeOUK1ukGCuKCxK9WH0LDM2rsnx6Vy+LMQbO
59+
bSZ8UFx0/TwhjCAE71XpKv71NS2G0ByfBZaRni90p1DbVd26/4qbzlADXeEQW6NL
60+
1UZzb1Lo5Qy2I3oiHjCGnzTSPmYs3LaWDe4hWVwXUCOlmi032O+FI8DohBTflTUa
61+
GA==
6262
-----END CERTIFICATE-----

‎mysql-test/std_data/crl-client-key.pem‎

Lines changed: 13 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -1,15 +1,15 @@
11
-----BEGIN RSA PRIVATE KEY-----
2-
MIICXAIBAAKBgQC9GL/FN373ih0iwE9acFHq31ZPKenHpYqrWki1+b/NKnP4+hMg
3-
/TMXEZNR8E/6pWq8N5SS3n3BCcZDwPfN3awGv/4Mn/zsW4OhHjTYr1AXTYRRIER2
4-
gdESdgb7BSlZRw+dl/FBL5IN5LbB+891lakPz7NPaaPRFOlrz75TvU4/XQIDAQAB
5-
AoGAYMe37rIWk47mlpCijIEMDA++Vsn20q2RKV4N9MUcO19M99LV036DlXzzT26V
6-
II1k8Wvo6Lpi1lewV6D9symPDwuxO3L/lSwInVSbAaCkRYq7BlpL+ShxsUpWT788
7-
ealwFTj3TeM1MCHpFwvO0xGBqFVk+ZadCNZjvwdQi44JCykCQQDqJgOTPPniq5Lk
8-
J6d+KWiCPVAEnEWk5lR0jQ2NZhSm4fFmCd0v6bNYhztk7dizSOiIrXnPLXx9Z8v0
9-
rwKr5WrHAkEAzr5ps9d/t4V60vAJCK+Sq1b+Qj42yEnH2eIjKAUFO63jkPtpOv9h
10-
nzYJTqajvEkHbYJ92elpzGx47FuSOjzAuwJAYpZC5xnDdSccoCf6I+q3cC70pBxQ
11-
TpAUe0ZwsFqM039KrtX0ZZoWw22dGm/yz/ogvnucUBks03iCrbGKhGoCPQJAdlhj
12-
U5I5Rsl+vH6w/Srbz37Vvv+0BkTNxPiA3Wi6TSZGDPkNjLshm6yn+UDEm4RGXzaC
13-
ahoF+QHi2pG0i+e4/wJBAOmbrYbjE2LAzIBy0NvRHslPABTK4zn1L9lzU5XIjV9r
14-
y8JiMfGNC5r7To/ERlFUlMbaPA5Zm9XNrZhDROMZLTc=
2+
MIICXQIBAAKBgQDYA5eZL1SG7LV5T4//u7gj4JvT1LpALjTdrYwsQ/l71U9c70e9
3+
47Ksduqy1ZfcmU762BNIosvuP0B6/q/x2M3IWx/3fKR/z/4CkebYOe/oT6j/tngp
4+
eHIkpPDkZ4pBUF6da6hPBvK0jiL5BeYxA/kbqCkWbXxdvWCBrG6cY1ukQQIDAQAB
5+
AoGBAL2RAXQcFhjGGEfaa6toaKOLlBSk5cI3CovTpmSeTo2+14PeNN5OuVkijrrc
6+
OQYNwELgZqPiwgZVmdeWNH+P3J2vo+QqfxskondSDM2ZDedvO8tc4W74oSQzsASr
7+
37ptEJlAdumzQ1XPxGwZi6E2KPzmTBQ4Q0j50UB2vagbR2cxAkEA7C3dVMyNYLew
8+
ycujuU7F4SQcYFY5/BMj6yanovBF80FRT2X+mxj3lSZux/tjZFvxeb9Q5vmJJRp6
9+
PUP/ROQVVQJBAOokfqS6jrvvNvqYZnMb54iDTP7Jx+EJyBJxYtJM53WC3NXarCQq
10+
EWyVD1KxJxxW1gfcmJbhVQYeUsictO24Uz0CQGEtxgJcYFfJfW6q4eUfqoAm8Z4a
11+
HKXB4mehchyzLLUYzTIUT5zVuxmdxLt4jr7+re9gbxN63ZlsuZt33RMlnjkCQGbF
12+
igkIEeqPv1QTXLSdxOz4pO0Y6HDweC8QMc4ZD2dW/1Om3fQpuugsLUOgmogn3V4q
13+
B5gCY+2BldiUYB4P0AkCQQDDkyhWJQvtXSLGFkfUBZ6PCzVfO+Pkb7tISQuDGT4J
14+
HY+UpnQBbe6WP2hGXzwaGw9rVYaA9IcvX8pOpWsCDk80
1515
-----END RSA PRIVATE KEY-----

‎mysql-test/std_data/crl-client-revoked-cert.pem‎

Lines changed: 62 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,62 @@
1+
Certificate:
2+
Data:
3+
Version: 3 (0x2)
4+
Serial Number:
5+
f9:e2:f3:98:0e:2b:05:7f
6+
Signature Algorithm: sha1WithRSAEncryption
7+
Issuer: C=BG, ST=Plovdiv, O=Oracle, OU=MySQL, CN=MySQL CRL test CA certificate
8+
Validity
9+
Not Before: May 17 15:21:12 2012 GMT
10+
Not After : May 15 15:21:12 2022 GMT
11+
Subject: C=BG, ST=Plovdiv, O=Oracle, OU=MySQL, CN=MySQL CRL test client certificate revoked
12+
Subject Public Key Info:
13+
Public Key Algorithm: rsaEncryption
14+
RSA Public Key: (1024 bit)
15+
Modulus (1024 bit):
16+
00:a5:dd:99:d5:fd:3a:9c:06:f4:2e:1a:e0:52:1b:
17+
f6:24:ca:e8:07:41:38:a6:9c:5f:84:5a:07:43:9e:
18+
de:91:37:6d:40:44:cd:8e:48:a2:b8:c4:39:75:41:
19+
d6:aa:97:26:01:37:76:7b:02:45:18:78:e1:1e:56:
20+
5d:f8:5d:e0:cc:a4:c4:bd:0d:1b:40:6e:00:4e:e0:
21+
ba:06:61:9f:81:f2:29:ae:db:31:b2:8f:26:2e:32:
22+
c5:74:b2:09:5f:76:a8:4a:5e:b4:f1:44:59:7e:3d:
23+
2a:9c:aa:b0:71:a4:2e:70:3b:8c:f2:93:2f:87:c1:
24+
a6:87:e6:6b:7c:1f:a5:f5:6b
25+
Exponent: 65537 (0x10001)
26+
X509v3 extensions:
27+
X509v3 Basic Constraints:
28+
CA:FALSE
29+
Netscape Comment:
30+
OpenSSL Generated Certificate
31+
X509v3 Subject Key Identifier:
32+
20:75:FB:E7:F0:11:4F:64:48:C6:F9:85:7C:1E:3A:C7:F0:16:8F:51
33+
X509v3 Authority Key Identifier:
34+
keyid:85:AB:E6:A7:57:88:7D:8D:BE:EB:64:53:73:94:64:CD:4B:8D:29:12
35+
36+
Signature Algorithm: sha1WithRSAEncryption
37+
d9:23:63:c2:da:d4:4a:53:85:c2:87:ab:e5:a4:7b:ea:cb:8a:
38+
0e:6e:6c:ef:a7:a3:e2:ff:29:9e:af:d0:24:08:40:44:0e:0c:
39+
91:5c:5e:38:25:c9:1b:c5:55:b1:17:01:12:57:60:5b:78:f5:
40+
e3:3c:47:e0:df:10:11:38:f6:18:ce:37:5f:ec:c6:a9:95:39:
41+
db:36:5d:78:12:9a:57:f8:bc:4d:cd:e5:e9:77:85:71:72:d1:
42+
66:99:0c:35:51:8a:3d:61:cf:0f:21:5e:e1:cb:4b:33:f7:68:
43+
8c:d2:fc:ca:a5:44:a7:d6:d3:76:9a:60:fb:0b:17:97:ee:3a:
44+
23:22
45+
-----BEGIN CERTIFICATE-----
46+
MIIC1TCCAj6gAwIBAgIJAPni85gOKwV/MA0GCSqGSIb3DQEBBQUAMGgxCzAJBgNV
47+
BAYTAkJHMRAwDgYDVQQIEwdQbG92ZGl2MQ8wDQYDVQQKEwZPcmFjbGUxDjAMBgNV
48+
BAsTBU15U1FMMSYwJAYDVQQDEx1NeVNRTCBDUkwgdGVzdCBDQSBjZXJ0aWZpY2F0
49+
ZTAeFw0xMjA1MTcxNTIxMTJaFw0yMjA1MTUxNTIxMTJaMHQxCzAJBgNVBAYTAkJH
50+
MRAwDgYDVQQIEwdQbG92ZGl2MQ8wDQYDVQQKEwZPcmFjbGUxDjAMBgNVBAsTBU15
51+
U1FMMTIwMAYDVQQDEylNeVNRTCBDUkwgdGVzdCBjbGllbnQgY2VydGlmaWNhdGUg
52+
cmV2b2tlZDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEApd2Z1f06nAb0Lhrg
53+
Uhv2JMroB0E4ppxfhFoHQ57ekTdtQETNjkiiuMQ5dUHWqpcmATd2ewJFGHjhHlZd
54+
+F3gzKTEvQ0bQG4ATuC6BmGfgfIprtsxso8mLjLFdLIJX3aoSl608URZfj0qnKqw
55+
caQucDuM8pMvh8Gmh+ZrfB+l9WsCAwEAAaN7MHkwCQYDVR0TBAIwADAsBglghkgB
56+
hvhCAQ0EHxYdT3BlblNTTCBHZW5lcmF0ZWQgQ2VydGlmaWNhdGUwHQYDVR0OBBYE
57+
FCB1++fwEU9kSMb5hXweOsfwFo9RMB8GA1UdIwQYMBaAFIWr5qdXiH2NvutkU3OU
58+
ZM1LjSkSMA0GCSqGSIb3DQEBBQUAA4GBANkjY8La1EpThcKHq+Wke+rLig5ubO+n
59+
o+L/KZ6v0CQIQEQODJFcXjglyRvFVbEXARJXYFt49eM8R+DfEBE49hjON1/sxqmV
60+
Ods2XXgSmlf4vE3N5el3hXFy0WaZDDVRij1hzw8hXuHLSzP3aIzS/MqlRKfW03aa
61+
YPsLF5fuOiMi
62+
-----END CERTIFICATE-----

‎mysql-test/std_data/crl-client-revoked-key.pem‎

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
-----BEGIN RSA PRIVATE KEY-----
2+
MIICXQIBAAKBgQCl3ZnV/TqcBvQuGuBSG/YkyugHQTimnF+EWgdDnt6RN21ARM2O
3+
SKK4xDl1QdaqlyYBN3Z7AkUYeOEeVl34XeDMpMS9DRtAbgBO4LoGYZ+B8imu2zGy
4+
jyYuMsV0sglfdqhKXrTxRFl+PSqcqrBxpC5wO4zyky+HwaaH5mt8H6X1awIDAQAB
5+
AoGAKkkoowmAG68aKXbooYZHZnHkXZUfIDrVjyR0naSvEU6UJ8JitVeHRJuiGmbC
6+
l5MZOU4ugoW9n9ORcO6L3nnwiVKWmG7K561ctp2tPQbUtCEMcFmGbnrJuJHrkyJX
7+
I0+E7+3mg2cCsTwofjR6bUeM7NnnM0Tf6Q5rKk/aXMW90MECQQDO9d3xt4TU1u/l
8+
uep52w43x23ZYx+YLIHVR9VRMZrYF62B8GpSf9TOdLOQBUyifdVJiXnuV1OkdHSX
9+
58G3P6sjAkEAzSrw66gH9YRC72tSU/m6LrMh9xmm3VqUWIYvzgX0Mw/a51VE+blr
10+
q/jctYicy1rbcDRsI9iKraXmB6fBhAA1GQJAK6VESh6Wv8AYVY0wusQMqoy/SNIT
11+
rqbsNotwnC/m5N2RdM67zWwx99w6pgvIDpiU6243raDy/cKleAejHb8qmwJBAJyQ
12+
Bzcdi61MV7PSJwoUCIK4idPBjHdgNtHy3CoQmxAYKkjb5f3XBBZAm1QgQt5foBLY
13+
vikAhpsKfSYcWuz7J4kCQQCX22QkqP9/JnC7CYfSasb69kD0A/zOn8wT3LQi4HRj
14+
3c2Mh+hKSVdMUXzULEnF+oZbMADSlPRY1qgykg+fK38R
15+
-----END RSA PRIVATE KEY-----

‎mysql-test/std_data/crl-client-revoked.crl‎

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,10 @@
11
-----BEGIN X509 CRL-----
2-
MIIBbDCB1gIBATANBgkqhkiG9w0BAQUFADBoMQswCQYDVQQGEwJCRzEQMA4GA1UE
2+
MIIBXjCByAIBATANBgkqhkiG9w0BAQUFADBoMQswCQYDVQQGEwJCRzEQMA4GA1UE
33
CBMHUGxvdmRpdjEPMA0GA1UEChMGT3JhY2xlMQ4wDAYDVQQLEwVNeVNRTDEmMCQG
4-
A1UEAxMdTXlTUUwgQ1JMIHRlc3QgQ0EgY2VydGlmaWNhdGUXDTExMDgxOTEwMDQ1
5-
MFoXDTE3MDIwODEwMDQ1MFowKjAoAgkApYXsYLFoRCQXDTExMDYxNzA3Mzc1OVow
6-
DDAKBgNVHRUEAwoBBaAOMAwwCgYDVR0UBAMCAQMwDQYJKoZIhvcNAQEFBQADgYEA
7-
BXAwYBjHUHG6MQ22/+1hvOaRtSYfj/E5bhKbBB8JlKSRFO+xIOF2i2H1AigunWpC
8-
R10NicSS7qjsr6yDyBaywZmi0TCNGksR7b3m1m97RnhrxkVRlr/i7L+o04ZwWo/b
9-
z9zoTX6RTj8rHgQtEdIOi/EArCvDv+wqYmkI+XMScGI=
4+
A1UEAxMdTXlTUUwgQ1JMIHRlc3QgQ0EgY2VydGlmaWNhdGUXDTEyMDUyMTE0NDEx
5+
NFoXDTIyMDUxOTE0NDExNFowHDAaAgkA+eLzmA4rBX8XDTEyMDUxNzE1Mjc1OVqg
6+
DjAMMAoGA1UdFAQDAgECMA0GCSqGSIb3DQEBBQUAA4GBAIEYWLAI+mGt21DVlg/t
7+
mGaQ629aabNhZL3An5+2z+tqzQbOv6bKMW5H8gNNeNrRqQR/XEJvhlg0BrxfIicM
8+
GbvVoud0HmECIoxNVmeI8UCNPkkeQONT+8ZW029iuJF2KgGI0m1ZJa3bjRaArian
9+
ag9dgLE4zLppD4aMal0ysHPZ
1010
-----END X509 CRL-----

0 commit comments

Comments
 (0)