Bug #75642 Extend valid range of dummy certificates ni mysql-test/std_data
Submitted: 27 Jan 2015 8:13 Modified: 1 Apr 2015 4:32
Reporter: Harin Vadodaria Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any

[27 Jan 2015 8:13] Harin Vadodaria
Description:
Certs files and tests:

  mysql-test/std_data/cacert.pem
  mysql-test/std_data/client-cert.pem
  mysql-test/std_data/client-key.pem
  mysql-test/std_data/server-cert.pem
  mysql-test/std_data/server-key.pem
  mysql-test/std_data/server8k-cert.pem
  mysql-test/std_data/server8k-key.pem
  mysql-test/r/ssl.result

will expire Jan 28 11:50:22 2015 GMT, after this date all SSL related tests
will fail.

How to repeat:
Adjust clock to later than Jan 28 11:50:22 2015 GMT and run SSL related MTR
tests.

Suggested fix:
Update certificates.
[27 Jan 2015 11:03] Harin Vadodaria
New Certificates

Attachment: new_certificates.tar.gz (application/gz, text), 19.43 KiB.

[7 Feb 2015 11:41] Daniƫl van Eeden
Seems to be fixed in 5.5.42 with the fix for Bug #18366947
It is also fixed in Percona Server 5.6.22-72.0
[11 Feb 2015 10:05] Laurynas Biveinis
5.5 $ git show -s 3e2d879a      
commit 3e2d879a238607792d5c8cfb8ba808597fa16fbc
Author: Harin Vadodaria <harin.vadodaria@oracle.com>
Date:   Fri Dec 5 11:35:11 2014 +0530

    Bug#18366947 : VALID DATE RANGE OF DUMMY SSL CERTS IS WAY TOO SHORT
    
    Generated new certificates with validity upto 2029.
[1 Apr 2015 4:32] Erlend Dahl
[27 Jan 2015 8:25] Paul Dubois

Noted in 5.5.42, 5.6.23, 5.7.6  changelogs.

The valid date range of the SSL certificates in mysql-test/std_data
has been extended to the year 2029.