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

Log more specific warning with log_warnings=2 if connection is aborted prior to authentication

Details

    Description

      If a connection is aborted prior to authentication, then a warning is only logged if log_warnings=4 is set, and the warning is the same "Aborted connection ... (CLOSE_CONNECTION)" warning as it is for any other connection.

      You can reproduce this by setting log_warnings=4:

      SET GLOBAL log_warnings=4;

      And then 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

      At that point, the error log will contain a message like this:

      2019-04-18 18:12:55 140535201905408 [Warning] Aborted connection 328 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (CLOSE_CONNECTION)

      I think this message should actually read something like this:

      2019-04-18 18:12:55 140535201905408 [Warning] Aborted connection 328 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (Connection closed without authenticating)

      I also think that this message should be logged when log_warnings=2, instead of log_warnings=4.

      I also think that MDEV-19277 should be implemented as part of this.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21456 TCP health checks to port 3306 quickly exceed max_connect_errors

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19469 Connection timeout before Authentication does not show up as an error

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19276 If login fails when selecting a database, no warning is printed to the log with log_warnings=2

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-19277 Add status variable that gets incremented if connection is aborted prior to authentication

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) created issue -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Field Original Value New Value
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Summary Log more specific warning if connection is aborted prior to authentication Log more specific warning with log_warnings=2 if connection is aborted prior to authentication
            serg Sergei Golubchik made changes -
            Assignee Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Sergei Golubchik [ serg ] Vladislav Vaintroub [ wlad ]
            wlad Vladislav Vaintroub made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            wlad Vladislav Vaintroub made changes -
            Assignee Vladislav Vaintroub [ wlad ] Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            sanja Oleksandr Byelkin made changes -
            Fix Version/s 10.4.5 [ 23311 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            marcosbc Marcos Bjoerkelund made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 96207 ] MariaDB v4 [ 133933 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 103711

            People

              sanja Oleksandr Byelkin
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.