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
|
-- source include/have_log_bin.inc
-- source include/not_windows.inc
CREATE DATABASE db_25380000;
USE db_25380000;
CREATE TABLE t_25380000(a INT);
INSERT INTO t_25380000 VALUES(1);
--echo #MYSQLDUMP
--exec $MYSQL_DUMP --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --databases db_25380000 > $MYSQLTEST_VARDIR/tmp/25380000_dump_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_dump_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #MYSQLIMPORT
--exec $MYSQL_DUMP --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --tab=$MYSQLTEST_VARDIR/tmp/ db_25380000
--exec $MYSQL_IMPORT --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem db_25380000 $MYSQLTEST_VARDIR/tmp/t_25380000.txt > $MYSQLTEST_VARDIR/tmp/25380000_import_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_import_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #MYSQL
--exec $MYSQL --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem -e "SELECT * from db_25380000.t_25380000;" > $MYSQLTEST_VARDIR/tmp/25380000_mysql_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_mysql_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #MYSQLCHECK
--exec $MYSQL_CHECK --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --analyze --databases db_25380000 > $MYSQLTEST_VARDIR/tmp/25380000_mysqlcheck_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_mysqlcheck_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #MYSQLBINLOG
--exec $MYSQL_BINLOG --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --read-from-remote-server binlog.000001 > $MYSQLTEST_VARDIR/tmp/25380000_mysqlbinlog_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_mysqlbinlog_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #MYSQLADMIN
--exec $MYSQLADMIN --no-defaults --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem -S $MASTER_MYSOCK -P $MASTER_MYPORT -uroot ping > $MYSQLTEST_VARDIR/tmp/25380000_mysqladmin_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_mysqladmin_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #MYSQLSHOW
--exec $MYSQL_SHOW --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem db_25380000 > $MYSQLTEST_VARDIR/tmp/25380000_mysqlshow_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_mysqlshow_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #MYSQLSLAP
--exec $MYSQL_SLAP --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem --query="SELECT * from db_25380000.t_25380000" --only-print > $MYSQLTEST_VARDIR/tmp/25380000_mysqlslap_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_mysqlslap_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #MYSQLTEST
--exec echo "SELECT * from db_25380000.t_25380000;" > $MYSQLTEST_VARDIR/tmp/mysqltest.sql
--exec $MYSQL_TEST --ssl-mode=DISABLED --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem < $MYSQLTEST_VARDIR/tmp/mysqltest.sql > $MYSQLTEST_VARDIR/tmp/25380000_mysqltest_result 2> $MYSQLTEST_VARDIR/tmp/25380000_stderr
--cat_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
# Search for warning message in the result file
--let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/25380000_mysqltest_result
--let SEARCH_PATTERN= WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
--source include/search_pattern.inc
--echo #Cleanup
DROP TABLE t_25380000;
DROP DATABASE db_25380000;
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_dump_result
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_import_result
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_mysql_result
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_mysqlcheck_result
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_mysqlbinlog_result
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_mysqladmin_result
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_mysqlshow_result
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_mysqlslap_result
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_mysqltest_result
--remove_file $MYSQLTEST_VARDIR/tmp/mysqltest.sql
--remove_file $MYSQLTEST_VARDIR/tmp/t_25380000.sql
--remove_file $MYSQLTEST_VARDIR/tmp/t_25380000.txt
--remove_file $MYSQLTEST_VARDIR/tmp/25380000_stderr
|
