[Pkg-nagios-devel] Bug#1116027: Bug#1116027: monitoring-plugins-standard: check_mysql fails for MySQL 8.4 due to deprecation of 'CHECK SLAVE STATUS' command

[Jon Cutting]

Hi Jan,

Thank you for the update. Unfortunately I think there is an issue in the 
server info or the test for MySQL in the output from that function.

I've cloned the 
https://salsa.debian.org/nagios-team/monitoring-plugins.git repository 
and built a package with gbp buildpackage --git-ignore-branch on the 
'trixie' branch.

Once installed onto the target server running MySQL 8.4 I see the following:


jon at TRIXIESERVER:~$ /usr/lib/nagios/plugins/check_mysql -u REDACTED -p 
REDACTED
Uptime: 21151  Threads: 9  Questions: 1855375  Slow queries: 0 Opens: 
2137  Flush tables: 3  Open tables: 804  Queries per second avg: 
87.720|Connections=724c;;;; Open_files=9;;;; Open_tables=804;;;; 
Queries=1855376c;;;; Questions=1652c;;;; Table_locks_waited=0c;;;; 
Threads_connected=2;;;; Threads_running=3;;;; Uptime=21151c;;;;


jon at TRIXIESERVER:~$ /usr/lib/nagios/plugins/check_mysql -u REDACTED -p 
REDACTED -S
Not a known sever implementation: 8.4.6


Thanks,

Jon


On 25/09/2025 09:16, Jan Wagner wrote:
> Hi Jon,
>
> Am 23.09.25 um 12:47 schrieb Jon Cutting:
>> The check_mysql plugin when checking MySQL's replica status fails for 
>> MySQL 8.4 because 'SHOW SLAVE STATUS' has now been fully deprecated 
>> in favour of 'CHECK REPLICA STATUS'
>
> many thanks for coming up with this. This isses was already addressed 
> in https://github.com/monitoring-plugins/monitoring-plugins/pull/2068 
> upstream.
> https://github.com/monitoring-plugins/monitoring-plugins/compare/master...maintenance-2.4.0-check_mysql.patch 
> should fix this for 2.4.0 and I've created 
> https://salsa.debian.org/nagios-team/monitoring-plugins/-/commit/dd1efc8f1be4d98463c567589a657a0e22fb06d4 
> to address this issue in trixie. Feedback is welcome, as I don't have 
> any MySQL 8.4 (with replication) available for testing myself.
>
> Thanks and with kind regards, Jan.

CONFIDENTIALITY NOTICE: 
This Email is confidential and may also be privileged. If you are not the
intended recipient, please notify the sender IMMEDIATELY; you should not
copy the email, use it for any purpose nor disclose its contents to any
other person. 

GENERAL STATEMENT: 
Any statements made, or intentions expressed, within this communication may
not necessarily reflect the views of the Company. Be advised that no content
herein may be held binding upon the Company or any associated company unless
confirmed by the issuance of a formal contractual document or Purchase
Order. 

Registered Office: 
38 Anson Road 
Martlesham Heath 
Ipswich 
Suffolk 
IP5 3RG 

Company Registration: 4426731 
VAT: GB 834 5358 17