pt-heartbeat super privilege
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
Triaged
|
Undecided
|
Unassigned | ||
Bug Description
# rpm -q mysql-server percona-toolkit
mysql-server-
percona-
Starting with an user that lacks necessary privileges brings me this.
Starting pt-heartbeat: DBD::mysql::db selectrow_hashref failed: Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation [for Statement "SHOW MASTER STATUS"] at /usr/bin/
FAILED
This error message is could easily trick an admin to think that both privileges are necessary. The mysql docu at
http://
The REPLICATION CLIENT privilege enables the use of SHOW MASTER STATUS and SHOW SLAVE STATUS.
so super is not needed.
http://
mysqld actually permits max_connections+1 clients to connect. etc...
Therefore I think it's important not to give SUPER privilege unnecessary. pt-heartbeat could eat up your extra connection slot (Imagine a full log partition for example)
I think the error message should read
you need the REPLICATION CLIENT privilege
instead of
you need the SUPER,REPLICATION CLIENT privilege
| description: | updated |
| Brian Fraser (fraserbn) wrote | #1 |
| Markus Falb (markus-falb) wrote | #2 |
| Daniel Nichter (daniel-nichter) wrote | #3 |
| Changed in percona-toolkit: | |
| status: | New → Triaged |
| tags: | added: docs privs pt-heartbeat |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #4 |
I agree, but that message comes straight from MySQL itself, not from the toolkit; Maybe you should resubmit the bug to the MySQL tracker?
We could catch the error and mangle it to look as you want, but Daniel will have to decide if we actually want to do that.