| 2011-09-07 16:08:24 |
Derek Downey |
bug |
|
|
added bug |
| 2011-09-07 18:35:32 |
Derek Downey |
description |
System info: Using pt-show-grants version 1.0.1 on mysql 5.5.15
pt-show-grants gives the following error when the --separate flag is specified: Use of uninitialized value in split at /usr/bin/pt-show-grants line 1714.
Here is output without separate flag:
$ pt-show-grants
$ pt-show-grants
-- Grants dumped by pt-show-grants
-- Dumped from server rs.dev via TCP/IP, MySQL 5.5.15-log at 2011-09-07 10:55:09
-- Grants for 'dtest'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'dtest'@'localhost' IDENTIFIED BY PASSWORD 'mypass';
-- Grants for 'proxy'@'localhost'
GRANT PROXY ON 'dtest'@'localhost' TO 'proxy'@'localhost';
GRANT USAGE ON *.* TO 'proxy'@'localhost';
-- Grants for 'root'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'rootPass' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;
And output with separate flag:
$ pt-show-grants --separate
-- Grants dumped by pt-show-grants
-- Dumped from server rs.dev via TCP/IP, MySQL 5.5.15-log at 2011-09-07 10:55:01
-- Grants for 'dtest'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'dtest'@'localhost' IDENTIFIED BY PASSWORD 'mypass';
Use of uninitialized value in split at /usr/bin/pt-show-grants line 1714.
I am only assuming this is because there is no GRANT USAGE clause for the user `dtest`@`localhost`, which is set up as a proxy user. |
System info: Using pt-show-grants version 1.0.1 on mysql 5.5.15
pt-show-grants gives the following error when the --separate flag is specified: Use of uninitialized value in split at /usr/bin/pt-show-grants line 1714.
Here is output without separate flag:
$ pt-show-grants
-- Grants dumped by pt-show-grants
-- Dumped from server rs.dev via TCP/IP, MySQL 5.5.15-log at 2011-09-07 10:55:09
-- Grants for 'dtest'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'dtest'@'localhost' IDENTIFIED BY PASSWORD 'mypass';
-- Grants for 'proxy'@'localhost'
GRANT PROXY ON 'dtest'@'localhost' TO 'proxy'@'localhost';
GRANT USAGE ON *.* TO 'proxy'@'localhost';
-- Grants for 'root'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'rootPass' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;
And output with separate flag:
$ pt-show-grants --separate
-- Grants dumped by pt-show-grants
-- Dumped from server rs.dev via TCP/IP, MySQL 5.5.15-log at 2011-09-07 10:55:01
-- Grants for 'dtest'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'dtest'@'localhost' IDENTIFIED BY PASSWORD 'mypass';
Use of uninitialized value in split at /usr/bin/pt-show-grants line 1714.
I am only assuming this is because there is no GRANT USAGE clause for the user `dtest`@`localhost`, which is set up as a proxy user. |
|
| 2011-11-04 17:22:50 |
Tom Krouper |
bug |
|
|
added subscriber Tom Krouper |
| 2011-12-16 15:32:49 |
Daniel Nichter |
tags |
proxy-users |
pt-show-grants |
|
| 2012-03-05 19:08:05 |
William Taylor |
attachment added |
|
proxy.patch https://bugs.launchpad.net/percona-toolkit/+bug/844034/+attachment/2818539/+files/proxy.patch |
|
| 2012-03-08 04:04:11 |
Brian Fraser |
percona-toolkit: status |
New |
Confirmed |
|
| 2012-04-03 18:49:15 |
William Taylor |
attachment added |
|
proxy.patch https://bugs.launchpad.net/percona-toolkit/+bug/844034/+attachment/2997965/+files/proxy.patch |
|
| 2012-06-12 00:20:50 |
Baron Schwartz |
percona-toolkit: status |
Confirmed |
Fix Committed |
|
| 2012-06-12 00:20:53 |
Baron Schwartz |
percona-toolkit: importance |
Undecided |
Medium |
|
| 2012-06-12 00:20:57 |
Baron Schwartz |
percona-toolkit: assignee |
|
Baron Schwartz (baron-xaprb) |
|
| 2012-06-12 00:21:01 |
Baron Schwartz |
percona-toolkit: milestone |
|
2.1.2 |
|
| 2012-06-12 00:21:47 |
Baron Schwartz |
tags |
pt-show-grants |
mysql-5.5 pt-show-grants |
|
| 2012-06-19 19:59:12 |
Daniel Nichter |
percona-toolkit: status |
Fix Committed |
Fix Released |
|
