## This is test file for verification binding on multiple addresses ## --source include/windows.inc --source ../include/have_performance_schema_threads.inc --source include/xplugin_preamble.inc ## Tests starting here --echo --echo --echo ## Table of testing --echo # --echo # 1. localhost bindings --echo # 2. "not existing hosts" bindings --echo # 3. skipped "*" binding --echo # 4. skipped "::" binding --echo # 5. skipped "empty address" binding --echo # 6. skipped "empty network namespace" binding --echo # 7. skipped "wildcard with namespace" binding --echo # 8. skipped "wrong network namespace" binding --echo # 9. skipped "distanthost" binding --echo # 10. default bindings --echo # --echo --echo # --echo # 1. localhost bindings --let $expect_bind_address=localhost,::1 --let $expect_address=127.0.0.1,::1 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 2. "not existing hosts" bindings --let $expect_bind_address=otherhost,anotherhost --let $expect_address=UNDEFINED --let $wait_for_tcpsocket_status = undefined_value --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address 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`'"); call mtr.add_suppression("Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'"); --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 3. skipped "*" binding --let $expect_bind_address=*,::1 --let $expect_address=::1 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address 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.'"); --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 4. skipped "::" binding --let $expect_bind_address=::,::1 --let $expect_address=::1 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address 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.'"); --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 5. skipped "empty address" binding --let $expect_bind_address=,::1 --let $expect_address=::1 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address 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.'"); --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 6. skipped "empty network namespace" binding --let $expect_bind_address=::1/,::1 --let $expect_address=::1 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address 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.'"); --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 7. skipped "wildcard with namespace" binding --let $expect_bind_address=::/wrong,::1 --let $expect_address=::1 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address 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.'"); --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 8. skipped "wrong network namespace" binding --let $expect_bind_address=::1/wrong,::1 --let $expect_address=::1 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address 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("Plugin mysqlx reported: 'Network Namespaces is not supported on this platform'"); --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 9. skipped "distanthost" binding --let $expect_bind_address=distanthost,::1 --let $expect_address=::1 --let $restart_parameters = restart: --mysqlx_bind_address=$expect_bind_address 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`'"); --source ../include/restart_mysqld_and_verify_bind_addresses.inc --echo --echo # --echo # 10. default bindings --let $expect_bind_address=* --let $expect_address=:: --let $restart_parameters = restart: --source ../include/restart_mysqld_and_verify_bind_addresses.inc ## Cleanup