MariaDB changed 'REPLICATION CLIENT' grant to 'BINLOG MONITOR' - Githubissues

puppetlabs / puppetlabs-mysql

MySQL Puppet Module / Manifests + Types & Providers

Apache License 2.0

380 stars 790 forks source link

MariaDB changed 'REPLICATION CLIENT' grant to 'BINLOG MONITOR' #1598

Open ubellavance opened 10 months ago

ubellavance commented 10 months ago

Describe the Bug

On this line: https://github.com/puppetlabs/puppetlabs-mysql/blob/29cfd39ae1ad389adb3bf1d631c0869ed77b57c7/manifests/backup/xtrabackup.pp#L69C15-L69C15, the required grant is 'REPLICATION CLIENT', but it doesn't work when used with MariaDB because MariaDB renamed the grant to 'BINLOG MONITOR': https://mariadb.com/kb/en/grant/#replication-client

Expected Behavior

Puppet runs without error

Steps to Reproduce

Steps to reproduce the behavior:

Use the xtrabackup, but with mariabackup method
You will get an error because Puppet removes the 'BINLOG MONITOR' grant and re-adds 'REPLICATION CLIENT'

Environment

Puppet version 7.25
RHEL, MariaDB 10.11
Module version : 14. I can't easily test v15 because of stdlib 9 dependency

Additional Context

Add any other context about the problem here.