Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
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
-
MDEV-21456 TCP health checks to port 3306 quickly exceed max_connect_errors
-
- Closed
-
- relates to
-
-
- Open
-
-
-
- Closed
-
-
-
- Closed
-