Description:
I have compiled mysql8.0.13 with openssl1.1.1. when I run the mysql-test, i find the main.grant_user_lock_qa is failed.
The information is as following:
leo@sly-ecs mysql-test $ ./mtr main.grant_user_lock_qa
Logging: ./mtr main.grant_user_lock_qa
MySQL Version 8.0.13
Checking supported features...
Using 'all' suites
Collecting tests...
Removing old var directory...
Creating var directory '/home/leo/wsp/mysql/install/mysql8.0.13/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..13019
[100%] main.grant_user_lock_qa [ fail ]
Test ended at 2018-11-30 15:22:21
CURRENT_TEST: main.grant_user_lock_qa
mysqltest: At line 403: Query 'connect con1, localhost, u7,,,,,SSL' failed.
ERROR 1045 (28000): Access denied for user 'u7'@'localhost' (using password: NO)
The result from queries just before the failure was:
< snip >
u6@localhost
CREATE USER u7@localhost IDENTIFIED WITH 'sha256_password'
REQUIRE CIPHER "DHE-RSA-AES256-SHA"
PASSWORD EXPIRE NEVER PASSWORD EXPIRE NEVER;
SELECT user,plugin,authentication_string,ssl_type,ssl_cipher,x509_issuer,
x509_subject,password_expired,password_lifetime,account_locked FROM mysql.user WHERE USER='u7';
user u7
plugin sha256_password
authentication_string #
ssl_type SPECIFIED
ssl_cipher DHE-RSA-AES256-SHA
x509_issuer
x509_subject
password_expired N
password_lifetime 0
account_locked N
SHOW CREATE USER u7@localhost;
CREATE USER for u7@localhost
CREATE USER 'u7'@'localhost' IDENTIFIED WITH 'sha256_password' REQUIRE CIPHER 'DHE-RSA-AES256-SHA' PASSWORD EXPIRE NEVER ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
safe_process[21431]: Child process: 21432, exit: 1
- the logfile can be found in '/home/leo/wsp/mysql/install/mysql8.0.13/mysql-test/var/log/main.grant_user_lock_qa/grant_user_lock_qa.log'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 23 seconds executing testcases
Completed: Failed 1/1 tests, 0.00% were successful.
Failing test(s): main.grant_user_lock_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
How to repeat:
Just compile mysql-8.0.13 with openssl1.1.1 and install it, and then go to mysql-test dir and run ./mtr main.grant_user_lock_qa. You will see the faild information.
I have test mysql8.0.12, and it also has this problem.
This testcase works fine with openssl old version(such as openssl1.0.2e).
Description: I have compiled mysql8.0.13 with openssl1.1.1. when I run the mysql-test, i find the main.grant_user_lock_qa is failed. The information is as following: leo@sly-ecs mysql-test $ ./mtr main.grant_user_lock_qa Logging: ./mtr main.grant_user_lock_qa MySQL Version 8.0.13 Checking supported features... Using 'all' suites Collecting tests... Removing old var directory... Creating var directory '/home/leo/wsp/mysql/install/mysql8.0.13/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..13019 [100%] main.grant_user_lock_qa [ fail ] Test ended at 2018-11-30 15:22:21 CURRENT_TEST: main.grant_user_lock_qa mysqltest: At line 403: Query 'connect con1, localhost, u7,,,,,SSL' failed. ERROR 1045 (28000): Access denied for user 'u7'@'localhost' (using password: NO) The result from queries just before the failure was: < snip > u6@localhost CREATE USER u7@localhost IDENTIFIED WITH 'sha256_password' REQUIRE CIPHER "DHE-RSA-AES256-SHA" PASSWORD EXPIRE NEVER PASSWORD EXPIRE NEVER; SELECT user,plugin,authentication_string,ssl_type,ssl_cipher,x509_issuer, x509_subject,password_expired,password_lifetime,account_locked FROM mysql.user WHERE USER='u7'; user u7 plugin sha256_password authentication_string # ssl_type SPECIFIED ssl_cipher DHE-RSA-AES256-SHA x509_issuer x509_subject password_expired N password_lifetime 0 account_locked N SHOW CREATE USER u7@localhost; CREATE USER for u7@localhost CREATE USER 'u7'@'localhost' IDENTIFIED WITH 'sha256_password' REQUIRE CIPHER 'DHE-RSA-AES256-SHA' PASSWORD EXPIRE NEVER ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT safe_process[21431]: Child process: 21432, exit: 1 - the logfile can be found in '/home/leo/wsp/mysql/install/mysql8.0.13/mysql-test/var/log/main.grant_user_lock_qa/grant_user_lock_qa.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 23 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.grant_user_lock_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 How to repeat: Just compile mysql-8.0.13 with openssl1.1.1 and install it, and then go to mysql-test dir and run ./mtr main.grant_user_lock_qa. You will see the faild information. I have test mysql8.0.12, and it also has this problem. This testcase works fine with openssl old version(such as openssl1.0.2e).