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