Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.29, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
Description
Email thread from the MariaDB mailing list...
Hi, Rhys.Campbell!
On Apr 26, Rhys.Campbell@XXXXXXXXXXXX wrote:
> Hello All,
>
> I've been using the userstats plugin to debug an application issue and
> I think there's a bug in the collection of statistics, or at least a
> case of bad wording...
>
> https://mariadb.com/kb/en/mariadb/user-statistics/
>
> DENIED_CONNECTIONS - The number of connections denied to this user.
> ACCESS_DENIED - The number of times this user's connections issued commands that were denied.
>
> A application user was displaying very high "DENIED_CONNECTION"
> values. This sent us in the direction a bad password was being
> supplied. Long story short it actually turns out that a series of
> ALTER TABLE statements were failing, because the application does not
> have permission to do so.
>
> During one our tests DENIED_CONNECTION was 5397 and ACCESS_DENIED was
> 0. We can see the ALTER TABLE statement failing and DENIED_CONNECTION
> being incremented quickly. According to the documentation shouldn't
> this ACCESS_DENIED (which I think might be better named
> COMMAND_DENIED?) be incremented?It's a bug. Could you please report it at jira.mariadb.org?
Regards,
Sergei
Chief Architect MariaDB
and security@mariadb.org