####
#	Version of linux I am running this on.
####
[root@mhdal05zm01 bin]# uname -a
Linux mhdal05zm01.mhsl.local 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

####
#	Currently running a MySQL cluster
#	Percona XtraDB Cluster
####
Server version:         5.7.24-26-57-log Percona XtraDB Cluster (GPL), Release rel26, Revision 65db531, WSREP version 31.33, wsrep_31.33


####
#	Current version of Zabbix Server
####
zabbix_server (Zabbix) 4.0.3
Revision 87993 20 December 2018, compilation time: Dec 20 2018 11:29:33

Copyright (C) 2018 Zabbix SIA
License GPLv2+: GNU GPL version 2 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it according to
the license. There is NO WARRANTY, to the extent permitted by law.

This product includes software developed by the OpenSSL Project
for use in the OpenSSL Toolkit (http://www.openssl.org/).

Compiled with OpenSSL 1.0.1e-fips 11 Feb 2013
Running with OpenSSL 1.0.1e-fips 11 Feb 2013

###
#	My current /etc/zabbix/zabbix_server.conf
#
###
LogFile=/var/log/zabbix/zabbix_server.log
LogFileSize=500
DebugLevel=3
PidFile=/var/run/zabbix/zabbix_server.pid
DBName=zabbix40
DBUser=zabbix
DBPassword=super-special
DBSocket=/var/lib/mysql-3306/mysql.sock
StartPollers=25
StartIPMIPollers=2
StartPollersUnreachable=10
StartTrappers=25
StartPingers=25
StartDiscoverers=5
StartHTTPPollers=5
StartTimers=10
StartEscalators=3
StartAlerters=1
StartVMwareCollectors=2
VMwareFrequency=60
VMwarePerfFrequency=60
VMwareCacheSize=512M
VMwareTimeout=10
SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
StartSNMPTrapper=1
CacheSize=2G
CacheUpdateFrequency=60
StartDBSyncers=10
HistoryCacheSize=512M
HistoryIndexCacheSize=512M
TrendCacheSize=512M
ValueCacheSize=512M
Timeout=3
TrapperTimeout=60
AlertScriptsPath=/usr/local/bin/
ExternalScripts=/usr/lib/zabbix/externalscripts
LogSlowQueries=3000
StartProxyPollers=2
AllowRoot=1


####
#	Basic test script used to validate if media type is working correctly.
####

[root@mhdal05zm01 bin]# cat simple-script-test
#!/bin/bash

timestamp=`date +%s`

echo $(date +%T)":"$timestamp "param count=$# - param 1: $1 - param 2: $2 - param 3: $3" >> /tmp/simple-script-test.log


####
#	SQL Queries used to reset actions table errors.
####

# Count the errors
select count(*) from alerts where status=2 and error like'%No such file or directory%';

# Reset the errored records for another try
update alerts set status=0, retries=1, error='' where status=2 and error like'%No such file or directory%';

# Command example to run sql query from bash
mysql -u <user> -p -e "select * from schema.table"

# Command to kill (single) alerter process.
kill -9 $(ps aux | grep -e alerter | grep -v grep | awk '{ print $2 }')

# Command to kill multipule alerter processes at once

killall -r --regexp alerter # untested

for KILLPID in `ps ax | grep 'alerter' | grep -v grep | awk ' { print $1;}'`; do 
  kill -9 $KILLPID;
done

#