Debian Codegraph @

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

raw
1 ## This is test file for verification binding on multiple addresses
2 ##
3 --source include/windows.inc
4 --source ../include/have_performance_schema_threads.inc
5 --source include/xplugin_preamble.inc
6
7
8 ## Tests starting here
9
10 --echo
11 --echo
12 --echo ## Table of testing
13 --echo #
14 --echo # 1. localhost bindings
15 --echo # 2. "not existing hosts" bindings
16 --echo # 3. skipped "*" binding
17 --echo # 4. skipped "::" binding
18 --echo # 5. skipped "empty address" binding
19 --echo # 6. skipped "empty network namespace" binding
20 --echo # 7. skipped "wildcard with namespace" binding
21 --echo # 8. skipped "wrong network namespace" binding
22 --echo # 9. skipped "distanthost" binding
23 --echo # 10. default bindings
24 --echo #
25
26 --echo
27 --echo #
28 --echo # 1. localhost bindings
29 --let $expect_bind_address=localhost,::1
30 --let $expect_address=127.0.0.1,::1
31 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
32 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
33
34
35
36 --echo
37 --echo #
38 --echo # 2. "not existing hosts" bindings
39 --let $expect_bind_address=otherhost,anotherhost
40 --let $expect_address=UNDEFINED
41 --let $wait_for_tcpsocket_status = undefined_value
42 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
43 call mtr.add_suppression("Plugin mysqlx reported: 'Value 'otherhost' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
44 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: 'otherhost' port: [0-9]* failed, can't resolve `hostname`'");
45 call mtr.add_suppression("Plugin mysqlx reported: 'Value 'anotherhost' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
46 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: 'anotherhost' port: [0-9]* failed, can't resolve `hostname`'");
47 call mtr.add_suppression("Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'");
48 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
49
50
51
52 --echo
53 --echo #
54 --echo # 3. skipped "*" binding
55 --let $expect_bind_address=*,::1
56 --let $expect_address=::1
57 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
58 call mtr.add_suppression("Plugin mysqlx reported: 'Validation of value '\\*' set to `Mysqlx_bind_address` failed: wildcards are not allowed when there are more than one address. Skipping this value.'");
59 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
60
61
62
63 --echo
64 --echo #
65 --echo # 4. skipped "::" binding
66 --let $expect_bind_address=::,::1
67 --let $expect_address=::1
68 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
69 call mtr.add_suppression("Plugin mysqlx reported: 'Validation of value '::' set to `Mysqlx_bind_address` failed: wildcards are not allowed when there are more than one address. Skipping this value.'");
70 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
71
72
73
74 --echo
75 --echo #
76 --echo # 5. skipped "empty address" binding
77 --let $expect_bind_address=,::1
78 --let $expect_address=::1
79 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
80 call mtr.add_suppression("Plugin mysqlx reported: 'Validation of value '' set to `Mysqlx_bind_address` failed: wildcards are not allowed when there are more than one address. Skipping this value.'");
81 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
82
83
84
85 --echo
86 --echo #
87 --echo # 6. skipped "empty network namespace" binding
88 --let $expect_bind_address=::1/,::1
89 --let $expect_address=::1
90 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
91 call mtr.add_suppression("Plugin mysqlx reported: 'Validation of value '::1/' set to `Mysqlx_bind_address` failed: can't be parsed as an address. Skipping this value.'");
92 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
93
94
95
96 --echo
97 --echo #
98 --echo # 7. skipped "wildcard with namespace" binding
99 --let $expect_bind_address=::/wrong,::1
100 --let $expect_address=::1
101 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
102 call mtr.add_suppression("Plugin mysqlx reported: 'Validation of value '::/wrong' set to `Mysqlx_bind_address` failed: network namespace are not allowed for wildcards. Skipping this value.'");
103 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
104
105
106
107 --echo
108 --echo #
109 --echo # 8. skipped "wrong network namespace" binding
110 --let $expect_bind_address=::1/wrong,::1
111 --let $expect_address=::1
112 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
113 call mtr.add_suppression("Plugin mysqlx reported: 'Value '::1/wrong' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
114 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: '::1/wrong' port: [0-9]* failed, '");
115 call mtr.add_suppression("Plugin mysqlx reported: 'Network Namespaces is not supported on this platform'");
116 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
117
118
119
120 --echo
121 --echo #
122 --echo # 9. skipped "distanthost" binding
123 --let $expect_bind_address=distanthost,::1
124 --let $expect_address=::1
125 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address
126 call mtr.add_suppression("Plugin mysqlx reported: 'Value 'distanthost' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
127 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: 'distanthost' port: [0-9]* failed, can't resolve `hostname`'");
128 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
129
130
131
132 --echo
133 --echo #
134 --echo # 10. default bindings
135 --let $expect_bind_address=*
136 --let $expect_address=::
137 --let $restart_parameters = restart:
138 --source ../include/restart_mysqld_and_verify_bind_addresses.inc
139
140
141 ## Cleanup