Bug #77275 Newest RHEL/CentOS openssl update breaks mysql DHE ciphers

Submitted: 8 Jun 2015 17:38 Modified: 19 Jun 2015 17:22
Reporter: Jacques Grove Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Security: Encryption Severity:S2 (Serious)
Version: OS:Linux (RHEL 6.6)
Assigned to: CPU Architecture:Any
Tags: SSL

[8 Jun 2015 17:38] Jacques Grove
Description:
The newest RHEL/CentOS/SL 6.6 openssl package (1.0.1e-30.el6_6.9 ; published around 6/4/2015) contains a fix for CVE-2015-4000 (LogJam) . RedHat's fix for this was to limit the use of any SSL DH key sizes to a minimum of 768 bits. This breaks any DHE SSL ciphers for MySQL clients as soon as you install the openssl update, since in vio/viosslfactories.c , the default DHPARAM is a 512 bit one. As far as I can tell this cannot be changed in configuration/runtime; and needs a recompile.

How to repeat:
 If a user on a MySQL 5.6.23 server is configured with grant "require SSL", and the client (using the updated openssl package:  1.0.1e-30.el6_6.9) executes:
  # mysql -u user -h serverhostname --ssl --ssl-cipher=DHE-RSA-AES256-SHA -p
Enter password:
ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)

Using a non-DHE cipher works fine, e.g.:

# mysql -u user -h serverhostname --ssl --ssl-cipher=AES256-SHA -p

The same problem will also occur for any supported DHE cipher.  Any non-DHE cipher will work as expected.

Workaround:
  * Downgrade the client openssl package to any version before 1.0.1e-30.el6_6.9; e.g. 0:1.0.1e-30.el6_6.8
  * Alternatively, do not use DH ciphers. This is not acceptable because the supported non-DH ciphers do not afford any PFS protection.

Suggested fix:
Solution is for the server to present a 1024 bit DH param. This would:

 * Avoid the problem with "fixed" client libraries.
 * Still be small enough to avoid problems with some clients (e.g. older Java versions do not like DH params > 1024 bit)
 * Improve security in general.

To achieve this, we should probably include this RedHat patch:

  https://lists.fedoraproject.org/pipermail/scm-commits/2012-December/910767.html
[9 Jun 2015 8:09] Terje Røsten
Verified, this is request for backport of:

  https://github.com/mysql/mysql-server/commit/866b988a76e8e7e217017a7883a52a12ec5024b9
[19 Jun 2015 17:22] Paul DuBois
Noted in 5.5.45, 5.6.26 changelogs.

The key length used in vio/viosslfactories.c for creating
Diffie-Hellman keys has been increased from 512 to 2,048 bits.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.