puppetlabs-mysql icon indicating copy to clipboard operation
puppetlabs-mysql copied to clipboard

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

Open ubellavance opened this issue 2 years ago • 0 comments

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:

  1. Use the xtrabackup, but with mariabackup method
  2. 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.

ubellavance avatar Oct 05 '23 17:10 ubellavance