[MDEV-20564] Mariabackup docs for privileges incomplete / outdated for rocksdb backups Created: 2019-09-11  Updated: 2019-09-12  Resolved: 2019-09-12

Status: Closed
Project: MariaDB Server
Component/s: Documentation, mariabackup
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Jonas Krauss Assignee: Geoff Montee (Inactive)
Resolution: Fixed Votes: 0
Labels: Documentation, mariabackup, privileges

Issue Links:
Relates
relates to MDEV-13122 Backup myrocks with mariabackup Closed
relates to MDEV-20577 Require lower privilege than SUPER to... Open

 Description   

OS: Linux Debian-93-stretch-64-minimal 4.9.0-8-amd64 #1 SMP Debian 4.9.144-3.1 (2019-02-19) x86_64

MariaDB: 10.2.21-MariaDB-10.2.21+maria~stretch-log (binary distribution with plugin-rocksdb)

mariabackup version: mariabackup based on MariaDB server 10.2.21-MariaDB debian-linux-gnu (x86_64)

User created according to the info found at https://mariadb.com/kb/en/library/mariabackup-overview/#authentication-and-privileges

When running mariabackup the following error message appears:
[..] Obtaining rocksdb checkpoint lock.
Error: failed to execute query SET GLOBAL rocksdb_create_checkpoint='/data/rocksdb/mariabackup-checkpoint': Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I will try to grant the SUPER privilege to the user and re-run the backup. Would be great to include that in the docs.



 Comments   
Comment by Jonas Krauss [ 2019-09-12 ]

With the SUPER privilege the backup ran through just fine.

Comment by Geoff Montee (Inactive) [ 2019-09-12 ]

The documentation has been updated. If we want to change the implementation to require lower privileges than SUPER, then that is now tracked as MDEV-20577.

Generated at Thu Feb 08 09:00:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.