## 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.xpl -->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.xpl 2>&1; --echo # Verify that TCP is disabled --replace_regex /error: .+:[0-9]+/ERROR: Connection refused connecting to localhost:PORT/ exec $MYSQLXTEST -u x_root --password='' --expect-error 2002 --file=$MYSQL_TMP_DIR/mysqlx-connection_current_user.xpl 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/ exec $MYSQLXTEST -u nonblank --password='nonblank' --expect-error 2002 --file=$MYSQL_TMP_DIR/mysqlx-connection_current_user.xpl 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.xpl 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.xpl 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; --source ../include/xplugin_cleanup.inc