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

[Jon Cutting]

On 01/10/2025 14:00, Jan Wagner wrote:
> Hi Jon,
>
> Am 27.09.25 um 16:46 schrieb Jan Wagner:
>> Am 26.09.25 um 17:22 schrieb Jan Wagner:
>>> Am 25.09.25 um 17:07 schrieb Jon Cutting:
>>>> 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.
>>>
>>> I've updated the patch with a solution hopefully dealing with it.
>>
>> I've also changed the RELEASE for the salsa pipeline and you can grab 
>> the build amd64 packages, if you have access to, from https:// 
>> salsa.debian.org/nagios-team/monitoring-plugins/-/jobs/8358724/ 
>> artifacts/browse/debian/output/
>
> Maybe you can give 
> https://salsa.debian.org/nagios-team/monitoring-plugins/-/jobs/8380920/artifacts/download 
> a try. I've applied another patch[1].
>
> Thanks, Jan.
>
> [1] 
> https://github.com/monitoring-plugins/monitoring-plugins/pull/2163#issuecomment-3355936224 
>


Thank you Jan, it works:


jon at SERVER:~$ /usr/lib/nagios/plugins/check_mysql -u REDACTED -p REDACTED -S
Uptime: 535194  Threads: 9  Questions: 40614835  Slow queries: 18 Opens: 
52253  Flush tables: 3  Open tables: 3856  Queries per second avg: 
75.888 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 
0|Connections=18294c;;;; Open_files=98;;;; Open_tables=3856;;;; 
Queries=40614836c;;;; Questions=428747c;;;; Table_locks_waited=0c;;;; 
Threads_connected=2;;;; Threads_running=3;;;; Uptime=535194c;;;; 
'seconds behind master'=0.000000s;0.000000;0.000000;


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