--source include/have_tlsv13.inc # Save the initial number of concurrent sessions --source include/count_sessions.inc --echo #======================================================================= --echo --echo # Setup --echo --connection default CREATE USER arthurdent@localhost; GRANT SERVICE_CONNECTION_ADMIN ON *.* TO arthurdent@localhost; CREATE DATABASE cipher_data; CREATE TABLE cipher_data.acceptable(ciphers JSON); CREATE TABLE cipher_data.blocked(ciphers JSON); --let $CIPHER_DB = cipher_data --let $USER = arthurdent --let $OPENSSL_102 = 0 --echo --echo #======================================================================= --echo --echo # Cert type: RSA | TLS version: 1.2 --echo --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.ssl_ca='$MYSQL_TEST_DIR/std_data/cacert.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.ssl_cert='$MYSQL_TEST_DIR/std_data/server-cert.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.ssl_key='$MYSQL_TEST_DIR/std_data/server-key.pem' ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_main; --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.admin_ssl_ca='$MYSQL_TEST_DIR/std_data/cacert.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.admin_ssl_cert='$MYSQL_TEST_DIR/std_data/server-cert.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.admin_ssl_key='$MYSQL_TEST_DIR/std_data/server-key.pem' ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin; INSERT INTO cipher_data.acceptable VALUES ('["ECDHE-RSA-AES128-GCM-SHA256", "ECDHE-RSA-AES256-GCM-SHA384", "ECDHE-RSA-CHACHA20-POLY1305", "DHE-RSA-AES128-GCM-SHA256", "DHE-RSA-AES256-GCM-SHA384", "DHE-RSA-AES256-CCM", "DHE-RSA-AES128-CCM", "DHE-RSA-CHACHA20-POLY1305"]'); INSERT INTO cipher_data.blocked VALUES ('["AECDH-NULL-SHA", "ECDHE-RSA-NULL-SHA", "ECDHE-ECDSA-NULL-SHA", "GOST94-NULL-GOST94", "GOST2001-GOST89-GOST89", "ECDH-RSA-NULL-SHA", "ECDH-ECDSA-NULL-SHA", "NULL-SHA256", "NULL-SHA", "NULL-MD5", "AECDH-AES256-SHA", "ADH-AES256-GCM-SHA384", "ADH-AES256-SHA256", "ADH-AES256-SHA", "ADH-CAMELLIA256-SHA256", "ADH-CAMELLIA256-SHA", "AECDH-AES128-SHA", "ADH-AES128-GCM-SHA256", "ADH-AES128-SHA256", "ADH-AES128-SHA", "ADH-CAMELLIA128-SHA256", "AADH-CAMELLIA128-SHA", "AECDH-RC4-SHA", "ADH-RC4-MD5", "AECDH-DES-CBC3-SHA", "ADH-DES-CBC3-SHA", "ADH-DES-CBC-SHA", "EXP-RC4-MD5", "EXP-RC2-CBC-MD5", "EXP-DES-CBC-SHA", "EXP-DH-DSS-DES-CBC-SHA", "EXP-DH-RSA-DES-CBC-SHA", "EXP-EDH-DSS-DES-CBC-SHA", "EXP-EDH-RSA-DES-CBC-SHA", "EXP-ADH-RC4-MD5", "EXP-ADH-DES-CBC-SHA", "EXP-KRB5-DES-CBC-SHA", "EXP-KRB5-RC2-CBC-SHA", "EXP-KRB5-RC4-SHA", "EXP-KRB5-DES-CBC-MD5", "EXP-KRB5-RC2-CBC-MD5", "EXP-KRB5-RC4-MD5", "EXP-RC4-MD5", "EXP-RC2-CBC-MD5", "TLS_RSA_EXPORT_WITH_DES40_CBC_SHA", "EXP-EDH-DSS-DES-CBC-SHA", "EXP-EDH-RSA-DES-CBC-SHA", "EXP-ADH-RC4-MD5", "EXP-ADH-DES-CBC-SHA", "EXP1024-DES-CBC-SHA", "EXP1024-RC4-SHA", "EXP1024-RC4-MD5", "EXP1024-RC2-CBC-MD5", "EXP1024-DHE-DSS-DES-CBC-SHA", "EXP1024-DHE-DSS-RC4-SHA", "EXP-RC4-MD5", "EXP-RC2-CBC-MD5", "EXP-RC2-MD5", "EDH-RSA-DES-CBC-SHA", "EDH-DSS-DES-CBC-SHA", "ADH-DES-CBC-SHA", "DES-CBC-SHA", "ADH-RC4-MD5", "RC4-MD5", "NULL-MD5", "ECDHE-RSA-RC4-SHA", "ECDHE-ECDSA-RC4-SHA", "AECDH-RC4-SHA", "ECDH-RSA-RC4-SHA", "ECDH-ECDSA-RC4-SHA", "RC4-SHA", "AECDH-NULL-SHA", "ECDH-RSA-NULL-SHA", "ECDH-ECDSA-NULL-SHA", "PSK-AES256-CBC-SHA", "PSK-AES128-CBC-SHA", "PSK-3DES-EDE-CBC-SHA", "PSK-RC4-SHA", "EXP-RC2-CBC-MD5", "EXP-KRB5-RC2-CBC-SHA", "EXP1024-RC2-CBC-MD5", "RC2-CBC-MD5", "EXP-RC2-CBC-MD5", "DH-RSA-AES128-SHA256", "DH-RSA-AES256-SHA256", "DH-DSS-AES128-SHA256", "DH-DSS-AES128-SHA", "DH-DSS-AES256-SHA", "DH-DSS-AES256-SHA256", "DH-RSA-AES128-SHA", "DH-RSA-AES256-SHA", "DH-DSS-AES128-GCM-SHA256", "DH-DSS-AES256-GCM-SHA384", "DH-RSA-AES128-GCM-SHA256", "DH-RSA-AES256-GCM-SHA384", "DH-DSS-DES-CBC3-SHA", "DH-RSA-DES-CBC3-SHA", "EDH-DSS-DES-CBC3-SHA", "EDH-RSA-DES-CBC3-SHA", "ECDH-RSA-DES-CBC3-SHA", "ECDH-ECDSA-DES-CBC3-SHA", "ECDHE-RSA-DES-CBC3-SHA", "ECDHE-ECDSA-DES-CBC3-SHA", "DES-CBC3-SHA"]'); --let $TLS_VERSION = TLSv1.2 --source suite/auth_sec/include/wl15800_cipher_test.inc --echo #======================================================================= --echo --echo # Cert type: RSA | TLS version: 1.3 --echo TRUNCATE TABLE cipher_data.acceptable; TRUNCATE TABLE cipher_data.blocked; INSERT INTO cipher_data.acceptable VALUES ('["TLS_AES_128_GCM_SHA256", "TLS_AES_256_GCM_SHA384", "TLS_CHACHA20_POLY1305_SHA256", "TLS_AES_128_CCM_SHA256"]'); --let $TLS_VERSION = TLSv1.3 --source suite/auth_sec/include/wl15800_cipher_test.inc --echo --echo #======================================================================= --echo --echo # Cert type: ECDSA | TLS Version: 1.2 --echo --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.ssl_ca='$MYSQL_TEST_DIR/std_data/ecdsa_certs/cacert.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.ssl_cert='$MYSQL_TEST_DIR/std_data/ecdsa_certs/server-cert.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.ssl_key='$MYSQL_TEST_DIR/std_data/ecdsa_certs/server-key.pem' ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_main; --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.admin_ssl_ca='$MYSQL_TEST_DIR/std_data/ecdsa_certs/cacert.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.admin_ssl_cert='$MYSQL_TEST_DIR/std_data/ecdsa_certs/server-cert.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET @@global.admin_ssl_key='$MYSQL_TEST_DIR/std_data/ecdsa_certs/server-key.pem' ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin; TRUNCATE TABLE cipher_data.acceptable; TRUNCATE TABLE cipher_data.blocked; INSERT INTO cipher_data.acceptable VALUES ('["ECDHE-ECDSA-AES128-GCM-SHA256", "ECDHE-ECDSA-AES256-GCM-SHA384", "ECDHE-ECDSA-CHACHA20-POLY1305", "ECDHE-ECDSA-AES256-CCM", "ECDHE-ECDSA-AES128-CCM"]'); INSERT INTO cipher_data.blocked VALUES ('["AECDH-NULL-SHA", "ECDHE-RSA-NULL-SHA", "ECDHE-ECDSA-NULL-SHA", "GOST94-NULL-GOST94", "GOST2001-GOST89-GOST89", "ECDH-RSA-NULL-SHA", "ECDH-ECDSA-NULL-SHA", "NULL-SHA256", "NULL-SHA", "NULL-MD5", "AECDH-AES256-SHA", "ADH-AES256-GCM-SHA384", "ADH-AES256-SHA256", "ADH-AES256-SHA", "ADH-CAMELLIA256-SHA256", "ADH-CAMELLIA256-SHA", "AECDH-AES128-SHA", "ADH-AES128-GCM-SHA256", "ADH-AES128-SHA256", "ADH-AES128-SHA", "ADH-CAMELLIA128-SHA256", "AADH-CAMELLIA128-SHA", "AECDH-RC4-SHA", "ADH-RC4-MD5", "AECDH-DES-CBC3-SHA", "ADH-DES-CBC3-SHA", "ADH-DES-CBC-SHA", "EXP-RC4-MD5", "EXP-RC2-CBC-MD5", "EXP-DES-CBC-SHA", "EXP-DH-DSS-DES-CBC-SHA", "EXP-DH-RSA-DES-CBC-SHA", "EXP-EDH-DSS-DES-CBC-SHA", "EXP-EDH-RSA-DES-CBC-SHA", "EXP-ADH-RC4-MD5", "EXP-ADH-DES-CBC-SHA", "EXP-KRB5-DES-CBC-SHA", "EXP-KRB5-RC2-CBC-SHA", "EXP-KRB5-RC4-SHA", "EXP-KRB5-DES-CBC-MD5", "EXP-KRB5-RC2-CBC-MD5", "EXP-KRB5-RC4-MD5", "EXP-RC4-MD5", "EXP-RC2-CBC-MD5", "TLS_RSA_EXPORT_WITH_DES40_CBC_SHA", "EXP-EDH-DSS-DES-CBC-SHA", "EXP-EDH-RSA-DES-CBC-SHA", "EXP-ADH-RC4-MD5", "EXP-ADH-DES-CBC-SHA", "EXP1024-DES-CBC-SHA", "EXP1024-RC4-SHA", "EXP1024-RC4-MD5", "EXP1024-RC2-CBC-MD5", "EXP1024-DHE-DSS-DES-CBC-SHA", "EXP1024-DHE-DSS-RC4-SHA", "EXP-RC4-MD5", "EXP-RC2-CBC-MD5", "EXP-RC2-MD5", "EDH-RSA-DES-CBC-SHA", "EDH-DSS-DES-CBC-SHA", "ADH-DES-CBC-SHA", "DES-CBC-SHA", "ADH-RC4-MD5", "RC4-MD5", "NULL-MD5", "ECDHE-RSA-RC4-SHA", "ECDHE-ECDSA-RC4-SHA", "AECDH-RC4-SHA", "ECDH-RSA-RC4-SHA", "ECDH-ECDSA-RC4-SHA", "RC4-SHA", "AECDH-NULL-SHA", "ECDH-RSA-NULL-SHA", "ECDH-ECDSA-NULL-SHA", "PSK-AES256-CBC-SHA", "PSK-AES128-CBC-SHA", "PSK-3DES-EDE-CBC-SHA", "PSK-RC4-SHA", "EXP-RC2-CBC-MD5", "EXP-KRB5-RC2-CBC-SHA", "EXP1024-RC2-CBC-MD5", "RC2-CBC-MD5", "EXP-RC2-CBC-MD5", "DH-RSA-AES128-SHA256", "DH-RSA-AES256-SHA256", "DH-DSS-AES128-SHA256", "DH-DSS-AES128-SHA", "DH-DSS-AES256-SHA", "DH-DSS-AES256-SHA256", "DH-RSA-AES128-SHA", "DH-RSA-AES256-SHA", "DH-DSS-AES128-GCM-SHA256", "DH-DSS-AES256-GCM-SHA384", "DH-RSA-AES128-GCM-SHA256", "DH-RSA-AES256-GCM-SHA384", "DH-DSS-DES-CBC3-SHA", "DH-RSA-DES-CBC3-SHA", "EDH-DSS-DES-CBC3-SHA", "EDH-RSA-DES-CBC3-SHA", "ECDH-RSA-DES-CBC3-SHA", "ECDH-ECDSA-DES-CBC3-SHA", "ECDHE-RSA-DES-CBC3-SHA", "ECDHE-ECDSA-DES-CBC3-SHA", "DES-CBC3-SHA"]'); --let $TLS_VERSION = TLSv1.2 --source suite/auth_sec/include/wl15800_cipher_test.inc --echo #======================================================================= --echo --echo # Cert type: ECDSA | TLS version: 1.3 --echo TRUNCATE TABLE cipher_data.acceptable; TRUNCATE TABLE cipher_data.blocked; INSERT INTO cipher_data.acceptable VALUES ('["TLS_AES_128_GCM_SHA256", "TLS_AES_256_GCM_SHA384", "TLS_CHACHA20_POLY1305_SHA256", "TLS_AES_128_CCM_SHA256"]'); --let $TLS_VERSION = TLSv1.3 --source suite/auth_sec/include/wl15800_cipher_test.inc --echo --echo #======================================================================= --echo --echo # Cleanup --echo DROP DATABASE cipher_data; DROP USER arthurdent@localhost; --echo --echo #======================================================================= # Wait till we reached the initial number of concurrent sessions --source include/wait_until_count_sessions.inc # Clean slate --source include/force_restart.inc