Gecko [ www.jdcpatala.org ]

Name	Size	Permission
access_credential_control-mast...	170 B	-rw-r--r--
access_credential_control.test	27.33 KB	-rw-r--r--
cert_verify.test	2.17 KB	-rw-r--r--
early_plugin_load-master.opt	23 B	-rw-r--r--
early_plugin_load.test	1.17 KB	-rw-r--r--
install_keyring_file-master.op...	73 B	-rw-r--r--
install_keyring_file.test	1.21 KB	-rw-r--r--
key_rotation.test	622 B	-rw-r--r--
key_rotation_qa-master.opt	20 B	-rw-r--r--
key_rotation_qa.test	9.02 KB	-rw-r--r--
key_value_auth-master.opt	170 B	-rw-r--r--
key_value_auth.test	23.04 KB	-rw-r--r--
keyring_file_data-master.opt	93 B	-rw-r--r--
keyring_file_data.test	1.18 KB	-rw-r--r--
keyring_file_data_qa-master.op...	73 B	-rw-r--r--
keyring_file_data_qa.test	2.84 KB	-rw-r--r--
keyring_udf-master.opt	37 B	-rw-r--r--
keyring_udf.test	5.2 KB	-rw-r--r--
multiple_plugins-master.opt	225 B	-rw-r--r--
multiple_plugins.test	505 B	-rw-r--r--
mysql_native_plugin.test	24.09 KB	-rw-r--r--
mysql_no_login-master.opt	20 B	-rw-r--r--
mysql_no_login.test	4.56 KB	-rw-r--r--
mysql_protocol_types.test	6.42 KB	-rw-r--r--
mysql_protocol_types_windows-m...	50 B	-rw-r--r--
mysql_protocol_types_windows.t...	3.38 KB	-rw-r--r--
mysql_sha256_plugin-master.opt	170 B	-rw-r--r--
mysql_sha256_plugin.test	21.21 KB	-rw-r--r--
mysql_ssl_connection-master.op...	35 B	-rw-r--r--
mysql_ssl_connection.test	418 B	-rw-r--r--
mysql_ssl_rsa_setup.test	12.05 KB	-rw-r--r--
named_pipe_ssl-master.opt	26 B	-rw-r--r--
named_pipe_ssl.test	959 B	-rw-r--r--
openssl_cert_generation-master...	39 B	-rw-r--r--
openssl_cert_generation.test	18.35 KB	-rw-r--r--
openssl_cert_generation_debug....	3.91 KB	-rw-r--r--
openssl_cert_generation_subjec...	39 B	-rw-r--r--
openssl_cert_generation_subjec...	3.37 KB	-rw-r--r--
openssl_cert_validity-master.o...	67 B	-rw-r--r--
openssl_cert_validity.test	590 B	-rw-r--r--
openssl_skip_cert_generation-m...	67 B	-rw-r--r--
openssl_skip_cert_generation.t...	2.46 KB	-rw-r--r--
password_expired-master.opt	170 B	-rw-r--r--
password_expired.test	22.89 KB	-rw-r--r--
password_expiry.test	7.69 KB	-rw-r--r--
require_secure_transport.test	3.15 KB	-rw-r--r--
require_secure_transport_windo...	50 B	-rw-r--r--
require_secure_transport_windo...	5.81 KB	-rw-r--r--
secure_file_priv_error.test	1.61 KB	-rw-r--r--
secure_file_priv_null-master.o...	24 B	-rw-r--r--
secure_file_priv_null.test	1.47 KB	-rw-r--r--
secure_file_priv_warnings-mast...	22 B	-rw-r--r--
secure_file_priv_warnings.test	2.18 KB	-rw-r--r--
secure_file_priv_warnings_not_...	1.22 KB	-rw-r--r--
secure_file_priv_warnings_win....	1.45 KB	-rw-r--r--
server_withssl_client_withouts...	405 B	-rw-r--r--
server_withssl_client_withouts...	11.95 KB	-rw-r--r--
server_withssl_client_withssl-...	405 B	-rw-r--r--
server_withssl_client_withssl....	15.89 KB	-rw-r--r--
set_password_deprecated.test	2.67 KB	-rw-r--r--
ssl_auto_detect-master.opt	124 B	-rw-r--r--
ssl_auto_detect.test	5.22 KB	-rw-r--r--
ssl_auto_detect_openssl-master...	118 B	-rw-r--r--
ssl_auto_detect_openssl.test	2.62 KB	-rw-r--r--
ssl_mode.test	9.47 KB	-rw-r--r--
tls.test	4.45 KB	-rw-r--r--
tls12_tls1.test	2.33 KB	-rw-r--r--
wrong_keyring_file_data-master...	90 B	-rw-r--r--
wrong_keyring_file_data.test	806 B	-rw-r--r--

Code Editor : mysql_protocol_types.test

######################## suite/auth_sec/mysql_protocol_types.test #####################
# Connetion Protocols testing with new CONNECTION_TYPE field in P_S.THREADS,audit log #
# and general log.                                                                    #
#                                                                                     #
# Test for WL#7729                                                                    #
# Created : 2015-05-14                                                                #
# Author  : Lalit Choudhary                                                           #
#######################################################################################

# Embedded server doesn't support external clients.
--source include/not_embedded.inc
# Windows does not have SOCKET connection protocol support.
--source include/not_windows.inc
--source include/no_protocol.inc
# Save the initial number of concurrent sessions
--source include/count_sessions.inc
## Connection Protocols: SOCKET, TCP/IP, SSL/TLS BY enabling general log.

--echo # Enabling general logs. Make sure we start with a clean slate.
TRUNCATE TABLE mysql.general_log;

--echo --------------- general log ---------------------------------------

SET @old_log_output=    @@global.log_output;
SET @old_general_log=         @@global.general_log;
SET @old_general_log_file=    @@global.general_log_file;

let $general_file_on = $MYSQLTEST_VARDIR/log/general_connection_protocols.log;
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
eval SET GLOBAL general_log_file = '$general_file_on';
SET GLOBAL log_output =       'FILE,TABLE';
SET GLOBAL general_log=       'ON';

--echo
# Creating users for connection protocols testing.
CREATE USER 'user_tcp'@'127.0.0.1';
GRANT ALL PRIVILEGES ON *.* TO 'user_tcp'@'127.0.0.1';
CREATE USER 'user_ssl'@'127.0.0.1';
GRANT ALL PRIVILEGES ON *.* TO 'user_ssl'@'127.0.0.1';

--echo
--echo # Connection type testing for SOCKET protocol.
connect(socket_con1,localhost,root);

connection default;
disconnect socket_con1;
--source include/wait_until_count_sessions.inc

connect(socket_con2,localhost,root,,,$MASTER_MYPORT);

connection default;
disconnect socket_con2;
--source include/wait_until_count_sessions.inc

connect(socket_con3,localhost,root,,,,$MASTER_MYSOCK);

connection default;
disconnect socket_con3;

# Wait till all disconnects are completed
--source include/wait_until_count_sessions.inc

# For SSL enabled server mysql and mysqladmin should connect using CONNECTION_TYPE: SSL/TLS.
--exec $MYSQLADMIN --host=localhost -S $MASTER_MYSOCK -uroot --ssl-mode=REQUIRED ping
--exec $MYSQLADMIN --host=localhost -S $MASTER_MYSOCK -uroot --ssl-mode=REQUIRED --protocol=SOCKET ping
--echo
# Skipping SSL
--exec $MYSQLADMIN --host=localhost -S $MASTER_MYSOCK -P $MASTER_MYPORT -uroot --ssl-mode=DISABLED --protocol=SOCKET ping

# Mysql client with SSL enabled server.
--exec $MYSQL --host=localhost --user=root --socket=$MASTER_MYSOCK --ssl-mode=REQUIRED --protocol=SOCKET -e "select CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'"
# Skipping SSL
--exec $MYSQL --host=localhost --user=root --socket=$MASTER_MYSOCK --ssl-mode=DISABLED --protocol=SOCKET -e "select CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'"

# Wait till all disconnects are completed
--source include/wait_until_count_sessions.inc

--echo
--echo # Connection type testing for TCP/IP  protocol.

--echo
connect(tcp_con1,127.0.0.1,user_tcp);

connection default;
disconnect tcp_con1;
--source include/wait_until_count_sessions.inc

connect(tcp_con2,127.0.0.1,user_tcp,,,,$MASTER_MYSOCK);

connection default;
disconnect tcp_con2;
--source include/wait_until_count_sessions.inc

--echo # MYSQLADMIN test
# For SSL enabled server mysql and mysqladmin should connect using CONNECTION_TYPE: SSL/TLS.
--exec $MYSQLADMIN --host=127.0.0.1 -S $MASTER_MYSOCK -P $MASTER_MYPORT -uuser_tcp --protocol=TCP ping
# Skipping SSL
--exec $MYSQLADMIN --host=127.0.0.1 -S $MASTER_MYSOCK -P $MASTER_MYPORT -uuser_tcp --ssl-mode=DISABLED --protocol=TCP ping

# Mysql client with SSL enabled server.
--exec $MYSQL --host=localhost --user=root --socket=$MASTER_MYSOCK --protocol=TCP -e "select CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'"
# Skipping SSL
--exec $MYSQL --host=127.0.0.1 --user=user_tcp --socket=$MASTER_MYSOCK --ssl-mode=DISABLED --protocol=TCP -e "select CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'"

--echo
--echo # Testing TCP/IP connections over SSL/TLS.
--echo
connect(ssl_con2,127.0.0.1,user_ssl,,,,,SSL);

connection default;
disconnect ssl_con2;
--source include/wait_until_count_sessions.inc

--echo
connect(ssl_con3,127.0.0.1,user_tcp,,,$MASTER_MYPORT,,SSL);

connection default;
disconnect ssl_con3;
--source include/wait_until_count_sessions.inc

--echo
connect(ssl_con4,127.0.0.1,user_ssl,,,$MASTER_MYPORT,$MASTER_MYSOCK,SSL);

connection default;
disconnect ssl_con4;

# Wait till all disconnects are completed
--source include/wait_until_count_sessions.inc

--echo
--echo # MYSQLADMIN test
# For SSL enabled server mysql and mysqladmin should connect using CONNECTION_TYPE: SSL/TLS.
--exec $MYSQLADMIN --host=127.0.0.1 -S $MASTER_MYSOCK -P $MASTER_MYPORT -uuser_tcp --ssl-mode=REQUIRED  ping
--echo
--exec $MYSQLADMIN --host=127.0.0.1 -S $MASTER_MYSOCK -P $MASTER_MYPORT -uuser_ssl --protocol=TCP --ssl-mode=REQUIRED ping

# Mysql client with SSL enabled server.
--exec $MYSQL --host=localhost --user=root --socket=$MASTER_MYSOCK --ssl-mode=REQUIRED  -e "select CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'"

--exec $MYSQL --host=127.0.0.1 --user=user_ssl --socket=$MASTER_MYSOCK --protocol=TCP --ssl-mode=REQUIRED -e "select CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'"
--echo

CREATE TABLE test_log (argument TEXT);
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
eval LOAD DATA LOCAL INFILE '$general_file_on'
INTO TABLE test_log FIELDS TERMINATED BY '\n' LINES TERMINATED BY '\n';

--echo Show what is logged:
--echo ------ rewrite ------
SELECT argument FROM mysql.general_log where command_type='connect';
--echo ------ done ------

--remove_file $general_file_on
DROP table test_log;

SET GLOBAL general_log_file=  @old_general_log_file;
SET GLOBAL general_log=       @old_general_log;
SET GLOBAL log_output=        @old_log_output;

--echo #Cleanup
DROP USER 'user_tcp'@'127.0.0.1', 'user_ssl'@'127.0.0.1';

${this.title}

Code Editor : mysql_protocol_types.test