Mariadb Aborted connection error without user name

Question

In MariaDB I am having this warning in the error log. Is there a way to resolve the issue without knowing the user name?

[Warning] Aborted connection 1101 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)

you can enable audit logs to track further about connections — ROHIT KHURANA
– ROHIT KHURANA, Commented Feb 11, 2021 at 6:05
I've had this happen with SSL connections because the user was connecting to the host as IP address instead of using its hostname... — MSpreij
– MSpreij, Commented Jun 16, 2021 at 12:55
I've also had this happen when someone tries to connect to the db with ssl enabled but using the wrong CA/cert/key for their client when using 2 way encryption with self signed certs. The connection might look something like this when using the command line mysql -u root -p -h mysite.com --protocol=TCP --ssl-ca=/pathto/client-ca-cert.pem --ssl-cert=/pathto/client-cert.pem --ssl-key=/pathto/client-key.pem --ssl-verify-server-cert — Nick
– Nick, Commented Aug 2, 2022 at 19:23

danblack · Accepted Answer · 2023-07-13 08:56:24Z

2

This is a user killing a connection before it negotiated to a user.

Unless you know what users executed mysql on the server at that exact time there's not much to track this down. Even if you did find a user, asking them to fully authenticate seems rather pointless.

edited Jul 13, 2023 at 8:56

answered Feb 11, 2021 at 4:42

danblack

14.9k2 gold badges27 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

danblack Over a year ago

Update: From MDEV-12274 newer MariaDB versions won't log this noise as a warning.

Collectives™ on Stack Overflow

Mariadb Aborted connection error without user name

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related