Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.5.5, 10.6.7
-
Rhel 8.2 - 4.18.0-193.1.2.el8_2.x86_64
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
Attachments
Issue Links
- causes
-
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
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)
|
You're right. Also SUPER is checked for killing connections however CONNECTION ADMIN should be checked as well.