Debian Codegraph @

mysql-test/suite/ndb/t/ndb_encrypted_backup.test

raw
1 -- source include/have_ndb.inc
2 -- source suite/ndb/include/backup_restore_setup.inc
3
4 set @windows = convert(@@version_compile_os using latin1)
5 in ('Win32', 'Win64', 'Windows');
6
7 CREATE TABLE t1(k int not null primary key auto_increment) engine=ndb;
8
9 INSERT INTO t1 VALUES (NULL);
10
11 INSERT INTO t1 SELECT NULL FROM t1;
12 INSERT INTO t1 SELECT NULL FROM t1;
13 INSERT INTO t1 SELECT NULL FROM t1;
14 INSERT INTO t1 SELECT NULL FROM t1;
15
16
17 # Test all encryption password formats
18
19 --echo # Password in double quotes
20 --echo ndb_mgm -e 'start backup snapshotend encrypt password="abc"'
21 if (!`select @windows`)
22 {
23 --replace_regex /[0-9]+/X/
24 --exec $NDB_MGM -e 'start backup snapshotend encrypt password="abc"'
25
26 }
27 if (`select @windows`)
28 {
29 --replace_regex /[0-9]+/X/
30 --exec $NDB_MGM -e "start backup snapshotend encrypt password=""abc"""
31
32 }
33
34 --echo # Password in single quotes
35 --echo ndb_mgm -e "start backup encrypt password='abc'"
36 --replace_regex /[0-9]+/X/
37 --exec $NDB_MGM -e "start backup encrypt password='abc'"
38
39 --echo # Empty password
40 --echo ndb_mgm -e "start backup encrypt password="
41 --error 255
42 --exec $NDB_MGM -e "start backup encrypt password="
43
44 --echo # Empty password
45 --echo ndb_mgm -e "start backup encrypt password=''"
46 --error 255
47 --exec $NDB_MGM -e "start backup encrypt password=''"
48
49 --echo # Empty password
50 --echo ndb_mgm -e 'start backup encrypt password=""'
51 if (!`select @windows`)
52 {
53 --error 255
54 --exec $NDB_MGM -e 'start backup encrypt password=""'
55 }
56 if (`select @windows`)
57 {
58 --error 255
59 --exec $NDB_MGM -e "start backup encrypt password="""""
60 }
61
62 --echo # Password of length 256
63 --echo ndb_mgm -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643K'"
64 --replace_regex /[0-9]+/X/
65 --exec $NDB_MGM -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643K'"
66
67 --echo # Password > 256 chars
68 --echo ndb_mgm -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643Ki'"
69 --error 255
70 --exec $NDB_MGM -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643Ki'"
71
72 --echo # Password >512 chars
73 --echo ndb_mgm -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643KiheCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643Ki'"
74 --error 255
75 --exec $NDB_MGM -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643KiheCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643Ki'"
76
77 --echo # Password =512 chars
78 --echo ndb_mgm -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643KiheCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643'"
79 --error 255
80 --exec $NDB_MGM -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643KiheCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643'"
81
82 --echo # Password with spaces
83 --echo ndb_mgm -e "start backup encrypt password='one two three '"
84 --replace_regex /[0-9]+/X/
85 --exec $NDB_MGM -e "start backup encrypt password='one two three '"
86
87 --echo # Password with disallowed characters
88 --echo ndb_mgm -e "start backup encrypt password='a#b!'"
89 --error 255
90 --exec $NDB_MGM -e "start backup encrypt password='a#b!'"
91
92 --echo # Password with allowed special characters
93 --echo ndb_mgm -e "start backup encrypt password='(+*-)'"
94 --replace_regex /[0-9]+/X/
95 --exec $NDB_MGM -e "start backup encrypt password='(+*-)'"
96
97 --echo # Invalid commands caught by ndb_mgm parser
98 --echo ndb_mgm -e "start backup encrypt password='abba' 'garbage'"
99 --error 255
100 --exec $NDB_MGM -e "start backup encrypt password='abba' 'garbage'"
101
102 --echo ndb_mgm -e 'start backup encrypt password="abba" encrypt password='"'garbage'"
103 if (!`select @windows`)
104 {
105 --error 255
106 --exec $NDB_MGM -e 'start backup encrypt password="abba" encrypt password='"'garbage'"
107 }
108 if (`select @windows`)
109 {
110 --error 255
111 --exec $NDB_MGM -e "start backup encrypt password=""abba"" encrypt password='garbage'"
112 }
113
114
115 --echo ndb_mgm -e "start backup encrypt password='abba' encrypt password='garbage'"
116 --error 255
117 --exec $NDB_MGM -e "start backup encrypt password='abba' encrypt password='garbage'"
118
119 --echo ndb_mgm -e "start backup encrypt password='"
120 --error 255
121 --exec $NDB_MGM -e "start backup encrypt password='"
122
123 --echo ndb_mgm -e "start backup encrypt password='abba' '"
124 --error 255
125 --exec $NDB_MGM -e "start backup encrypt password='abba' '"
126
127 write_file $MYSQL_TMP_DIR/backup_password.txt;
128 SECRET
129 EOF
130
131 # If one for example do:
132 #
133 # ./mtr --defaults-extra-file=suite/ndb/encrypted_backup.cnf ...
134 #
135 # then ndb_mgm below will emit a password on command line warning due to the
136 # use of --skip-backup-password (via $NDB_MGM_NO_ENCR) to undo the setting of
137 # backup-password in encrypted_backup.cnf.
138 #
139 # Therefore we remove the warning in below two cases.
140
141 --echo
142 --echo # Test START BACKUP ENCRYPT with password from stdin
143 replace_regex /[0-9]+/X/
144 /ndb_mgm: .Warning. Using a password on the command line interface can be insecure.*\n//;
145 exec $NDB_MGM $NDB_MGM_NO_ENCR 2>&1 < $MYSQL_TMP_DIR/backup_password.txt
146 --backup-password-from-stdin
147 --execute="START BACKUP ENCRYPT";
148
149 --echo
150 --echo # Make START BACKUP trigger encrypted backup.
151 replace_regex /[0-9]+/X/
152 /ndb_mgm: .Warning. Using a password on the command line interface can be insecure.*\n//;
153 exec $NDB_MGM $NDB_MGM_NO_ENCR 2>&1 < $MYSQL_TMP_DIR/backup_password.txt
154 --encrypt-backup
155 --backup-password-from-stdin
156 --execute="START BACKUP";
157
158 #cleanup
159 DROP TABLE t1;
160
161 remove_file $MYSQL_TMP_DIR/backup_password.txt;
162
163 --source suite/ndb/include/backup_restore_cleanup.inc