Hi
I know I am running this on a very old version, am in the process of upgrading, but it is taken time.
Hoping someone can help on this?
Have a script check_mysql_slavestatus.sh
Script Link
Script runs OK, but MRPE gives an error, not sure where I have gone wrong
Script output is:
OK: Slave SQL running: Yes Slave IO running: Yes / master: unrisd-pg.bsky.net / slave is 0 seconds behind master | delay=0s
Agent output is:
check_mk_agent | grep -A1 ‘^…mrpe’
MYSQL_REPLICATION 3 Warning threshold must be a valid integer greater than 0
MRPE file is:
MYSQL_REPLICATION /usr/local/bin/check_mysql_slavestatus.sh -H localhost -P 3306 -u root -p ******* -w 1800 -c 3600
Hope someone can point me in the right direction.
CMK Version 1.2.6
OS Version CentOS 6
ERROR: MYSQL_REPLICATION 3 Warning threshold must be a valid integer greater than 0
DEBUG OUTPUT:
OMD[bk]:~$ cmk --debug -vvn *******
Check_mk version 1.2.6p12
Connecting via TCP to 192.168.30.54:6556.
CPU load OK - 15min load 0.05 at 2 CPUs
CPU utilization OK - user: 0.8%, system: 0.7%, wait: 0.0%, total: 1.5%
Disk IO SUMMARY OK - 0.00 B/sec read, 409.60 B/sec write, IOs: 0.10/sec
Interface ens160 OK - [2] (up) MAC: 00:50:56:af:19:3c, 10.00 Gbit/s, in: 6.6 Kbit/s, 10min avg: 3.8 Kbit/s, out: 43.9 Kbit/s, 10min avg: 9.1 Kbit/s
Kernel Context Switches OK - 361/s
Kernel Major Page Faults OK - 0/s
Kernel Process Creations OK - 11/s
MYSQL_REPLICATION UNKNOWN - Warning threshold must be a valid integer greater than 0
Memory used OK - 1.04 GB used (1.04 RAM + 0.00 SWAP + 0.01 Pagetables, this is 18.4% of 5.66 RAM (2.00 total SWAP)), 0.1 mapped, 1.0 committed, 0.1 shared
Mount options of / OK - mount options exactly as expected
Mount options of /boot OK - mount options exactly as expected
MySQL DB Slave OK - Slave-IO: running, Slave-SQL: running, Time behind Master: 0 sec
MySQL DB sys Size OK - Size is 16.00 kB
MySQL DB unrisd_db Size OK - Size is 105.25 MB
MySQL Daemon Connections OK - Max. parallel Connections: 3 (Max.: 151): 1.99%
MySQL Daemon InnoDB IO OK - 0.00 B/sec read, 0.00 B/sec write
MySQL Daemon Sessions OK - 2 total, 3 running, 0.39 connections/s
NTP Time OK - sys.peer - stratum 2, offset 0.43 ms, jitter 0.48 ms, last reached 718 secs ago (synchronized on 109.74.206.120)
Number of threads OK - 178 threads
Postfix Queue OK - The mailqueue is empty
TCP Connections OK - ESTABLISHED: 4, TIME_WAIT: 1
Uptime OK - up since Tue Apr 5 10:39:52 2022 (6d 23:43:02)
fs_/ OK - 12.1% used (23.88 of 197.49 GB), (levels at 95.00/98.00%), trend: +1.88 GB / 168 hours, inodes available 206958k/99.93%
fs_/boot OK - 54.4% used (270.08 of 496.67 MB), (levels at 95.00/98.00%), trend: -5.92 MB / 168 hours, inodes available 511k/99.93%
proc_nginxMaster OK - 1 processes 38.4 MB virtual, 1.1 MB resident, 0.0% CPU
proc_nginxWorker OK - 2 processes 77.5 MB virtual, 4.0 MB resident, 0.0% CPU
proc_postfix OK - 1 processes 87.6 MB virtual, 2.2 MB resident, 0.0% CPU
proc_sshd OK - 1 processes 110.3 MB virtual, 4.3 MB resident, 0.0% CPU
OK - Agent version 1.2.6p12, execution time 0.3 sec|execution_time=0.311 user_time=0.860 system_time=0.080 children_user_time=0.000 children_system_time=0.000