Gecko [ www.jdcpatala.org ]

Name	Size	Permission
admin_list_objects_table_names...	1.86 KB	-rw-r--r--
connection_default_schema.inc	374 B	-rw-r--r--
connection_ssl.inc	14.67 KB	-rw-r--r--
connection_user_authentication...	4.36 KB	-rw-r--r--
have_performance_schema_thread...	212 B	-rw-r--r--
is_local_machine.inc	107 B	-rw-r--r--
mysqlxtest_expected_error.inc	713 B	-rw-r--r--
mysqlxtest_macro_dir.inc	509 B	-rw-r--r--
performance_schema_assert_empt...	3.87 KB	-rw-r--r--
restart_mysqld_and_wait_for_xp...	409 B	-rw-r--r--
restart_mysqld_pipe.inc	1.52 KB	-rw-r--r--
wait_until_connected_again_pip...	782 B	-rw-r--r--
xplugin_install_and_wait.inc	910 B	-rw-r--r--
xplugin_pfs_instruments_enable...	294 B	-rw-r--r--
xplugin_pfs_instruments_query....	998 B	-rw-r--r--
xplugin_preamble.inc	1.07 KB	-rw-r--r--
xplugin_wait_for_interfaces.in...	1.43 KB	-rw-r--r--

Code Editor : connection_user_authentication.inc

--source ../include/xplugin_preamble.inc

## Test starts here
--let $mysqlxscript_success= $MYSQL_TMP_DIR/connection_mysqlx_user.tmp
--let $mysqlxscript_failure= $MYSQL_TMP_DIR/connection_mysqlx_user_failure.tmp
--let $MYSQLXTEST_LOGIN_SUCCESS= $MYSQLXTEST -uuser1 -f $mysqlxscript_success --schema xtest --fatal-errors=1
--let $MYSQLXTEST_LOGIN_FAILURE= $MYSQLXTEST -uuser1 -f $mysqlxscript_failure --schema xtest --fatal-errors=1 --no-auth

--write_file $mysqlxscript_success
-->stmtsql select current_user();
-->recvresult

-->noquery_result
-->stmtsql select * from `table_all_hosts`;
-->expecterror %TABLE_ALL_HOSTS_RESULT%
-->recvresult

-->stmtsql select * from `table_127.0.0.1`;
-->expecterror %TABLE_127.0.0.1_RESULT%
-->recvresult

-->stmtsql select * from `table_localhost`;
-->expecterror %TABLE_LOCALHOST_RESULT%
-->recvresult
EOF

--write_file $mysqlxscript_failure
-->echo Login with '%OPTION_CLIENT_USER%:%OPTION_CLIENT_PASSWORD%@%OPTION_CLIENT_HOST%/%OPTION_CLIENT_SCHEMA%' should fail
-->loginerror %EXPECTED_ERROR%	%OPTION_CLIENT_USER%	%OPTION_CLIENT_PASSWORD%	%OPTION_CLIENT_SCHEMA%
EOF

call mtr.add_suppression("Plugin mysqlx reported: .*Unsuccessful login attempt: Invalid user or password");

CREATE DATABASE xtest;
USE xtest;
CREATE USER user1@'%'         IDENTIFIED BY 'pass_all_hosts';
CREATE USER user1@'127.0.0.1' IDENTIFIED BY 'pass_127.0.0.1';
CREATE USER user1@'localhost' IDENTIFIED BY 'pass_localhost';

CREATE TABLE `table_all_hosts`(id integer);
CREATE TABLE `table_127.0.0.1`(id integer);
CREATE TABLE `table_localhost`(id integer);

INSERT INTO `table_all_hosts`(id) VALUES(2),(4);
INSERT INTO `table_127.0.0.1`(id) VALUES(1),(3);
INSERT INTO `table_localhost`(id) VALUES(5),(6);

GRANT SELECT ON xtest.`table_all_hosts` TO 'user1'@'%';
GRANT SELECT ON xtest.`table_127.0.0.1` TO 'user1'@'127.0.0.1';
GRANT SELECT ON xtest.`table_localhost` TO 'user1'@'localhost';

--echo ##
--echo ## X Plugin should only authenticate 'user1'@'127.0.0.1' account on TCP
--echo ##
exec $MYSQLXTEST_LOGIN_SUCCESS -p"pass_127.0.0.1"
                           -v%TABLE_ALL_HOSTS_RESULT%=0
                           -v%TABLE_127.0.0.1_RESULT%=0
                           -v%TABLE_LOCALHOST_RESULT%=0;
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_localhost" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1;
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_all_hosts" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1;

if (`select convert(@@version_compile_os using latin1) IN ("Win32","Win64","Windows") = 0`)
{
--echo ##
--echo ## X Plugin should only authenticate 'user1'@'localhost' account on UNIX socket
--echo ##
exec $MYSQLXTEST_LOGIN_SUCCESS -p"pass_localhost" --socket=$MASTER_X_MYSOCK
                           -v%TABLE_ALL_HOSTS_RESULT%=0
                           -v%TABLE_127.0.0.1_RESULT%=ER_TABLEACCESS_DENIED_ERROR
                           -v%TABLE_LOCALHOST_RESULT%=0;
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_127.0.0.1" --socket=$MASTER_X_MYSOCK -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1;
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_all_hosts" --socket=$MASTER_X_MYSOCK -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1;
}

DROP USER user1@'127.0.0.1';

--echo ##
--echo ## X Plugin should only authenticate 'user1'@'127.0.0.%' account on TCP
--echo ##
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_127.0.0.1" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1;
exec $MYSQLXTEST_LOGIN_SUCCESS -p"pass_localhost"
                           -v%TABLE_ALL_HOSTS_RESULT%=0
                           -v%TABLE_127.0.0.1_RESULT%=ER_TABLEACCESS_DENIED_ERROR
                           -v%TABLE_LOCALHOST_RESULT%=0;
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_all_hosts" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1;

DROP USER user1@'localhost';

--echo ##
--echo ## X Plugin should only authenticate 'user1'@'%' account on TCP
--echo ##
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_127.0.0.1" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1;
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_localhost" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1;
exec $MYSQLXTEST_LOGIN_SUCCESS -p"pass_all_hosts"
                           -v%TABLE_ALL_HOSTS_RESULT%=0
                           -v%TABLE_127.0.0.1_RESULT%=ER_TABLEACCESS_DENIED_ERROR
                           -v%TABLE_LOCALHOST_RESULT%=ER_TABLEACCESS_DENIED_ERROR;

## Postamble
DROP DATABASE xtest;

DROP USER user1@'%';

--remove_file $mysqlxscript_success
--remove_file $mysqlxscript_failure

UNINSTALL PLUGIN `mysqlx`;

${this.title}

Code Editor : connection_user_authentication.inc