BhanuNidumolu commented on issue #3737: URL: https://github.com/apache/hertzbeat/issues/3737#issuecomment-3751153219
Hi maintainers π Iβve completed the **MySQL account expiry monitoring** task. Implemented in: - `app-mysql.yml` (new `account_expiry` metrics) - `app-mysql.md` (metric documentation) PR: π https://github.com/apache/hertzbeat/pull/3969 ### Whatβs included The MySQL template now exposes: - `user` - `host` - `days_left` (computed from `password_lifetime` and `password_last_changed`) - `password_expired` This enables alerting on: - accounts expiring soon - already expired accounts ### Verification Manual validation was performed with a real MySQL instance: - Created users with different password lifetimes and expired states - Verified via SQL from `mysql.user` - Confirmed the same values appear in HertzBeat UI The SQL output and HertzBeat UI show identical: `user`, `host`,` days_left`, `password_expired`. SQL β Collector β Template β UI is consistent. Screenshots and SQL output are attached in the PR. I can proceed with more databases (MariaDB, MongoDB, etc.) after this is reviewed. Thanks! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
