Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19277

Add status variable that gets incremented if connection is aborted prior to authentication

    Details

      Description

      If a connection is aborted prior to authentication, then the only status variable that gets incremented is Aborted_connects. The Aborted_connects status variable gets incremented for a lot of reasons though, so there is no status variable that can be used to determine how many connections have gotten aborted prior to authentication.

      You can reproduce this by doing something like using telnet to connect to the MariaDB port, and then killing the telnet process:

      $ telnet 127.0.0.1 3306
      Trying 127.0.0.1...
      Connected to 127.0.0.1.
      Escape character is '^]'.
      Y
      5.5.5-10.1.38-MariaDB@TcxOay_?▒MFWbhc931>#4mysql_native_password^CConnection closed by foreign host
      

      The only status variable that is incremented from this is Aborted_connects:

      MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'Aborted%';
      +------------------+-------+
      | Variable_name    | Value |
      +------------------+-------+
      | Aborted_clients  | 0     |
      | Aborted_connects | 1     |
      +------------------+-------+
      2 rows in set (0.00 sec)
       
      MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'Access_denied%';
      +----------------------+-------+
      | Variable_name        | Value |
      +----------------------+-------+
      | Access_denied_errors | 0     |
      +----------------------+-------+
      1 row in set (0.00 sec)
       
      MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'Connection_errors%';
      +-----------------------------------+-------+
      | Variable_name                     | Value |
      +-----------------------------------+-------+
      | Connection_errors_accept          | 0     |
      | Connection_errors_internal        | 0     |
      | Connection_errors_max_connections | 0     |
      | Connection_errors_peer_address    | 0     |
      | Connection_errors_select          | 0     |
      | Connection_errors_tcpwrap         | 0     |
      +-----------------------------------+-------+
      6 rows in set (0.00 sec)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                GeoffMontee Geoff Montee
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: