Debian Codegraph @

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

raw
1
2
3 ##
4 ## Table of testing
5 #
6 # 1. localhost bindings, skip 127.0.0.1
7 # 2. "skip-networking" bindings
8 # 3. "not existing hosts" bindings
9 # 4. skipped "*" binding
10 # 5. skipped "0.0.0.0" binding
11 # 6. skipped "empty address" binding
12 # 7. skipped "empty network namespace" binding
13 # 8. skipped "wildcard with namespace" binding
14 # 9. skipped "wrong network namespace" binding
15 # 10. skipped "distanthost" binding
16 # 11. "ifconfig" bindings
17 # 12. default bindings
18
19
20 #
21 # 1. localhost bindings, skip 127.0.0.1
22 call mtr.add_suppression("Plugin mysqlx reported: 'Value '127.0.0.1' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
23 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: '127.0.0.1' port: [0-9]* failed, `bind\\(\\)` failed with error: Address already in use \\([0-9]+\\). Do you already have another mysqld server running with Mysqlx \\?'");
24 # restart: --mysqlx_bind_address=localhost,127.0.0.1
25 include/assert.inc [There status variable must point to 127.0.0.1]
26 include/assert.inc [There variable must point to localhost,127.0.0.1]
27
28 #
29 # 2. "skip-networking" bindings
30 # restart: --skip-networking --mysqlx_bind_address=localhost,distanthost
31 include/assert.inc [There status variable must point to UNDEFINED]
32 include/assert.inc [There variable must point to localhost,distanthost]
33
34 #
35 # 3. "not existing hosts" bindings
36 call mtr.add_suppression("Plugin mysqlx reported: 'Value 'otherhost' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
37 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: 'otherhost' port: [0-9]* failed, can't resolve `hostname`'");
38 call mtr.add_suppression("Plugin mysqlx reported: 'Value 'anotherhost' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
39 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: 'anotherhost' port: [0-9]* failed, can't resolve `hostname`'");
40 # restart: --mysqlx_bind_address=otherhost,anotherhost
41 include/assert.inc [There status variable must point to UNDEFINED]
42 include/assert.inc [There variable must point to otherhost,anotherhost]
43
44 #
45 # 4. skipped "*" binding
46 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.'");
47 # restart: --mysqlx_bind_address=*,localhost
48 include/assert.inc [There status variable must point to 127.0.0.1]
49 include/assert.inc [There variable must point to *,localhost]
50
51 #
52 # 5. skipped "0.0.0.0" binding
53 call mtr.add_suppression("Plugin mysqlx reported: 'Validation of value '0.0.0.0' set to `Mysqlx_bind_address` failed: wildcards are not allowed when there are more than one address. Skipping this value.'");
54 # restart: --mysqlx_bind_address=0.0.0.0,localhost
55 include/assert.inc [There status variable must point to 127.0.0.1]
56 include/assert.inc [There variable must point to 0.0.0.0,localhost]
57
58 #
59 # 6. skipped "empty address" binding
60 call mtr.add_suppression("Validation of value '' set to `Mysqlx_bind_address` failed: wildcards are not allowed when there are more than one address. Skipping this value.'");
61 # restart: --mysqlx_bind_address=,localhost
62 include/assert.inc [There status variable must point to 127.0.0.1]
63 include/assert.inc [There variable must point to ,localhost]
64
65 #
66 # 7. skipped "empty network namespace" binding
67 call mtr.add_suppression("Plugin mysqlx reported: 'Validation of value 'localhost/' set to `Mysqlx_bind_address` failed: can't be parsed as an address. Skipping this value.'");
68 # restart: --mysqlx_bind_address=localhost/,localhost
69 include/assert.inc [There status variable must point to 127.0.0.1]
70 include/assert.inc [There variable must point to localhost/,localhost]
71
72 #
73 # 8. skipped "wildcard with namespace" binding
74 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.'");
75 # restart: --mysqlx_bind_address=*/wrong,localhost
76 include/assert.inc [There status variable must point to 127.0.0.1]
77 include/assert.inc [There variable must point to */wrong,localhost]
78
79 #
80 # 9. skipped "wrong network namespace" binding
81 call mtr.add_suppression("Plugin mysqlx reported: 'Value 'localhost/wrong' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
82 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: 'localhost/wrong' port: [0-9]* failed, '");
83 call mtr.add_suppression("Unknown network namespace 'wrong'");
84 call mtr.add_suppression("Plugin mysqlx reported: 'Network Namespaces is not supported on this platform'");
85 # restart: --mysqlx_bind_address=localhost/wrong,localhost
86 include/assert.inc [There status variable must point to 127.0.0.1]
87 include/assert.inc [There variable must point to localhost/wrong,localhost]
88
89 #
90 # 10. skipped "distanthost" binding
91 call mtr.add_suppression("Plugin mysqlx reported: 'Value 'distanthost' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'");
92 call mtr.add_suppression("Plugin mysqlx reported: 'Setup of bind-address: 'distanthost' port: [0-9]* failed, can't resolve `hostname`'");
93 # restart: --mysqlx_bind_address=distanthost,localhost
94 include/assert.inc [There status variable must point to 127.0.0.1]
95 include/assert.inc [There variable must point to distanthost,localhost]
96
97 #
98 # 11. "ifconfig" bindings
99 # restart: --mysqlx_bind_address=$IPs
100 SELECT variable_value FROM performance_schema.global_status WHERE variable_name LIKE "Mysqlx_address" INTO @MYSQLX_ADDRESSES;
101 include/assert.inc [There status variable must point some of $IPs]
102 include/assert.inc [There variable must point to $IPs]
103
104 #
105 # 12. default bindings
106 # restart:
107 include/assert.inc [There status variable must point to ::]
108 include/assert.inc [There variable must point to *]
109 DROP TABLE test.ip;