Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-450

LP #916168: pt-table-checksum privilege check fails on MySQL 5.5

    Details

      Description

      **Reported in Launchpad by Aurimas Mikalauskas last update 10-08-2012 18:13:32

      If percona.checksum table exists, privileges check fails with the following error:

      01-13T12:21:20 User does not have all privileges on --replicate table `percona`.`checksums`.

      Here's the PTDEBUG output:

      1. pt_table_checksum:6995 6643 Checking --replicate table `percona`.`checksums`
      2. pt_table_checksum:7000 6643 SHOW DATABASES LIKE 'percona'
      3. pt_table_checksum:7098 6643 use_repl_db
      4. pt_table_checksum:7119 6643 USE `percona`
      5. TableParser:1952 6643 Checking `percona`.`checksums`
      6. TableParser:1956 6643 SHOW TABLES FROM `percona` LIKE 'checksums'
      7. TableParser:1970 6643 Table exists; no privs to check
      8. pt_table_checksum:7033 6643 --replicate table `percona`.`checksums` already exists
      9. TableParser:1952 6643 Checking `percona`.`checksums`
      10. TableParser:1956 6643 SHOW TABLES FROM `percona` LIKE 'checksums'
      11. TableParser:1970 6643 Table exists; no privs to check
      12. TableParser:1974 6643 SHOW FULL COLUMNS FROM `percona`.`checksums`
      13. TableParser:1989 6643 DELETE FROM `percona`.`checksums` LIMIT 0
      14. TableParser:1995 6643 User privs on `percona`.`checksums` : select delete
      15. TableParser:2000 6643 User does not have all privs
        01-13T12:21:20 User does not have all privileges on --replicate table `percona`.`checksums`.
      16. Cxn:1514 6643 Disconnecting dbh DBI::db=HASH(0xffdb2c0) undef
      17. Cxn:1514 6643 Disconnecting dbh DBI::db=HASH(0x1038c830) undef

      When I drop the table, everything starts up just fine. I have created the following privileges:

      grant select, replication slave, replication client, super, process on . to 'u'@'10.0.0.0/255.255.255.0' identified by 'p';
      grant all on percona.* to 'u'@'10.0.0.0/255.255.255.0';
      create database percona;

      And I run check as:

      perl pt-table-checksum h=10.0.0.1,u=u,p=p

      On 5.5.14-55-log Percona Server (GPL), Release rel20.5, Revision 149

      Aurimas

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: