Debian Codegraph @

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

raw
1 call mtr.add_suppression("Maximum number of authentication attempts reached");
2 call mtr.add_suppression("Access denied for user .*");
3
4
5 #
6 ## Execute three "PLAIN" authentications
7 ## checking severity of returned errors (last one must be FATAL)
8 #
9 connecting...
10 active session is now 'seq'
11 Mysqlx.Ok {
12 }
13
14
15 # First authentication attempt
16 send Mysqlx.Session.AuthenticateStart {
17 mech_name: "PLAIN"
18 auth_data: "test\000not_existing_user\000invalid_password"
19 }
20
21 Mysqlx.Error(severity) = ERROR
22
23 # Second authentication attempt
24 send Mysqlx.Session.AuthenticateStart {
25 mech_name: "PLAIN"
26 auth_data: "test\000not_existing_user\000invalid_password"
27 }
28
29 Mysqlx.Error(severity) = ERROR
30
31 # Third authentication attempt (last one)
32 send Mysqlx.Session.AuthenticateStart {
33 mech_name: "PLAIN"
34 auth_data: "test\000not_existing_user\000invalid_password"
35 }
36
37 Mysqlx.Error(severity) = FATAL
38 closing session seq
39 switched to session default
40 Mysqlx.Ok {
41 msg: "bye!"
42 }
43 ok
44
45
46 #
47 ## Execute three "SHA256_MEMORY" authentications
48 ## checking severity of returned errors (last one must be FATAL)
49 #
50 connecting...
51 active session is now 'seq'
52 Mysqlx.Ok {
53 }
54
55
56 # First authentication attempt
57 send Mysqlx.Session.AuthenticateStart {
58 mech_name: "SHA256_MEMORY"
59 }
60
61 Mysqlx.Session.AuthenticateContinue {...}
62 send Mysqlx.Session.AuthenticateContinue {
63 auth_data: "test\000not_existing_user\000invalid_scramble"
64 }
65
66 Mysqlx.Error(severity) = ERROR
67
68 # Second authentication attempt
69 send Mysqlx.Session.AuthenticateStart {
70 mech_name: "SHA256_MEMORY"
71 }
72
73 Mysqlx.Session.AuthenticateContinue {...}
74 send Mysqlx.Session.AuthenticateContinue {
75 auth_data: "test\000not_existing_user\000invalid_scramble"
76 }
77
78 Mysqlx.Error(severity) = ERROR
79
80 # Third authentication attempt (last one)
81 send Mysqlx.Session.AuthenticateStart {
82 mech_name: "SHA256_MEMORY"
83 }
84
85 Mysqlx.Session.AuthenticateContinue {...}
86 send Mysqlx.Session.AuthenticateContinue {
87 auth_data: "test\000not_existing_user\000invalid_scramble"
88 }
89
90 Mysqlx.Error(severity) = FATAL
91 closing session seq
92 switched to session default
93 Mysqlx.Ok {
94 msg: "bye!"
95 }
96 ok
97
98
99 #
100 ## Execute three mixed authentications
101 ## checking severity of returned errors (last one must be FATAL)
102 #
103 connecting...
104 active session is now 'seq'
105 Mysqlx.Ok {
106 }
107
108
109 # First authentication attempt
110 send Mysqlx.Session.AuthenticateStart {
111 mech_name: "MYSQL41"
112 }
113
114 Mysqlx.Session.AuthenticateContinue {...}
115 send Mysqlx.Session.AuthenticateContinue {
116 auth_data: "test\000not_existing_user\000invalid_scramble"
117 }
118
119 Mysqlx.Error(severity) = ERROR
120
121 # Second authentication attempt
122 send Mysqlx.Session.AuthenticateStart {
123 mech_name: "SHA256_MEMORY"
124 }
125
126 Mysqlx.Session.AuthenticateContinue {...}
127 send Mysqlx.Session.AuthenticateContinue {
128 auth_data: "test\000not_existing_user\000invalid_scramble"
129 }
130
131 Mysqlx.Error(severity) = ERROR
132
133 # Third authentication attempt (last one)
134 send Mysqlx.Session.AuthenticateStart {
135 mech_name: "MYSQL41"
136 }
137
138 Mysqlx.Session.AuthenticateContinue {...}
139 send Mysqlx.Session.AuthenticateContinue {
140 auth_data: "test\000not_existing_user\000invalid_scramble"
141 }
142
143 Mysqlx.Error(severity) = FATAL
144 closing session seq
145 switched to session default
146 Mysqlx.Ok {
147 msg: "bye!"
148 }
149 ok
150
151
152 #
153 ## Execute "SHA256_MEMORY", "MYSQL41", "PLAIN"
154 ## checking severity of returned errors (last one must be FATAL)
155 #
156 connecting...
157 active session is now 'seq'
158 Mysqlx.Ok {
159 }
160
161
162 # First authentication attempt
163 send Mysqlx.Session.AuthenticateStart {
164 mech_name: "SHA256_MEMORY"
165 }
166
167 Mysqlx.Session.AuthenticateContinue {...}
168 send Mysqlx.Session.AuthenticateContinue {
169 auth_data: "test\000not_existing_user\000invalid_scramble"
170 }
171
172 Mysqlx.Error(severity) = ERROR
173
174 # Second authentication attempt
175 send Mysqlx.Session.AuthenticateStart {
176 mech_name: "MYSQL41"
177 }
178
179 Mysqlx.Session.AuthenticateContinue {...}
180 send Mysqlx.Session.AuthenticateContinue {
181 auth_data: "test\000not_existing_user\000invalid_scramble"
182 }
183
184 Mysqlx.Error(severity) = ERROR
185
186 # Third authentication attempt (last one)
187 send Mysqlx.Session.AuthenticateStart {
188 mech_name: "PLAIN"
189 auth_data: "test\000not_existing_user\000invalid_password"
190 }
191
192 Mysqlx.Error(severity) = FATAL
193 closing session seq
194 switched to session default
195 Mysqlx.Ok {
196 msg: "bye!"
197 }
198 ok
199
200
201 #
202 ## Verify that AuthenticateContinue message instead AuthStart
203 ## will trigger FATAL error and disconnection
204 #
205 send Mysqlx.Session.AuthenticateContinue {
206 auth_data: "not meaningful field payload"
207 }
208
209 Mysqlx.Error(severity) = FATAL
210 ok
211
212
213 #
214 ## Verify that StmtExecute message instead AuthStart
215 ## will trigger FATAL error and disconnection
216 #
217 send Mysqlx.Sql.StmtExecute {
218 stmt: "not meaningful field payload"
219 }
220
221 Mysqlx.Error(severity) = FATAL
222 ok