71 lines
2.7 KiB
Plaintext
71 lines
2.7 KiB
Plaintext
## This is test file for connection authentication using mysqlx.
|
|
##
|
|
--source include/not_windows.inc
|
|
--source include/xplugin_preamble.inc
|
|
--source include/xplugin_create_user.inc
|
|
|
|
create user nonblank@localhost identified by 'nonblank';
|
|
|
|
--write_file $MYSQL_TMP_DIR/mysqlx-connection_current_user.tmp
|
|
-->sql
|
|
select user(),current_user(),@@bind_address;
|
|
-->endsql
|
|
EOF
|
|
|
|
--echo Test starts here
|
|
--disable_query_log
|
|
--disable_result_log
|
|
let $restart_parameters = restart: --skip-networking;
|
|
let $XPLUGIN_SOCKET=$MASTER_X_MYSOCK;
|
|
|
|
--replace_regex /restart: .+$XPLUGIN_SOCKE/restart: --skip-networking/
|
|
--let $wait_for_tcpsocket_status = undefined_value
|
|
--source include/restart_mysqld.inc
|
|
|
|
--enable_query_log
|
|
--enable_result_log
|
|
|
|
--echo # Verify that UNIX socket connection still works
|
|
--exec $MYSQLXTEST -u x_root --password='' --socket=$XPLUGIN_SOCKET --file=$MYSQL_TMP_DIR/mysqlx-connection_current_user.tmp 2>&1
|
|
|
|
--echo # Verify that TCP is disabled
|
|
--replace_regex /ERROR: .+:[0-9]+/ERROR: Connection refused connecting to localhost:PORT/
|
|
--error 1
|
|
--exec $MYSQLXTEST -u x_root --password='' --file=$MYSQL_TMP_DIR/mysqlx-connection_current_user.tmp 2>&1
|
|
|
|
--echo # Try login using mysqlx protocol when server started with skip-networking options and mysqlx loaded with non super user
|
|
--replace_regex /ERROR: .+:[0-9]+/ERROR: Connection refused connecting to localhost:PORT/
|
|
--error 1
|
|
--exec $MYSQLXTEST -u nonblank --password='nonblank' --file=$MYSQL_TMP_DIR/mysqlx-connection_current_user.tmp 2>&1
|
|
|
|
|
|
call mtr.add_suppression("Plugin mysqlx reported: .Preparation of I/O interfaces failed, X Protocol won't be accessible");
|
|
call mtr.add_suppression("Plugin mysqlx reported: .X Plugin failed to setup .+ .., with:");
|
|
call mtr.add_suppression("Plugin mysqlx reported: .+ path is empt");
|
|
call mtr.add_suppression("Plugin mysqlx reported: .+ is set to empty text");
|
|
let $restart_parameters = $restart_parameters --loose-mysqlx-socket=;
|
|
--replace_regex /restart: .+--loose-mysqlx-socket=/restart: --skip-networking --loose-mysqlx-socket=/
|
|
--let $wait_for_tcpsocket_status = undefined_value
|
|
--let $wait_for_unixsocket_status = undefined_value
|
|
--source include/restart_mysqld.inc
|
|
|
|
--disable_result_log
|
|
--echo # Verify that TCP is disabled
|
|
--error 1
|
|
--exec $MYSQLXTEST -u x_root --password='' --file=$MYSQL_TMP_DIR/mysqlx-connection_current_user.tmp 2>&1
|
|
|
|
--echo # Verify that UNIX socket is disabled
|
|
--error 1
|
|
--exec $MYSQLXTEST -u x_root --password='' --socket=$XPLUGIN_SOCKET --file=$MYSQL_TMP_DIR/mysqlx-connection_current_user.tmp 2>&1
|
|
|
|
--disable_query_log
|
|
let $restart_parameters = restart:;
|
|
--source include/restart_mysqld.inc
|
|
--enable_query_log
|
|
--enable_result_log
|
|
|
|
## Cleanup
|
|
drop user nonblank@localhost;
|
|
--remove_file $MYSQL_TMP_DIR/mysqlx-connection_current_user.tmp
|
|
--source include/xplugin_drop_user.inc
|