support for mysql 5.6+ login paths

[samva259]

Thank you very much for making this available. I have a small improvement request. Could support for the --login-path parameter for the mysql client be added to this script ?

For example if a new "-l" switch was added the affected lines of code might be something like these (plus relevant documentation changes):

...
while getopts "H:P:u:p:S:s:w:c:o:m:h:l" Input;
...
l) loginpath="--login-path=${OPTARG}";;
...
then for the case we receive the -l switch the invoke of the mysql client would be

ConnectionResult=$(mysql ${loginpath} ${optfile} ... -e "show slave ${connection} status\G" 2>&1)
...

Thank you again for considering this

[samva259]

sample code to add support for --login-path parameter as an alternative to --user and --password parameters, and to add some logic to check for conflicting parameter(s):
...
#########################################################################

Usage: ./check_mysql_slavestatus.sh (-o file|(-H dbhost [-P port]|-S socket) (-u dbuser -p dbpass|-l loginpath)) [-s connection] [-w integer] [-c integer] [-m integer]

#########################################################################
help="\ncheck_mysql_slavestatus.sh (c) 2008-2019 GNU GPLv2 licence
Usage: $0 (-o file|(-H dbhost [-P port]|-S socket) (-u username -p password|-l loginpath)) [-s connection] [-w integer] [-c integer] [-m]\n
Options:\n-o Path to option file containing connection settings (e.g. /home/nagios/.my.cnf). Note: If this option is used, -H, -u, -p, -l parameters will become optional\n-H Hostname or IP of slave server\n-P MySQL Port of slave server (optional, defaults to 3306)\n-u Username of DB-user\n-p Password of DB-user\n-l Login Path (used instead of Username and Password)\n-S database socket\n-s Connection name (optional, with multi-source replication)\n-w Replication delay in seconds for Warning status (optional)\n-c Replication delay in seconds for Critical status (optional)\n-m Threshold in seconds since when replication did not move (compares the slaves log position)\n
Attention: The DB-user you type in must have CLIENT REPLICATION rights on the DB-server. Example:\n\tGRANT REPLICATION CLIENT on . TO 'nagios'@'%' IDENTIFIED BY 'secret';"
...
while getopts "H:P:u:p:S:s:w:c:o:m:l:h" Input;
...
l) loginpath_p="y";loginpath="--login-path=${OPTARG}";;
...

Check whether all required arguments were passed in (either option file or full connection settings)

if [[ -z "${optfile}" && -z "${host}" && -z "${socket}" && -z "${loginpath}" ]]; then
echo -e "Missing required parameter(s)"; exit ${STATE_UNKNOWN}
elif [[ -z "${optfile}" && ((-z "${host}" && -z "${socket}") || (-z "${loginpath}" && (-z "${user}" || -z "${password}"))) ]]; then
echo -e "Missing required parameter(s)"; exit ${STATE_UNKNOWN}
elif [[ -z "${optfile}" && (-n "${host}" && -n "${socket}") ]]; then
echo -e "Conflicting parameter(s)"; exit ${STATE_UNKNOWN}
elif [[ -z "${optfile}" && (-n "${loginpath}" && -n "${user}") ]]; then
echo -e "Conflicting parameter(s)"; exit ${STATE_UNKNOWN}
elif [[ -z "${optfile}" && (-n "${loginpath}" && -n "${password}") ]]; then
echo -e "Conflicting parameter(s)"; exit ${STATE_UNKNOWN}
fi
...

Connect to the DB server and store output in vars

if [[ -n $loginpath ]]; then
if [[ -n $socket ]]; then
ConnectionResult=$(mysql ${loginpath} ${optfile} ${socket} -e "show slave ${connection} status\G" 2>&1)
else
ConnectionResult=$(mysql ${loginpath} ${optfile} ${host} ${port} -e "show slave ${connection} status\G" 2>&1)
fi
else
if [[ -n $socket ]]; then
ConnectionResult=$(mysql ${optfile} ${socket} ${user} -e "show slave ${connection} status\G" 2>&1)
else
ConnectionResult=$(mysql ${optfile} ${host} ${port} ${user} -e "show slave ${connection} status\G" 2>&1)
fi
fi
...