[MDEV-23607] Warning: missing required privilege REPLICATION CLIENT Created: 2020-08-27  Updated: 2023-12-13  Resolved: 2022-08-26

Status: Closed
Project: MariaDB Server
Component/s: Backup, mariabackup
Affects Version/s: 10.5.5, 10.6.7
Fix Version/s: 10.5.18, 10.6.10, 10.7.6, 10.8.5, 10.9.3, 10.10.2

Type: Bug Priority: Minor
Reporter: Justin Gerry Assignee: Daniel Black
Resolution: Fixed Votes: 1
Labels: beginner-friendly
Environment:

Rhel 8.2 - 4.18.0-193.1.2.el8_2.x86_64

Issue Links:
Problem/Incident
causes MDEV-33006 Missing required privilege CONNECTION... Closed
Relates
relates to MDEV-27867 missing required privilege REPLICATIO... Closed

 Description   

mariabackup giving what appears to be a benign error regarding sst user rights during SST process.

[00] 2020-08-26 23:25:00 Warning: missing required privilege REPLICATION CLIENT on .
/usr/bin/mariabackup based on MariaDB server 10.5.5-MariaDB Linux (x86_64)

I believe mariadb still expects that REPLICATION CLIENT exist in the grants table when its been updated to BINLOG MONITOR per the documentation. I don't believe mariabackup attempts to check the new grant type.

Everything is functioning normally. Trivial bug but is misleading.

-Justin

 Comments   
Comment by Daniel Black [ 2022-03-31 ]

You're right. Also SUPER is checked for killing connections however CONNECTION ADMIN should be checked as well.

Comment by Nilnandan Joshi [ 2022-04-27 ]

One of our customer is also seeing the same warning while running mariabackup. 

SHOW GRANTS FOR 'mariabackup'@'localhost';
 
+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| Grants for mariabackup@localhost |
 
+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| GRANT RELOAD, PROCESS, LOCK TABLES, BINLOG MONITOR ON *.* TO `mariabackup`@`localhost` IDENTIFIED BY PASSWORD '' |


root@frtecdtbpl020 prog]# mariabackup --defaults-extra-file=/etc/my.cnf.d/mariabackup.cnf --port=3306 --parallel=2 --backup --galera-info --target-dir=/mariabackup/20220428_TEST/FULL
 
[00] 2022-04-27 10:48:37 Connecting to MariaDB server host: localhost, user: mariabackup, password: set, port: 3306, socket: /data/mysql.sock
 
....
 
[00] 2022-04-27 10:48:37 Warning: missing required privilege REPLICATION CLIENT on *.*
 
mariabackup based on MariaDB server 10.6.7-MariaDB Linux (x86_64)

Comment by Daniel Black [ 2022-07-29 ]

wlad can I get a review on PR #2211 please.

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