Debian Codegraph @

mysql-test/suite/mariabackup/backup_grants.test

raw
1 let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
2 let $info=$MYSQLTEST_VARDIR/tmp/backup/mariadb_backup_info;
3 let $log=$MYSQLTEST_VARDIR/tmp/backup.log;
4 CREATE user backup@localhost IDENTIFIED BY 'xyz';
5
6 # backup possible for unprivileges user, with --no-lock
7 --disable_result_log
8 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 -ubackup -pxyz --no-lock --target-dir=$targetdir > $MYSQLTEST_VARDIR/tmp/backup.log 2>&1;
9 --enable_result_log
10
11 --let SEARCH_FILE=$log
12 --let SEARCH_PATTERN= missing required privilege
13 --source include/search_pattern_in_file.inc
14 --let SEARCH_FILE=$info
15 --let SEARCH_PATTERN=xyz
16 --source include/search_pattern_in_file.inc
17 rmdir $targetdir;
18
19 # backup fails without --no-lock, because of FTWRL
20 --disable_result_log
21 error 1;
22 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 -ubackup -pxyz --target-dir=$targetdir > $MYSQLTEST_VARDIR/tmp/backup.log 2>&1;
23 --enable_result_log
24
25 --let SEARCH_FILE=$log
26 --let SEARCH_PATTERN= missing required privilege RELOAD
27 --source include/search_pattern_in_file.inc
28 --let SEARCH_PATTERN= missing required privilege PROCESS
29 --source include/search_pattern_in_file.inc
30 --let SEARCH_PATTERN= GRANT USAGE ON
31 --source include/search_pattern_in_file.inc
32 # backup succeeds with RELOAD privilege
33 GRANT RELOAD, PROCESS on *.* to backup@localhost;
34 --disable_result_log
35 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --user=backup --password=xyz --target-dir=$targetdir > $MYSQLTEST_VARDIR/tmp/backup.log 2>&1;
36 --enable_result_log
37 --let SEARCH_PATTERN= missing required privilege
38 --source include/search_pattern_in_file.inc
39 --let SEARCH_FILE=$info
40 --let SEARCH_PATTERN=xyz
41 --source include/search_pattern_in_file.inc
42 rmdir $targetdir;
43
44 # MDEV-23607 Warning: missing required privilege REPLICATION CLIENT
45 # --slave-info and --galera-info require REPLICA MONITOR
46 --disable_result_log
47 error 1;
48 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --user=backup --password=xyz --slave-info --target-dir=$targetdir > $MYSQLTEST_VARDIR/tmp/backup.log 2>&1;
49 --enable_result_log
50 rmdir $targetdir;
51
52 --let SEARCH_FILE=$log
53 --let SEARCH_PATTERN= missing required privilege SLAVE MONITOR
54 --source include/search_pattern_in_file.inc
55
56 GRANT REPLICA MONITOR ON *.* TO backup@localhost;
57 --disable_result_log
58 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --user=backup --password=xyz --slave-info --target-dir=$targetdir > $MYSQLTEST_VARDIR/tmp/backup.log 2>&1;
59 --enable_result_log
60 --let SEARCH_PATTERN= missing required privilege
61 --source include/search_pattern_in_file.inc
62 --let SEARCH_FILE=$info
63 --let SEARCH_PATTERN=xyz
64 --source include/search_pattern_in_file.inc
65 rmdir $targetdir;
66 REVOKE REPLICA MONITOR ON *.* FROM backup@localhost;
67
68 # --safe-slave-backup requires REPLICATION SLAVE ADMIN, and REPLICA MONITOR
69 --disable_result_log
70 error 1;
71 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --user=backup --password=xyz --safe-slave-backup --target-dir=$targetdir > $MYSQLTEST_VARDIR/tmp/backup.log;
72 --enable_result_log
73 rmdir $targetdir;
74
75 --let SEARCH_FILE=$log
76 --let SEARCH_PATTERN= missing required privilege REPLICATION SLAVE ADMIN
77 --source include/search_pattern_in_file.inc
78 --let SEARCH_PATTERN= missing required privilege SLAVE MONITOR
79 --source include/search_pattern_in_file.inc
80
81 GRANT REPLICATION SLAVE ADMIN ON *.* TO backup@localhost;
82 GRANT REPLICA MONITOR ON *.* TO backup@localhost;
83 --disable_result_log
84 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup -ubackup -pxyz --safe-slave-backup --target-dir=$targetdir > $MYSQLTEST_VARDIR/tmp/backup.log 2>&1;
85 --enable_result_log
86 --let SEARCH_PATTERN= missing required privilege
87 --source include/search_pattern_in_file.inc
88 --let SEARCH_FILE=$info
89 --let SEARCH_PATTERN=xyz
90 --source include/search_pattern_in_file.inc
91 rmdir $targetdir;
92
93 DROP USER backup@localhost;