| 1 |
set @windows = convert(@@version_compile_os using latin1) |
| 2 |
in ('Win32', 'Win64', 'Windows'); |
| 3 |
CREATE TABLE t1(k int not null primary key auto_increment) engine=ndb; |
| 4 |
INSERT INTO t1 VALUES (NULL); |
| 5 |
INSERT INTO t1 SELECT NULL FROM t1; |
| 6 |
INSERT INTO t1 SELECT NULL FROM t1; |
| 7 |
INSERT INTO t1 SELECT NULL FROM t1; |
| 8 |
INSERT INTO t1 SELECT NULL FROM t1; |
| 9 |
# Password in double quotes |
| 10 |
ndb_mgm -e 'start backup snapshotend encrypt password="abc"' |
| 11 |
Waiting for completed, this may take several minutes |
| 12 |
Node X: Backup X started from node X |
| 13 |
Node X: Backup X started from node X completed |
| 14 |
StartGCP: X StopGCP: X |
| 15 |
#Records: X #LogRecords: X |
| 16 |
Data: X bytes Log: X bytes |
| 17 |
# Password in single quotes |
| 18 |
ndb_mgm -e "start backup encrypt password='abc'" |
| 19 |
Waiting for completed, this may take several minutes |
| 20 |
Node X: Backup X started from node X |
| 21 |
Node X: Backup X started from node X completed |
| 22 |
StartGCP: X StopGCP: X |
| 23 |
#Records: X #LogRecords: X |
| 24 |
Data: X bytes Log: X bytes |
| 25 |
# Empty password |
| 26 |
ndb_mgm -e "start backup encrypt password=" |
| 27 |
Invalid command: backup encrypt password= |
| 28 |
Encryption password should be within quotes |
| 29 |
Type HELP for help. |
| 30 |
|
| 31 |
# Empty password |
| 32 |
ndb_mgm -e "start backup encrypt password=''" |
| 33 |
Waiting for completed, this may take several minutes |
| 34 |
Backup failed |
| 35 |
* 3001: Could not start backup |
| 36 |
* Encryption password is of zero length: Permanent error: Configuration or application error |
| 37 |
# Empty password |
| 38 |
ndb_mgm -e 'start backup encrypt password=""' |
| 39 |
Waiting for completed, this may take several minutes |
| 40 |
Backup failed |
| 41 |
* 3001: Could not start backup |
| 42 |
* Encryption password is of zero length: Permanent error: Configuration or application error |
| 43 |
# Password of length 256 |
| 44 |
ndb_mgm -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643K'" |
| 45 |
Waiting for completed, this may take several minutes |
| 46 |
Node X: Backup X started from node X |
| 47 |
Node X: Backup X started from node X completed |
| 48 |
StartGCP: X StopGCP: X |
| 49 |
#Records: X #LogRecords: X |
| 50 |
Data: X bytes Log: X bytes |
| 51 |
# Password > 256 chars |
| 52 |
ndb_mgm -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643Ki'" |
| 53 |
Waiting for completed, this may take several minutes |
| 54 |
Backup failed |
| 55 |
* 3001: Could not start backup |
| 56 |
* Encryption password is too long (see 'HELP START BACKUP'): Permanent error: Configuration or application error |
| 57 |
# Password >512 chars |
| 58 |
ndb_mgm -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643KiheCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643Ki'" |
| 59 |
Waiting for completed, this may take several minutes |
| 60 |
Backup failed |
| 61 |
* 5001: Usage error |
| 62 |
* Line length exceeded due to argument: encryption_password |
| 63 |
# Password =512 chars |
| 64 |
ndb_mgm -e "start backup encrypt password='heCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643KiheCrNh3UIn3yDmO02yic6FTAdkTRQEd2qunuj2K5QHluWa52YvsVnS1yzLJuXnSEeZENu9RBjf3bu3acQg56H1jnvWs4kesAPJPZFHRtdv9ap5WXWyGLBIUE7fOANSX2xIlkoHpy39RtdJAMuKa5cXC1ZTrrFujAPET68QHraLLWOJHNf7fYsqdehwGQiZG0cz2TErLQoNWu5YX32iBGPHTopZ1yDsAEOZyOdaDcbz0bflKZcSWH5FoVjyGF643'" |
| 65 |
Waiting for completed, this may take several minutes |
| 66 |
Backup failed |
| 67 |
* 5001: Usage error |
| 68 |
* Line length exceeded due to argument: encryption_password |
| 69 |
# Password with spaces |
| 70 |
ndb_mgm -e "start backup encrypt password='one two three '" |
| 71 |
Waiting for completed, this may take several minutes |
| 72 |
Node X: Backup X started from node X |
| 73 |
Node X: Backup X started from node X completed |
| 74 |
StartGCP: X StopGCP: X |
| 75 |
#Records: X #LogRecords: X |
| 76 |
Data: X bytes Log: X bytes |
| 77 |
# Password with disallowed characters |
| 78 |
ndb_mgm -e "start backup encrypt password='a#b!'" |
| 79 |
Waiting for completed, this may take several minutes |
| 80 |
Backup failed |
| 81 |
* 3001: Could not start backup |
| 82 |
* Encryption password has bad character/s (see 'HELP START BACKUP'): Permanent error: Configuration or application error |
| 83 |
# Password with allowed special characters |
| 84 |
ndb_mgm -e "start backup encrypt password='(+*-)'" |
| 85 |
Waiting for completed, this may take several minutes |
| 86 |
Node X: Backup X started from node X |
| 87 |
Node X: Backup X started from node X completed |
| 88 |
StartGCP: X StopGCP: X |
| 89 |
#Records: X #LogRecords: X |
| 90 |
Data: X bytes Log: X bytes |
| 91 |
# Invalid commands caught by ndb_mgm parser |
| 92 |
ndb_mgm -e "start backup encrypt password='abba' 'garbage'" |
| 93 |
Invalid command: backup encrypt password='abba' 'garbage' |
| 94 |
Type HELP for help. |
| 95 |
|
| 96 |
ndb_mgm -e 'start backup encrypt password="abba" encrypt password='"'garbage'" |
| 97 |
Invalid command: backup encrypt password="abba" encrypt password='garbage' |
| 98 |
Type HELP for help. |
| 99 |
|
| 100 |
ndb_mgm -e "start backup encrypt password='abba' encrypt password='garbage'" |
| 101 |
Invalid command: backup encrypt password='abba' encrypt password='garbage' |
| 102 |
Type HELP for help. |
| 103 |
|
| 104 |
ndb_mgm -e "start backup encrypt password='" |
| 105 |
Invalid command: backup encrypt password=' |
| 106 |
Encryption password should be within quotes |
| 107 |
Type HELP for help. |
| 108 |
|
| 109 |
ndb_mgm -e "start backup encrypt password='abba' '" |
| 110 |
Invalid command: backup encrypt password='abba' ' |
| 111 |
Type HELP for help. |
| 112 |
|
| 113 |
|
| 114 |
# Test START BACKUP ENCRYPT with password from stdin |
| 115 |
Waiting for completed, this may take several minutes |
| 116 |
Node X: Backup X started from node X |
| 117 |
Node X: Backup X started from node X completed |
| 118 |
StartGCP: X StopGCP: X |
| 119 |
#Records: X #LogRecords: X |
| 120 |
Data: X bytes Log: X bytes |
| 121 |
|
| 122 |
# Make START BACKUP trigger encrypted backup. |
| 123 |
Waiting for completed, this may take several minutes |
| 124 |
Node X: Backup X started from node X |
| 125 |
Node X: Backup X started from node X completed |
| 126 |
StartGCP: X StopGCP: X |
| 127 |
#Records: X #LogRecords: X |
| 128 |
Data: X bytes Log: X bytes |
| 129 |
DROP TABLE t1; |