Gecko [ goons4good.org ]

Name	Size	Permission	Date
a2cop.sh	5.28 KB	-rwxr-xr-x	2023-07-05 13:07
a2cop.sh.bak	5.22 KB	-rwxr-xr-x	2023-07-05 13:07
apache_up.sh	199 B	-rwxr-xr-x	2022-10-27 11:41
auto_fsck_off	81 B	-rwxr-xr-x	2022-10-27 11:41
backup_storage_config.sh	1.53 KB	-rwxr-xr-x	2022-08-15 03:10
cdns_check.sh	1.39 KB	-rwxr-xr-x	2022-10-27 11:41
check_autossl_domains.py	4.58 KB	-rwxr-xr-x	2023-07-04 02:48
check_autossl_excluded.sh	6.88 KB	-rwxr-xr-x	2023-05-22 11:59
check_clnrepos.sh	1.33 KB	-rwxr-xr-x	2024-10-14 15:57
check_rpmdb.sh	670 B	-rwxr-xr-x	2024-06-20 10:20
clean_authorized_keys.sh	2.24 KB	-rwxr-xr-x	2025-09-25 05:08
clean_htdocs.sh	1.13 KB	-rwxr-xr-x	2022-10-27 11:41
clean_temp.sh	301 B	-rwxr-xr-x	2022-10-27 11:41
cleanup-modsec-logs.sh	269 B	-rwxr-xr-x	2022-10-27 11:41
cpanel-config.sh	4.54 KB	-rwxr-xr-x	2025-01-10 04:36
cpanel.config.template	8.87 KB	-rwxr-xr-x	2025-01-09 03:02
cron_frequency.sh	145 B	-rwxr-xr-x	2022-10-27 11:41
dbgovernor_check.sh	92 B	-rwxr-xr-x	2022-10-27 11:41
disable_cpupdate_mdedi.sh	658 B	-rwx------	2024-02-06 02:56
enable_process_accounting.sh	130 B	-rwxr-xr-x	2022-10-27 11:41
fsck_no.sh	209 B	-rwxr-xr-x	2022-10-27 11:41
grubinst7.sh	1.43 KB	-rwxr-xr-x	2024-12-16 13:25
io_nice.sh	125 B	-rwxr-xr-x	2022-10-27 11:41
kill_php.sh	1.57 KB	-rwxr-xr-x	2022-10-27 11:41
litespeed_mailer.sh	2.18 KB	-rwxr-x---	2024-05-14 05:54
lsup_wrap.sh	2.72 KB	-rwx------	2024-09-19 15:53
mailperm_random.sh	117 B	-rwxr-xr-x	2022-10-27 11:41
mdedi_disk_monitoring.sh	6.76 KB	-rwx------	2024-04-18 04:49
mysql_dumpdbs_all.sh	5.81 KB	-rwxr-xr-x	2023-04-18 13:21
patchman-check.sh	106 B	-rwxr-xr-x	2022-10-27 11:41
php_handler_fix.sh	571 B	-rwxr-xr-x	2023-12-06 02:25
pull_disk_locator.sh	813 B	-rwxr-xr-x	2022-10-27 15:28
ramcheck.py	2.75 KB	-rwxr-xr-x	2023-03-21 12:53
randomize_litespeed_server_admin_password.sh	935 B	-rwxr-xr-x	2023-04-24 13:27
randomize_root_password.sh	265 B	-rwxr-xr-x	2022-10-27 11:41
randomize_sqlroot_password.sh	2.1 KB	-rwxr-xr-x	2023-06-19 01:28
referee	2.52 KB	-rwxr-xr-x	2022-10-27 11:41
salt_deployment_cleaner.sh	637 B	-rwxr-xr-x	2023-03-06 04:07
salt_minion_restart.sh	1.68 KB	-rwxr-xr-x	2022-12-19 04:12
upcp-major-at-scheduler.sh	621 B	-rwxr-xr-x	2022-09-29 15:30
upcp-major.sh	2.33 KB	-rwxr-xr-x	2022-10-12 13:41
update_localdomains.sh	60 B	-rwxr-xr-x	2022-10-27 11:41
updatecfips.sh	1.62 KB	-rwxr-xr-x	2023-05-22 11:59

Rename

#!/bin/bash
#
# Randomizing MySQL/MariaDB root user password.
# Ref : SYSENG-4047.
#       SYSENG-20728 - added WITH mysql_native_password for mysql80
#

mysql_version_min="57"
mariadb_version_min="102"
sql_conf_file="/root/.my.cnf"
sql_server_type=$(mysql -V | grep -o "MariaDB")
sql_root_pass=$(tr -dc 'a-zA-Z0-9-!@#%+' </dev/urandom | head -c 20)
sql_ver=$(mysqladmin version | awk '/Server version/{print $NF}' | awk -F "." '{print $1$2}')

# query function for mysql80
mysql80_reset_pw() {
  if sudo mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '${sql_root_pass}';"; then
    printf '%s\n' "[client]" "password=\"${sql_root_pass}\"" "user=root" >${sql_conf_file}
    logger -t $0 -i "sql root password updated sucessfully!"
  else
    logger -t $0 -i "Error updating sql root password"
    touch "/tmp/.randomize_sqlroot_password.failed"
  fi
}

# query function for newer sql versions
latest_sql_reset_pw() {
  if sudo mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '${sql_root_pass}';"; then
    printf '%s\n' "[client]" "password=\"${sql_root_pass}\"" "user=root" >${sql_conf_file}
    logger -t $0 -i "sql root password updated sucessfully!"
  else
    logger -t $0 -i "Error updating sql root password"
    touch "/tmp/.randomize_sqlroot_password.failed"
  fi
}

# query function for older sql versions
legacy_sql_reset_pw() {
  if sudo mysql -e "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('${sql_root_pass}');"; then
    printf '%s\n' "[client]" "password=\"${sql_root_pass}\"" "user=root" >${sql_conf_file}
    logger -t $0 -i "sql root password updated sucessfully!"
  else
    logger -t $0 -i "Error updating sql root password"
    touch "/tmp/.randomize_sqlroot_password.failed"
  fi
}

# change mysql root password
if [[ ${sql_server_type} != "MariaDB" ]]; then
  if [[ ${sql_ver} -lt ${mysql_version_min} ]]; then
    legacy_sql_reset_pw
  elif [[ ${sql_ver} -eq 80 ]]; then
    mysql80_reset_pw
  else
    latest_sql_reset_pw
  fi
else
  # change mariadb root password
  if [[ ${sql_ver} -lt ${mariadb_version_min} ]]; then
    legacy_sql_reset_pw
  else
    latest_sql_reset_pw
  fi
fi