Linux 186-227-203-186.cprapid.com 4.18.0-553.22.1.lve.1.el8.x86_64 #1 SMP Tue Oct 8 15:52:54 UTC 2024 x86_64
Apache
Server IP : 186.227.203.186 & Your IP : 216.73.216.196
Domains : 154 Domain
User : pmcaxingo
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-11-04 17:30
php_sandbox
[ DIR ]
drwxr-xr-x
2024-11-04 17:30
MirrorSearch_pingtest
2.38
KB
-rwxr-xr-x
2024-11-04 17:30
activesync-invite-reply
1.69
KB
-rwxr-xr-x
2024-11-04 17:30
add_dns
2.36
KB
-rwxr-xr-x
2024-11-04 17:30
adddns
2.36
KB
-rwxr-xr-x
2024-11-04 17:30
addpop
6.08
KB
-rwxr-xr-x
2024-11-04 17:30
addsystemuser
3.27
KB
-rwxr-xr-x
2024-11-04 17:30
adduser
92
B
-rwxr-xr-x
2024-11-04 17:30
agent360.sh
16.03
KB
-rwx------
2026-04-13 20:58
apachelimits
4.31
KB
-rwxr-xr-x
2024-11-04 17:30
archive_sync_zones
3.05
KB
-rwxr-xr-x
2024-11-04 17:30
auto-adjust-mysql-limits
1.81
KB
-rwxr-xr-x
2024-11-04 17:30
autorepair
1.24
KB
-rwxr-xr-x
2024-11-04 17:30
backup_jobs_helper
10.88
KB
-rwxr-xr-x
2026-06-08 21:46
backups_clean_metadata_for_missing_backups
1.57
KB
-rwxr-xr-x
2024-11-04 17:30
backups_create_metadata
15.75
KB
-rwxr-xr-x
2024-11-04 17:30
backups_list_user_files
4.56
KB
-rwxr-xr-x
2024-11-04 17:30
balance_linked_node_quotas
2.58
KB
-rwxr-xr-x
2024-11-04 17:30
biglogcheck
1.69
KB
-rwxr-xr-x
2024-11-04 17:30
build_bandwidthdb_root_cache_in_background
1.52
KB
-rwxr-xr-x
2024-11-04 17:30
build_cpnat
3.41
KB
-rwxr-xr-x
2024-11-04 17:30
build_mail_sni
3.87
KB
-rwxr-xr-x
2024-11-04 17:30
build_maxemails_config
1.14
KB
-rwxr-xr-x
2024-11-04 17:30
builddovecotconf
9.64
KB
-rwxr-xr-x
2026-01-09 03:04
buildeximconf
7
KB
-rwxr-xr-x
2024-11-04 17:30
buildhttpdconf
2.6
KB
-rwxr-xr-x
2024-11-04 17:30
buildpureftproot
539
B
-rwxr-xr-x
2024-11-04 17:30
call_pkgacct
2.25
KB
-rwxr-xr-x
2026-06-08 21:46
ccs-check
4.91
KB
-rwxr-xr-x
2024-11-04 17:30
check_cpanel_pkgs
10.75
KB
-rwxr-xr-x
2024-11-04 17:30
check_domain_tls_service_domains.pl
6.68
KB
-rwxr-xr-x
2024-11-04 17:30
check_immutable_files
5.49
KB
-rwxr-xr-x
2024-11-04 17:30
check_mail_spamassassin_compiledregexps_body_0
187
B
-rwxr-xr-x
2024-11-04 17:30
check_maxmem_against_domains_count
3.57
KB
-rwxr-xr-x
2024-11-04 17:30
check_mount_procfs
2.02
KB
-rwxr-xr-x
2024-11-04 17:30
check_mysql
5.56
KB
-rwxr-xr-x
2024-12-06 03:04
check_plugin_pkgs
2.45
KB
-rwxr-xr-x
2024-11-04 17:30
check_security_advice_changes
8.28
KB
-rwxr-xr-x
2024-11-04 17:30
check_unmonitored_enabled_services
4.56
KB
-rwxr-xr-x
2024-11-04 17:30
check_unreliable_resolvers
3.59
KB
-rwxr-xr-x
2024-11-04 17:30
check_users_my_cnf
6.05
KB
-rwxr-xr-x
2024-11-04 17:30
check_valid_server_hostname
7.66
KB
-rwxr-xr-x
2024-11-04 17:30
checkalldomainsmxs
2.4
KB
-rwxr-xr-x
2024-11-04 17:30
checkbashshell
1.18
KB
-rwxr-xr-x
2024-11-04 17:30
checkccompiler
1.22
KB
-rwxr-xr-x
2024-11-04 17:30
checkexim.pl
3.1
KB
-rwxr-xr-x
2024-11-04 17:30
checklink
1.29
KB
-rwxr-xr-x
2024-11-04 17:30
checkusers
856
B
-rwxr-xr-x
2024-11-04 17:30
chkpaths
141
B
-rwxr-xr-x
2024-11-04 17:30
chpass
416
B
-rwxr-xr-x
2024-11-04 17:30
ckillall
1.11
KB
-rwxr-xr-x
2024-11-04 17:30
cl_pkg_verify_hook.py
2.38
KB
-rwxr-xr-x
2026-06-03 03:06
clean_dead_mailman_locks
2.09
KB
-rwxr-xr-x
2024-11-04 17:30
clean_up_temp_wheel_users
2.44
KB
-rwxr-xr-x
2024-11-04 17:30
clean_user_php_sessions
4.76
KB
-rwxr-xr-x
2024-11-04 17:30
cleandns
13.11
KB
-rwxr-xr-x
2024-11-04 17:30
cleandns8
417
B
-rwxr-xr-x
2024-11-04 17:30
cleanmsglog
735
B
-rwxr-xr-x
2024-11-04 17:30
cleanphpsessions
932
B
-rwxr-xr-x
2024-11-04 17:30
cleanphpsessions.php
658
B
-rw-r--r--
2024-11-04 17:30
cleanquotas
1.61
KB
-rwxr-xr-x
2024-11-04 17:30
cleansessions
5.89
KB
-rwxr-xr-x
2024-11-04 17:30
cleanupinterchange
2.64
KB
-rwxr-xr-x
2024-11-04 17:30
cleanupmysqlprivs
773
B
-rwxr-xr-x
2025-02-25 03:04
clear_orphaned_virtfs_mounts
3.56
KB
-rwxr-xr-x
2024-11-04 17:30
comet_license_registration_sync
1.67
KB
-rwxr-xr-x
2026-06-08 21:46
comet_protected_item_maintenance
20.78
KB
-rwxr-xr-x
2026-06-08 21:46
comparecdb
1.52
KB
-rwxr-xr-x
2024-11-04 17:30
compilers
2.86
KB
-rwxr-xr-x
2024-11-04 17:30
compilerscheck
999
B
-rwxr-xr-x
2024-11-04 17:30
configure_firewall_for_cpanel
520
B
-rwxr-xr-x
2024-11-04 17:30
configure_rh_firewall_for_cpanel
520
B
-rwxr-xr-x
2024-11-04 17:30
configure_rh_ipv6_firewall_for_cpanel
520
B
-rwxr-xr-x
2024-11-04 17:30
convert2dovecot
682
B
-rwxr-xr-x
2024-11-04 17:30
convert_accesshash_to_token
4.07
KB
-rwxr-xr-x
2024-11-04 17:30
convert_and_migrate_from_legacy_backup
1.97
KB
-rwxr-xr-x
2024-11-04 17:30
convert_maildir_to_mdbox
1.66
KB
-rwxr-xr-x
2024-11-04 17:30
convert_mdbox_to_maildir
1.66
KB
-rwxr-xr-x
2024-11-04 17:30
convert_roundcube_mysql2sqlite
26.12
KB
-rwxr-xr-x
2025-03-20 03:04
convert_to_dovecot_delivery
4.33
KB
-rwxr-xr-x
2024-11-04 17:30
convert_whmxfer_to_sqlite
1.46
KB
-rwxr-xr-x
2024-11-04 17:30
copy_user_mail_as_root
1.25
KB
-rwxr-xr-x
2024-11-04 17:30
copy_user_mail_as_user
1.34
KB
-rwxr-xr-x
2024-11-04 17:30
cpan_config
2.8
KB
-rwxr-xr-x
2024-11-04 17:30
cpanel_initial_install
67.95
KB
-rwxr-xr-x
2026-06-11 03:04
cpanelsync
28.31
KB
-rwxr-xr-x
2024-11-04 17:30
cpanelsync_postprocessor
1.62
KB
-rwxr-xr-x
2024-11-04 17:30
cpanpingtest
965
B
-rwxr-xr-x
2024-11-04 17:30
cpbackup
44.79
KB
-rwxr-xr-x
2024-11-04 17:30
cpbackup_transport_file
5.65
KB
-rwxr-xr-x
2024-11-04 17:30
cpdig
2.81
KB
-rwxr-xr-x
2026-04-16 03:04
cpfetch
1.23
KB
-rwxr-xr-x
2024-11-04 17:30
cphulkdblacklist
433
B
-rwxr-xr-x
2024-11-04 17:30
cphulkdwhitelist
1.3
KB
-rwxr-xr-x
2024-11-04 17:30
cpservice
2.87
KB
-rwxr-xr-x
2024-11-04 17:30
cpuser_port_authority
19.29
KB
-rwxr-xr-x
2024-11-04 17:30
cpuser_service_manager
10.85
KB
-rwxr-xr-x
2024-11-04 17:30
create_default_featurelist
11.62
KB
-rwx------
2026-05-08 00:47
createacct
30.32
MB
-rwx------
2026-06-11 03:04
custom_backup_destination.pl.sample
5.06
KB
-rwxr-xr-x
2024-11-04 17:30
custom_backup_destination.pl.skeleton
2.84
KB
-rwxr-xr-x
2024-11-04 17:30
dcpumon-wrapper
850
B
-rwxr-xr-x
2024-11-04 17:30
delpop
6.2
KB
-rwxr-xr-x
2024-11-04 17:30
detect_env_capabilities
508
B
-rwxr-xr-x
2024-11-04 17:30
disable_prelink
2.77
KB
-rwxr-xr-x
2024-11-04 17:30
disablefileprotect
2.19
KB
-rwxr-xr-x
2024-11-04 17:30
distro_changed_hook
1.16
KB
-rwxr-xr-x
2024-11-04 17:30
dnscluster
4.44
KB
-rwxr-xr-x
2024-11-04 17:30
dnsqueuecron
1.29
KB
-rwxr-xr-x
2024-11-04 17:30
dnssec-cluster-keys
3.75
KB
-rwxr-xr-x
2024-11-04 17:30
dovecot_maintenance
7.66
KB
-rwxr-xr-x
2025-01-22 03:04
dovecot_set_defaults.pl
984
B
-rwxr-xr-x
2024-11-04 17:30
dumpcdb
866
B
-rwxr-xr-x
2024-11-04 17:30
dumpinodes
687
B
-rwxr-xr-x
2024-11-04 17:30
dumpquotas
616
B
-rwxr-xr-x
2024-11-04 17:30
dumpstor
913
B
-rwxr-xr-x
2024-11-04 17:30
ea4_fresh_install
2.64
KB
-rwxr-xr-x
2024-11-04 17:30
edit_cpanelsync_exclude_list
2.58
KB
-rwxr-xr-x
2024-11-04 17:30
editquota
3.43
KB
-rwxr-xr-x
2024-11-04 17:30
email_archive_maintenance
6.15
KB
-rwxr-xr-x
2024-11-04 17:30
email_hold_maintenance
1.46
KB
-rwxr-xr-x
2024-11-04 17:30
enable_spf_dkim_globally
8.83
KB
-rwxr-xr-x
2024-11-04 17:30
enablefileprotect
2.1
KB
-rwxr-xr-x
2024-11-04 17:30
ensure_autoenabled_features
3.17
MB
-rwx------
2026-06-11 03:04
ensure_conf_dir_crt_key
4.82
KB
-rwxr-xr-x
2024-11-04 17:30
ensure_cpuser_file_ip
2.55
KB
-rwxr-xr-x
2024-11-04 17:30
ensure_crontab_permissions
1.08
KB
-rwxr-xr-x
2024-11-04 17:30
ensure_dovecot_memory_limits_meet_minimum
3.13
KB
-rwxr-xr-x
2024-11-04 17:30
ensure_hostname_resolves
2.51
KB
-rwxr-xr-x
2025-03-27 03:04
ensure_includes
601
B
-rwxr-xr-x
2024-11-04 17:30
ensure_vhost_includes
13.53
KB
-rwxr-xr-x
2024-11-04 17:30
exim_tidydb
2.96
KB
-rwxr-xr-x
2024-11-04 17:30
eximconfgen
1.32
KB
-rwxr-xr-x
2024-11-04 17:30
eximstats_spam_check
867
B
-rwxr-xr-x
2024-11-04 17:30
expunge_expired_certificates_from_sslstorage
3.56
KB
-rwxr-xr-x
2024-11-04 17:30
expunge_expired_pkgacct_sessions
852
B
-rwxr-xr-x
2024-11-04 17:30
expunge_expired_transfer_sessions
1.06
KB
-rwxr-xr-x
2024-11-04 17:30
fastmail
5.16
KB
-rwxr-xr-x
2024-11-04 17:30
featuremod
1.92
KB
-rwxr-xr-x
2024-11-04 17:30
fetchfile
422
B
-rwxr-xr-x
2024-11-04 17:30
find_and_fix_rpm_issues
6.99
KB
-rwxr-xr-x
2024-11-04 17:30
find_outdated_services
6.47
KB
-rwxr-xr-x
2026-04-24 03:04
find_pids_with_inotify_watch_on_path
3.66
KB
-rwxr-xr-x
2024-11-04 17:30
fix-cpanel-perl
28.43
KB
-rwxr-xr-x
2026-04-01 03:04
fix-listen-on-localhost
3.94
KB
-rwxr-xr-x
2026-06-03 03:04
fix-web-vhost-configuration
6.15
KB
-rwxr-xr-x
2024-11-04 17:30
fix_dns_zone_ttls
1.34
KB
-rwxr-xr-x
2024-11-04 17:30
fix_innodb_tables
4.05
KB
-rwxr-xr-x
2024-11-04 17:30
fix_reseller_acls
10.7
KB
-rwxr-xr-x
2025-06-03 03:04
fixetchosts
4.32
KB
-rwxr-xr-x
2024-11-04 17:30
fixheaders
572
B
-rwxr-xr-x
2024-11-04 17:30
fixmailinglistperms
1008
B
-rwxr-xr-x
2024-11-04 17:30
fixmailman
2.09
KB
-rwxr-xr-x
2024-11-04 17:30
fixnamedviews
1.22
KB
-rwxr-xr-x
2024-11-04 17:30
fixndc
413
B
-rwxr-xr-x
2024-11-04 17:30
fixquotas
18.39
KB
-rwxr-xr-x
2024-11-04 17:30
fixrelayd
1.74
KB
-rwxr-xr-x
2024-11-04 17:30
fixrndc
16.39
KB
-rwxr-xr-x
2024-11-04 17:30
fixtar
503
B
-rwxr-xr-x
2024-11-04 17:30
fixtlsversions
4.7
KB
-rwxr-xr-x
2024-11-04 17:30
fixvaliases
2
KB
-rwxr-xr-x
2024-11-04 17:30
fixwebalizer
966
B
-rwxr-xr-x
2024-11-04 17:30
forcelocaldomain
895
B
-rwxr-xr-x
2024-11-04 17:30
ftpfetch
2.2
KB
-rwxr-xr-x
2024-11-04 17:30
ftpquotacheck
8.31
KB
-rwxr-xr-x
2024-11-04 17:30
ftpsfetch
2.36
KB
-rwxr-xr-x
2024-11-04 17:30
ftpupdate
261
B
-rwxr-xr-x
2024-11-04 17:30
gather_update_log_stats
4.25
KB
-rwx------
2026-06-10 19:26
gather_update_logs_setupcrontab
5.45
KB
-rwx------
2026-06-10 19:26
gemwrapper
1.74
KB
-rwxr-xr-x
2024-11-04 17:30
gencrt
6.26
KB
-rwxr-xr-x
2024-11-04 17:30
generate_account_suspension_include
5.7
KB
-rwxr-xr-x
2024-11-04 17:30
generate_google_drive_credentials
1.11
KB
-rwxr-xr-x
2024-11-04 17:30
generate_google_drive_oauth_uri
984
B
-rwxr-xr-x
2024-11-04 17:30
generate_maildirsize
13.94
KB
-rwxr-xr-x
2024-11-04 17:30
gensysinfo
1.16
KB
-rwxr-xr-x
2024-11-04 17:30
get_locale_from_legacy_name_info
1.99
KB
-rwxr-xr-x
2024-11-04 17:30
getremotecpmove
12.67
KB
-rwxr-xr-x
2024-11-04 17:30
grpck
1.19
KB
-rwxr-xr-x
2024-11-04 17:30
hackcheck
3.02
KB
-rwxr-xr-x
2024-11-04 17:30
hook
1.45
KB
-rwxr-xr-x
2024-11-04 17:30
httpspamdetect
2.82
KB
-rwxr-xr-x
2026-04-16 03:04
hulk-unban-ip
4.09
MB
-rwx------
2026-06-11 03:04
import_exim_data
8.39
KB
-rwxr-xr-x
2024-11-04 17:30
increase_filesystem_limits
891
B
-rwxr-xr-x
2024-11-04 17:30
initacls
4.99
KB
-rwxr-xr-x
2024-11-04 17:30
initfpsuexec
444
B
-rwxr-xr-x
2024-11-04 17:30
initialize_360monitoring
2.76
KB
-rwx------
2026-06-09 19:13
initquotas
19.35
KB
-rwxr-xr-x
2026-02-04 03:04
initsuexec
4.03
KB
-rwxr-xr-x
2024-11-04 17:30
install_cpanel_analytics
1.93
KB
-rwxr-xr-x
2024-11-04 17:30
install_dovecot_fts
1.57
KB
-rwxr-xr-x
2024-11-04 17:30
install_plugin
2.8
KB
-rwxr-xr-x
2024-11-04 17:30
install_tuxcare_els_php
1.84
KB
-rwxr-xr-x
2025-12-18 03:04
installpkg
575
B
-rwxr-xr-x
2024-11-04 17:30
installpostgres
6.56
KB
-rwxr-xr-x
2025-11-06 03:05
installsqlite3
1.82
KB
-rwxr-xr-x
2024-11-04 17:30
ipcheck
3.93
KB
-rwxr-xr-x
2024-11-04 17:30
ipusage
7.45
KB
-rwxr-xr-x
2024-11-04 17:30
is_update_available
3.26
KB
-rwxr-xr-x
2026-05-20 03:04
isdedicatedip
602
B
-rwxr-xr-x
2024-11-04 17:30
jetbackup-check
3.69
KB
-rwxr-xr-x
2024-11-04 17:30
killdns
422
B
-rwxr-xr-x
2024-11-04 17:30
killdns-dnsadmin
1.15
KB
-rwxr-xr-x
2024-11-04 17:30
killmysqluserprivs
433
B
-rwxr-xr-x
2024-11-04 17:30
killmysqlwildcard
1.15
KB
-rwxr-xr-x
2024-11-04 17:30
killpvhost
853
B
-rwxr-xr-x
2024-11-04 17:30
killspamkeys
937
B
-rwxr-xr-x
2024-11-04 17:30
link_3rdparty_binaries
1.24
KB
-rwxr-xr-x
2024-11-04 17:30
linksubemailtomainacct
3.17
KB
-rwxr-xr-x
2024-11-04 17:30
listcheck
538
B
-rwxr-xr-x
2024-11-04 17:30
listsubdomains
1.05
KB
-rwxr-xr-x
2024-11-04 17:30
litespeed-check
3.86
KB
-rwxr-xr-x
2024-11-04 17:30
locale_export
5.21
KB
-rwxr-xr-x
2025-01-22 03:04
locale_import
4.35
KB
-rwxr-xr-x
2024-11-04 17:30
locale_info
3.99
KB
-rwxr-xr-x
2024-11-04 17:30
log_retention
21.28
KB
-rwxr-xr-x
2026-02-18 03:04
logo.dat
205
B
-rw-r--r--
2024-11-04 17:30
magicloader
1.94
KB
-rwxr-xr-x
2024-11-04 17:30
maildir_converter
6.08
KB
-rwxr-xr-x
2024-11-04 17:30
mailperm
16.53
KB
-rwxr-xr-x
2024-11-04 17:30
mailscannerupdate
2.42
KB
-rwxr-xr-x
2024-11-04 17:30
mainipcheck
10
KB
-rwxr-xr-x
2024-11-04 17:30
maintenance
52.61
KB
-rwxr-xr-x
2026-06-03 03:04
make_config
407
B
-rw-r--r--
2024-11-04 17:30
make_hostname_unowned
1.16
KB
-rwxr-xr-x
2024-11-04 17:30
manage_extra_marketing
12.76
KB
-rwx------
2026-05-08 00:47
manage_greylisting
16.33
KB
-rwxr-xr-x
2026-06-11 03:04
manage_mysql_profiles
16.33
KB
-rwxr-xr-x
2024-11-04 17:30
mass_change_php_setting
10.65
KB
-rwxr-xr-x
2026-04-16 03:04
migrate_ccs_to_cpdavd
47.06
KB
-rwxr-xr-x
2025-02-11 03:04
migrate_local_ini_to_php_ini
7.41
KB
-rwxr-xr-x
2024-11-04 17:30
migrate_whmtheme_file_to_userdata
2.95
KB
-rwxr-xr-x
2024-11-04 17:30
mkwwwacctconf
2.33
KB
-rwxr-xr-x
2024-11-04 17:30
modify_accounts
4.07
KB
-rwxr-xr-x
2025-01-22 03:04
modify_featurelist
11.33
KB
-rwx------
2026-05-08 00:47
modify_packages
3.64
KB
-rwxr-xr-x
2025-01-22 03:04
modsec_vendor
15.63
KB
-rwxr-xr-x
2024-11-04 17:30
mysqlconnectioncheck
6.72
KB
-rwxr-xr-x
2024-11-04 17:30
mysqlpasswd
4.14
KB
-rwxr-xr-x
2024-11-04 17:30
named.ca
1.57
KB
-rw-r--r--
2024-11-04 17:30
named.rfc1912.zones
774
B
-rw-r--r--
2024-11-04 17:30
notify_expiring_certificates
9.37
KB
-rwxr-xr-x
2024-11-04 17:30
notify_expiring_certificates_on_linked_nodes
1.33
KB
-rwxr-xr-x
2024-11-04 17:30
oopscheck
1.12
KB
-rwxr-xr-x
2024-11-04 17:30
optimize_eximstats
3.88
KB
-rwxr-xr-x
2024-11-04 17:30
panel_ini
4.11
KB
-rwxr-xr-x
2026-06-03 03:04
patch_mail_spamassassin_compiledregexps_body_0
2.39
KB
-rwxr-xr-x
2024-11-04 17:30
patchfdsetsize
2.72
KB
-rwxr-xr-x
2024-11-04 17:30
pedquota
2.26
KB
-rwxr-xr-x
2024-11-04 17:30
perform_sqlite_auto_rebuild_db_maintenance
1.98
KB
-rwxr-xr-x
2025-01-22 03:04
perlinstaller
528
B
-rwxr-xr-x
2024-11-04 17:30
perlmods
1.18
KB
-rwxr-xr-x
2024-11-04 17:30
php_fpm_config
9.73
KB
-rwxr-xr-x
2024-11-04 17:30
phpini_tidy
687
B
-rwxr-xr-x
2024-11-04 17:30
pkgacct
89.91
KB
-rwxr-xr-x
2026-04-16 03:04
post_snapshot
2.09
KB
-rwxr-xr-x
2024-11-04 17:30
post_sync_cleanup
5.83
KB
-rwxr-xr-x
2026-06-11 03:04
postupcp
193
B
-rwxr-xr-x
2026-06-16 03:10
primary_virtual_host_migration
2.44
KB
-rwxr-xr-x
2024-11-04 17:30
process_cpmove
4.32
KB
-rwxr-xr-x
2026-06-08 21:46
process_pending_cpanel_php_pear_registration
2.73
KB
-rwxr-xr-x
2025-06-03 03:04
proxydomains
9.59
KB
-rwxr-xr-x
2025-11-06 03:05
ptycheck
724
B
-rwxr-xr-x
2024-11-04 17:30
purge_modsec_log
1.53
KB
-rwxr-xr-x
2024-11-04 17:30
purge_old_config_caches
2.08
KB
-rwxr-xr-x
2024-11-04 17:30
pwck
708
B
-rwxr-xr-x
2024-11-04 17:30
quickdnslookup
1.13
KB
-rwxr-xr-x
2024-11-04 17:30
quickwhoisips
2.29
KB
-rwxr-xr-x
2024-11-04 17:30
quota_auto_fix
1.41
KB
-rwxr-xr-x
2024-11-04 17:30
quotacheck
22.36
KB
-rwxr-xr-x
2024-11-04 17:30
rawchpass
460
B
-rwxr-xr-x
2024-11-04 17:30
rdate
4.8
KB
-rwxr-xr-x
2024-11-04 17:30
realadduser
5.61
KB
-rwxr-xr-x
2024-11-04 17:30
realchpass
3.26
KB
-rwxr-xr-x
2024-11-04 17:30
realperlinstaller
5.67
KB
-rwxr-xr-x
2024-11-04 17:30
realrawchpass
425
B
-rwxr-xr-x
2024-11-04 17:30
rebuild_bandwidthdb_root_cache
1.45
KB
-rwxr-xr-x
2024-11-04 17:30
rebuild_dbmap
5.8
KB
-rwxr-xr-x
2024-11-04 17:30
rebuild_provider_openid_connect_links_db
1.01
KB
-rwxr-xr-x
2024-11-04 17:30
rebuild_whm_chrome
2.22
KB
-rwxr-xr-x
2024-11-04 17:30
rebuilddnsconfig
25.5
KB
-rwxr-xr-x
2025-05-08 03:04
rebuildhttpdconf
2.6
KB
-rwxr-xr-x
2024-11-04 17:30
rebuildinstalledssldb
2.85
KB
-rwxr-xr-x
2024-11-04 17:30
rebuildippool
509
B
-rwxr-xr-x
2024-11-04 17:30
rebuilduserssldb
948
B
-rwxr-xr-x
2024-11-04 17:30
refresh-dkim-validity-cache
5.97
KB
-rwxr-xr-x
2024-11-04 17:30
regenerate_tokens
2.18
KB
-rwxr-xr-x
2024-11-04 17:30
remote_log_transfer
11.6
KB
-rwxr-xr-x
2024-11-04 17:30
remove_dovecot_index_files
5.89
KB
-rwxr-xr-x
2024-11-04 17:30
removeacct
28.2
MB
-rwx------
2026-06-11 03:04
rescan_user_dovecot_fts
2.98
KB
-rwxr-xr-x
2024-11-04 17:30
reset_mail_quotas_to_sane_values
6.82
KB
-rwxr-xr-x
2024-11-04 17:30
resetmailmanurls
2.03
KB
-rwxr-xr-x
2024-11-04 17:30
resetquotas
4.61
KB
-rwxr-xr-x
2024-11-04 17:30
restartsrv
3.19
KB
-rwxr-xr-x
2024-11-04 17:30
restartsrv_apache
422
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_apache_php_fpm
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_base
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_bind
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_chkservd
427
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_clamd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_cpanel_php_fpm
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_cpanellogd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_cpdavd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_cpgreylistd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_cphulkd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_cpipv6
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_cpsrvd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_crond
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_dnsadmin
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_dovecot
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_exim
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_eximstats
504
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_ftpd
426
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_ftpserver
911
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_httpd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_imap
437
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_inetd
2.47
KB
-rwxr-xr-x
2024-11-04 17:30
restartsrv_ipaliases
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_lmtp
437
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_mailman
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_mysql
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_named
579
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_nscd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_p0f
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_pdns
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_pop3
437
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_postgres
427
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_postgresql
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_powerdns
442
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_proftpd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_pureftpd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_queueprocd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_rsyslog
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_rsyslogd
437
B
-rwxr-xr-x
2024-11-04 17:30
restartsrv_spamd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_sshd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_syslogd
2.4
KB
-rwxr-xr-x
2024-11-04 17:30
restartsrv_tailwatchd
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_unknown
10.85
MB
-rwxr-xr-x
2026-06-11 03:04
restartsrv_xinetd
422
B
-rwxr-xr-x
2024-11-04 17:30
restorecpuserfromcache
1.96
KB
-rwxr-xr-x
2024-11-04 17:30
restorepkg
48.67
MB
-rwx------
2026-06-12 03:04
rfc1912_zones.tar
10
KB
-rw-r--r--
2024-11-04 17:30
rpmup
5.07
KB
-rwxr-xr-x
2024-11-04 17:30
rsync-user-homedir.pl
5.76
KB
-rwxr-xr-x
2024-11-04 17:30
run_if_exists
512
B
-rwxr-xr-x
2024-11-04 17:30
run_plugin_lifecycle
3.82
KB
-rwx------
2026-05-08 00:47
runstatsonce
440
B
-rwxr-xr-x
2024-11-04 17:30
runweblogs
1.02
KB
-rwxr-xr-x
2024-11-04 17:30
sa-update_wrapper
3.34
KB
-rwxr-xr-x
2024-11-04 17:30
safetybits.pl
844
B
-rwxr-xr-x
2024-11-04 17:30
secureit
4.72
KB
-rwxr-xr-x
2024-11-04 17:30
securemysql
4.4
KB
-rwxr-xr-x
2024-11-04 17:30
securerailsapps
3.58
KB
-rwxr-xr-x
2024-11-04 17:30
securetmp
16.76
KB
-rwxr-xr-x
2025-07-16 03:04
selectorunparkhook.py
1.7
KB
-rwxr-xr-x
2026-06-03 03:06
sendicq
474
B
-rwxr-xr-x
2024-11-04 17:30
servicedomains
9.59
KB
-rwxr-xr-x
2025-11-06 03:05
set_mailman_archive_perms
1.75
KB
-rwxr-xr-x
2024-11-04 17:30
setpostgresconfig
6.04
KB
-rwxr-xr-x
2024-11-04 17:30
setup_greylist_db
16.33
KB
-rwxr-xr-x
2026-06-11 03:04
setup_modsec_db
1.3
KB
-rwxr-xr-x
2024-11-04 17:30
setup_systemd_timer_for_plugins
3.92
KB
-rwx------
2026-05-08 00:47
setupftpserver
10.47
KB
-rwxr-xr-x
2024-11-04 17:30
setupmailserver
9.39
KB
-rwxr-xr-x
2025-05-08 03:04
setupnameserver
12.6
KB
-rwxr-xr-x
2025-11-06 03:05
show_php_settings
3.67
KB
-rwxr-xr-x
2026-04-16 03:04
shrink_modsec_ip_database
12.97
KB
-rwxr-xr-x
2024-11-04 17:30
simpleps
3.05
KB
-rwxr-xr-x
2024-11-04 17:30
slurp_exim_mainlog
5.78
KB
-rwxr-xr-x
2024-11-04 17:30
smartcheck
15.13
KB
-rwxr-xr-x
2025-06-03 03:04
smtpmailgidonly
8.15
KB
-rwxr-xr-x
2024-11-04 17:30
snapshot_prep
5.88
KB
-rwxr-xr-x
2024-11-04 17:30
spamassassin_dbm_cleaner
5.85
KB
-rwxr-xr-x
2024-11-04 17:30
spamassassindisable
3.74
KB
-rwxr-xr-x
2024-11-04 17:30
spamboxdisable
2.27
KB
-rwxr-xr-x
2024-11-04 17:30
sshcontrol
14.38
KB
-rwxr-xr-x
2024-11-04 17:30
ssl_crt_status
3.84
KB
-rwxr-xr-x
2024-11-04 17:30
suspendacct
18.08
KB
-rwxr-xr-x
2025-11-06 03:05
suspendmysqlusers
4.78
KB
-rwxr-xr-x
2024-11-04 17:30
swapip
3.82
KB
-rwxr-xr-x
2024-11-04 17:30
sync-mysql-users-from-grants
1.2
KB
-rwxr-xr-x
2024-11-04 17:30
sync_child_accounts
1.77
KB
-rwxr-xr-x
2024-11-04 17:30
sync_contact_emails_to_cpanel_users_files
1.14
KB
-rwxr-xr-x
2024-11-04 17:30
synctransfers
1.92
KB
-rwxr-xr-x
2024-11-04 17:30
syslog_check
1.36
KB
-rwxr-xr-x
2024-11-04 17:30
sysup
645
B
-rwxr-xr-x
2024-11-04 17:30
test_sa_compiled
1.07
KB
-rwxr-xr-x
2024-11-04 17:30
transfer_account_as_user
2.34
KB
-rwxr-xr-x
2024-11-04 17:30
transfer_accounts_as_root
4.76
KB
-rwxr-xr-x
2024-11-04 17:30
transfer_in_progress
3.08
KB
-rwxr-xr-x
2024-11-04 17:30
transfer_in_progress.pod
312
B
-rw-r--r--
2024-11-04 17:30
transfermysqlusers
10.13
MB
-rwx------
2026-06-11 03:04
try-later
7.95
KB
-rwxr-xr-x
2024-11-04 17:30
unblockip
667
B
-rwxr-xr-x
2024-11-04 17:30
uninstall_cpanel_analytics
1.2
KB
-rwxr-xr-x
2024-11-04 17:30
uninstall_dovecot_fts
562
B
-rwxr-xr-x
2024-11-04 17:30
uninstall_plugin
2.84
KB
-rwxr-xr-x
2024-11-04 17:30
unlink_service_account
2.62
KB
-rwxr-xr-x
2024-11-04 17:30
unpkgacct
4.6
KB
-rwxr-xr-x
2024-11-04 17:30
unslavenamedconf
863
B
-rwxr-xr-x
2024-11-04 17:30
unsuspendacct
17.96
KB
-rwxr-xr-x
2025-11-06 03:05
unsuspendmysqlusers
7.1
KB
-rwxr-xr-x
2024-11-04 17:30
upcp
33.9
KB
-rwxr-xr-x
2026-01-21 03:04
upcp-running
2.7
KB
-rwxr-xr-x
2024-11-04 17:30
upcp.static
745.21
KB
-rwxr-xr-x
2026-06-11 03:04
update-packages
5.07
KB
-rwxr-xr-x
2024-11-04 17:30
update_apachectl
480
B
-rwxr-xr-x
2024-11-04 17:30
update_db_cache
430
B
-rwxr-xr-x
2024-11-04 17:30
update_dkim_keys
1.45
KB
-rwxr-xr-x
2024-11-04 17:30
update_exim_rejects
1.21
KB
-rwxr-xr-x
2024-11-04 17:30
update_existing_mail_quotas_for_account
4.78
KB
-rwxr-xr-x
2024-11-04 17:30
update_feature_flags
957
B
-rwxr-xr-x
2024-11-04 17:30
update_freebusy_data
5.25
KB
-rwxr-xr-x
2025-05-08 03:04
update_known_proxy_ips
1002
B
-rwxr-xr-x
2024-11-04 17:30
update_local_rpm_versions
4.56
KB
-rwxr-xr-x
2024-11-04 17:30
update_mailman_cache
8.34
KB
-rwxr-xr-x
2024-11-04 17:30
update_mysql_systemd_config
1.07
KB
-rwxr-xr-x
2025-05-08 03:04
update_neighbor_netblocks
487
B
-rwxr-xr-x
2024-11-04 17:30
update_sa_config
2.14
KB
-rwxr-xr-x
2024-11-04 17:30
update_spamassassin_config
10.73
KB
-rwxr-xr-x
2024-11-04 17:30
update_users_jail
691
B
-rwxr-xr-x
2024-11-04 17:30
update_users_vhosts
801
B
-rwxr-xr-x
2024-11-04 17:30
updatedomainips
605
B
-rwxr-xr-x
2024-11-04 17:30
updatenameserverips
1.66
KB
-rwxr-xr-x
2024-11-04 17:30
updatenow
5.18
KB
-rwxr-xr-x
2024-11-04 17:30
updatenow.static
2.01
MB
-rwxr-xr-x
2026-06-13 03:04
updatesigningkey
1.95
KB
-rwxr-xr-x
2024-11-04 17:30
updatessldomains
1.81
KB
-rwxr-xr-x
2024-11-04 17:30
updatesupportauthorizations
2.49
KB
-rwxr-xr-x
2024-11-04 17:30
updateuserdatacache
2.47
KB
-rwxr-xr-x
2024-11-04 17:30
updateuserdomains
774
B
-rwxr-xr-x
2024-11-04 17:30
upgrade_bandwidth_dbs
2.22
KB
-rwxr-xr-x
2024-11-04 17:30
upgrade_subaccount_databases
2.73
KB
-rwxr-xr-x
2024-11-04 17:30
userdata_wildcard_cleanup
5.74
KB
-rwxr-xr-x
2024-11-04 17:30
userdirctl
5.01
KB
-rwxr-xr-x
2024-11-04 17:30
validate_sshkey_passphrase
1.21
KB
-rwxr-xr-x
2024-11-04 17:30
verify_api_spec_files
757
B
-rwxr-xr-x
2024-11-04 17:30
verify_pidfile
1.96
KB
-rwxr-xr-x
2024-11-04 17:30
verify_vhost_includes
7.34
KB
-rwxr-xr-x
2024-11-04 17:30
vps_optimizer
7.82
KB
-rwxr-xr-x
2024-11-04 17:30
vzzo-fixer
725
B
-rwxr-xr-x
2024-11-04 17:30
whmlogin
2.33
KB
-rwxr-xr-x
2024-11-04 17:30
whoowns
1.13
KB
-rwxr-xr-x
2024-11-04 17:30
wwwacct
30.32
MB
-rwx------
2026-06-11 03:04
wwwacct2
88
B
-rwxr-xr-x
2024-11-04 17:30
xfer_rcube_schema_migrate.pl
2.4
KB
-rwxr-xr-x
2024-11-04 17:30
xfer_rcube_uid_resolver.pl
1.8
KB
-rwxr-xr-x
2024-11-04 17:30
xferpoint
3.13
KB
-rwxr-xr-x
2024-11-04 17:30
xfertool
16.23
KB
-rwxr-xr-x
2024-11-04 17:30
zoneexists
800
B
-rwxr-xr-x
2024-11-04 17:30
Save
Rename
#!/usr/local/cpanel/3rdparty/bin/perl # cpanel - scripts/convert_roundcube_mysql2sqlite 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 Script::RCube::Mysql2Sqlite; use strict; ## no critic (RequireUseWarnings) use Try::Tiny; use Cpanel::AccessIds::ReducedPrivileges (); use Cpanel::Config::LoadCpConf (); use Cpanel::MysqlUtils (); use Cpanel::DbUtils (); use Cpanel::MysqlUtils::Connect (); use Cpanel::MysqlUtils::Command (); use Cpanel::MysqlRun (); use Cpanel::Config::LoadUserDomains (); use Cpanel::Email::RoundCube (); use Cpanel::Email::RoundCube::DBI (); use Cpanel::Quota::Temp (); use Cpanel::PwCache (); use Cpanel::Logger (); use Cpanel::Filesys::Home (); use File::Basename (); use File::Copy (); use File::Path (); use File::Slurper (); use DBI; use XML::Simple (); use IPC::Open3 (); $XML::Simple::PREFERRED_PARSER = "XML::SAX::PurePerl"; my $sqlite_table_file = '/usr/local/cpanel/base/3rdparty/roundcube/SQL/sqlite.initial.sql'; my $log_file = '/usr/local/cpanel/logs/roundcube_sqlite_convert_log'; my %opts = ( 'alternate_logfile' => $log_file ); my $logger = Cpanel::Logger->new( \%opts ); my $mysql_dbname = 'roundcube'; my $dbh; # If this updates, then do_all_rcube_xml_to_db() needs to be updated to match my @dumptables = qw(users identities contacts contactgroups contactgroupmembers calendars caldav_calendars events caldav_events attachments caldav_attachments itipinvitations responses); my $time = time(); ## if invoked as a script, there is nothing in the call stack my $invoked_as_script = !caller(); __PACKAGE__->script(@ARGV) if ($invoked_as_script); my $mysql_plus_sqlite; sub script { my ( $package, $opt_user, $opt_dbname ) = @_; my $cpconf = Cpanel::Config::LoadCpConf::loadcpconf(); my $db_type = 'mysql'; if ( exists $cpconf->{'roundcube_db'} ) { $db_type = 'sqlite' if $cpconf->{'roundcube_db'} eq 'sqlite'; $mysql_plus_sqlite = $cpconf->{'roundcube_db'} eq 'mysql_plus_sqlite'; } if ( defined $opt_user ) { ## the optional user arg feature is currently *only* called as a script; ## otherwise, all these exits would check $invoked_as_script ## Transfers.pm is the only user of $opt_user, which it uses in conjunction with $opt_user; ## this changes the global variable $opt_dbname just in time to be used in &init_check if ( defined $opt_dbname ) { $mysql_dbname = $opt_dbname; } if ( $db_type eq 'sqlite' && init_check($cpconf) ) { my $wasSuccess = convert_mysql_roundcube_to_sqlite($opt_user); if ($wasSuccess) { ## Transfers.pm operates over a different dbname, and is responsible for the ## removal of the temporary database unless ( defined $opt_dbname ) { Cpanel::Email::RoundCube::archive_and_drop_mysql_roundcube($logger); } return 1; } die "Conversion for user '$opt_user' was not successful.\n"; } ## SOMEDAY @GOLIVE: update-roundcube-sqlite-db gets moved to update-roundcube-db. Update this message and the conditional @GOIVE. die "The optional user argument is to be used only when Roundcube has been converted to sqlite. Use bin/update-roundcube-sqlite-db Exiting.\n"; } ## Has the roundcube conversion already happened? ## note: this check is here, and not in init_check, because Transfers.pm calls into this ## from a different context. The src server uses MySQL but the dest machine has done ## the sqlite conversion. if ( $db_type eq 'sqlite' ) { $logger->info("Roundcube conversion already occurred, bailing out."); if ($invoked_as_script) { exit(0); } return 1; } unless ( init_check($cpconf) ) { if ($invoked_as_script) { exit(0); } return 1; } my %TRUEDOMAINS; Cpanel::Config::LoadUserDomains::loadtrueuserdomains( \%TRUEDOMAINS ); my @users = sort values %TRUEDOMAINS; my $success_cnt = 0; my $success_verify = scalar @users; for my $user (@users) { $success_cnt += convert_mysql_roundcube_to_sqlite($user); } unless ( $success_cnt == $success_verify ) { $logger->warn("Roundcube Mysql to sqlite conversion was not completely successful. Please check $log_file for details."); if ($invoked_as_script) { exit(1); } return; } ## Conversion is a success, so switch Roundcube configuration to use SQLite before dropping the database. my $DIR = '/usr/local/cpanel/base/3rdparty'; Cpanel::Email::RoundCube::generate_roundcube_config_sqlite( $DIR, $logger ); ## if the conversion was a complete success (as checked above), we can safely archive and ## delete the MySQL roundcube database. This will prevent future problems with transfers, ## and in fact is the final solution for the original Roundcube case 12162! ## already asserted via &init_check my $archive_success = Cpanel::Email::RoundCube::archive_and_drop_mysql_roundcube($logger); require Cpanel::Config::CpConfGuard; my $cpconf_guard = Cpanel::Config::CpConfGuard->new(); $cpconf->{'roundcube_db'} = $cpconf_guard->{'data'}->{'roundcube_db'} = 'sqlite'; $cpconf_guard->save(); if ($invoked_as_script) { Cpanel::Email::RoundCube::restart_cpsrvd(); exit(0); } return 1; } sub convert_mysql_roundcube_to_sqlite { my ($user) = @_; my @domains = Cpanel::Email::RoundCube::collect_domains($user); my @uid_name_pairs = collect_roundcube_user_info( \@domains, $user ); ## returning 1: no conversion necessary return 1 unless ( scalar @uid_name_pairs ); ## e.g. '/home' my $best_mnt_point = Cpanel::Filesys::Home::get_homematch_with_most_free_space(); my $tmpdir_root_base = "$best_mnt_point/roundcube_convert"; if ( -d $tmpdir_root_base ) { rename( $tmpdir_root_base, "$tmpdir_root_base.$time" ); } mkdir($tmpdir_root_base); my $tmpdir_root_sys = "$tmpdir_root_base/$user"; mkdir($tmpdir_root_sys); my @pwinfo = Cpanel::PwCache::getpwnam($user); my ( $mmuid, $mmgid, $homedir ) = @pwinfo[ 2, 3, 7 ]; my $tmpdir_emailuser_base = "$homedir/tmp/roundcube_convert"; my $success_cnt = 0; my %has_sqlite_trapper_keeper; for my $email_user_info (@uid_name_pairs) { my ( $uid, $email_user ) = @$email_user_info; if ($mysql_plus_sqlite) { my $db_path = _roundcube_db_path( $user, $homedir, $email_user ); $has_sqlite_trapper_keeper{$db_path} = -f $db_path; next if $has_sqlite_trapper_keeper{$db_path}; } my $tmpdir_root_sys_emailuser = "$tmpdir_root_sys/$email_user"; mkdir($tmpdir_root_sys_emailuser); do_mysqldumps_for_user( $uid, $tmpdir_root_sys_emailuser ); } ## ensures that $best/rcube/$sysuser/$emailuser is readable by $sysuser, ## so that $sysuser can move it to their $homedir after the setuid my $tempquota = Cpanel::Quota::Temp->new( user => $user, log => 1 ); $tempquota->disable(); my $rv_chmod = system("chmod -R 700 $tmpdir_root_sys"); my $rv_chown = system("chown -Rf $mmuid:$mmgid $tmpdir_root_sys"); for my $email_user_info (@uid_name_pairs) { my ( $uid, $email_user ) = @$email_user_info; if ($mysql_plus_sqlite) { my $db_path = _roundcube_db_path( $user, $homedir, $email_user ); if ( $has_sqlite_trapper_keeper{$db_path} ) { $logger->info("$email_user already has an SQLite DB, skipping..."); $success_cnt++; next; } } chdir($tmpdir_root_base); my $tmpdir_root_sys_emailuser = "$tmpdir_root_sys/$email_user"; my $rv_convert = xml_to_sqlite( $user, $tmpdir_root_sys_emailuser, $tmpdir_emailuser_base, $email_user, $homedir ); unless ($rv_convert) { $logger->warn("Conversion was not successful for user '$user'."); } $success_cnt += $rv_convert; ## note: no need to "rmdir($tmpdir_root_sys_emailuser)", as this dir was moved ## to $homedir/tmp/rcube/$emailuser (during the setuid) ## SOMEDAY @GOLIVE: remove the mysql roundcube database (steal mysql/roundcube backup/archive ## clauses from update-roundcube-db, the mysql version) } $tempquota->restore(); rmdir($tmpdir_root_sys); rmdir($tmpdir_root_base); return $success_cnt == scalar(@uid_name_pairs); } sub collect_roundcube_user_info { my ( $ar_domains, $user ) = @_; my $regexp = '@(' . join( '|', map { s/\./\\./gr } @$ar_domains ) . ')$'; my @ids; try { @ids = $dbh->selectall_array( "SELECT user_id, username FROM users WHERE username REGEXP ? or username = ?", {}, $regexp, $user ); }; return @ids; } ## Stolen from pkgacct; needs to be modularized! ## SOMEDAY: this version has converged; move pkgacct version to module, and get rid of below sub mysqldumpdb { my ($args) = @_; my @options = @{ $args->{'options'} }; my $db = $args->{'db'}; my $table = $args->{'table'}; my $file = $args->{'file'}; my $file_mode = $args->{'append'} ? '>>' : '>'; # for testing my @extra_options = _get_extra_options(); my $mysqldump = Cpanel::DbUtils::find_mysqldump(); my @db = ($db); if ($table) { push @db, $table; } my $pid = IPC::Open3::open3( my $w, my $r, '', $mysqldump, @extra_options, @options, @db ); my $first_line = 1; if ( open( my $fh, $file_mode, $file ) ) { while (<$r>) { if ( $first_line && ( !$_ || m/^mysqldump:/ ) ) { warn join( '.', @db ) . ': ' . $_; close $w; close $r; waitpid( $pid, 0 ); $first_line = 0; my $mysqlcheck = Cpanel::DbUtils::find_mysqlcheck(); system( $mysqlcheck, '--repair', @extra_options, @db ); $pid = IPC::Open3::open3( $w, $r, '', $mysqldump, @extra_options, @options, @db ); } else { print {$fh} $_; } } } close $w; close $r; waitpid( $pid, 0 ); return; } sub do_mysqldumps_for_user { my ( $uid, $tmp_convertdir ) = @_; for my $tbl (@dumptables) { ## these two tables do not key off user_id next if grep { $tbl eq $_ } qw{contactgroupmembers events ical_events caldav_events attachments ical_attachments caldav_attachments caldav_calendars}; ## XML output, not suppressing table structure, with a where clause on user_id list my @opts = ( '--xml', '-w', qq{user_id = $uid} ); mysqldumpdb( { 'options' => [@opts], 'db' => $mysql_dbname, 'file' => "$tmp_convertdir/rcube.$tbl.xml", 'table' => $tbl } ); } ## contactgroupmembers is gathered in two steps, otherwise would be a LEFT JOIN that ## &mysqldumpdb can not currently support my $contacts = _get_ids_from_col( 'contactgroups', 'contactgroup_id', $uid, 'user_id' ); _dump_stuff_in( 'contactgroupmembers', 'contactgroup_id', $contacts, $tmp_convertdir ) if scalar(@$contacts); # Handle events & attachments for calendaring, as those are identified by # calendar & event respectively. my $cals = _get_ids_from_col( "calendars", 'calendar_id', $uid, 'user_id' ); next if !scalar(@$cals); my @events2export; my @attachments2export; foreach my $cal (@$cals) { my $events = _get_ids_from_col( "events", 'event_id', $cal, 'calendar_id' ); # Can't have attachments if no events exist to attach em to, so # next here is appropriate. next if !scalar(@$events); push @events2export, @$events; my $attachments = _get_ids_from_col( "attachments", 'attachment_id', $events, 'event_id' ); next if !scalar(@$attachments); push @attachments2export, @$attachments; } _dump_stuff_in( "events", 'event_id', \@events2export, $tmp_convertdir ) if @events2export; _dump_stuff_in( "attachments", 'attachment_id', \@attachments2export, $tmp_convertdir ) if @attachments2export; return undef; } # Only here so that I don't "repeat myself". sub _get_ids_from_col { my ( $tbl, $col, $search_term, $filter_on, $filter_mode ) = @_; my @ids; try { # Quoting anything other than values here is actually harmful. # Don't do it as such. Same for IN statement here. my $where_clause = "WHERE $filter_on = ?"; if ( ref $search_term eq 'ARRAY' ) { my $count = scalar(@$search_term); die "Bad call to _get_ids_from_col: no search term specified!" if !$count; my $qs = ( '?,' x ( $count - 1 ) ) . '?'; $where_clause = "WHERE $filter_on IN ($qs)"; @ids = map { $_->[0] } $dbh->selectall_array( "SELECT $col FROM $tbl $where_clause", {}, @$search_term ); } else { @ids = map { $_->[0] } $dbh->selectall_array( "SELECT $col FROM $tbl $where_clause", {}, $search_term ); } } catch { $logger->warn( "Attempt to find necessary data from $col in $tbl failed: " . $dbh->errstr() ); }; return \@ids; } # Only here so that I don't "repeat myself". sub _dump_stuff_in { my ( $tbl, $col, $in, $tmp_convertdir ) = @_; # It is possible that we have a very large number of ID's. # If so, we need to do this in chunks. my $chunk_size = 1000; my @chunks; while ( $in->@* ) { push @chunks, [ splice( $in->@*, 0, $chunk_size ) ]; } my $file_num = 0; foreach my $chunk (@chunks) { my $f_name = $file_num ? "$tmp_convertdir/rcube.$tbl.$file_num.xml" : "$tmp_convertdir/rcube.$tbl.xml"; my $csv = join( ',', $chunk->@* ); mysqldumpdb( { 'options' => [ '--xml', '-w', qq{$col IN ($csv)} ], 'db' => $mysql_dbname, 'file' => $f_name, 'table' => $tbl, } ); $file_num++; } return; } sub create_rcube_sqlite_tables { my ($dbh) = @_; Cpanel::Email::RoundCube::DBI::ensure_schema_update( $dbh, 'sqlite' ); return undef; } # This used to do all sorts of things like telling rcube_xml_to_db what needed # quoting, what needed to be set to NULL, etc. -- thankfully all that is # absolutely unnecessary with sqlite3. sub do_all_rcube_xml_to_db { my ( $dbh, $xmldir ) = @_; my $success_cnt = 0; ## verify the number of XML docs to convert to SQL my $success_verify = scalar(@dumptables); { ## note: there is a disparity in the sqlite.initial.sql, and the "table_structure" for "users"; ## preferences is not NULLABLE. my @_cols = qw(user_id username mail_host created last_login language preferences); $success_cnt += rcube_xml_to_db( $xmldir, 'users', $dbh, \@_cols ); } { my @_cols = qw( identity_id user_id changed del standard name organization email reply-to bcc signature html_signature); $success_cnt += rcube_xml_to_db( $xmldir, 'identities', $dbh, \@_cols ); } { my @_cols = qw(contact_id user_id changed del name email firstname surname vcard); $success_cnt += rcube_xml_to_db( $xmldir, 'contacts', $dbh, \@_cols ); } ## new contactgroups table { my @_cols = qw( contactgroup_id user_id changed del name ); $success_cnt += rcube_xml_to_db( $xmldir, 'contactgroups', $dbh, \@_cols ); } ## new contactgroupmembers table ## guard clause: contactgroupmembers is gathered conditionally, so it is the only file which ## may not exist if ( -e _xml_file( $xmldir, 'contactgroupmembers' ) ) { my @_cols = qw( contactgroup_id contact_id created ); $success_cnt += rcube_xml_to_db( $xmldir, 'contactgroupmembers', $dbh, \@_cols ); } else { $success_cnt++; } # Restore calendar data foreach my $cal_tbl (qw{calendars caldav_calendars}) { unless ( -e _xml_file( $xmldir, $cal_tbl ) ) { $success_cnt++; next; } my @_cols = qw( calendar_id user_id name color showalarms ); push( @_cols, qw{ical_url ical_user ical_pass ical_last_change} ) if $cal_tbl eq 'ical_calendars'; push( @_cols, qw{readonly caldav_url caldav_tag caldav_user caldav_pass caldav_oauth_provider caldav_last_change} ) if $cal_tbl eq 'caldav_calendars'; $success_cnt += rcube_xml_to_db( $xmldir, $cal_tbl, $dbh, \@_cols ); } foreach my $evt_tbl (qw{events caldav_events}) { unless ( -e _xml_file( $xmldir, $evt_tbl ) ) { $success_cnt++; next; } my @_cols = qw( event_id calendar_id recurrence_id uid instance isexception created changed sequence start end recurrence title description location categories url all_day free_busy priority sensitivity status alarms attendees notifyat ); push( @_cols, qw{ical_url ical_last_change} ) if $evt_tbl eq 'ical_events'; push( @_cols, qw{caldav_url caldav_tag caldav_last_change} ) if $evt_tbl eq 'caldav_events'; $success_cnt += rcube_xml_to_db( $xmldir, $evt_tbl, $dbh, \@_cols ); } foreach my $atc_tbl (qw{attachments caldav_attachments}) { unless ( -e _xml_file( $xmldir, $atc_tbl ) ) { $success_cnt++; next; } my @_cols = qw( attachment_id event_id filename mimetype size data ); $success_cnt += rcube_xml_to_db( $xmldir, $atc_tbl, $dbh, \@_cols ); } if ( -e _xml_file( $xmldir, 'itipinvitations' ) ) { my @_cols = qw(token event_uid user_id event expires cancelled); $success_cnt += rcube_xml_to_db( $xmldir, 'itipinvitations', $dbh, \@_cols ); } else { $success_cnt++; } ## Restore responses table, if available if ( -e _xml_file( $xmldir, 'responses' ) ) { my @_cols = qw( response_id user_id name data is_html changed del ); $success_cnt += rcube_xml_to_db( $xmldir, 'responses', $dbh, \@_cols ); } else { $success_cnt++; } return $success_cnt == $success_verify; } sub _xml_file { my ( $xmldir, $tbl ) = @_; return "$xmldir/rcube.$tbl.xml"; } sub _get_all_xml_files { my ( $xmldir, $tbl ) = @_; opendir( my $dh, $xmldir ) or die "Cannot open directory $xmldir: $!"; my @files = map { "$xmldir/$_" } grep { /^rcube\.$tbl\.(?:[0-9]+\.)?xml$/ } readdir($dh); return @files; } sub rcube_xml_to_db { my ( $xmldir, $tbl, $dbh, $ar_cols ) = @_; my @xml_fnames = _get_all_xml_files( $xmldir, $tbl ); my %common_opts = ( ForceArray => 1, KeyAttr => [], ContentKey => '__content' ); foreach my $xml_fname (@xml_fnames) { ## $ref->{database}->[0]->{table_data}->[0]->{row}->[$x]->{field}->[$x]->{__content} my $ref; my $err; try { $ref = XML::Simple::XMLin( $xml_fname, %common_opts ); } catch { $err = $_; }; if ($err) { $logger->warn("Failed to load xml for $tbl: $err"); return; } my $rows = $ref->{'database'}->[0]->{'table_data'}->[0]->{'row'}; ## FWIW, Perl does not complain if $rows is undef, when called in a for loop context. for my $row (@$rows) { # XXX Placeholders don't work on columns, but stuff with dashes # still needs quoting. As such, quote all col names. # Sorry, couldn't find a way around it. my $update_hr = { map { $dbh->quote_identifier( $_->{'name'} ) => $_->{'__content'} || '' } @{ $row->{'field'} } }; my $rv = $dbh->do( rcube_make_sql( $tbl, $update_hr ) ); unless ($rv) { $logger->warn( "Conversion was not successful: " . $dbh->errstr() ); return; } } } return 1; } sub rcube_make_sql { my ( $table, $update_hr ) = @_; # Lets hope these actually are nonzero my @values = values(%$update_hr); my $qs = ( '?,' x ( scalar(@values) - 1 ) ) . '?'; return ( "INSERT OR REPLACE INTO $table (" . join( ",", keys(%$update_hr) ) . ") VALUES ($qs)", undef, @values, ); } sub check_mysqlup { ## note: this call is cached with a ttl of 600 my $isrunning = Cpanel::MysqlRun::running(); if ($isrunning) { return 1; } return undef; } sub ensure_roundcube_tables { my ($dbh) = @_; my %tables = map { $_ => undef } $dbh->tables(); # system table is created during a migration my @expected = qw(session cache system); push( @expected, @dumptables ); for my $exp (@expected) { next if $exp =~ /^caldav_|^ical_/; ## ignoring as of 120 if ( !exists $tables{$exp} && !exists $tables{qq{"main"."$exp"}} ) { $logger->warn("ERROR: missing $exp table"); return; } } return 1; } sub init_check { my ($cpconf) = @_; ## Ensure root return unless ( 0 == $> ); unless ( -e $sqlite_table_file ) { $logger->info("Roundcube is not installed; conversion is irrelevant."); return; } if ( exists $cpconf->{'skiproundcube'} and $cpconf->{'skiproundcube'} ) { $logger->info("Roundcube should be skipped, bailing out."); return; } my $mysqlup = check_mysqlup(); unless ($mysqlup) { $logger->warn("Mysql not currently running, bailing out."); return; } ## Does this installation use Roundcube/MySQL? unless ( Cpanel::MysqlUtils::Command::db_exists($mysql_dbname) ) { $logger->warn("mysql database $mysql_dbname is missing"); return; } my $error; try { my $dbc = Cpanel::MysqlUtils::Connect->new( database => $mysql_dbname ); $dbh = $dbc->db_handle(); } catch { $error = $_; }; if ($error) { $logger->warn("Failed to connect to MySQL database '$mysql_dbname'."); return; } return 1; } ############################################################## # These functions allow tests to use a temporary MySQL server sub _get_extra_options_string { if ( scalar _get_extra_options() ) { return join( ' ', _get_extra_options() ); } return; } sub _get_extra_options { return @Cpanel::MysqlUtils::_EXTRA_MYSQL_ARGS; } # ############################################################## sub xml_to_sqlite { my ( $user, $tmpdir_root, $tmpdir_convert_base, $email_user, $homedir ) = @_; my $code_ref = _closure_maker( $user, $tmpdir_root, $tmpdir_convert_base, $email_user, $homedir ); #fixup a user who's purposefully deleted their "etc" dir Cpanel::AccessIds::ReducedPrivileges::call_as_user( sub { File::Path::make_path( File::Basename::dirname( _roundcube_db_path( $user, $homedir, $email_user ) ), { chmod => 0750 } ); }, $user, 'mail' ); my $rv = Cpanel::AccessIds::ReducedPrivileges::call_as_user( $code_ref, $user ); return $rv; } sub _roundcube_db_path { my ( $system_user, $homedir, $mail_account ) = @_; my ( $mail_user, $mail_domain ) = split( '@', $mail_account ); my $db_path = ( defined $mail_domain ) ? "$homedir/etc/$mail_domain/$mail_user.rcube.db" : "$homedir/etc/$mail_user.rcube.db"; return $db_path; } ## defining as a closure, as ::run_as_user does not currently handle sub args sub _closure_maker { my ( $system_user, $tmpdir_root, $tmpdir_convert_base, $email_user, $homedir ) = @_; my $code_ref = sub { my $tmp_convertdir = "$tmpdir_convert_base/$email_user"; if ( -d $tmp_convertdir ) { rename( $tmp_convertdir, "$tmp_convertdir.$time" ); } # Copy the XML files over to the user's tempdir. # Hopefully these are simple renames. But directories may be on different # mount points requiring a copy. File::Path::make_path($tmp_convertdir); for my $table (@dumptables) { my @all_src = _get_all_xml_files( $tmpdir_root, $table ); foreach my $src (@all_src) { if ( -e $src ) { my $filename = File::Basename::basename($src); my $dest = "$tmp_convertdir/$filename"; File::Copy::move( $src, $dest ); } } } # Clean up empty source directory. # This will fail if the above moves failed. rmdir($tmpdir_root); ## note: similar clause in cpsrvd to set up $ENV{'_RCUBE'} my ( $mail_user, $mail_domain ) = split( '@', $email_user ); my $rcube_sqlite_loc8 = _roundcube_db_path( $system_user, $homedir, $email_user ); if ( -e $rcube_sqlite_loc8 ) { rename( $rcube_sqlite_loc8, "$rcube_sqlite_loc8.$time" ); } my $dbh = DBI->connect( "dbi:SQLite:dbname=$rcube_sqlite_loc8", "", "" ) or do { $logger->info("Connection error to $rcube_sqlite_loc8: $!"); return; }; ## note: $dbh->{sqlite_version} is confirmed 2.8.15 create_rcube_sqlite_tables($dbh); return unless ensure_roundcube_tables($dbh); unless ( do_all_rcube_xml_to_db( $dbh, $tmp_convertdir ) ) { $logger->info("Conversion of roundcube XML dump to sqlite database failed"); return; } $dbh->disconnect(); chmod( 0600, $rcube_sqlite_loc8 ); ## the return values on these rm calls are not critical ## only remove the /tmp directory if the XML converion has been successful thus far try { File::Path::remove_tree($tmp_convertdir); }; ## attempt to rmdir, which will intentionally fail if any of the converts did not succeed rmdir($tmpdir_convert_base); return 1; }; return $code_ref; } 1;