mk-audit dies ungracefully if user does not have privs to see processlist

hugowan / maatkit

Automatically exported from code.google.com/p/maatkit

0 stars 0 forks source link

mk-audit dies ungracefully if user does not have privs to see processlist #60

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago

DBD::mysql::db selectall_arrayref failed: Access denied; you need the
PROCESS privilege for this operation at ./mk-audit line 2435.

Original issue reported on code.google.com by dan...@percona.com on 29 Aug 2008 at 7:07

GoogleCodeExporter commented 9 years ago

There's code in mk-find that you can rip out and put into a module for 
permissions
checking.  (Ultimately mk-show-grants should end up using that too.)  It already
checks for PROCESS.  Maybe you can do it better but it might also be good 
inspiration.

Original comment by baron.schwartz on 29 Aug 2008 at 7:17

GoogleCodeExporter commented 9 years ago

Original comment by baron.schwartz on 1 Oct 2008 at 3:15

Added labels: Tool-mk_audit

GoogleCodeExporter commented 9 years ago

Original comment by baron.schwartz on 3 Oct 2008 at 12:46

Added labels: Milestone-2008_10

GoogleCodeExporter commented 9 years ago

I'm working on this.

Original comment by dan...@percona.com on 12 Oct 2008 at 2:55

Changed state: Started

GoogleCodeExporter commented 9 years ago

This has been fixed (r2421) thanks to the the Grants module now in mk-audit.
For future reference, some clever MySQL hacker commented on this oddity at:
http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html
The manual says that a user can alway see at least their own processlist but 
this
differs for anonymous users.

Original comment by dan...@percona.com on 12 Oct 2008 at 4:57

Changed state: Fixed