Debian Codegraph @

mysql-test/suite/x/r/system_variable_enable_hello_notice.result

raw
1
2 ## Test shows that user can DISABLE/ENABLE ServerHello notice
3 ## using 'mysqlx_enable_hello_notice' variable:
4 #
5 # 1. Verify raw connection to X Plugin with ServerHello notice on
6 # 2. Verify raw connection to X Plugin with ServerHello notice off
7 # 3. Verify SSL connection to X Plugin with ServerHello notice on
8 # 4. Verify SSL connection to X Plugin with ServerHello notice off
9 # 5. Unprivileged user fails to change ServerHello notice configuration;
10 #
11 CREATE USER 'some_user' @'localhost' IDENTIFIED WITH 'mysql_native_password';
12
13 #
14 # 1. Raw connection to X Plugin with ServerHello notice on
15 RUN SET GLOBAL mysqlx_enable_hello_notice= TRUE
16
17 0 rows affected
18 connecting...
19 active session is now 'attempt1'
20 Mysqlx.Notice.Frame {
21 type: 5
22 payload: ""
23 }
24
25 Login OK
26
27 #
28 # 2. Raw connection to X Plugin with ServerHello notice off
29 RUN SET GLOBAL mysqlx_enable_hello_notice= FALSE
30
31 0 rows affected
32 connecting...
33 active session is now 'attempt2'
34 Login OK
35
36 #
37 # 3. SSL connection to X Plugin with ServerHello notice on
38 RUN SET GLOBAL mysqlx_enable_hello_notice= TRUE
39
40 0 rows affected
41 connecting...
42 active session is now 'attempt3'
43 Mysqlx.Notice.Frame {
44 type: 5
45 payload: ""
46 }
47
48 send Mysqlx.Connection.CapabilitiesSet {
49 capabilities {
50 capabilities {
51 name: "tls"
52 value {
53 type: SCALAR
54 scalar {
55 type: V_BOOL
56 v_bool: true
57 }
58 }
59 }
60 }
61 }
62
63 Mysqlx.Ok {
64 }
65
66 Login OK
67
68 #
69 # 4. SSL connection to X Plugin with ServerHello notice off
70 RUN SET GLOBAL mysqlx_enable_hello_notice= FALSE
71
72 0 rows affected
73 connecting...
74 active session is now 'attempt4'
75 send Mysqlx.Connection.CapabilitiesSet {
76 capabilities {
77 capabilities {
78 name: "tls"
79 value {
80 type: SCALAR
81 scalar {
82 type: V_BOOL
83 v_bool: true
84 }
85 }
86 }
87 }
88 }
89
90 Mysqlx.Ok {
91 }
92
93 Login OK
94
95 #
96 # 5. Unprivileged user tries to enable ServerHello notice
97 RUN SET GLOBAL mysqlx_enable_hello_notice= FALSE
98
99 0 rows affected
100 connecting...
101 active session is now 'attempt5'
102 RUN SET GLOBAL mysqlx_enable_hello_notice= TRUE
103 While executing SET GLOBAL mysqlx_enable_hello_notice= TRUE:
104 Got expected error: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation (code 1227)
105 closing session attempt5
106 Mysqlx.Ok {
107 msg: "bye!"
108 }
109 ok
110 SET GLOBAL mysqlx_enable_hello_notice= DEFAULT;
111 DROP USER 'some_user' @'localhost';