/usr/lib/mysql-testsuite/include/wl6301.inc is in percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 | --source include/not_windows.inc
--perl
my $MYSQL = $ENV{'MYSQL'};
my $MYSQLADMIN = $ENV{'MYSQLADMIN'};
my $MASTER_MYPORT = $ENV{'MASTER_MYPORT'};
my $MYSQLTEST_VARDIR = $ENV{'MYSQLTEST_VARDIR'};
my $LOG_FILE = $ENV{'WL6301_LOG_FILE'};
my @ipv4_addresses = split (/\n/, `ifconfig | grep 'inet addr' | sed 's/^.*inet addr://' | sed 's/ .*\$//'`);
my @ipv6_addresses = split (/\n/, `ifconfig | grep 'inet6 addr.*Scope:Global' | sed 's/^.*inet6 addr: //' | sed 's/ .*\$//' | sed 's|/.*\$||'`);
push (@ipv6_addresses, '::1');
open (LOGFH, ">$LOG_FILE") or
die "Can not open '$LOG_FILE': $!\n";
my $ipv4_failed = 0;
foreach my $ip (@ipv4_addresses)
{
print LOGFH "- ipv4: '$ip'\n";
my $rc =
system(
"$MYSQL " .
"--host=127.0.0.1 " .
"--port=$MASTER_MYPORT " .
"--user=root " .
"test " .
"-e 'GRANT ALL PRIVILEGES ON test.* TO u1@$ip;'");
print LOGFH " GRANT status: $rc\n";
$ipv4_failed |= $rc;
$rc =
system(
"$MYSQLADMIN " .
"--host=$ip " .
"--port=$MASTER_MYPORT " .
"--user=u1 " .
"ping > /dev/null 2>&1");
print LOGFH " Connect u1@$ip status: $rc\n";
$ipv4_failed |= $rc;
$rc =
system(
"$MYSQL " .
"--host=127.0.0.1 " .
"--port=$MASTER_MYPORT " .
"--user=root " .
"test " .
"-e 'DROP USER u1@$ip;'");
print LOGFH " DROP USER status: $rc\n";
$ipv4_failed |= $rc;
}
my $ipv6_failed = 0;
foreach my $ip (@ipv6_addresses)
{
print LOGFH "- ipv6: '$ip'\n";
my $rc =
system(
"$MYSQL " .
"--host=127.0.0.1 " .
"--port=$MASTER_MYPORT " .
"--user=root " .
"test " .
"-e 'GRANT ALL PRIVILEGES ON test.* TO u1@$ip;'");
print LOGFH " GRANT status: $rc\n";
$ipv6_failed |= $rc;
$rc =
system(
"$MYSQLADMIN " .
"--host=$ip " .
"--port=$MASTER_MYPORT " .
"--user=u1 " .
"ping > /dev/null 2>&1");
print LOGFH " Connect u1@$ip status: $rc\n";
$ipv6_failed |= $rc;
$rc =
system(
"$MYSQL " .
"--host=127.0.0.1 " .
"--port=$MASTER_MYPORT " .
"--user=root " .
"test " .
"-e 'DROP USER u1@$ip;'");
print LOGFH " DROP USER status: $rc\n";
$ipv6_failed |= $rc;
}
close LOGFH;
unless ($ipv4_failed)
{
print "IPv4 connectivity: OK\n";
}
else
{
print "IPv4 connectivity: FAIL\n";
}
unless ($ipv6_failed)
{
print "IPv6 connectivity: OK\n";
}
else
{
print "IPv6 connectivity: FAIL\n";
}
EOF
|