Debian Codegraph @

mysql-test/suite/x/include/connection_user_authentication.inc

raw
1
2 ## Test starts here
3 --let $mysqlxscript_success= $MYSQL_TMP_DIR/connection_mysqlx_user.xpl
4 --let $mysqlxscript_failure= $MYSQL_TMP_DIR/connection_mysqlx_user_failure.xpl
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 -->echo Login with '%OPTION_CLIENT_USER%:%OPTION_CLIENT_PASSWORD%@%OPTION_CLIENT_HOST%/%OPTION_CLIENT_SCHEMA%' should fail
28 -->import connection.macro
29 -->callmacro Verify_its_xprotocol_connection
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