66 lines
2.3 KiB
Plaintext
66 lines
2.3 KiB
Plaintext
# Test of ipv6 format, especially "change master host=..."
|
|
# Options: --skip-name-resolve, master: --bind-address=::, slave: --bind-address=0.0.0.0
|
|
# (see corresponding cnf file)
|
|
#
|
|
|
|
--source include/check_ipv6.inc
|
|
--source include/have_log_bin.inc
|
|
|
|
--let $extra_root_users_for_slave= 1
|
|
--source include/add_extra_root_users.inc
|
|
|
|
let $IPv6= ::1;
|
|
--echo #################### IP: $IPv6 ###########################
|
|
--source include/rpl_ip_mix.inc
|
|
|
|
let $IPv6= ::1/128;
|
|
#--echo #################### IP: $IPv6 ###########################
|
|
#--source include/rpl_ip_mix.inc
|
|
|
|
let $IPv6= 0000:0000:0000:0000:0000:0000:0000:0001;
|
|
--echo #################### IP: $IPv6 ###########################
|
|
--source include/rpl_ip_mix.inc
|
|
|
|
let $IPv6= 0:0:0:0:0:0:0:1;
|
|
--echo #################### IP: $IPv6 ###########################
|
|
--source include/rpl_ip_mix.inc
|
|
|
|
let $IPv6= ::1;
|
|
--echo #################### IP: $IPv6 mix #######################
|
|
--echo connect (master,$IPv6,root,,test,MASTER_MYPORT);
|
|
connect (master,$IPv6,root,,test,$MASTER_MYPORT);
|
|
--echo connect (slave,127.0.0.1,root,,test,SLAVE_MYPORT);
|
|
connect (slave,127.0.0.1,root,,test,$SLAVE_MYPORT);
|
|
--echo connection master;
|
|
connection master;
|
|
reset master;
|
|
source include/show_master_status.inc;
|
|
--echo connection slave;
|
|
connection slave;
|
|
reset slave;
|
|
let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
|
|
--echo Master-Host: $master_host
|
|
eval change master to master_host='$IPv6';
|
|
let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
|
|
--echo Master-Host: $master_host
|
|
eval change master to master_host='127.0.0.1';
|
|
let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
|
|
--echo Master-Host: $master_host
|
|
eval change master to master_host='0:0:0:0:0:0:0:1';
|
|
let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
|
|
--echo Master-Host: $master_host
|
|
|
|
# clean up
|
|
--replace_column 2 ####
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root';
|
|
|
|
# Current master connects using $IPv6= ::1. This user happens to be deleted
|
|
# first in the inc file below. With WL#12098, the current user loses
|
|
# the ability to delete other users if it deletes itself first.
|
|
# Therefore, connecting with user which is deleted in the end.
|
|
connect (master_IPv4,127.0.0.1,root,,test,$MASTER_MYPORT);
|
|
--source include/remove_extra_root_users.inc
|
|
|
|
--connection master
|
|
--source suite/xengine/include/check_xengine_log_error.inc
|