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 main.grant_alter_user_qa
Logging: ./mtr main.grant_alter_user_qa
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.grant_alter_user_qa [ fail ]
Test ended at 2018-12-03 17:17:32
CURRENT_TEST: main.grant_alter_user_qa
mysqltest: At line 190: query 'connect con1, localhost, u10,'auth_string#y',,,,SSL' failed: 1045: Access denied for user 'u10'@'localhost' (using password: YES)
The result from queries just before the failure was:
< snip >
ssl_type SPECIFIED
ssl_cipher
x509_issuer
x509_subject sub
CREATE USER u10@localhost IDENTIFIED WITH 'sha256_password' BY 'auth_string#y'
REQUIRE CIPHER "DHE-RSA-AES256-SHA" AND
SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client"
ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA"
PASSWORD EXPIRE DEFAULT;
SELECT User,plugin,authentication_string,ssl_type,ssl_cipher,x509_issuer,
x509_subject,password_expired,password_lifetime FROM mysql.user WHERE USER='u10';
User u10
plugin sha256_password
authentication_string #
ssl_type SPECIFIED
ssl_cipher DHE-RSA-AES256-SHA
x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
password_expired N
password_lifetime NULL
safe_process[19375]: Child process: 19376, exit: 1
- the logfile can be found in '/data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/var/log/main.grant_alter_user_qa/grant_alter_user_qa.log'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 5 seconds executing testcases
Completed: Failed 1/1 tests, 0.00% were successful.
Failing test(s): main.grant_alter_user_qa
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
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 ./mtr main.grant_alter_user_qa
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 main.grant_alter_user_qa Logging: ./mtr main.grant_alter_user_qa 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.grant_alter_user_qa [ fail ] Test ended at 2018-12-03 17:17:32 CURRENT_TEST: main.grant_alter_user_qa mysqltest: At line 190: query 'connect con1, localhost, u10,'auth_string#y',,,,SSL' failed: 1045: Access denied for user 'u10'@'localhost' (using password: YES) The result from queries just before the failure was: < snip > ssl_type SPECIFIED ssl_cipher x509_issuer x509_subject sub CREATE USER u10@localhost IDENTIFIED WITH 'sha256_password' BY 'auth_string#y' REQUIRE CIPHER "DHE-RSA-AES256-SHA" AND SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client" ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA" PASSWORD EXPIRE DEFAULT; SELECT User,plugin,authentication_string,ssl_type,ssl_cipher,x509_issuer, x509_subject,password_expired,password_lifetime FROM mysql.user WHERE USER='u10'; User u10 plugin sha256_password authentication_string # ssl_type SPECIFIED ssl_cipher DHE-RSA-AES256-SHA x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client password_expired N password_lifetime NULL safe_process[19375]: Child process: 19376, exit: 1 - the logfile can be found in '/data/MS031218-mysql-5.7.24-linux-x86_64-debug/mysql-test/var/log/main.grant_alter_user_qa/grant_alter_user_qa.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 5 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.grant_alter_user_qa 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 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 ./mtr main.grant_alter_user_qa