Bug #104428 Improve password expiry message in error log
Submitted: 27 Jul 2021 14:22 Modified: 27 Jul 2021 14:47
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:8.0.26 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution, error log, expiry, host, username

[27 Jul 2021 14:22] Simon Mudd 
Description:
I noticed on a server this message happening frequently:

2021-07-22T10:53:59.740182Z 2671636 [Note] [MY-010928] [Server] Your password has expired. To log in you must change it using a client that supports expired passwords.
2021-07-22T10:54:03.178113Z 2671640 [Note] [MY-010928] [Server] Your password has expired. To log in you must change it using a client that supports expired passwords.
2021-07-22T10:54:09.718676Z 2671647 [Note] [MY-010928] [Server] Your password has expired. To log in you must change it using a client that supports expired passwords.
2021-07-22T10:54:13.254478Z 2671671 [Note] [MY-010928] [Server] Your password has expired. To log in you must change it using a client that supports expired passwords.

The message is great but it does not tell me which user is affected by this. Please improve the error message to report the username as identified by MySQL. e.g. 'some_user'@'10.%' and potentially indicate the host/socket the connection came over. e.g. 10.1.2.3. This improves identifying the problem "user" and resolving the issue.

How to repeat:
see above.

Suggested fix:
https://github.com/mysql/mysql-server/pull/352 or similar.
[27 Jul 2021 14:40] OCA Admin 
Contribution submitted via Github - Improved the expired password logging sent to the error log 
(*) Contribution by Simon Mudd (Github sjmudd, mysql-server/pull/352#issuecomment-887554996): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_697877695.txt (text/plain), 2.14 KiB.
[27 Jul 2021 14:47] MySQL Verification Team 
Hello Simon,

Thank you for the report and contribution!

regards,
Umesh