Description:
# openssl version
OpenSSL 1.1.1a 20 Nov 2018
cmake . -DWITH_SSL=system -DCMAKE_BUILD_TYPE=Debug -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DDEBUG_EXTNAME=OFF -DWITH_EMBEDDED_SERVER=0 -DENABLE_DOWNLOADS=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/tmp/boost_091908 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_ZLIB=system -DWITH_PAM=ON
# ./mtr ssl
Logging: ./mtr ssl
MySQL Version 5.7.24
Checking supported features...
- SSL connections supported
- binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/var'...
Installing system database...
Using parallel: 1
==============================================================================
TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
[100%] main.ssl [ fail ]
Test ended at 2018-12-03 17:08:48
CURRENT_TEST: main.ssl
--- /data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/r/ssl.result 2018-12-03 19:48:38.000000000 +0300
+++ /data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/var/log/ssl.reject 2018-12-03 20:08:48.655913854 +0300
@@ -1,6 +1,6 @@
SHOW STATUS LIKE 'Ssl_cipher';
Variable_name Value
-Ssl_cipher SSL_CIPHER
+Ssl_cipher TLS_AES_256_GCM_SHA384
SHOW STATUS LIKE 'Ssl_server_not_before';
Variable_name Value
Ssl_server_not_before Dec 5 04:48:40 2014 GMT
@@ -2233,7 +2233,7 @@
drop table t1;
SHOW STATUS LIKE 'Ssl_cipher';
Variable_name Value
-Ssl_cipher SSL_CIPHER
+Ssl_cipher TLS_AES_256_GCM_SHA384
#
# Bug#54790: Use of non-blocking mode for sockets limits performance
#
mysqltest: Result content mismatch
safe_process[19179]: Child process: 19180, exit: 1
- the logfile can be found in '/data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/var/log/main.ssl/ssl.log'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 15 seconds executing testcases
Completed: Failed 1/1 tests, 0.00% were successful.
Failing test(s): main.ssl
The log files in var/log may give you some hint of what went wrong.
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
mysql-test-run: *** ERROR: there were failing test cases
Below tests also failing with openssl 1.1.1a build
main.ssl_8k_key
main.ssl_compress
auth_sec.mysql_ssl_connection
auth_sec.ssl_auto_detect
How to repeat:
# openssl version
OpenSSL 1.1.1a 20 Nov 2018
cmake . -DWITH_SSL=system -DCMAKE_BUILD_TYPE=Debug -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DDEBUG_EXTNAME=OFF -DWITH_EMBEDDED_SERVER=0 -DENABLE_DOWNLOADS=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/tmp/boost_091908 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_ZLIB=system -DWITH_PAM=ON
and run below tests
./mtr ssl
main.ssl_8k_key
main.ssl_compress
auth_sec.mysql_ssl_connection
auth_sec.ssl_auto_detect
Description: # openssl version OpenSSL 1.1.1a 20 Nov 2018 cmake . -DWITH_SSL=system -DCMAKE_BUILD_TYPE=Debug -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DDEBUG_EXTNAME=OFF -DWITH_EMBEDDED_SERVER=0 -DENABLE_DOWNLOADS=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/tmp/boost_091908 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_ZLIB=system -DWITH_PAM=ON # ./mtr ssl Logging: ./mtr ssl MySQL Version 5.7.24 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped [100%] main.ssl [ fail ] Test ended at 2018-12-03 17:08:48 CURRENT_TEST: main.ssl --- /data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/r/ssl.result 2018-12-03 19:48:38.000000000 +0300 +++ /data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/var/log/ssl.reject 2018-12-03 20:08:48.655913854 +0300 @@ -1,6 +1,6 @@ SHOW STATUS LIKE 'Ssl_cipher'; Variable_name Value -Ssl_cipher SSL_CIPHER +Ssl_cipher TLS_AES_256_GCM_SHA384 SHOW STATUS LIKE 'Ssl_server_not_before'; Variable_name Value Ssl_server_not_before Dec 5 04:48:40 2014 GMT @@ -2233,7 +2233,7 @@ drop table t1; SHOW STATUS LIKE 'Ssl_cipher'; Variable_name Value -Ssl_cipher SSL_CIPHER +Ssl_cipher TLS_AES_256_GCM_SHA384 # # Bug#54790: Use of non-blocking mode for sockets limits performance # mysqltest: Result content mismatch safe_process[19179]: Child process: 19180, exit: 1 - the logfile can be found in '/data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/var/log/main.ssl/ssl.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 15 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.ssl The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases Below tests also failing with openssl 1.1.1a build main.ssl_8k_key main.ssl_compress auth_sec.mysql_ssl_connection auth_sec.ssl_auto_detect How to repeat: # openssl version OpenSSL 1.1.1a 20 Nov 2018 cmake . -DWITH_SSL=system -DCMAKE_BUILD_TYPE=Debug -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DDEBUG_EXTNAME=OFF -DWITH_EMBEDDED_SERVER=0 -DENABLE_DOWNLOADS=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/tmp/boost_091908 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_ZLIB=system -DWITH_PAM=ON and run below tests ./mtr ssl main.ssl_8k_key main.ssl_compress auth_sec.mysql_ssl_connection auth_sec.ssl_auto_detect