Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27867

missing required privilege REPLICATION CLIENT by /usr/bin/mariabackup

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.7.3
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
      None
    • Environment:
      RedHat Enterprise Linux 8.5

      Description

      I am using mariadb 10.7.3. I tried to perform db backup using '/usr/bin/mariabackup' by user other than root.

      /usr/bin/mariabackup --backup -umariadbbackup -pxxxxxx --binlog-info=on --databases=all -h /mysql --galera-info --target-dir=/backup/`hostname`-mariadb-backup-${DATEVAR}
      

      I have granted the following privileges to the backup db user, mariadbbackup:

      > show grants for "mariadbbackup"@"localhost";
      +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Grants for mariadbbackup@localhost                                                                                                                                                                                   |
      +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | GRANT SELECT, RELOAD, PROCESS, SHOW DATABASES, LOCK TABLES, BINLOG MONITOR, SHOW VIEW, EVENT, SLAVE MONITOR ON *.* TO `mariadbbackup`@`localhost` IDENTIFIED BY PASSWORD '......' |
      +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
      

      After backup, I reviewed the backup log and found the following statement:

      Warning: missing required privilege REPLICATION CLIENT on .
      /usr/bin/mariabackup based on MariaDB server 10.7.3-MariaDB Linux (x86_64)

      I have already granted 'REPLICATION CLIENT' but it didn't show up after using 'show grant' command. I already have both BINLOG MONITOR and REPLICA MONITOR privileges granted. But still the warning message appears.

      How should I solve this issue?

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            testjetco Test Jetco
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.