| 1 |
|
| 2 |
## Test starts here |
| 3 |
--let $mysqlxscript_success= $MYSQL_TMP_DIR/connection_mysqlx_user.tmp |
| 4 |
--let $mysqlxscript_failure= $MYSQL_TMP_DIR/connection_mysqlx_user_failure.tmp |
| 5 |
--let $MYSQLXTEST_LOGIN_SUCCESS= $MYSQLXTEST -uuser1 $USER_CIPHER -f $mysqlxscript_success --schema xtest --fatal-errors=1 |
| 6 |
--let $MYSQLXTEST_LOGIN_FAILURE= $MYSQLXTEST -uuser1 $USER_CIPHER -f $mysqlxscript_failure --schema xtest --fatal-errors=1 --no-auth |
| 7 |
|
| 8 |
--write_file $mysqlxscript_success |
| 9 |
-->stmtsql select current_user(); |
| 10 |
-->recvresult |
| 11 |
|
| 12 |
-->noquery_result |
| 13 |
-->stmtsql select * from `table_all_hosts`; |
| 14 |
-->expecterror %TABLE_ALL_HOSTS_RESULT% |
| 15 |
-->recvresult |
| 16 |
|
| 17 |
-->stmtsql select * from `table_127.0.0.1`; |
| 18 |
-->expecterror %TABLE_127.0.0.1_RESULT% |
| 19 |
-->recvresult |
| 20 |
|
| 21 |
-->stmtsql select * from `table_localhost`; |
| 22 |
-->expecterror %TABLE_LOCALHOST_RESULT% |
| 23 |
-->recvresult |
| 24 |
EOF |
| 25 |
|
| 26 |
--write_file $mysqlxscript_failure |
| 27 |
-->import connection.macro |
| 28 |
-->callmacro Verify_its_xprotocol_connection |
| 29 |
-->echo Login with '%OPTION_CLIENT_USER%:%OPTION_CLIENT_PASSWORD%@%OPTION_CLIENT_HOST%/%OPTION_CLIENT_SCHEMA%' should fail |
| 30 |
-->loginerror %EXPECTED_ERROR% %OPTION_CLIENT_USER% %OPTION_CLIENT_PASSWORD% %OPTION_CLIENT_SCHEMA% |
| 31 |
EOF |
| 32 |
|
| 33 |
call mtr.add_suppression("Plugin mysqlx reported: .*Unsuccessful login attempt: Invalid user or password"); |
| 34 |
|
| 35 |
CREATE DATABASE xtest; |
| 36 |
USE xtest; |
| 37 |
eval CREATE USER user1@'%' IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'pass_all_hosts'; |
| 38 |
eval CREATE USER user1@'127.0.0.1' IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'pass_127.0.0.1'; |
| 39 |
eval CREATE USER user1@'localhost' IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'pass_localhost'; |
| 40 |
|
| 41 |
CREATE TABLE `table_all_hosts`(id integer); |
| 42 |
CREATE TABLE `table_127.0.0.1`(id integer); |
| 43 |
CREATE TABLE `table_localhost`(id integer); |
| 44 |
|
| 45 |
INSERT INTO `table_all_hosts`(id) VALUES(2),(4); |
| 46 |
INSERT INTO `table_127.0.0.1`(id) VALUES(1),(3); |
| 47 |
INSERT INTO `table_localhost`(id) VALUES(5),(6); |
| 48 |
|
| 49 |
GRANT SELECT ON xtest.`table_all_hosts` TO 'user1'@'%'; |
| 50 |
GRANT SELECT ON xtest.`table_127.0.0.1` TO 'user1'@'127.0.0.1'; |
| 51 |
GRANT SELECT ON xtest.`table_localhost` TO 'user1'@'localhost'; |
| 52 |
|
| 53 |
--echo ## |
| 54 |
--echo ## X Plugin should only authenticate 'user1'@'127.0.0.1' account on TCP |
| 55 |
--echo ## |
| 56 |
exec $MYSQLXTEST_LOGIN_SUCCESS -p"pass_127.0.0.1" |
| 57 |
-v%TABLE_ALL_HOSTS_RESULT%=0 |
| 58 |
-v%TABLE_127.0.0.1_RESULT%=0 |
| 59 |
-v%TABLE_LOCALHOST_RESULT%=0; |
| 60 |
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_localhost" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1; |
| 61 |
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_all_hosts" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1; |
| 62 |
|
| 63 |
if ($UNIX_SOCKET_TESTING) |
| 64 |
{ |
| 65 |
--echo ## |
| 66 |
--echo ## X Plugin should only authenticate 'user1'@'localhost' account on UNIX socket |
| 67 |
--echo ## |
| 68 |
exec $MYSQLXTEST_LOGIN_SUCCESS -p"pass_localhost" --socket=$MASTER_X_MYSOCK |
| 69 |
-v%TABLE_ALL_HOSTS_RESULT%=0 |
| 70 |
-v%TABLE_127.0.0.1_RESULT%=ER_TABLEACCESS_DENIED_ERROR |
| 71 |
-v%TABLE_LOCALHOST_RESULT%=0; |
| 72 |
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_127.0.0.1" --socket=$MASTER_X_MYSOCK -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1; |
| 73 |
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_all_hosts" --socket=$MASTER_X_MYSOCK -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1; |
| 74 |
} |
| 75 |
|
| 76 |
DROP USER user1@'127.0.0.1'; |
| 77 |
|
| 78 |
--echo ## |
| 79 |
--echo ## X Plugin should only authenticate 'user1'@'127.0.0.%' account on TCP |
| 80 |
--echo ## |
| 81 |
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_127.0.0.1" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1; |
| 82 |
exec $MYSQLXTEST_LOGIN_SUCCESS -p"pass_localhost" |
| 83 |
-v%TABLE_ALL_HOSTS_RESULT%=0 |
| 84 |
-v%TABLE_127.0.0.1_RESULT%=ER_TABLEACCESS_DENIED_ERROR |
| 85 |
-v%TABLE_LOCALHOST_RESULT%=0; |
| 86 |
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_all_hosts" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1; |
| 87 |
|
| 88 |
DROP USER user1@'localhost'; |
| 89 |
|
| 90 |
--echo ## |
| 91 |
--echo ## X Plugin should only authenticate 'user1'@'%' account on TCP |
| 92 |
--echo ## |
| 93 |
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_127.0.0.1" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1; |
| 94 |
exec $MYSQLXTEST_LOGIN_FAILURE -p"pass_localhost" -v%EXPECTED_ERROR%=ER_ACCESS_DENIED_ERROR 2>&1; |
| 95 |
exec $MYSQLXTEST_LOGIN_SUCCESS -p"pass_all_hosts" |
| 96 |
-v%TABLE_ALL_HOSTS_RESULT%=0 |
| 97 |
-v%TABLE_127.0.0.1_RESULT%=ER_TABLEACCESS_DENIED_ERROR |
| 98 |
-v%TABLE_LOCALHOST_RESULT%=ER_TABLEACCESS_DENIED_ERROR; |
| 99 |
|
| 100 |
## Postamble |
| 101 |
DROP DATABASE xtest; |
| 102 |
|
| 103 |
DROP USER user1@'%'; |
| 104 |
|
| 105 |
--remove_file $mysqlxscript_success |
| 106 |
--remove_file $mysqlxscript_failure |
| 107 |
|