Gecko [ www.jdcpatala.org ]

Name	Size	Permission
access_credential_control.resu...	23.21 KB	-rw-r--r--
cert_verify.result	304 B	-rw-r--r--
early_plugin_load.result	789 B	-rw-r--r--
have_mysql_upgrade.result	21 B	-rw-r--r--
have_ssl.require	33 B	-rw-r--r--
install_keyring.result	263 B	-rw-r--r--
install_keyring_file.result	979 B	-rw-r--r--
key_rotation.result	427 B	-rw-r--r--
key_rotation_qa.result	7.57 KB	-rw-r--r--
key_value_auth.result	13 KB	-rw-r--r--
keyring_file.result	479 B	-rw-r--r--
keyring_file_data.result	1.17 KB	-rw-r--r--
keyring_file_data_qa.result	2.66 KB	-rw-r--r--
keyring_udf.result	29.95 KB	-rw-r--r--
multiple_plugins.result	5.46 KB	-rw-r--r--
mysql_native_plugin.result	10.46 KB	-rw-r--r--
mysql_no_login.result	2.03 KB	-rw-r--r--
mysql_protocol_types.result	2.38 KB	-rw-r--r--
mysql_protocol_types_windows.r...	1.93 KB	-rw-r--r--
mysql_sha256_plugin.result	9.84 KB	-rw-r--r--
mysql_ssl_connection.result	202 B	-rw-r--r--
mysql_ssl_rsa_setup.result	1.4 KB	-rw-r--r--
named_pipe_ssl.result	255 B	-rw-r--r--
not_embedded.require	16 B	-rw-r--r--
not_openssl.require	36 B	-rw-r--r--
not_ssl.require	32 B	-rw-r--r--
openssl.require	37 B	-rw-r--r--
openssl_cert_generation.result	7.37 KB	-rw-r--r--
openssl_cert_generation_debug....	577 B	-rw-r--r--
openssl_cert_generation_subjec...	435 B	-rw-r--r--
openssl_cert_validity.result	109 B	-rw-r--r--
openssl_skip_cert_generation.r...	442 B	-rw-r--r--
password_expired.result	16.4 KB	-rw-r--r--
password_expiry.result	8.09 KB	-rw-r--r--
require_secure_transport.resul...	1.49 KB	-rw-r--r--
require_secure_transport_windo...	2.08 KB	-rw-r--r--
secure_file_priv_error.result	358 B	-rw-r--r--
secure_file_priv_null.result	1.08 KB	-rw-r--r--
secure_file_priv_warnings.resu...	876 B	-rw-r--r--
secure_file_priv_warnings_not_...	582 B	-rw-r--r--
secure_file_priv_warnings_win....	454 B	-rw-r--r--
server_withssl_client_withouts...	6.18 KB	-rw-r--r--
server_withssl_client_withssl....	6.08 KB	-rw-r--r--
set_password_deprecated.result	4.76 KB	-rw-r--r--
ssl_auto_detect.result	1.82 KB	-rw-r--r--
ssl_auto_detect_openssl.result	361 B	-rw-r--r--
ssl_mode.result	5.16 KB	-rw-r--r--
tls.result	1.25 KB	-rw-r--r--
tls12_tls1.result	510 B	-rw-r--r--
wrong_keyring_file.result	166 B	-rw-r--r--
wrong_keyring_file_data.result	731 B	-rw-r--r--

Code Editor : ssl_mode.result

CREATE USER 'user1'@'%' require ssl;
grant all on *.* to 'user1'@'%' ;
# Testing of all clients with ssl mode PREFERRED
mysql.user                                         OK
Database: mysql  Table: user  Wildcard: user
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type     | Collation | Null | Key | Default | Extra | Privileges                      | Comment |
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
| User  | char(32) | utf8_bin  | NO   | PRI |         |       | select,insert,update,references |         |
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
mysql.test: Records: 1  Deleted: 0  Skipped: 0  Warnings: 1
# Testing of all clients with ssl mode REQUIRED
mysql.user                                         OK
Database: mysql  Table: user  Wildcard: user
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type     | Collation | Null | Key | Default | Extra | Privileges                      | Comment |
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
| User  | char(32) | utf8_bin  | NO   | PRI |         |       | select,insert,update,references |         |
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
mysql.test: Records: 1  Deleted: 0  Skipped: 0  Warnings: 1
# Testing of all clients with ssl mode VERIFY_CA
mysql.user                                         OK
Database: mysql  Table: user  Wildcard: user
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type     | Collation | Null | Key | Default | Extra | Privileges                      | Comment |
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
| User  | char(32) | utf8_bin  | NO   | PRI |         |       | select,insert,update,references |         |
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
mysql.test: Records: 1  Deleted: 0  Skipped: 0  Warnings: 1
# Testing of all clients with ssl mode VERIFY_IDENTITY
mysql.user                                         OK
Database: mysql  Table: user  Wildcard: user
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type     | Collation | Null | Key | Default | Extra | Privileges                      | Comment |
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
| User  | char(32) | utf8_bin  | NO   | PRI |         |       | select,insert,update,references |         |
+-------+----------+-----------+------+-----+---------+-------+---------------------------------+---------+
mysql.test: Records: 1  Deleted: 0  Skipped: 0  Warnings: 1
# Tests related to deprecation of ssl options
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.
WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
ERROR 1045 (28000): Access denied for user 'user1'@'localhost' (using password: NO)
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
WARNING: --ssl-verify-server-cert is deprecated and will be removed in a future version. Use --ssl-mode=VERIFY_IDENTITY instead.
# Tests related to invalid option of --ssl-mode
# Tests related to valid values of --ssl-mode
Variable_name	Value
Ssl_cipher	
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
# Check behavior when --ssl-mode is not passed explicitly
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
# Check behavior when multiple times --ssl-mode is passed
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
# Check the legacy options
Variable_name	Value
Ssl_cipher	
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.
ERROR 2026 (HY000): SSL connection error: SSL_CTX_set_default_verify_paths failed
Variable_name	Value
Ssl_cipher	DHE-RSA-AES256-SHA
WARNING: --ssl-verify-server-cert is deprecated and will be removed in a future version. Use --ssl-mode=VERIFY_IDENTITY instead.
WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
WARNING: --ssl-verify-server-cert is deprecated and will be removed in a future version. Use --ssl-mode=VERIFY_IDENTITY instead.
ERROR 2026 (HY000): SSL connection error: SSL_CTX_set_default_verify_paths failed
# Cleanup
DROP USER 'user1'@'%';
DROP TABLE mysql.test;

${this.title}

Code Editor : ssl_mode.result