holland-coredev team mailing list archive

[Andrew Garner <1162006@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

The various mysql plugins should check grants and verify that we have
the correct privileges.  This allows us to fail early and with a more
clear error message and avoid some nasty silent MySQL behaviors.  For
instance if we lack the TRIGGER privilege, triggers will silently be
skipped by mysqldump and the backup will be missing data.

mysqldump effectively needs (for 5.1+):

SELECT, RELOAD, SUPER, LOCK TABLES, REPLICATION CLIENT, EVENT, TRIGGER

(SUPER is required for stop-slave)

mysql-lvm needs:

RELOAD, REPLICATION CLIENT

But mysqldump-lvm will have the same requirements as mysqldump

xtrabackup is essentially the same:

RELOAD, REPLICATION CLIENT, SUPER

Ideally holland should also have a command for generating the right
grant for the current mysql version.

** Affects: holland-backup
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Holland
Build, which is subscribed to holland-backup.
https://bugs.launchpad.net/bugs/1162006

Title:
  check grants in mysql plugins

Status in Holland Backup Framework:
  New

Bug description:
  The various mysql plugins should check grants and verify that we have
  the correct privileges.  This allows us to fail early and with a more
  clear error message and avoid some nasty silent MySQL behaviors.  For
  instance if we lack the TRIGGER privilege, triggers will silently be
  skipped by mysqldump and the backup will be missing data.

  mysqldump effectively needs (for 5.1+):

  SELECT, RELOAD, SUPER, LOCK TABLES, REPLICATION CLIENT, EVENT, TRIGGER

  (SUPER is required for stop-slave)

  mysql-lvm needs:

  RELOAD, REPLICATION CLIENT

  But mysqldump-lvm will have the same requirements as mysqldump

  xtrabackup is essentially the same:

  RELOAD, REPLICATION CLIENT, SUPER

  Ideally holland should also have a command for generating the right
  grant for the current mysql version.

To manage notifications about this bug go to:
https://bugs.launchpad.net/holland-backup/+bug/1162006/+subscriptions