Gecko [ goons4good.org ]

Name	Size	Permission	Date
cron	[ DIR ]	drwxr-xr-x	2025-07-23 04:12
add-pgsql-ipv6-support.sh	564 B	-rwxr-xr-x	2022-09-28 10:30
allow_cl.sh	3.3 KB	-rwxr-xr-x	2024-03-05 16:15
auth-removal.sh	1.95 KB	-rwx------	2023-01-23 13:29
block_ssh.sh	1.15 KB	-rwxr-xr-x	2023-05-23 21:01
cfm_control	4.65 KB	-rwxr-xr-x	2024-03-28 12:14
check_autossl_excluded.sh	6.88 KB	-rwxr-xr-x	2023-05-22 11:59
convert_to_clos.sh	5.73 KB	-rwxr-xr-x	2023-02-09 14:50
convert_to_core.sh	276 B	-rwx------	2025-04-01 06:33
disable_cpbackups.sh	1.39 KB	-rwxr-xr-x	2024-10-10 07:11
domain_check.py	6.24 KB	-rwxr-xr-x	2024-08-27 10:40
grubinst6.sh	230 B	-rwxr-xr-x	2022-10-27 11:41
grubinst7.sh	323 B	-rwxr-xr-x	2024-01-24 12:57
install-ipa.sh	2 KB	-rwxr-xr-x	2024-09-26 04:24
install-ipa.sh.bak	2.37 KB	-rwxr-xr-x	2023-07-05 13:07
install_cloudlinux.sh	1.31 KB	-rwxr-xr-x	2022-09-29 15:30
install_csf.sh	2.91 KB	-rwx------	2023-05-08 10:57
install_elasticsearch.sh	2.19 KB	-rwx------	2022-07-25 14:24
install_litespeed.sh	4.33 KB	-rwx------	2024-06-13 10:28
install_multiphp.sh	976 B	-rwx------	2022-10-10 14:55
install_redis.sh	709 B	-rwx------	2022-09-28 10:30
ipmicfg	429.04 KB	-rwxr-xr-x	2023-10-04 10:59
lets_encrypt_accept.sh	306 B	-rwxr-xr-x	2024-05-14 09:32
mailqueue_check.sh	1.65 KB	-rwxr-xr-x	2022-04-11 09:40
mysql_minor_upgrade.sh	9.33 KB	-rwxr-xr-x	2024-09-11 17:25
server-scripts_deployer.sh	13.54 KB	-rwxr-xr-x	2024-03-28 12:59
set_autossl_onlynotify_expiry.sh	1.91 KB	-rwxr-xr-x	2022-09-14 08:37
updatecfips.sh	1.62 KB	-rwxr-xr-x	2023-05-22 11:59
wp_plugin_scan.py	14.8 KB	-rw-------	2025-01-21 11:31

Rename

#!/bin/bash
#
# Ref - SYSENG-27158 - this script helps us upgrade minor MySQL/MariaDB versions easily
# Ref - SYSENG-27155 - Lock and unloick MySQL/MariaDB version for EL7/8, yum/dnf
#

help() {
  echo -e "$0 - a helper script to manage minor SQL versions\nAvailable options:\n$0 --check\n$0 --upgrade\n$0 --lock\n$0 --unlock\n$0 --gov-lock\n$0 --gov-unlock"
}
_option=$1
if [ -z "${_option}" ]; then
  echo "$0 requires an argument!"
  help
  exit
fi

_sql_version=$(/bin/salt-call grains.get mysql_version --out=newline_values_only | tr -d '.')
_sql_el_version=$(uname -r | grep -o "el[0-9]")
_sql_update_log="/var/log/mysql_minor_upgrade.log"
_apipass='Xazbcq6Y4cMFNJhGmBoy'
_sql_host=$(hostname -s)
version_lock_file="/etc/yum/pluginconf.d/versionlock.list"
_notify_slack() {
  if [ ! -f /var/tmp/silent_mysql_update ]; then
    curl -s -X POST https://engbot.a2hosted.com/send_message -H "API-Key: $_apipass" -H "Content-Type: application/json" -d "{\"channel\": \"GC577Q36G\", \"message\": \"$_sql_host : $message\" }"
  fi
}

if [ "${_sql_version}" -gt 100 ]; then
  _sql_server=cl-MariaDB${_sql_version}-server
  _sql_provider=cl-MariaDB${_sql_version}
else
  _sql_server=cl-MySQL${_sql_version}-server
  _sql_provider=cl-MySQL${_sql_version}
fi
sql_current_version=$(rpm -q ${_sql_server} | awk -F '.module' '{print $1}')

sql_check_update() {
  if [ "${_sql_el_version}" == "el7" ]; then
    sql_avail_version=$(yum check-update ${_sql_server} --disableexcludes=all | grep ${_sql_server} | awk '{print $2}' | awk -F '.el7' '{print $1}')
    sql_locked_packages=$(grep -c ${_sql_provider} ${version_lock_file} 2>/dev/null)
    if [ -n "${sql_avail_version}" ]; then
      echo "Update available:- ${sql_current_version} -> ${sql_avail_version}"
    elif [ -e "${version_lock_file}" ] && [ "${sql_locked_packages}" -gt 2 ]; then
      echo "Current version: ${sql_current_version}, unable to check update as version is locked for ${_sql_provider}"
    else
      echo "No update available:- current version: ${sql_current_version}"
    fi
  elif [ "${_sql_el_version}" == "el8" ]; then
    sql_avail_version=$(yum check-update ${_sql_server} --disableexcludes=all | grep ${_sql_server} | awk '{print $2}' | awk -F '.module' '{print $1}')
    sql_locked_packages=$(grep -c ${_sql_provider} ${version_lock_file} 2>/dev/null)
    if [ -n "${sql_avail_version}" ]; then
      echo "Update available:- ${sql_current_version} -> ${sql_avail_version}"
    elif [ -e "${version_lock_file}" ] && [ "${sql_locked_packages}" -gt 2 ]; then
      echo "Current version: ${sql_current_version}, unable to check update as version is locked for ${_sql_provider}"
    else
      echo "No update available:- current version: ${sql_current_version}"
    fi
  else
    echo "unsupported el system!"
  fi
}

sql_update() {
  sql_locked_packages=$(grep -c ${_sql_provider} ${version_lock_file} 2>/dev/null)
  if [ "${_sql_el_version}" == "el7" ]; then
    sql_avail_version=$(yum check-update ${_sql_server} --disableexcludes=all | grep ${_sql_server} | awk '{print $2}' | awk -F '.el7' '{print $1}')
    if [ -n "${sql_avail_version}" ]; then
      echo "Updating:- ${sql_current_version} -> ${sql_avail_version}, this might take a while.."
      yum update ${_sql_provider}* --disableexcludes=all -y >> ${_sql_update_log} 2>&1
      sql_new_version=$(rpm -q ${_sql_server} | awk -F '.module' '{print $1}')
      if [ "${sql_current_version}" != "${sql_new_version}" ]; then
        message="${_sql_host} - SQL Minor Upgrade : ${_sql_server} upgraded from ${sql_current_version} to ${sql_new_version}"
        _notify_slack
	echo "${message}"
      fi
    elif [ -e "${version_lock_file}" ] && [ "${sql_locked_packages}" -gt 2 ]; then
      echo "Current version: ${sql_current_version}, unable to check or upgrade as version is locked for ${_sql_provider}"
    else
      echo "No update available:- current version: ${sql_current_version}"
    fi
  elif [ "${_sql_el_version}" == "el8" ]; then
    sql_avail_version=$(yum check-update ${_sql_server} --disableexcludes=all | grep ${_sql_server} | awk '{print $2}' | awk -F '.module' '{print $1}')
    if [ -n "${sql_avail_version}" ]; then
      echo "Updating:- ${sql_current_version} -> ${sql_avail_version}, this might take a while.."
      yum update ${_sql_provider}* --disableexcludes=all -y >> ${_sql_update_log} 2>&1
      sql_new_version=$(rpm -q ${_sql_server} | awk -F '.module' '{print $1}')
      if [ "${sql_current_version}" != "${sql_new_version}" ]; then
        message="${_sql_host} - SQL Minor Upgrade : ${_sql_server} upgraded from ${sql_current_version} to ${sql_new_version}"
        _notify_slack
	echo "${message}"
      fi
    elif [ -e "${version_lock_file}" ] && [ "${sql_locked_packages}" -gt 2 ]; then
      echo "Current version: ${sql_current_version}, unable to check or upgrade as version is locked for ${_sql_provider}"
    else
      echo "No update available:- current version: ${sql_current_version}"
    fi
  else
    echo "unsupported el system!"
  fi
}

sql_lock() {
  if [ "${_sql_el_version}" == "el7" ]; then
    version_lock_rpm="rpm -q yum-plugin-versionlock"
    if [ -e "${version_lock_file}" ] && [ -n "${version_lock_rpm}" ];then
      echo -e "Locking ${_sql_provider}* with minor version ${sql_current_version}"
      yum versionlock "${_sql_provider}*"
      sql_locked_packages=$(grep -c ${_sql_provider} ${version_lock_file} 2>/dev/null)
      if [ -e "${version_lock_file}" ] && [ "${sql_locked_packages}" -lt 2 ]; then
        echo "Locking ${_sql_provider}* failed, check packages in: ${version_lock_file}"
      else
        echo "Locking ${_sql_provider}* succesful"
      fi
    else
      echo "Unable to lock ${_sql_provider}*, check if package yum-plugin-versionlock installed"
    fi
  elif [ "${_sql_el_version}" == "el8" ]; then
    version_lock_rpm="rpm -q python3-dnf-plugin-versionlock"
    if [ -e "${version_lock_file}" ] && [ -n "${version_lock_rpm}" ];then
      echo -e "Locking ${_sql_provider}* with minor version ${sql_current_version}"
      yum versionlock "${_sql_provider}*"
      sql_locked_packages=$(grep -c ${_sql_provider} ${version_lock_file} 2>/dev/null)
      if [ -e "${version_lock_file}" ] && [ "${sql_locked_packages}" -lt 2 ]; then
        echo "Locking ${_sql_provider}* failed, check packages in: ${version_lock_file}"
      else
        echo "Locking ${_sql_provider}* succesful"
      fi
    else
      echo "Unable to lock ${_sql_provider}*, check if package python3-dnf-plugin-versionlock installed"
    fi
  else
    echo "unsupported el system!"
  fi
}

sql_unlock() {
  if [ "${_sql_el_version}" == "el7" ]; then
    version_lock_rpm="rpm -q yum-plugin-versionlock"
    if [ -e "${version_lock_file}" ] && [ -n "${version_lock_rpm}" ];then
      echo -e "Unlocking ${_sql_provider}*"
      yum versionlock delete "${_sql_provider}*"
      sql_locked_packages=$(grep -c ${_sql_provider} ${version_lock_file} 2>/dev/null)
      if [ -e "${version_lock_file}" ] && [ "${sql_locked_packages}" -ne 0 ]; then
        echo "Unlocking ${_sql_provider}* might have failed, check packages in: ${version_lock_file} or run yum versionlock delete ${_sql_provider}* again."
      else
        echo "Unlocking version ${_sql_provider}* succesful"
      fi
    else
      echo "Unable to lock ${_sql_provider}*, check if package yum-plugin-versionlock installed"
    fi
  elif [ "${_sql_el_version}" == "el8" ]; then
    version_lock_rpm="rpm -q python3-dnf-plugin-versionlock"
    if [ -e "${version_lock_file}" ] && [ -n "${version_lock_rpm}" ];then
      echo -e "Unlocking ${_sql_provider}*"
      yum versionlock delete "${_sql_provider}*"
      sql_locked_packages=$(grep -c ${_sql_provider} ${version_lock_file} 2>/dev/null)
      if [ -e "${version_lock_file}" ] && [ "${sql_locked_packages}" -ne 0 ]; then
        echo "Unlocking ${_sql_provider}* might have failed, check packages in: ${version_lock_file} or run yum versionlock delete ${_sql_provider}* again."
      else
        echo "Unlocking version ${_sql_provider}* succesful"
      fi
    else
      echo "Unable to lock ${_sql_provider}*, check if package yum-plugin-versionlock installed"
    fi
  else
    echo "unsupported el system!"
  fi
}

# lock/unlock governor-mysql
_sql_gov="governor-mysql"
sql_gov_lock() {
  yum versionlock "${_sql_gov}"
  sql_gov_locked_packages=$(grep -c ${_sql_gov} ${version_lock_file} 2>/dev/null)
  if [ -e "${version_lock_file}" ] && [ "${sql_gov_locked_packages}" -lt 1 ]; then
    echo "Locking ${_sql_gov} failed, check packages in: ${version_lock_file}"
  else
    echo "Locking ${_sql_gov} succesful"
  fi
}

sql_gov_unlock() {
  yum versionlock delete "${_sql_gov}"
  sql_gov_locked_packages=$(grep -c ${_sql_gov} ${version_lock_file} 2>/dev/null)
  if [ -e "${version_lock_file}" ] && [ "${sql_gov_locked_packages}" -ne 0 ]; then
    echo "Unlocking ${_sql_gov} failed, check packages in: ${version_lock_file}"
  else
    echo "Unlocking ${_sql_gov} succesful"
  fi
}

if [ "${_option}" == "--check" ]; then
  sql_check_update
elif [ "${_option}" == "--upgrade" ]; then
  sql_update | tee -a ${_sql_update_log}
elif [ "${_option}" == "--lock" ]; then
  sql_lock | tee -a ${_sql_update_log}
elif [ "${_option}" == "--unlock" ]; then
  sql_unlock | tee -a ${_sql_update_log}
elif [ "${_option}" == "--gov-lock" ]; then
  sql_gov_lock | tee -a ${_sql_update_log}
elif [ "${_option}" == "--gov-unlock" ]; then
  sql_gov_unlock | tee -a ${_sql_update_log}
else
  echo "${_option} is not a supported argument"
  help
fi