Debian Codegraph @

mysql-test/suite/ndb/r/ndb_encrypted_backup.result

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