| 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 |