Debian Codegraph @

mysql-test/suite/x/t/admin_kill_client.test

raw
1 ## Kill client
2
3 --source include/xplugin_preamble.inc
4 --source include/xplugin_create_user.inc
5
6 create user unpriv@localhost;
7 set password for unpriv@localhost = 'x';
8
9 ## Test starts here
10 --let $xtest_file= $MYSQL_TMP_DIR/admin_kill_mysqlx.xpl
11 --write_file $xtest_file
12 -->quiet
13 ## Test data
14
15 -->varlet %CLIENT_ID1% %ACTIVE_CLIENT_ID%
16
17 -->stmtadmin list_clients
18 -->recvresult
19
20 -->stmtadmin list_clients {"what":"all"}
21 -->expecterror ER_X_CMD_INVALID_ARGUMENT
22 -->recvresult
23
24
25 ## create and activate new session
26 -->newsession aux x_root
27
28 -->varlet %CLIENT_ID2% %ACTIVE_CLIENT_ID%
29
30 -->wait_for 2 SELECT COUNT(*) FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' AND (command LIKE 'Sleep%' OR command LIKE 'Query%');
31
32 -->stmtadmin list_clients
33 -->recvresult
34
35 -->echo switched to session default
36 -->setsession
37
38 -->stmtadmin list_clients
39 -->recvresult
40
41 -->stmtadmin kill_client
42 -->expecterror ER_X_CMD_NUM_ARGUMENTS
43 -->recvresult
44
45
46 -->stmtadmin kill_client {"id": %CLIENT_ID2% }
47 -->recvresult
48
49 -->setsession aux
50 -->recvuntildisc show-received
51
52 -->setsession
53 -->wait_for 1 SELECT count(*) FROM information_schema.processlist WHERE user = 'x_root'
54
55 -->stmtadmin list_clients
56 -->recvresult
57
58
59 ### Create a separate session with diff account
60 -->newsession unpriv unpriv x
61
62 -->varlet %CLIENT_ID3% %ACTIVE_CLIENT_ID%
63
64 -->wait_for 1 SELECT COUNT(*) FROM information_schema.processlist WHERE info LIKE 'PLUGIN%' AND (command LIKE 'Sleep%' OR command LIKE 'Query%');
65
66 -->echo Should list unprivs session only
67 -->stmtadmin list_clients
68 -->recvresult
69
70
71 ## Try to kill a x_root session from unpriv
72 -->stmtadmin kill_client {"id": %CLIENT_ID1% }
73 -->expecterror ER_KILL_DENIED_ERROR
74 -->recvresult
75
76 -->echo switched to session default
77 -->setsession
78
79 -->sleep 1;
80
81
82 ## Should list all sessions
83 -->stmtadmin list_clients
84 -->recvresult
85
86
87 ## kill the unpriv session
88 -->stmtadmin kill_client {"id": %CLIENT_ID3% }
89 -->recvresult
90
91 -->setsession unpriv
92 -->recvuntildisc show-received
93
94 -->setsession
95 -->wait_for 1 SELECT count(*) FROM information_schema.processlist WHERE user = 'x_root'
96
97 ## Should list only x_root session
98 -->stmtadmin list_clients
99 -->recvresult
100 EOF
101
102 --replace_regex /([a-z]*.+localhost[ ]+)[0-9]+/\1$SESSION/ /You are not owner of thread [0-9]+/You are not owner of thread/
103 --exec $MYSQLXTEST -ux_root --password='' --file=$xtest_file 2>&1
104
105 ## Cleanup
106 drop user unpriv@localhost;
107 --source ../include/xplugin_cleanup.inc