Linux host2.homegym.sg 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64
Apache
Server IP : 159.223.38.192 & Your IP : 159.223.38.192
Domains : 20 Domain
User : eachadea
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Lock Shell
Lock File++
Readme
/
usr /
local /
cpanel /
scripts /
Delete
Unzip
Name
Size
Permission
Date
Action
cpan_sandbox
[ DIR ]
drwxr-xr-x
2024-05-22 18:59
php_sandbox
[ DIR ]
drwxr-xr-x
2024-05-22 18:59
zabbix
[ DIR ]
drwxr-xr-x
2024-05-29 15:09
MirrorSearch_pingtest
2.38
KB
-rwxr-xr-x
2024-05-22 18:59
activesync-invite-reply
1.69
KB
-rwxr-xr-x
2024-05-22 18:59
add_dns
2.36
KB
-rwxr-xr-x
2024-05-22 18:59
adddns
2.36
KB
-rwxr-xr-x
2024-05-22 18:59
addpop
6.08
KB
-rwxr-xr-x
2024-05-22 18:59
addsystemuser
3.27
KB
-rwxr-xr-x
2024-05-22 18:59
adduser
92
B
-rwxr-xr-x
2024-05-22 18:59
agent360.sh
16.03
KB
-rwx------
2025-09-17 21:17
apachelimits
4.31
KB
-rwxr-xr-x
2024-05-22 18:59
archive_sync_zones
3.05
KB
-rwxr-xr-x
2024-05-22 18:59
auto-adjust-mysql-limits
1.81
KB
-rwxr-xr-x
2024-05-22 18:59
autorepair
1.24
KB
-rwxr-xr-x
2024-05-22 18:59
backups_clean_metadata_for_missing_backups
1.57
KB
-rwxr-xr-x
2024-05-22 18:59
backups_create_metadata
15.75
KB
-rwxr-xr-x
2024-05-22 18:59
backups_list_user_files
4.56
KB
-rwxr-xr-x
2024-05-22 18:59
balance_linked_node_quotas
2.58
KB
-rwxr-xr-x
2024-05-22 18:59
biglogcheck
1.69
KB
-rwxr-xr-x
2024-05-22 18:59
build_bandwidthdb_root_cache_in_background
1.52
KB
-rwxr-xr-x
2024-05-22 18:59
build_cpnat
3.41
KB
-rwxr-xr-x
2024-05-22 18:59
build_mail_sni
3.87
KB
-rwxr-xr-x
2024-05-22 18:59
build_maxemails_config
1.14
KB
-rwxr-xr-x
2024-05-22 18:59
builddovecotconf
6.76
KB
-rwxr-xr-x
2024-05-22 18:59
buildeximconf
7
KB
-rwxr-xr-x
2024-05-22 18:59
buildhttpdconf
2.6
KB
-rwxr-xr-x
2024-05-22 18:59
buildpureftproot
539
B
-rwxr-xr-x
2024-05-22 18:59
ccs-check
4.91
KB
-rwxr-xr-x
2024-05-22 18:59
check_cpanel_pkgs
10.75
KB
-rwxr-xr-x
2024-05-22 18:59
check_domain_tls_service_domains.pl
6.68
KB
-rwxr-xr-x
2024-05-22 18:59
check_immutable_files
5.49
KB
-rwxr-xr-x
2024-05-22 18:59
check_mail_spamassassin_compiledregexps_body_0
187
B
-rwxr-xr-x
2024-05-22 18:59
check_maxmem_against_domains_count
3.57
KB
-rwxr-xr-x
2024-05-22 18:59
check_mount_procfs
2.02
KB
-rwxr-xr-x
2024-05-22 18:59
check_mysql
5.56
KB
-rwxr-xr-x
2024-12-11 18:06
check_plugin_pkgs
2.45
KB
-rwxr-xr-x
2024-05-22 18:59
check_security_advice_changes
8.28
KB
-rwxr-xr-x
2024-05-22 18:59
check_unmonitored_enabled_services
4.56
KB
-rwxr-xr-x
2024-05-22 18:59
check_unreliable_resolvers
3.59
KB
-rwxr-xr-x
2024-05-22 18:59
check_users_my_cnf
6.05
KB
-rwxr-xr-x
2024-05-22 18:59
check_valid_server_hostname
7.66
KB
-rwxr-xr-x
2024-05-22 18:59
checkalldomainsmxs
2.4
KB
-rwxr-xr-x
2024-05-22 18:59
checkbashshell
1.18
KB
-rwxr-xr-x
2024-05-22 18:59
checkccompiler
1.22
KB
-rwxr-xr-x
2024-05-22 18:59
checkexim.pl
3.1
KB
-rwxr-xr-x
2024-05-22 18:59
checklink
1.29
KB
-rwxr-xr-x
2024-05-22 18:59
checkusers
856
B
-rwxr-xr-x
2024-05-22 18:59
chkpaths
141
B
-rwxr-xr-x
2024-05-22 18:59
chpass
416
B
-rwxr-xr-x
2024-05-22 18:59
ckillall
1.11
KB
-rwxr-xr-x
2024-05-22 18:59
clean_dead_mailman_locks
2.09
KB
-rwxr-xr-x
2024-05-22 18:59
clean_up_temp_wheel_users
2.44
KB
-rwxr-xr-x
2024-05-22 18:59
clean_user_php_sessions
4.76
KB
-rwxr-xr-x
2024-05-22 18:59
cleandns
13.11
KB
-rwxr-xr-x
2024-05-22 18:59
cleandns8
417
B
-rwxr-xr-x
2024-05-22 18:59
cleanmsglog
735
B
-rwxr-xr-x
2024-05-22 18:59
cleanphpsessions
932
B
-rwxr-xr-x
2024-05-22 18:59
cleanphpsessions.php
658
B
-rw-r--r--
2024-05-22 18:59
cleanquotas
1.61
KB
-rwxr-xr-x
2024-05-22 18:59
cleansessions
5.89
KB
-rwxr-xr-x
2024-05-22 18:59
cleanupinterchange
2.64
KB
-rwxr-xr-x
2024-05-22 18:59
cleanupmysqlprivs
773
B
-rwxr-xr-x
2025-02-24 18:06
clear_cpaddon_ui_caches
1.27
KB
-rwxr-xr-x
2024-05-22 18:59
clear_orphaned_virtfs_mounts
3.56
KB
-rwxr-xr-x
2024-05-22 18:59
comparecdb
1.52
KB
-rwxr-xr-x
2024-05-22 18:59
compilers
2.86
KB
-rwxr-xr-x
2024-05-22 18:59
compilerscheck
999
B
-rwxr-xr-x
2024-05-22 18:59
configure_firewall_for_cpanel
520
B
-rwxr-xr-x
2024-05-22 18:59
configure_rh_firewall_for_cpanel
520
B
-rwxr-xr-x
2024-05-22 18:59
configure_rh_ipv6_firewall_for_cpanel
520
B
-rwxr-xr-x
2024-05-22 18:59
convert2dovecot
682
B
-rwxr-xr-x
2024-05-22 18:59
convert_accesshash_to_token
4.07
KB
-rwxr-xr-x
2024-05-22 18:59
convert_and_migrate_from_legacy_backup
1.97
KB
-rwxr-xr-x
2024-05-22 18:59
convert_maildir_to_mdbox
1.66
KB
-rwxr-xr-x
2024-05-22 18:59
convert_mdbox_to_maildir
1.66
KB
-rwxr-xr-x
2024-05-22 18:59
convert_roundcube_mysql2sqlite
26.12
KB
-rwxr-xr-x
2025-03-20 18:06
convert_to_dovecot_delivery
4.33
KB
-rwxr-xr-x
2024-05-22 18:59
convert_whmxfer_to_sqlite
1.46
KB
-rwxr-xr-x
2024-05-22 18:59
copy_user_mail_as_root
1.25
KB
-rwxr-xr-x
2024-05-22 18:59
copy_user_mail_as_user
1.34
KB
-rwxr-xr-x
2024-05-22 18:59
cpaddonsup
3.25
KB
-rwxr-xr-x
2024-05-22 18:59
cpan_config
2.8
KB
-rwxr-xr-x
2024-05-22 18:59
cpanel_initial_install
67.16
KB
-rwxr-xr-x
2025-09-18 18:06
cpanelsync
28.31
KB
-rwxr-xr-x
2024-05-22 18:59
cpanelsync_postprocessor
1.62
KB
-rwxr-xr-x
2024-05-22 18:59
cpanpingtest
965
B
-rwxr-xr-x
2024-05-22 18:59
cpbackup
44.79
KB
-rwxr-xr-x
2024-05-22 18:59
cpbackup_transport_file
5.65
KB
-rwxr-xr-x
2024-05-22 18:59
cpdig
2.09
KB
-rwxr-xr-x
2024-05-22 18:59
cpfetch
1.23
KB
-rwxr-xr-x
2024-05-22 18:59
cphulkdblacklist
433
B
-rwxr-xr-x
2024-05-22 18:59
cphulkdwhitelist
1.3
KB
-rwxr-xr-x
2024-05-22 18:59
cpservice
2.87
KB
-rwxr-xr-x
2024-05-22 18:59
cpuser_port_authority
19.29
KB
-rwxr-xr-x
2024-05-22 18:59
cpuser_service_manager
10.85
KB
-rwxr-xr-x
2024-05-22 18:59
createacct
27.78
MB
-rwx------
2025-10-16 18:06
custom_backup_destination.pl.sample
5.06
KB
-rwxr-xr-x
2024-05-22 18:59
custom_backup_destination.pl.skeleton
2.84
KB
-rwxr-xr-x
2024-05-22 18:59
dcpumon-wrapper
850
B
-rwxr-xr-x
2024-05-22 18:59
delpop
6.2
KB
-rwxr-xr-x
2024-05-22 18:59
detect_env_capabilities
508
B
-rwxr-xr-x
2024-05-22 18:59
disable_prelink
2.77
KB
-rwxr-xr-x
2024-05-22 18:59
disable_sqloptimizer
1.49
KB
-rwxr-xr-x
2024-05-22 18:59
disablefileprotect
2.19
KB
-rwxr-xr-x
2024-05-22 18:59
distro_changed_hook
1.16
KB
-rwxr-xr-x
2024-05-22 18:59
dnscluster
4.44
KB
-rwxr-xr-x
2024-05-22 18:59
dnsqueuecron
1.29
KB
-rwxr-xr-x
2024-05-22 18:59
dnssec-cluster-keys
3.75
KB
-rwxr-xr-x
2024-05-22 18:59
dovecot_maintenance
7.66
KB
-rwxr-xr-x
2025-04-15 18:06
dovecot_set_defaults.pl
984
B
-rwxr-xr-x
2024-05-22 18:59
dumpcdb
866
B
-rwxr-xr-x
2024-05-22 18:59
dumpinodes
687
B
-rwxr-xr-x
2024-05-22 18:59
dumpquotas
616
B
-rwxr-xr-x
2024-05-22 18:59
dumpstor
913
B
-rwxr-xr-x
2024-05-22 18:59
ea4_fresh_install
2.64
KB
-rwxr-xr-x
2024-05-22 18:59
edit_cpanelsync_exclude_list
2.58
KB
-rwxr-xr-x
2024-05-22 18:59
editquota
3.43
KB
-rwxr-xr-x
2024-05-22 18:59
elevate-cpanel
386.27
KB
-rwx------
2025-10-30 18:10
email_archive_maintenance
6.15
KB
-rwxr-xr-x
2024-05-22 18:59
email_hold_maintenance
1.46
KB
-rwxr-xr-x
2024-05-22 18:59
enable_spf_dkim_globally
8.83
KB
-rwxr-xr-x
2024-05-22 18:59
enable_sqloptimizer
1.57
KB
-rwxr-xr-x
2024-05-22 18:59
enablefileprotect
2.1
KB
-rwxr-xr-x
2024-05-22 18:59
ensure_autoenabled_features
3.01
MB
-rwx------
2025-10-16 18:06
ensure_conf_dir_crt_key
4.82
KB
-rwxr-xr-x
2024-05-22 18:59
ensure_cpuser_file_ip
2.55
KB
-rwxr-xr-x
2024-05-22 18:59
ensure_crontab_permissions
1.08
KB
-rwxr-xr-x
2024-05-22 18:59
ensure_dovecot_memory_limits_meet_minimum
3.13
KB
-rwxr-xr-x
2024-05-22 18:59
ensure_hostname_resolves
2.51
KB
-rwxr-xr-x
2025-03-26 18:06
ensure_includes
601
B
-rwxr-xr-x
2024-05-22 18:59
ensure_vhost_includes
13.53
KB
-rwxr-xr-x
2024-05-22 18:59
exim_tidydb
2.96
KB
-rwxr-xr-x
2024-05-22 18:59
eximconfgen
1.32
KB
-rwxr-xr-x
2024-05-22 18:59
eximstats_spam_check
867
B
-rwxr-xr-x
2024-05-22 18:59
expunge_expired_certificates_from_sslstorage
3.56
KB
-rwxr-xr-x
2024-05-22 18:59
expunge_expired_pkgacct_sessions
852
B
-rwxr-xr-x
2024-05-22 18:59
expunge_expired_transfer_sessions
1.06
KB
-rwxr-xr-x
2024-05-22 18:59
fastmail
5.16
KB
-rwxr-xr-x
2024-05-22 18:59
featuremod
1.92
KB
-rwxr-xr-x
2024-05-22 18:59
fetchfile
422
B
-rwxr-xr-x
2024-05-22 18:59
find_and_fix_rpm_issues
6.99
KB
-rwxr-xr-x
2024-09-13 18:06
find_outdated_services
6.06
KB
-rwxr-xr-x
2024-05-22 18:59
find_pids_with_inotify_watch_on_path
3.66
KB
-rwxr-xr-x
2024-05-22 18:59
fix-cpanel-perl
28.22
KB
-rwxr-xr-x
2025-10-16 18:06
fix-listen-on-localhost
3.52
KB
-rwxr-xr-x
2024-05-22 18:59
fix-web-vhost-configuration
6.15
KB
-rwxr-xr-x
2024-05-22 18:59
fix_addon_permissions
7.69
KB
-rwxr-xr-x
2025-06-18 18:06
fix_dns_zone_ttls
1.34
KB
-rwxr-xr-x
2024-05-22 18:59
fix_innodb_tables
4.05
KB
-rwxr-xr-x
2024-05-22 18:59
fix_reseller_acls
10.7
KB
-rwxr-xr-x
2025-06-18 18:06
fixetchosts
4.32
KB
-rwxr-xr-x
2024-05-22 18:59
fixheaders
572
B
-rwxr-xr-x
2024-05-22 18:59
fixmailinglistperms
1008
B
-rwxr-xr-x
2024-05-22 18:59
fixmailman
2.09
KB
-rwxr-xr-x
2024-05-22 18:59
fixnamedviews
1.22
KB
-rwxr-xr-x
2024-05-22 18:59
fixndc
413
B
-rwxr-xr-x
2024-05-22 18:59
fixquotas
18.39
KB
-rwxr-xr-x
2024-09-13 18:06
fixrelayd
1.74
KB
-rwxr-xr-x
2024-05-22 18:59
fixrndc
16.39
KB
-rwxr-xr-x
2024-05-22 18:59
fixtar
503
B
-rwxr-xr-x
2024-05-22 18:59
fixtlsversions
4.7
KB
-rwxr-xr-x
2024-05-22 18:59
fixvaliases
2
KB
-rwxr-xr-x
2024-05-22 18:59
fixwebalizer
966
B
-rwxr-xr-x
2024-05-22 18:59
forcelocaldomain
895
B
-rwxr-xr-x
2024-05-22 18:59
ftpfetch
2.2
KB
-rwxr-xr-x
2024-05-22 18:59
ftpquotacheck
8.31
KB
-rwxr-xr-x
2024-05-22 18:59
ftpsfetch
2.36
KB
-rwxr-xr-x
2024-05-22 18:59
ftpupdate
261
B
-rwxr-xr-x
2024-05-22 18:59
gather_update_log_stats
4.25
KB
-rwx------
2025-10-21 19:53
gather_update_logs_setupcrontab
5.45
KB
-rwx------
2025-10-21 19:53
gemwrapper
1.74
KB
-rwxr-xr-x
2024-05-22 18:59
gencrt
6.26
KB
-rwxr-xr-x
2024-05-22 18:59
generate_account_suspension_include
5.7
KB
-rwxr-xr-x
2024-05-22 18:59
generate_google_drive_credentials
1.11
KB
-rwxr-xr-x
2024-05-22 18:59
generate_google_drive_oauth_uri
984
B
-rwxr-xr-x
2024-05-22 18:59
generate_maildirsize
13.94
KB
-rwxr-xr-x
2024-05-22 18:59
gensysinfo
1.16
KB
-rwxr-xr-x
2024-05-22 18:59
get_locale_from_legacy_name_info
1.99
KB
-rwxr-xr-x
2024-05-22 18:59
getremotecpmove
12.67
KB
-rwxr-xr-x
2024-05-22 18:59
grpck
1.19
KB
-rwxr-xr-x
2024-05-22 18:59
hackcheck
3.02
KB
-rwxr-xr-x
2024-05-22 18:59
hook
1.45
KB
-rwxr-xr-x
2024-05-22 18:59
httpspamdetect
2.66
KB
-rwxr-xr-x
2024-05-22 18:59
hulk-unban-ip
3.97
MB
-rwx------
2025-10-16 18:06
import_exim_data
8.39
KB
-rwxr-xr-x
2024-05-22 18:59
increase_filesystem_limits
891
B
-rwxr-xr-x
2024-05-22 18:59
initacls
4.99
KB
-rwxr-xr-x
2024-05-22 18:59
initfpsuexec
444
B
-rwxr-xr-x
2024-05-22 18:59
initialize_360monitoring
2.76
KB
-rwx------
2025-07-25 20:58
initquotas
19.47
KB
-rwxr-xr-x
2025-06-18 18:06
initsuexec
4.03
KB
-rwxr-xr-x
2024-05-22 18:59
install_cpanel_analytics
1.93
KB
-rwxr-xr-x
2024-05-22 18:59
install_dovecot_fts
1.57
KB
-rwxr-xr-x
2024-05-22 18:59
install_plugin
2.8
KB
-rwxr-xr-x
2024-05-22 18:59
installpkg
575
B
-rwxr-xr-x
2024-05-22 18:59
installpostgres
6.46
KB
-rwxr-xr-x
2025-06-18 18:06
installsqlite3
1.82
KB
-rwxr-xr-x
2024-05-22 18:59
ipcheck
3.93
KB
-rwxr-xr-x
2024-05-22 18:59
ipusage
7.45
KB
-rwxr-xr-x
2024-05-22 18:59
isdedicatedip
602
B
-rwxr-xr-x
2024-05-22 18:59
jetbackup-check
3.69
KB
-rwxr-xr-x
2024-05-22 18:59
killdns
422
B
-rwxr-xr-x
2024-05-22 18:59
killdns-dnsadmin
1.15
KB
-rwxr-xr-x
2024-05-22 18:59
killmysqluserprivs
433
B
-rwxr-xr-x
2024-05-22 18:59
killmysqlwildcard
1.15
KB
-rwxr-xr-x
2024-05-22 18:59
killpvhost
853
B
-rwxr-xr-x
2024-05-22 18:59
killspamkeys
937
B
-rwxr-xr-x
2024-05-22 18:59
link_3rdparty_binaries
1.24
KB
-rwxr-xr-x
2024-05-22 18:59
linksubemailtomainacct
3.17
KB
-rwxr-xr-x
2024-05-22 18:59
listcheck
538
B
-rwxr-xr-x
2024-05-22 18:59
listsubdomains
1.05
KB
-rwxr-xr-x
2024-05-22 18:59
litespeed-check
3.86
KB
-rwxr-xr-x
2024-05-22 18:59
locale_export
5.21
KB
-rwxr-xr-x
2025-04-15 18:06
locale_import
4.35
KB
-rwxr-xr-x
2024-05-22 18:59
locale_info
3.99
KB
-rwxr-xr-x
2024-05-22 18:59
logo.dat
205
B
-rw-r--r--
2024-05-22 18:59
magicloader
1.94
KB
-rwxr-xr-x
2024-05-22 18:59
maildir_converter
6.08
KB
-rwxr-xr-x
2024-05-22 18:59
mailperm
16.53
KB
-rwxr-xr-x
2024-05-22 18:59
mailscannerupdate
2.42
KB
-rwxr-xr-x
2024-05-22 18:59
mainipcheck
10
KB
-rwxr-xr-x
2024-05-22 18:59
maintenance
46.22
KB
-rwxr-xr-x
2025-02-20 18:06
make_config
407
B
-rw-r--r--
2024-05-22 18:59
make_hostname_unowned
1.16
KB
-rwxr-xr-x
2024-05-22 18:59
manage_extra_marketing
12.41
KB
-rwx------
2025-08-26 21:44
manage_greylisting
16.19
KB
-rwxr-xr-x
2024-05-22 18:59
manage_mysql_profiles
16.33
KB
-rwxr-xr-x
2024-05-22 18:59
migrate_ccs_to_cpdavd
47.06
KB
-rwxr-xr-x
2025-02-20 18:06
migrate_local_ini_to_php_ini
7.41
KB
-rwxr-xr-x
2024-05-22 18:59
migrate_whmtheme_file_to_userdata
2.95
KB
-rwxr-xr-x
2024-05-22 18:59
mkwwwacctconf
2.33
KB
-rwxr-xr-x
2024-05-22 18:59
modify_accounts
4.07
KB
-rwxr-xr-x
2025-04-15 18:06
modify_featurelist
9.2
KB
-rwx------
2025-08-26 21:44
modify_packages
3.64
KB
-rwxr-xr-x
2025-04-15 18:06
modsec_vendor
15.63
KB
-rwxr-xr-x
2024-05-22 18:59
mysqlconnectioncheck
6.72
KB
-rwxr-xr-x
2024-09-13 18:06
mysqlpasswd
4.14
KB
-rwxr-xr-x
2024-09-13 18:06
named.ca
1.57
KB
-rw-r--r--
2024-05-22 18:59
named.rfc1912.zones
774
B
-rw-r--r--
2024-05-22 18:59
notify_expiring_certificates
9.37
KB
-rwxr-xr-x
2024-05-22 18:59
notify_expiring_certificates_on_linked_nodes
1.33
KB
-rwxr-xr-x
2024-05-22 18:59
oopscheck
1.12
KB
-rwxr-xr-x
2024-05-22 18:59
optimize_eximstats
3.88
KB
-rwxr-xr-x
2024-05-22 18:59
patch_mail_spamassassin_compiledregexps_body_0
2.39
KB
-rwxr-xr-x
2024-05-22 18:59
patchfdsetsize
2.72
KB
-rwxr-xr-x
2024-05-22 18:59
pedquota
2.26
KB
-rwxr-xr-x
2024-05-22 18:59
perform_sqlite_auto_rebuild_db_maintenance
1.98
KB
-rwxr-xr-x
2025-04-15 18:06
perlinstaller
528
B
-rwxr-xr-x
2024-05-22 18:59
perlmods
1.18
KB
-rwxr-xr-x
2024-05-22 18:59
php_fpm_config
9.73
KB
-rwxr-xr-x
2024-05-22 18:59
phpini_tidy
687
B
-rwxr-xr-x
2024-05-22 18:59
pkgacct
88.03
KB
-rwxr-xr-x
2024-11-20 18:06
post_snapshot
2.09
KB
-rwxr-xr-x
2024-09-13 18:06
post_sync_cleanup
6.09
KB
-rwxr-xr-x
2024-05-22 18:59
postupcp
107
B
-rwxr-xr-x
2025-07-02 18:06
primary_virtual_host_migration
2.44
KB
-rwxr-xr-x
2024-05-22 18:59
process_pending_cpanel_php_pear_registration
2.73
KB
-rwxr-xr-x
2025-06-18 18:06
process_site_templates
7.27
KB
-rwxr-xr-x
2024-05-22 18:59
proxydomains
9.64
KB
-rwxr-xr-x
2025-06-18 18:06
ptycheck
724
B
-rwxr-xr-x
2024-05-22 18:59
purge_modsec_log
1.53
KB
-rwxr-xr-x
2024-05-22 18:59
purge_old_config_caches
2.08
KB
-rwxr-xr-x
2024-05-22 18:59
pwck
708
B
-rwxr-xr-x
2024-05-22 18:59
quickdnslookup
1.13
KB
-rwxr-xr-x
2024-05-22 18:59
quickwhoisips
2.29
KB
-rwxr-xr-x
2024-05-22 18:59
quota_auto_fix
1.41
KB
-rwxr-xr-x
2024-05-22 18:59
quotacheck
22.36
KB
-rwxr-xr-x
2024-05-22 18:59
rawchpass
460
B
-rwxr-xr-x
2024-05-22 18:59
rdate
4.8
KB
-rwxr-xr-x
2024-05-22 18:59
realadduser
5.61
KB
-rwxr-xr-x
2024-05-22 18:59
realchpass
3.26
KB
-rwxr-xr-x
2024-05-22 18:59
realperlinstaller
5.67
KB
-rwxr-xr-x
2024-05-22 18:59
realrawchpass
425
B
-rwxr-xr-x
2024-05-22 18:59
rebuild_available_addons_packages_cache
1.27
KB
-rwxr-xr-x
2024-05-22 18:59
rebuild_available_rpm_addons_cache
1.27
KB
-rwxr-xr-x
2024-05-22 18:59
rebuild_bandwidthdb_root_cache
1.45
KB
-rwxr-xr-x
2024-05-22 18:59
rebuild_dbmap
5.8
KB
-rwxr-xr-x
2024-05-22 18:59
rebuild_provider_openid_connect_links_db
1.01
KB
-rwxr-xr-x
2024-05-22 18:59
rebuild_whm_chrome
2.22
KB
-rwxr-xr-x
2024-05-22 18:59
rebuilddnsconfig
25.5
KB
-rwxr-xr-x
2025-06-18 18:06
rebuildhttpdconf
2.6
KB
-rwxr-xr-x
2024-05-22 18:59
rebuildinstalledssldb
2.85
KB
-rwxr-xr-x
2024-05-22 18:59
rebuildippool
509
B
-rwxr-xr-x
2024-05-22 18:59
rebuilduserssldb
948
B
-rwxr-xr-x
2024-05-22 18:59
refresh-dkim-validity-cache
5.97
KB
-rwxr-xr-x
2024-05-22 18:59
regenerate_tokens
2.18
KB
-rwxr-xr-x
2024-05-22 18:59
remote_log_transfer
11.6
KB
-rwxr-xr-x
2024-05-22 18:59
remove_dovecot_index_files
5.89
KB
-rwxr-xr-x
2024-05-22 18:59
removeacct
26.37
MB
-rwx------
2025-10-16 18:06
rescan_user_dovecot_fts
2.98
KB
-rwxr-xr-x
2024-05-22 18:59
reset_mail_quotas_to_sane_values
6.82
KB
-rwxr-xr-x
2024-05-22 18:59
resetmailmanurls
2.03
KB
-rwxr-xr-x
2024-05-22 18:59
resetquotas
4.61
KB
-rwxr-xr-x
2024-05-22 18:59
restartsrv
3.19
KB
-rwxr-xr-x
2024-05-22 18:59
restartsrv_apache
422
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_apache_php_fpm
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_base
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_bind
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_chkservd
427
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_clamd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_cpanel_php_fpm
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_cpanellogd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_cpdavd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_cpgreylistd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_cphulkd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_cpipv6
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_cpsrvd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_crond
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_dnsadmin
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_dovecot
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_exim
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_eximstats
504
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_ftpd
426
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_ftpserver
911
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_httpd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_imap
437
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_inetd
2.47
KB
-rwxr-xr-x
2024-05-22 18:59
restartsrv_ipaliases
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_lmtp
437
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_mailman
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_mysql
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_named
579
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_nscd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_p0f
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_pdns
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_pop3
437
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_postgres
427
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_postgresql
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_powerdns
442
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_proftpd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_pureftpd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_queueprocd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_rsyslog
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_rsyslogd
437
B
-rwxr-xr-x
2024-05-22 18:59
restartsrv_spamd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_sshd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_syslogd
2.4
KB
-rwxr-xr-x
2024-05-22 18:59
restartsrv_tailwatchd
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_unknown
10.36
MB
-rwxr-xr-x
2025-10-16 18:06
restartsrv_xinetd
422
B
-rwxr-xr-x
2024-05-22 18:59
restorecpuserfromcache
1.96
KB
-rwxr-xr-x
2024-05-22 18:59
restorepkg
44.36
MB
-rwx------
2025-10-16 18:06
rfc1912_zones.tar
10
KB
-rw-r--r--
2024-05-22 18:59
rpmup
5.07
KB
-rwxr-xr-x
2024-05-22 18:59
rsync-user-homedir.pl
5.76
KB
-rwxr-xr-x
2024-05-22 18:59
run_if_exists
512
B
-rwxr-xr-x
2024-05-22 18:59
run_plugin_lifecycle
3.53
KB
-rwx------
2025-08-26 21:44
runstatsonce
440
B
-rwxr-xr-x
2024-05-22 18:59
runweblogs
1.02
KB
-rwxr-xr-x
2024-05-22 18:59
sa-update_wrapper
3.34
KB
-rwxr-xr-x
2024-05-22 18:59
safetybits.pl
844
B
-rwxr-xr-x
2024-05-22 18:59
secureit
4.72
KB
-rwxr-xr-x
2024-05-22 18:59
securemysql
4.4
KB
-rwxr-xr-x
2024-06-27 02:06
securerailsapps
3.58
KB
-rwxr-xr-x
2024-05-22 18:59
securetmp
16.76
KB
-rwxr-xr-x
2025-09-18 18:06
sendicq
474
B
-rwxr-xr-x
2024-05-22 18:59
servicedomains
9.64
KB
-rwxr-xr-x
2025-06-18 18:06
set_mailman_archive_perms
1.75
KB
-rwxr-xr-x
2024-05-22 18:59
setpostgresconfig
6.04
KB
-rwxr-xr-x
2024-05-22 18:59
setup_greylist_db
16.19
KB
-rwxr-xr-x
2024-05-22 18:59
setup_modsec_db
1.3
KB
-rwxr-xr-x
2024-05-22 18:59
setup_systemd_timer_for_plugins
3.92
KB
-rwx------
2025-08-26 21:44
setupftpserver
10.47
KB
-rwxr-xr-x
2024-05-22 18:59
setupmailserver
9.39
KB
-rwxr-xr-x
2025-06-18 18:06
setupnameserver
12.52
KB
-rwxr-xr-x
2024-09-13 18:06
shrink_modsec_ip_database
12.97
KB
-rwxr-xr-x
2024-05-22 18:59
simpleps
3.05
KB
-rwxr-xr-x
2024-05-22 18:59
slurp_exim_mainlog
5.78
KB
-rwxr-xr-x
2024-05-22 18:59
smartcheck
15.13
KB
-rwxr-xr-x
2025-06-18 18:06
smtpmailgidonly
8.15
KB
-rwxr-xr-x
2024-05-22 18:59
snapshot_prep
5.88
KB
-rwxr-xr-x
2024-09-13 18:06
spamassassin_dbm_cleaner
5.85
KB
-rwxr-xr-x
2024-05-22 18:59
spamassassindisable
3.74
KB
-rwxr-xr-x
2024-05-22 18:59
spamboxdisable
2.27
KB
-rwxr-xr-x
2024-05-22 18:59
sshcontrol
14.38
KB
-rwxr-xr-x
2024-05-22 18:59
ssl_crt_status
3.84
KB
-rwxr-xr-x
2024-05-22 18:59
suspendacct
18.01
KB
-rwxr-xr-x
2024-05-22 18:59
suspendmysqlusers
4.78
KB
-rwxr-xr-x
2024-05-22 18:59
swapip
3.82
KB
-rwxr-xr-x
2024-05-22 18:59
sync-mysql-users-from-grants
1.2
KB
-rwxr-xr-x
2024-05-22 18:59
sync_child_accounts
1.77
KB
-rwxr-xr-x
2024-05-22 18:59
sync_contact_emails_to_cpanel_users_files
1.14
KB
-rwxr-xr-x
2024-05-22 18:59
synccpaddonswithsqlhost
6.59
KB
-rwxr-xr-x
2024-05-22 18:59
synctransfers
1.92
KB
-rwxr-xr-x
2024-05-22 18:59
syslog_check
1.36
KB
-rwxr-xr-x
2024-05-22 18:59
sysup
645
B
-rwxr-xr-x
2024-05-22 18:59
test_sa_compiled
1.07
KB
-rwxr-xr-x
2024-05-22 18:59
transfer_account_as_user
2.34
KB
-rwxr-xr-x
2024-05-22 18:59
transfer_accounts_as_root
4.76
KB
-rwxr-xr-x
2024-05-22 18:59
transfer_in_progress
3.08
KB
-rwxr-xr-x
2024-05-22 18:59
transfer_in_progress.pod
312
B
-rw-r--r--
2024-05-22 18:59
transfermysqlusers
9.84
MB
-rwx------
2025-10-16 18:06
try-later
7.95
KB
-rwxr-xr-x
2024-05-22 18:59
unblockip
667
B
-rwxr-xr-x
2024-05-22 18:59
uninstall_cpanel_analytics
1.2
KB
-rwxr-xr-x
2024-05-22 18:59
uninstall_dovecot_fts
562
B
-rwxr-xr-x
2024-05-22 18:59
uninstall_plugin
2.84
KB
-rwxr-xr-x
2024-05-22 18:59
unlink_service_account
2.62
KB
-rwxr-xr-x
2024-05-22 18:59
unpkgacct
4.6
KB
-rwxr-xr-x
2024-05-22 18:59
unslavenamedconf
863
B
-rwxr-xr-x
2024-05-22 18:59
unsuspendacct
17.8
KB
-rwxr-xr-x
2024-05-22 18:59
unsuspendmysqlusers
7.1
KB
-rwxr-xr-x
2024-05-22 18:59
upcp
31.97
KB
-rwxr-xr-x
2024-11-20 18:06
upcp-running
2.7
KB
-rwxr-xr-x
2024-05-22 18:59
upcp.static
721.63
KB
-rwxr-xr-x
2025-10-16 18:06
update-packages
5.07
KB
-rwxr-xr-x
2024-05-22 18:59
update_apachectl
480
B
-rwxr-xr-x
2024-05-22 18:59
update_db_cache
430
B
-rwxr-xr-x
2024-05-22 18:59
update_dkim_keys
1.45
KB
-rwxr-xr-x
2024-05-22 18:59
update_exim_rejects
1.21
KB
-rwxr-xr-x
2024-05-22 18:59
update_existing_mail_quotas_for_account
4.78
KB
-rwxr-xr-x
2024-05-22 18:59
update_feature_flags
957
B
-rwxr-xr-x
2024-05-22 18:59
update_freebusy_data
5.25
KB
-rwxr-xr-x
2025-06-18 18:06
update_known_proxy_ips
1002
B
-rwxr-xr-x
2024-05-22 18:59
update_local_rpm_versions
4.56
KB
-rwxr-xr-x
2024-05-22 18:59
update_mailman_cache
8.34
KB
-rwxr-xr-x
2024-05-22 18:59
update_mysql_systemd_config
1.07
KB
-rwxr-xr-x
2025-06-18 18:06
update_neighbor_netblocks
487
B
-rwxr-xr-x
2024-05-22 18:59
update_sa_config
2.14
KB
-rwxr-xr-x
2024-05-22 18:59
update_spamassassin_config
10.73
KB
-rwxr-xr-x
2024-05-22 18:59
update_users_jail
691
B
-rwxr-xr-x
2024-05-22 18:59
update_users_vhosts
801
B
-rwxr-xr-x
2024-05-22 18:59
updatedomainips
605
B
-rwxr-xr-x
2024-05-22 18:59
updatenameserverips
1.66
KB
-rwxr-xr-x
2024-05-22 18:59
updatenow
5.18
KB
-rwxr-xr-x
2024-05-22 18:59
updatenow.static
2.02
MB
-rwxr-xr-x
2025-10-16 18:06
updatesigningkey
1.95
KB
-rwxr-xr-x
2024-05-22 18:59
updatessldomains
1.81
KB
-rwxr-xr-x
2024-05-22 18:59
updatesupportauthorizations
2.49
KB
-rwxr-xr-x
2024-05-22 18:59
updateuserdatacache
2.47
KB
-rwxr-xr-x
2024-05-22 18:59
updateuserdomains
774
B
-rwxr-xr-x
2024-05-22 18:59
upgrade_bandwidth_dbs
2.22
KB
-rwxr-xr-x
2024-05-22 18:59
upgrade_subaccount_databases
2.73
KB
-rwxr-xr-x
2024-05-22 18:59
userdata_wildcard_cleanup
5.74
KB
-rwxr-xr-x
2024-05-22 18:59
userdirctl
5.01
KB
-rwxr-xr-x
2024-05-22 18:59
validate_sshkey_passphrase
1.21
KB
-rwxr-xr-x
2024-05-22 18:59
verify_api_spec_files
757
B
-rwxr-xr-x
2024-05-22 18:59
verify_pidfile
1.96
KB
-rwxr-xr-x
2024-05-22 18:59
verify_vhost_includes
7.34
KB
-rwxr-xr-x
2024-05-22 18:59
vps_optimizer
7.82
KB
-rwxr-xr-x
2024-05-22 18:59
vzzo-fixer
725
B
-rwxr-xr-x
2024-05-22 18:59
whmlogin
2.33
KB
-rwxr-xr-x
2024-05-22 18:59
whoowns
1.13
KB
-rwxr-xr-x
2024-05-22 18:59
wwwacct
27.78
MB
-rwx------
2025-10-16 18:06
wwwacct2
88
B
-rwxr-xr-x
2024-05-22 18:59
xfer_rcube_schema_migrate.pl
2.4
KB
-rwxr-xr-x
2024-05-22 18:59
xfer_rcube_uid_resolver.pl
1.8
KB
-rwxr-xr-x
2024-05-22 18:59
xferpoint
3.13
KB
-rwxr-xr-x
2024-05-22 18:59
xfertool
16.23
KB
-rwxr-xr-x
2024-05-22 18:59
zoneexists
800
B
-rwxr-xr-x
2024-05-22 18:59
Save
Rename
#!/usr/local/cpanel/3rdparty/bin/perl # cpanel - scripts/manage_mysql_profiles Copyright 2022 cPanel, L.L.C. # All rights reserved. # copyright@cpanel.net http://cpanel.net # This code is subject to the cPanel license. Unauthorized copying is prohibited package scripts::manage_mysql_profiles; use strict; use Try::Tiny; use Cpanel::JSON (); use Getopt::Long (); use Cpanel::Backup::Config (); use Cpanel::Logger (); use Cpanel::LoadFile (); use Cpanel::Exception (); use Cpanel::Hooks (); use Cpanel::DIp::MainIP (); use Cpanel::SafeFile (); use Cpanel::SafeRun::Errors (); use Cpanel::Services::Enabled (); use Cpanel::MysqlUtils::MyCnf::Basic (); use Cpanel::MysqlUtils::MyCnf (); use Cpanel::MysqlUtils::Command (); use Cpanel::MysqlUtils::Connect (); use Cpanel::MysqlUtils::Quote (); use Cpanel::MysqlUtils::Integration (); use Cpanel::MysqlUtils::RemoteMySQL::ActivationJob (); use Cpanel::MysqlUtils::RemoteMySQL::ProfileManager (); use Cpanel::Config::LoadCpConf (); use Cpanel::Sys::Hostname (); exit run(@ARGV) unless caller(); sub run { my @cmdline_args = @_; return usage(1) if !@cmdline_args; unless ( $> == 0 && $< == 0 ) { return usage( 1, "[!] This program can only be run by root!\n" ); } my $opts = {}; Getopt::Long::GetOptionsFromArray( \@cmdline_args, 'activate=s' => \$opts->{'activate'}, 'import=s' => \$opts->{'import'}, 'force' => \$opts->{'force'}, 'export=s@' => \$opts->{'export'}, 'export_to=s' => \$opts->{'export_to'}, 'recreate_active_profile' => \$opts->{'recreate_active_profile'}, 'help|h' => \$opts->{'help'}, ); return usage(0) if $opts->{'help'}; return activate_profile( $opts->{'activate'} ) if $opts->{'activate'}; return import_profiles( $opts->{'import'}, $opts->{'force'} ) if $opts->{'import'}; return export_profiles( $opts->{'export'}, $opts->{'export_to'} ) if $opts->{'export'} && scalar @{ $opts->{'export'} }; return recreate_active_profile( $opts->{'force'} ) if $opts->{'recreate_active_profile'}; return usage(1); } sub recreate_active_profile { my $force = shift; try { my $profile_manager = Cpanel::MysqlUtils::RemoteMySQL::ProfileManager->new(); my $active_profile = $profile_manager->get_active_profile('dont_die'); if ( !$force && $active_profile ) { print "[!] '$active_profile' is already active.\n"; } else { print "[*] Recreating active profile …\n"; $profile_manager->generate_active_profile_if_none_set($force); $profile_manager->save_changes_to_disk(); my $active_profile = $profile_manager->get_active_profile('dont_die'); print "[+] New active profile created: $active_profile\n"; } } catch { _handle_failure( { 'action' => 'recreate', 'exception' => $_ } ); }; return 0; } sub import_profiles { my ( $input_file, $force ) = @_; try { open( my $input_file_fh, '<', $input_file ) or die Cpanel::Exception::create( 'IO::FileReadError', [ path => $input_file, error => $! ] ); my $json = Cpanel::JSON::LoadFile( $input_file_fh, $input_file ); die Cpanel::Exception::create( 'IO::FileReadError', [ path => $input_file, error => 'Invalid JSON data' ] ) if !$json || ref $json ne 'HASH'; print "[*] Importing MySQL profiles: " . join( ', ', ( keys %{$json} ) ) . "\n\n"; my $profile_manager = Cpanel::MysqlUtils::RemoteMySQL::ProfileManager->new(); my $existing_profiles = $profile_manager->read_profiles(); my $active_profile_exists = $profile_manager->get_active_profile('dont_die'); foreach my $profile_name ( keys %{$json} ) { my $overwrite = $force ? 1 : 0; if ( !$overwrite and exists $existing_profiles->{$profile_name} ) { print "[*] '$profile_name' already exists …\n"; next; # skip } # If an active profile is already present, then mark the newly # imported profile as inactive to avoid conflicts. if ( $json->{$profile_name}->{'active'} && $active_profile_exists ) { $json->{$profile_name}->{'active'} = 0; } $profile_manager->create_profile( { 'name' => $profile_name, %{ $json->{$profile_name} } }, { 'overwrite' => $overwrite } ); print "[+] '$profile_name' imported.\n"; } $profile_manager->save_changes_to_disk(); } catch { _handle_failure( { 'action' => 'import', 'exception' => $_ } ); }; return 0; } sub export_profiles { my ( $profiles_to_export_ar, $output_file ) = @_; print STDERR "[*] Exporting MySQL profiles: " . join( ', ', @{$profiles_to_export_ar} ) . "\n\n"; try { my $profile_manager = Cpanel::MysqlUtils::RemoteMySQL::ProfileManager->new( { 'read_only' => 1 } ); my $existing_profiles = $profile_manager->read_profiles(); my $output = {}; my $output_fh; if ($output_file) { open $output_fh, '>', $output_file or die Cpanel::Exception::create( 'IOError', 'Failed to open “[_1]” for writing: [_2]', [ $output_file, $! ] ); print STDERR "[*] Saving to '$output_file'\n"; } foreach my $profile_to_export ( @{$profiles_to_export_ar} ) { if ( not exists $existing_profiles->{$profile_to_export} ) { print STDERR "[!] Profile not found: $profile_to_export\n"; next; } $output->{$profile_to_export} = $existing_profiles->{$profile_to_export}; } # If there are any profiles to export, then output the json if ( scalar keys %{$output} ) { print { $output_fh ? $output_fh : \*STDOUT } Cpanel::JSON::pretty_dump($output); } else { print "\n[!] No profiles to export.\n"; } } catch { _handle_failure( { 'action' => 'export', 'exception' => $_ } ); }; return 0; } sub activate_profile { my $profile_name = shift; Cpanel::Hooks::hook( { 'category' => 'Whostmgr', 'event' => 'RemoteMySQL::activate_profile', 'stage' => 'pre', }, { 'profile_name' => $profile_name, }, ); my $activation_job = Cpanel::MysqlUtils::RemoteMySQL::ActivationJob->new($profile_name); my $profile_manager = Cpanel::MysqlUtils::RemoteMySQL::ProfileManager->new(); try { my $current_active_profile = $profile_manager->get_active_profile('dont_die'); # TODO: should we care about situations where the profile being switched to is the same as the active profile? print "[*] Current active MySQL profile: " . ( $current_active_profile || 'N/A' ) . " \n"; print "[*] Activating MySQL profile: $profile_name\n\n"; # Step 1: Validation. $activation_job->start_step('Validating profile'); try { $profile_manager->validate_profile($profile_name); } catch { $activation_job->fail_step( 'Validating profile', { 'error' => $_->to_string() } ); die Cpanel::Exception::create( 'RemoteMySQL::ActivationFailed', 'Failed to activate [asis,MySQL] profile, “[_1]”: [_2]', [ $profile_name, 'Failed to validate profile' ] ); }; $activation_job->done_step('Validating profile'); my $profile = $profile_manager->read_profiles()->{$profile_name}; # STEP 2: Update local root .my.cnf file $activation_job->start_step('Updating /root/.my.cnf'); my $old_my_cnf = Cpanel::LoadFile::loadfile('/root/.my.cnf'); my $is_localhost = Cpanel::Services::Enabled::is_enabled('mysql') && Cpanel::MysqlUtils::MyCnf::Basic::is_local_mysql( $profile->{'mysql_host'} ); if ( _update_local_mycnf( $profile, { localhost => $is_localhost } ) ) { $activation_job->done_step('Updating /root/.my.cnf'); } else { $activation_job->fail_step( 'Updating /root/.my.cnf', { 'error' => 'Failed to update /root/.my.cnf' } ); die Cpanel::Exception::create( 'RemoteMySQL::ActivationFailed', 'Failed to activate [asis,MySQL] profile, “[_1]”: [_2]', [ $profile_name, 'Failed to update /root/.my.cnf' ] ); } # STEP 3: Verify root cnf changes allows mysql* tools to work. Test with mysqladmin $activation_job->start_step('Testing /root/.my.cnf changes with mysqladmin'); my $ping_ok = eval { Cpanel::MysqlUtils::Connect::get_dbi_handle(); 1; }; if ( !$ping_ok ) { my $err = $@; $activation_job->fail_step( 'Testing /root/.my.cnf changes with mysqladmin', { 'error' => $err } ); $activation_job->start_step('Restoring /root/.my.cnf to previous version'); if ( _restore_old_mycnf($old_my_cnf) ) { $activation_job->done_step('Restoring /root/.my.cnf to previous version'); } else { $activation_job->fail_step( 'Restoring /root/.my.cnf to previous version', { 'error' => 'Failed to restore previous config.' } ); } die Cpanel::Exception::create( 'RemoteMySQL::ActivationFailed', 'Failed to activate [asis,MySQL] profile, “[_1]”: [_2]', [ $profile_name, 'Failed to connect to MySQL server after updating /root/.my.cnf' ] ); } $activation_job->done_step('Testing /root/.my.cnf changes with mysqladmin'); # STEP 4: Update DB cache $activation_job->start_step('Updating DB Cache'); Cpanel::SafeRun::Errors::saferunnoerror('/usr/local/cpanel/scripts/update_db_cache'); $activation_job->done_step('Updating DB Cache'); # STEP 5: Update cPanel Apps using MySQL $activation_job->start_step('Updating cPanel Apps that use MySQL'); Cpanel::MysqlUtils::Integration::update_apps_that_use_mysql(); $activation_job->done_step('Updating cPanel Apps that use MySQL'); my $cpconf_ref = Cpanel::Config::LoadCpConf::loadcpconf(); if ( !$is_localhost ) { # STEP 6: If going to remote host, then transfermysqlusers $activation_job->start_step('Transferring MySQL users to remote MySQL host'); Cpanel::SafeRun::Errors::saferunnoerror( '/usr/local/cpanel/bin/transfermysqlusers', '--from', $current_active_profile ); $activation_job->done_step('Transferring MySQL users to remote MySQL host'); # This addresses concerns with edge cases where 'skip_name_resolve' is set # on the remote MySQL server, and we can't depend on the 'hostname' authentication. # Especially, when the mysql server sees the connecting ip as something different than what the 'main ip' is, etc. # # In order to ensure that we are granting access to the 'proper' IP - we check the process list in mysql # to see what the 'connecting' IP is according to the remote MySQL server, and apply the grants on that IP address. my $mainip = Cpanel::MysqlUtils::Quote::safesqlstring( Cpanel::DIp::MainIP::getmainserverip() ); my $hostname = Cpanel::MysqlUtils::Quote::safesqlstring( Cpanel::Sys::Hostname::gethostname() ); my $clientip = Cpanel::MysqlUtils::Quote::safesqlstring( Cpanel::MysqlUtils::Command::sqlcmd('SELECT SUBSTRING_INDEX(`host`,":",1) FROM `information_schema`.`processlist` WHERE ID = CONNECTION_ID();') ); } $profile_manager->mark_profile_as_active($profile_name); $profile_manager->save_changes_to_disk(); # STEP 9: Update the backup config to not backup directories if remote if ( !$is_localhost ) { $activation_job->start_step('Updating backup settings'); my $backup_conf = Cpanel::Backup::Config::load(); if ( $backup_conf->{'MYSQLBACKUP'} eq 'both' or $backup_conf->{'MYSQLBACKUP'} eq 'dir' ) { $backup_conf->{'MYSQLBACKUP'} = 'accounts'; Cpanel::Backup::Config::save($backup_conf); } $activation_job->done_step('Updating backup settings'); } else { print "No need to adjust backup configuration since we are activating a local MySQL profile\n"; } $activation_job->mark_job_done(); } catch { $activation_job->mark_job_failed(); _handle_failure( { 'action' => 'activate', 'exception' => $_ } ); }; Cpanel::Hooks::hook( { 'category' => 'Whostmgr', 'event' => 'RemoteMySQL::activate_profile', 'stage' => 'post', }, { 'profile_name' => $profile_name, 'result' => $activation_job->{progress}{status} eq 'DONE' ? 1 : 0, }, ); return 0; } sub _restore_old_mycnf { my $old_my_cnf = shift; my $mylock = Cpanel::SafeFile::safeopen( \*MYCNF, '>', '/root/.my.cnf' ); if ($mylock) { print MYCNF $old_my_cnf; Cpanel::SafeFile::safeclose( \*MYCNF, $mylock ); return 1; } return; } sub _update_local_mycnf { my ( $profile_hr, $opts_hr ) = @_; my $unix_socket_connection = $opts_hr->{'localhost'} && $profile_hr->{'mysql_port'} == 3306; return Cpanel::MysqlUtils::MyCnf::update_mycnf( user => 'root', items => [ { host => ( $unix_socket_connection ? undef : $profile_hr->{'mysql_host'} ), user => $profile_hr->{'mysql_user'}, pass => $profile_hr->{'mysql_pass'}, port => $profile_hr->{'mysql_port'}, } ], ); } sub usage { my ( $retval, $msg ) = @_; my $fh = $retval ? \*STDERR : \*STDOUT; if ( !defined $msg ) { $msg = <<USAGE; $0 Utility to manage the MySQL profiles configured on the server. Available options: --import [/path/to/json/file] Imports the profiles contained in the specified JSON file. To force import and overwrite any existing profiles use the '--force' switch: $0 --import import.json --force --export [profile name] Exports one or more profiles. To export more than one profile, specify multiple switches: $0 --export profile1 --export profile2 To export the profiles to a file, specify the 'export_to' switch: $0 --export profile1 --export_to export.json Or redirect stdout: $0 --export profile1 > export.json --activate [profile name] Activates the profile specified. --recreate_active_profile If no active profile is present on the system, this option will allow you to (re)create the profile. It reads the current '/root/.my.cnf' file and creates a profile based on that information. If the 'force' flag is specified, this option will recreate the active profile, regardless of whether one exists or not, based on the content of '/root/.my.cnf'. --help Displays this help message. USAGE } print {$fh} $msg; return $retval; } sub _handle_failure { my $opts = shift; my $action = $opts->{'action'}; my $exceptions = ref $opts->{'exception'} eq 'HASH' ? $opts->{'exception'}->{'exceptions'} : [ $opts->{'exception'} ]; my $logger = Cpanel::Logger->new(); $logger->info( "Failed to $action MySQL profile(s). " . scalar @{$exceptions} . " error(s) occurred." ); my $index = 1; foreach my $error ( @{$exceptions} ) { $logger->info( "Error $index: " . Cpanel::Exception::get_string($error) ); $index++; } return 1; } 1;