Bug #50804 main.openssl_1 test case fails
Submitted: 1 Feb 2010 20:32 Modified: 1 Feb 2010 22:13
Reporter: BJ Dierkes Email Updates:
Status: Duplicate Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.0.90, 5.1.43 OS:Linux (RedHat Enterprise Linux 5.4 Server)
Assigned to: CPU Architecture:Any

[1 Feb 2010 20:32] BJ Dierkes
Description:
main.openssl_1                           [ fail ]
        Test ended at 2010-02-01 14:13:28
CURRENT_TEST: main.openssl_1
mysqltest: At line 23: query 'connect  con1,localhost,ssl_user1,,,,,SSL' failed: 2026: SSL connection error
The result from queries just before the failure was:
drop table if exists t1;
create table t1(f1 int);
insert into t1 values (5);
grant select on test.* to ssl_user1@localhost require SSL;
grant select on test.* to ssl_user2@localhost require cipher "DHE-RSA-AES256-SHA";
grant select on test.* to ssl_user3@localhost require cipher "DHE-RSA-AES256-SHA" AND SUBJECT "/C=SE/ST=Uppsala/O=MySQL AB/emailAddress=abstract.mysql.developer@mysql.com";
grant select on test.* to ssl_user4@localhost require cipher "DHE-RSA-AES256-SHA" AND SUBJECT "/C=SE/ST=Uppsala/O=MySQL AB/emailAddress=abstract.mysql.developer@mysql.com" ISSUER "/C=SE/ST=Uppsala/L=Uppsala/O=MySQL AB";
grant select on test.* to ssl_user5@localhost require cipher "DHE-RSA-AES256-SHA" AND SUBJECT "xxx";
flush privileges;
 - saving '/builddir/build/BUILD/mysql-5.1.43/mysql-test/var/log/main.openssl_1/' to '/builddir/build/BUILD/mysql-5.1.43/mysql-test/var/log/main.openssl_1/'

How to repeat:
# -----------------------------------
  ./configure --build=x86_64-redhat-linux-gnu --host=x86_64-redhat-linux-gnu \
        --target=x86_64-redhat-linux-gnu \
        --program-prefix= \
        --prefix=/usr \
        --exec-prefix=/usr \
        --bindir=/usr/bin \
        --sbindir=/usr/sbin \
        --sysconfdir=/etc \
        --datadir=/usr/share \
        --includedir=/usr/include \
        --libdir=/usr/lib64 \
        --libexecdir=/usr/libexec \
        --localstatedir=/var \
        --sharedstatedir=/usr/com \
        --mandir=/usr/share/man \
        --infodir=/usr/share/info \
        --with-pic \
        --with-readline \
        --with-ssl \
        --without-debug \
        --enable-shared \
        --enable-community-features \
        --enable-profiling \
        --with-bench \
        --localstatedir=/var/lib/mysql \
        --with-unix-socket-path=/var/lib/mysql/mysql.sock \
        --with-mysqld-user="mysql" \
        --with-extra-charsets=all \
        --with-innodb \
        --with-berkeley-db \
        --enable-local-infile \
        --enable-largefile \
        --enable-thread-safe-client \
        --disable-dependency-tracking \
        --with-plugin-partition \
        --with-plugin-csv \
        --without-plugin-ndbcluster \
        --with-named-thread-libs="-lpthread"
# -----------------------------------

Build --with-ssl:

make && make test

Suggested fix:
Not sure.
[1 Feb 2010 21:01] BJ Dierkes
This also seems to be the same exact bug or test-bug in 5.0.90.
[1 Feb 2010 21:05] BJ Dierkes
Possibly [regression] related to:

http://bugs.mysql.com/bug.php?id=50227
[1 Feb 2010 22:13] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

This is because expired certificates. Duplicate of bug #50642