======================================================================== main.ssl_cipher ======================================================================== [ 3120s] main.ssl_cipher w6 [ fail ] [ 3120s] Test ended at 2018-09-12 15:17:27 [ 3120s] [ 3120s] CURRENT_TEST: main.ssl_cipher [ 3120s] --- /home/abuild/rpmbuild/BUILD/mariadb-10.2.17/mysql-test/r/ssl_cipher.result 2018-08-12 11:29:49.000000000 +0000 [ 3120s] +++ /home/abuild/rpmbuild/BUILD/mariadb-10.2.17/mysql-test/r/ssl_cipher.reject 2018-09-12 15:17:25.820000000 +0000 [ 3120s] @@ -4,9 +4,9 @@ [ 3120s] connect ssl_con,localhost,root,,,,,SSL; [ 3120s] SHOW STATUS LIKE 'Ssl_cipher'; [ 3120s] Variable_name Value [ 3120s] -Ssl_cipher AES128-SHA [ 3120s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3120s] SHOW STATUS LIKE 'Ssl_cipher_list'; [ 3120s] Variable_name Value [ 3120s] -Ssl_cipher_list AES128-SHA [ 3120s] +Ssl_cipher_list TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_GCM_SHA256:AES128-SHA [ 3120s] connection default; [ 3120s] disconnect ssl_con; [ 3120s] [ 3120s] mysqltest: Result length mismatch [ 3120s] [ 3120s] - saving '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/6/log/main.ssl_cipher/' to '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/log/main.ssl_cipher/' ======================================================================== main.openssl_6975 'tlsv10' ======================================================================== [ 3125s] main.openssl_6975 'tlsv10' w6 [ fail ] [ 3125s] Test ended at 2018-09-12 15:17:31 [ 3125s] [ 3125s] CURRENT_TEST: main.openssl_6975 [ 3125s] --- /home/abuild/rpmbuild/BUILD/mariadb-10.2.17/mysql-test/r/openssl_6975,tlsv10.result 2018-08-12 11:29:49.000000000 +0000 [ 3125s] +++ /home/abuild/rpmbuild/BUILD/mariadb-10.2.17/mysql-test/r/openssl_6975,tlsv10.reject 2018-09-12 15:17:31.056000000 +0000 [ 3125s] @@ -3,22 +3,23 @@ [ 3125s] create user ssl_tls12@localhost; [ 3125s] grant select on test.* to ssl_tls12@localhost require cipher "AES128-SHA256"; [ 3125s] TLS1.2 ciphers: user is ok with any cipher [ 3125s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3125s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3125s] +Variable_name Value [ 3125s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3125s] +Variable_name Value [ 3125s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3125s] TLS1.2 ciphers: user requires SSLv3 cipher AES128-SHA [ 3125s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3125s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3125s] +ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) [ 3125s] +ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) [ 3125s] TLS1.2 ciphers: user requires TLSv1.2 cipher AES128-SHA256 [ 3125s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3125s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3125s] +ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) [ 3125s] +ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) [ 3125s] SSLv3 ciphers: user is ok with any cipher [ 3125s] Variable_name Value [ 3125s] -Ssl_cipher AES256-SHA [ 3125s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3125s] Variable_name Value [ 3125s] -Ssl_cipher DHE-RSA-AES256-SHA [ 3125s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3125s] SSLv3 ciphers: user requires SSLv3 cipher AES128-SHA [ 3125s] -Variable_name Value [ 3125s] -Ssl_cipher AES128-SHA [ 3125s] +ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) [ 3125s] ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) [ 3125s] SSLv3 ciphers: user requires TLSv1.2 cipher AES128-SHA256 [ 3125s] ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) [ 3125s] [ 3125s] mysqltest: Result length mismatch [ 3125s] [ 3125s] - saving '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/6/log/main.openssl_6975-tlsv10/' to '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/log/main.openssl_6975-tlsv10/' ======================================================================== main.openssl_6975 'tlsv12' ======================================================================== [ 3130s] main.openssl_6975 'tlsv12' w6 [ fail ] [ 3130s] Test ended at 2018-09-12 15:17:37 [ 3130s] [ 3130s] CURRENT_TEST: main.openssl_6975 [ 3130s] --- /home/abuild/rpmbuild/BUILD/mariadb-10.2.17/mysql-test/r/openssl_6975,tlsv12.result 2018-08-12 11:29:49.000000000 +0000 [ 3130s] +++ /home/abuild/rpmbuild/BUILD/mariadb-10.2.17/mysql-test/r/openssl_6975,tlsv12.reject 2018-09-12 15:17:36.728000000 +0000 [ 3130s] @@ -4,24 +4,25 @@ [ 3130s] grant select on test.* to ssl_tls12@localhost require cipher "AES128-SHA256"; [ 3130s] TLS1.2 ciphers: user is ok with any cipher [ 3130s] Variable_name Value [ 3130s] -Ssl_cipher AES128-SHA256 [ 3130s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3130s] Variable_name Value [ 3130s] -Ssl_cipher DHE-RSA-AES256-GCM-SHA384 [ 3130s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3130s] TLS1.2 ciphers: user requires SSLv3 cipher AES128-SHA [ 3130s] ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) [ 3130s] ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) [ 3130s] TLS1.2 ciphers: user requires TLSv1.2 cipher AES128-SHA256 [ 3130s] -Variable_name Value [ 3130s] -Ssl_cipher AES128-SHA256 [ 3130s] +ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) [ 3130s] ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) [ 3130s] SSLv3 ciphers: user is ok with any cipher [ 3130s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3130s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3130s] +Variable_name Value [ 3130s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3130s] +Variable_name Value [ 3130s] +Ssl_cipher TLS_AES_256_GCM_SHA384 [ 3130s] SSLv3 ciphers: user requires SSLv3 cipher AES128-SHA [ 3130s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3130s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3130s] +ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) [ 3130s] +ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) [ 3130s] SSLv3 ciphers: user requires TLSv1.2 cipher AES128-SHA256 [ 3130s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3130s] -ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure [ 3130s] +ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) [ 3130s] +ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) [ 3130s] drop user ssl_sslv3@localhost; [ 3130s] drop user ssl_tls12@localhost; [ 3130s] [ 3130s] mysqltest: Result length mismatch [ 3130s] [ 3130s] - saving '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/6/log/main.openssl_6975-tlsv12/' to '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/log/main.openssl_6975-tlsv12/' ======================================================================== main.ssl ======================================================================== [ 3607s] main.ssl w5 [ fail ] [ 3607s] Test ended at 2018-09-12 15:25:34 [ 3607s] [ 3607s] CURRENT_TEST: main.ssl [ 3607s] mysqltest: At line 37: exec of '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/client/mysql --defaults-file=/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/5/my.cnf -umysqltest_1 --ssl-cipher=AES256-SHA -e "show status like 'ssl_cipher'" 2>&1' failed, error: 256, status: 1, errno: 0 [ 3607s] Output from before failure: [ 3607s] ERROR 1045 (28000): Access denied for user 'mysqltest_1'@'localhost' (using password: NO) [ 3607s] [ 3607s] [ 3607s] [ 3607s] The result from queries just before the failure was: [ 3607s] < snip > [ 3607s] INSERT INTO t1 VALUES (3359362,406,3359362,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1509984,2145874,'+','','P',1909154,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); [ 3607s] SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie; [ 3607s] Kundentyp kategorie [ 3607s] Privat (Private Nutzung) Mobilfunk [ 3607s] Warnings: [ 3607s] Warning 1052 Column 'kundentyp' in group statement is ambiguous [ 3607s] drop table t1; [ 3607s] SELECT (VARIABLE_VALUE <> '') AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher'; [ 3607s] have_ssl [ 3607s] 1 [ 3607s] select aes_decrypt('MySQL','adf'); [ 3607s] aes_decrypt('MySQL','adf') [ 3607s] NULL [ 3607s] select 'still connected?'; [ 3607s] still connected? [ 3607s] still connected? [ 3607s] connection default; [ 3607s] disconnect ssl_con; [ 3607s] create user mysqltest_1@localhost; [ 3607s] grant usage on mysqltest.* to mysqltest_1@localhost require cipher "AES256-SHA"; [ 3607s] [ 3607s] More results from queries before failure can be found in /home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/5/log/ssl.log [ 3607s] [ 3607s] - saving '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/5/log/main.ssl/' to '/home/abuild/rpmbuild/BUILD/mariadb-10.2.17/build/mysql-test/var/log/main.ssl/'