Linux cyberpanel 5.15.0-156-generic #166-Ubuntu SMP Sat Aug 9 00:02:46 UTC 2025 x86_64
LiteSpeed
: 160.191.175.3 | : 216.73.216.114
Cant Read [ /etc/named.conf ]
8.2.29
aodai6801
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
usr /
sbin /
[ HOME SHELL ]
Name
Size
Permission
Action
ModemManager
2.09
MB
-rwxr-xr-x
aa-remove-unknown
3
KB
-rwxr-xr-x
aa-status
62.62
KB
-rwxr-xr-x
aa-teardown
137
B
-rwxr-xr-x
accessdb
14.55
KB
-rwxr-xr-x
add-shell
1.03
KB
-rwxr-xr-x
addgnupghome
3
KB
-rwxr-xr-x
addgroup
37.35
KB
-rwxr-xr-x
adduser
37.35
KB
-rwxr-xr-x
agetty
55.56
KB
-rwxr-xr-x
apparmor_parser
1.48
MB
-rwxr-xr-x
apparmor_status
62.62
KB
-rwxr-xr-x
applygnupgdefaults
2.17
KB
-rwxr-xr-x
arp
61.61
KB
-rwxr-xr-x
arpd
26.33
KB
-rwxr-xr-x
arptables
219.04
KB
-rwxr-xr-x
arptables-nft
219.04
KB
-rwxr-xr-x
arptables-nft-restore
219.04
KB
-rwxr-xr-x
arptables-nft-save
219.04
KB
-rwxr-xr-x
arptables-restore
219.04
KB
-rwxr-xr-x
arptables-save
219.04
KB
-rwxr-xr-x
aspell-autobuildhash
13.4
KB
-rwxr-xr-x
badblocks
34.32
KB
-rwxr-xr-x
bcache-super-show
14.3
KB
-rwxr-xr-x
biosdecode
23.2
KB
-rwxr-xr-x
blkdeactivate
15.97
KB
-rwxr-xr-x
blkdiscard
22.38
KB
-rwxr-xr-x
blkid
50.41
KB
-rwxr-xr-x
blkzone
34.38
KB
-rwxr-xr-x
blockdev
30.38
KB
-rwxr-xr-x
bridge
92.49
KB
-rwxr-xr-x
cache_check
1.33
MB
-rwxr-xr-x
cache_dump
1.33
MB
-rwxr-xr-x
cache_metadata_size
1.33
MB
-rwxr-xr-x
cache_repair
1.33
MB
-rwxr-xr-x
cache_restore
1.33
MB
-rwxr-xr-x
cache_writeback
1.33
MB
-rwxr-xr-x
capsh
30.3
KB
-rwxr-xr-x
cfdisk
94.73
KB
-rwxr-xr-x
cgdisk
150.48
KB
-rwxr-xr-x
chcpu
30.38
KB
-rwxr-xr-x
chgpasswd
58.13
KB
-rwxr-xr-x
chmem
34.38
KB
-rwxr-xr-x
chpasswd
54.16
KB
-rwxr-xr-x
chroot
38.51
KB
-rwxr-xr-x
convertquota
66.88
KB
-rwxr-xr-x
cpgr
48.29
KB
-rwxr-xr-x
cppw
48.29
KB
-rwxr-xr-x
cron
50.58
KB
-rwxr-xr-x
cryptdisks_start
1.51
KB
-rwxr-xr-x
cryptdisks_stop
844
B
-rwxr-xr-x
cryptsetup
169.55
KB
-rwxr-xr-x
cryptsetup-reencrypt
90.38
KB
-rwxr-xr-x
cryptsetup-ssh
23.53
KB
-rwxr-xr-x
ctrlaltdel
14.38
KB
-rwxr-xr-x
dcb
80.52
KB
-rwxr-xr-x
debugfs
229.8
KB
-rwxr-xr-x
delgroup
16.11
KB
-rwxr-xr-x
deluser
16.11
KB
-rwxr-xr-x
depmod
166.36
KB
-rwxr-xr-x
devlink
142.86
KB
-rwxr-xr-x
dhclient
442.66
KB
-rwxr-xr-x
dhclient-script
15.92
KB
-rwxr-xr-x
dmeventd
50.38
KB
-rwxr-xr-x
dmidecode
122.98
KB
-rwxr-xr-x
dmsetup
171.02
KB
-rwxr-xr-x
dmstats
171.02
KB
-rwxr-xr-x
dosfsck
82.38
KB
-rwxr-xr-x
dosfslabel
38.38
KB
-rwxr-xr-x
dovecot
94.43
KB
-rwxr-xr-x
dpkg-preconfigure
3.58
KB
-rwxr-xr-x
dpkg-reconfigure
4.38
KB
-rwxr-xr-x
dumpe2fs
30.31
KB
-rwxr-xr-x
e2freefrag
14.3
KB
-rwxr-xr-x
e2fsck
351.84
KB
-rwxr-xr-x
e2image
42.31
KB
-rwxr-xr-x
e2label
102.55
KB
-rwxr-xr-x
e2mmpstatus
30.31
KB
-rwxr-xr-x
e2scrub
7.13
KB
-rwxr-xr-x
e2scrub_all
5.27
KB
-rwxr-xr-x
e2undo
22.3
KB
-rwxr-xr-x
e4crypt
30.38
KB
-rwxr-xr-x
e4defrag
30.3
KB
-rwxr-xr-x
ebtables
219.04
KB
-rwxr-xr-x
ebtables-nft
219.04
KB
-rwxr-xr-x
ebtables-nft-restore
219.04
KB
-rwxr-xr-x
ebtables-nft-save
219.04
KB
-rwxr-xr-x
ebtables-restore
219.04
KB
-rwxr-xr-x
ebtables-save
219.04
KB
-rwxr-xr-x
edquota
83.31
KB
-rwxr-xr-x
era_check
1.33
MB
-rwxr-xr-x
era_dump
1.33
MB
-rwxr-xr-x
era_invalidate
1.33
MB
-rwxr-xr-x
era_restore
1.33
MB
-rwxr-xr-x
ethtool
551.48
KB
-rwxr-xr-x
faillock
14.15
KB
-rwxr-xr-x
fatlabel
38.38
KB
-rwxr-xr-x
fdisk
110.42
KB
-rwxr-xr-x
filefrag
18.32
KB
-rwxr-xr-x
findfs
14.38
KB
-rwxr-xr-x
firewalld
7.98
KB
-rwxr-xr-x
fixparts
58.48
KB
-rwxr-xr-x
fsadm
23.94
KB
-rwxr-xr-x
fsck
42.42
KB
-rwxr-xr-x
fsck.btrfs
1.16
KB
-rwxr-xr-x
fsck.cramfs
30.44
KB
-rwxr-xr-x
fsck.ext2
351.84
KB
-rwxr-xr-x
fsck.ext3
351.84
KB
-rwxr-xr-x
fsck.ext4
351.84
KB
-rwxr-xr-x
fsck.fat
82.38
KB
-rwxr-xr-x
fsck.minix
54.41
KB
-rwxr-xr-x
fsck.msdos
82.38
KB
-rwxr-xr-x
fsck.vfat
82.38
KB
-rwxr-xr-x
fsck.xfs
1.89
KB
-rwxr-xr-x
fsfreeze
14.38
KB
-rwxr-xr-x
fstab-decode
18.3
KB
-rwxr-xr-x
fstrim
42.38
KB
-rwxr-xr-x
gdisk
174.48
KB
-rwxr-xr-x
genl
90.44
KB
-rwxr-xr-x
getcap
14.3
KB
-rwxr-xr-x
getpcaps
14.3
KB
-rwxr-xr-x
getty
55.56
KB
-rwxr-xr-x
groupadd
66.91
KB
-rwxr-xr-x
groupdel
62.73
KB
-rwxr-xr-x
groupmems
54.19
KB
-rwxr-xr-x
groupmod
66.82
KB
-rwxr-xr-x
grpck
58.13
KB
-rwxr-xr-x
grpconv
50.01
KB
-rwxr-xr-x
grpunconv
50.01
KB
-rwxr-xr-x
grub-bios-setup
941.42
KB
-rwxr-xr-x
grub-install
1.15
MB
-rwxr-xr-x
grub-macbless
929.11
KB
-rwxr-xr-x
grub-mkconfig
8.6
KB
-rwxr-xr-x
grub-mkdevicemap
215.7
KB
-rwxr-xr-x
grub-probe
941.36
KB
-rwxr-xr-x
grub-reboot
4.73
KB
-rwxr-xr-x
grub-set-default
3.47
KB
-rwxr-xr-x
halt
1.06
MB
-rwxr-xr-x
hdparm
139.43
KB
-rwxr-xr-x
hwclock
50.5
KB
-rwxr-xr-x
iconvconfig
30.4
KB
-rwxr-xr-x
ifconfig
77.17
KB
-rwxr-xr-x
ifdown
93.55
KB
-rwxr-xr-x
ifquery
93.55
KB
-rwxr-xr-x
ifup
93.55
KB
-rwxr-xr-x
inetd
42.53
KB
-rwxr-xr-x
init
1.76
MB
-rwxr-xr-x
insmod
166.36
KB
-rwxr-xr-x
installkernel
2.6
KB
-rwxr-xr-x
integritysetup
54.07
KB
-rwxr-xr-x
invoke-rc.d
16.12
KB
-rwxr-xr-x
ip
702.05
KB
-rwxr-xr-x
ip6tables
219.04
KB
-rwxr-xr-x
ip6tables-apply
6.89
KB
-rwxr-xr-x
ip6tables-legacy
96.95
KB
-rwxr-xr-x
ip6tables-legacy-restore
96.95
KB
-rwxr-xr-x
ip6tables-legacy-save
96.95
KB
-rwxr-xr-x
ip6tables-nft
219.04
KB
-rwxr-xr-x
ip6tables-nft-restore
219.04
KB
-rwxr-xr-x
ip6tables-nft-save
219.04
KB
-rwxr-xr-x
ip6tables-restore
219.04
KB
-rwxr-xr-x
ip6tables-restore-translate
219.04
KB
-rwxr-xr-x
ip6tables-save
219.04
KB
-rwxr-xr-x
ip6tables-translate
219.04
KB
-rwxr-xr-x
ipmaddr
18.3
KB
-rwxr-xr-x
ipset
14.15
KB
-rwxr-xr-x
ipset-translate
14.15
KB
-rwxr-xr-x
iptables
219.04
KB
-rwxr-xr-x
iptables-apply
6.89
KB
-rwxr-xr-x
iptables-legacy
96.95
KB
-rwxr-xr-x
iptables-legacy-restore
96.95
KB
-rwxr-xr-x
iptables-legacy-save
96.95
KB
-rwxr-xr-x
iptables-nft
219.04
KB
-rwxr-xr-x
iptables-nft-restore
219.04
KB
-rwxr-xr-x
iptables-nft-save
219.04
KB
-rwxr-xr-x
iptables-restore
219.04
KB
-rwxr-xr-x
iptables-restore-translate
219.04
KB
-rwxr-xr-x
iptables-save
219.04
KB
-rwxr-xr-x
iptables-translate
219.04
KB
-rwxr-xr-x
iptunnel
18.3
KB
-rwxr-xr-x
irqbalance
66.86
KB
-rwxr-xr-x
irqbalance-ui
34.38
KB
-rwxr-xr-x
iscsi-iname
14.3
KB
-rwxr-xr-x
iscsi_discovery
5.17
KB
-rwxr-xr-x
iscsiadm
398.46
KB
-rwxr-xr-x
iscsid
298.55
KB
-rwxr-xr-x
iscsistart
278.56
KB
-rwxr-xr-x
isosize
14.38
KB
-rwxr-xr-x
ispell-autobuildhash
15.56
KB
-rwxr-xr-x
iucode-tool
58.34
KB
-rwxr-xr-x
iucode_tool
58.34
KB
-rwxr-xr-x
kbdrate
18.16
KB
-rwxr-xr-x
killall5
30.38
KB
-rwxr-xr-x
kpartx
46.16
KB
-rwxr-xr-x
ldattach
26.38
KB
-rwxr-xr-x
ldconfig
387
B
-rwxr-xr-x
ldconfig.real
1.16
MB
-rwxr-xr-x
locale-gen
4.29
KB
-rwxr-xr-x
logrotate
102.24
KB
-rwxr-xr-x
logsave
14.16
KB
-rwxr-xr-x
losetup
70.52
KB
-rwxr-xr-x
lsmod
166.36
KB
-rwxr-xr-x
luksformat
3.32
KB
-rwxr-xr-x
lvchange
2.89
MB
-rwxr-xr-x
lvconvert
2.89
MB
-rwxr-xr-x
lvcreate
2.89
MB
-rwxr-xr-x
lvdisplay
2.89
MB
-rwxr-xr-x
lvextend
2.89
MB
-rwxr-xr-x
lvm
2.89
MB
-rwxr-xr-x
lvmconfig
2.89
MB
-rwxr-xr-x
lvmdiskscan
2.89
MB
-rwxr-xr-x
lvmdump
10.07
KB
-rwxr-xr-x
lvmpolld
236.2
KB
-rwxr-xr-x
lvmsadc
2.89
MB
-rwxr-xr-x
lvmsar
2.89
MB
-rwxr-xr-x
lvreduce
2.89
MB
-rwxr-xr-x
lvremove
2.89
MB
-rwxr-xr-x
lvrename
2.89
MB
-rwxr-xr-x
lvresize
2.89
MB
-rwxr-xr-x
lvs
2.89
MB
-rwxr-xr-x
lvscan
2.89
MB
-rwxr-xr-x
make-bcache
22.38
KB
-rwxr-xr-x
make-ssl-cert
6.65
KB
-rwxr-xr-x
mariadbd
25.32
MB
-rwxr-xr-x
mdadm
601.31
KB
-rwxr-xr-x
mdmon
258.44
KB
-rwxr-xr-x
mii-tool
26.73
KB
-rwxr-xr-x
mkdosfs
50.83
KB
-rwxr-xr-x
mke2fs
130.62
KB
-rwxr-xr-x
mkfs
14.38
KB
-rwxr-xr-x
mkfs.bfs
22.38
KB
-rwxr-xr-x
mkfs.btrfs
471.25
KB
-rwxr-xr-x
mkfs.cramfs
34.32
KB
-rwxr-xr-x
mkfs.ext2
130.62
KB
-rwxr-xr-x
mkfs.ext3
130.62
KB
-rwxr-xr-x
mkfs.ext4
130.62
KB
-rwxr-xr-x
mkfs.fat
50.83
KB
-rwxr-xr-x
mkfs.minix
42.39
KB
-rwxr-xr-x
mkfs.msdos
50.83
KB
-rwxr-xr-x
mkfs.ntfs
70.38
KB
-rwxr-xr-x
mkfs.vfat
50.83
KB
-rwxr-xr-x
mkfs.xfs
382.77
KB
-rwxr-xr-x
mkhomedir_helper
22.17
KB
-rwxr-xr-x
mkinitramfs
12.16
KB
-rwxr-xr-x
mklost+found
14.3
KB
-rwxr-xr-x
mkntfs
70.38
KB
-rwxr-xr-x
mkswap
46.38
KB
-rwxr-xr-x
modinfo
166.36
KB
-rwxr-xr-x
modprobe
166.36
KB
-rwxr-xr-x
mount.fuse
18.3
KB
-rwxr-xr-x
mount.fuse3
18.3
KB
-rwxr-xr-x
mount.lowntfs-3g
114.98
KB
-rwxr-xr-x
mount.ntfs
159.01
KB
-rwxr-xr-x
mount.ntfs-3g
159.01
KB
-rwxr-xr-x
mpathpersist
31.05
KB
-rwxr-xr-x
multipath
34.15
KB
-rwxr-xr-x
multipathd
134.26
KB
-rwxr-xr-x
mysqld
25.32
MB
-rwxr-xr-x
nameif
14.48
KB
-rwxr-xr-x
needrestart
38.71
KB
-rwxr-xr-x
netplan
798
B
-rwxr-xr-x
newusers
74.73
KB
-rwxr-xr-x
nfnl_osf
18.3
KB
-rwxr-xr-x
nft
26.23
KB
-rwxr-xr-x
nghttpd
122.34
KB
-rwxr-xr-x
nghttpx
954.44
KB
-rwxr-xr-x
nologin
14.3
KB
-rwxr-xr-x
ntfsclone
50.38
KB
-rwxr-xr-x
ntfscp
34.38
KB
-rwxr-xr-x
ntfslabel
22.38
KB
-rwxr-xr-x
ntfsresize
62.39
KB
-rwxr-xr-x
ntfsundelete
50.38
KB
-rwxr-xr-x
on_ac_power
3.7
KB
-rwxr-xr-x
opendkim
234.05
KB
-rwxr-xr-x
opendkim-atpszone
38.38
KB
-rwxr-xr-x
opendkim-expire
5.81
KB
-rwxr-xr-x
opendkim-gengraphs
12.05
KB
-rwxr-xr-x
opendkim-genkey
6.44
KB
-rwxr-xr-x
opendkim-genstats
23.57
KB
-rwxr-xr-x
opendkim-genzone
56.46
KB
-rwxr-xr-x
opendkim-importstats
30.65
KB
-rwxr-xr-x
opendkim-stats
14.3
KB
-rwxr-xr-x
opendkim-testkey
60.46
KB
-rwxr-xr-x
opendkim-testmsg
14.3
KB
-rwxr-xr-x
overlayroot-chroot
2.45
KB
-rwxr-xr-x
ownership
14.45
KB
-rwxr-xr-x
pam-auth-update
20.5
KB
-rwxr-xr-x
pam_extrausers_chkpwd
22.15
KB
-rwxr-sr-x
pam_extrausers_update
30.15
KB
-rwxr-xr-x
pam_getenv
2.82
KB
-rwxr-xr-x
pam_timestamp_check
14.15
KB
-rwxr-xr-x
paperconfig
4.07
KB
-rwxr-xr-x
parted
86.4
KB
-rwxr-xr-x
partprobe
14.38
KB
-rwxr-xr-x
pdata_tools
1.33
MB
-rwxr-xr-x
pdns_server
4.86
MB
-rwxr-xr-x
phpdismod
7.11
KB
-rwxr-xr-x
phpenmod
7.11
KB
-rwxr-xr-x
phpquery
6.24
KB
-rwxr-xr-x
pivot_root
14.38
KB
-rwxr-xr-x
plipconfig
14.3
KB
-rwxr-xr-x
plymouthd
150.55
KB
-rwxr-xr-x
postalias
22.3
KB
-rwxr-xr-x
postcat
22.37
KB
-rwxr-xr-x
postconf
183.8
KB
-rwxr-xr-x
postdrop
22.42
KB
-r-xr-sr-x
postfix
18.38
KB
-rwxr-xr-x
postfix-add-filter
4.84
KB
-rwxr-xr-x
postfix-add-policy
3.77
KB
-rwxr-xr-x
postfix-collate
2.87
KB
-rwxr-xr-x
postkick
14.3
KB
-rwxr-xr-x
postlock
14.3
KB
-rwxr-xr-x
postlog
14.45
KB
-rwxr-xr-x
postmap
22.3
KB
-rwxr-xr-x
postmulti
30.69
KB
-rwxr-xr-x
postqueue
22.38
KB
-r-xr-sr-x
postsuper
30.59
KB
-rwxr-xr-x
posttls-finger
42.38
KB
-rwxr-xr-x
poweroff
1.06
MB
-rwxr-xr-x
pure-authd
22.57
KB
-rwxr-xr-x
pure-certd
22.48
KB
-rwxr-xr-x
pure-ftpd-control
1.68
KB
-rwxr-xr-x
pure-ftpd-mysql
202.02
KB
-rwxr-xr-x
pure-ftpd-mysql-virtualchroot
210.02
KB
-rwxr-xr-x
pure-ftpd-wrapper
12.29
KB
-rwxr-xr-x
pure-ftpwho
26.18
KB
-rwxr-xr-x
pure-mrtginfo
14.15
KB
-rwxr-xr-x
pure-quotacheck
22.16
KB
-rwxr-xr-x
pure-uploadscript
22.41
KB
-rwxr-xr-x
pvchange
2.89
MB
-rwxr-xr-x
pvck
2.89
MB
-rwxr-xr-x
pvcreate
2.89
MB
-rwxr-xr-x
pvdisplay
2.89
MB
-rwxr-xr-x
pvmove
2.89
MB
-rwxr-xr-x
pvremove
2.89
MB
-rwxr-xr-x
pvresize
2.89
MB
-rwxr-xr-x
pvs
2.89
MB
-rwxr-xr-x
pvscan
2.89
MB
-rwxr-xr-x
pwck
50.13
KB
-rwxr-xr-x
pwconv
46.01
KB
-rwxr-xr-x
pwunconv
42.01
KB
-rwxr-xr-x
qemu-ga
647.66
KB
-rwxr-xr-x
qmqp-sink
18.3
KB
-rwxr-xr-x
qmqp-source
22.31
KB
-rwxr-xr-x
qshape
12.55
KB
-rwxr-xr-x
quota_nld
26.41
KB
-rwxr-xr-x
quotacheck
91.34
KB
-rwxr-xr-x
quotaoff
54.78
KB
-rwxr-xr-x
quotaon
54.78
KB
-rwxr-xr-x
quotastats
14.15
KB
-rwxr-xr-x
rarp
32.33
KB
-rwxr-xr-x
readprofile
22.41
KB
-rwxr-xr-x
reboot
1.06
MB
-rwxr-xr-x
remove-default-ispell
2.86
KB
-rwxr-xr-x
remove-default-wordlist
2.86
KB
-rwxr-xr-x
remove-shell
1.07
KB
-rwxr-xr-x
repquota
71.41
KB
-rwxr-xr-x
resize2fs
66.3
KB
-rwxr-xr-x
rmail
18.3
KB
-rwxr-xr-x
rmmod
166.36
KB
-rwxr-xr-x
rmt
58.57
KB
-rwxr-xr-x
rmt-tar
58.57
KB
-rwxr-xr-x
route
64.27
KB
-rwxr-xr-x
rpc.rquotad
75.18
KB
-rwxr-xr-x
rsyslogd
767.19
KB
-rwxr-xr-x
rtacct
28.31
KB
-rwxr-xr-x
rtcwake
34.38
KB
-rwxr-xr-x
rtmon
90.39
KB
-rwxr-xr-x
runlevel
1.06
MB
-rwxr-xr-x
runuser
54.38
KB
-rwxr-xr-x
safe_finger
14.34
KB
-rwxr-xr-x
select-default-ispell
3.23
KB
-rwxr-xr-x
select-default-wordlist
3.21
KB
-rwxr-xr-x
sendmail
30.45
KB
-rwxr-xr-x
service
8.88
KB
-rwxr-xr-x
setcap
14.3
KB
-rwxr-xr-x
setquota
79.38
KB
-rwxr-xr-x
setvesablank
14.23
KB
-rwxr-xr-x
setvtrgb
14.29
KB
-rwxr-xr-x
sfdisk
102.38
KB
-rwxr-xr-x
sgdisk
162.48
KB
-rwxr-xr-x
shadowconfig
885
B
-rwxr-xr-x
shutdown
1.06
MB
-rwxr-xr-x
slattach
36.08
KB
-rwxr-xr-x
smtp-sink
35.27
KB
-rwxr-xr-x
smtp-source
30.32
KB
-rwxr-xr-x
sshd
899.7
KB
-rwxr-xr-x
start-stop-daemon
47.35
KB
-rwxr-xr-x
sudo_logsrvd
200.1
KB
-rwxr-xr-x
sudo_sendlog
107.34
KB
-rwxr-xr-x
sulogin
42.38
KB
-rwxr-xr-x
swaplabel
18.38
KB
-rwxr-xr-x
swapoff
22.38
KB
-rwxr-xr-x
swapon
42.38
KB
-rwxr-xr-x
switch_root
22.38
KB
-rwxr-xr-x
sysctl
30.23
KB
-rwxr-xr-x
tarcat
936
B
-rwxr-xr-x
tc
614.08
KB
-rwxr-xr-x
tcpd
14.3
KB
-rwxr-xr-x
tcpdchk
30.41
KB
-rwxr-xr-x
tcpdmatch
22.31
KB
-rwxr-xr-x
telinit
1.06
MB
-rwxr-xr-x
thermald
554.6
KB
-rwxr-xr-x
thin_check
1.33
MB
-rwxr-xr-x
thin_delta
1.33
MB
-rwxr-xr-x
thin_dump
1.33
MB
-rwxr-xr-x
thin_ls
1.33
MB
-rwxr-xr-x
thin_metadata_size
1.33
MB
-rwxr-xr-x
thin_repair
1.33
MB
-rwxr-xr-x
thin_restore
1.33
MB
-rwxr-xr-x
thin_rmap
1.33
MB
-rwxr-xr-x
thin_trim
1.33
MB
-rwxr-xr-x
tipc
90.44
KB
-rwxr-xr-x
try-from
14.3
KB
-rwxr-xr-x
tune2fs
102.55
KB
-rwxr-xr-x
tzconfig
106
B
-rwxr-xr-x
u-d-c-print-pci-ids
517
B
-rwxr-xr-x
umount.udisks2
14.3
KB
-rwxr-xr-x
unix_chkpwd
26.15
KB
-rwxr-sr-x
unix_update
30.15
KB
-rwxr-xr-x
update-ca-certificates
5.29
KB
-rwxr-xr-x
update-default-aspell
1
KB
-rwxr-xr-x
update-default-ispell
9.68
KB
-rwxr-xr-x
update-default-wordlist
7.5
KB
-rwxr-xr-x
update-dictcommon-aspell
1
KB
-rwxr-xr-x
update-dictcommon-hunspell
782
B
-rwxr-xr-x
update-grub
64
B
-rwxr-xr-x
update-grub-gfxpayload
301
B
-rwxr-xr-x
update-grub2
64
B
-rwxr-xr-x
update-gsfontmap
470
B
-rwxr-xr-x
update-inetd
5.83
KB
-rwxr-xr-x
update-info-dir
1.66
KB
-rwxr-xr-x
update-initramfs
6.74
KB
-rwxr-xr-x
update-locale
2.99
KB
-rwxr-xr-x
update-mime
9.39
KB
-rwxr-xr-x
update-passwd
34.56
KB
-rwxr-xr-x
update-pciids
1.71
KB
-rwxr-xr-x
update-rc.d
16.92
KB
-rwxr-xr-x
update-shells
3.72
KB
-rwxr-xr-x
upgrade-from-grub-legacy
1.56
KB
-rwxr-xr-x
usb_modeswitch
59.66
KB
-rwxr-xr-x
usb_modeswitch_dispatcher
26.78
KB
-rwxr-xr-x
usbmuxd
86.6
KB
-rwxr-xr-x
useradd
127.66
KB
-rwxr-xr-x
userdel
86.85
KB
-rwxr-xr-x
usermod
123.46
KB
-rwxr-xr-x
uuidd
30.85
KB
-rwxr-xr-x
validlocale
1.73
KB
-rwxr-xr-x
vcstime
14.15
KB
-rwxr-xr-x
vdpa
30.56
KB
-rwxr-xr-x
veritysetup
43.76
KB
-rwxr-xr-x
vgcfgbackup
2.89
MB
-rwxr-xr-x
vgcfgrestore
2.89
MB
-rwxr-xr-x
vgchange
2.89
MB
-rwxr-xr-x
vgck
2.89
MB
-rwxr-xr-x
vgconvert
2.89
MB
-rwxr-xr-x
vgcreate
2.89
MB
-rwxr-xr-x
vgdisplay
2.89
MB
-rwxr-xr-x
vgexport
2.89
MB
-rwxr-xr-x
vgextend
2.89
MB
-rwxr-xr-x
vgimport
2.89
MB
-rwxr-xr-x
vgimportclone
2.89
MB
-rwxr-xr-x
vgmerge
2.89
MB
-rwxr-xr-x
vgmknodes
2.89
MB
-rwxr-xr-x
vgreduce
2.89
MB
-rwxr-xr-x
vgremove
2.89
MB
-rwxr-xr-x
vgrename
2.89
MB
-rwxr-xr-x
vgs
2.89
MB
-rwxr-xr-x
vgscan
2.89
MB
-rwxr-xr-x
vgsplit
2.89
MB
-rwxr-xr-x
vigr
56.53
KB
-rwxr-xr-x
vipw
56.53
KB
-rwxr-xr-x
visudo
219.79
KB
-rwxr-xr-x
vpddecode
14.58
KB
-rwxr-xr-x
warnquota
87.3
KB
-rwxr-xr-x
wipefs
38.38
KB
-rwxr-xr-x
xfs_admin
1.37
KB
-rwxr-xr-x
xfs_bmap
695
B
-rwxr-xr-x
xfs_copy
82.48
KB
-rwxr-xr-x
xfs_db
652.44
KB
-rwxr-xr-x
xfs_estimate
14.16
KB
-rwxr-xr-x
xfs_freeze
800
B
-rwxr-xr-x
xfs_fsr
42.18
KB
-rwxr-xr-x
xfs_growfs
38.28
KB
-rwxr-xr-x
xfs_info
1.26
KB
-rwxr-xr-x
xfs_io
199.55
KB
-rwxr-xr-x
xfs_logprint
78.33
KB
-rwxr-xr-x
xfs_mdrestore
26.17
KB
-rwxr-xr-x
xfs_metadump
782
B
-rwxr-xr-x
xfs_mkfile
1.02
KB
-rwxr-xr-x
xfs_ncheck
685
B
-rwxr-xr-x
xfs_quota
90.16
KB
-rwxr-xr-x
xfs_repair
599.38
KB
-rwxr-xr-x
xfs_rtcp
18.15
KB
-rwxr-xr-x
xfs_scrub
106.27
KB
-rwxr-xr-x
xfs_scrub_all
5.87
KB
-rwxr-xr-x
xfs_spaceman
42.3
KB
-rwxr-xr-x
xqmstats
14.15
KB
-rwxr-xr-x
xtables-legacy-multi
96.95
KB
-rwxr-xr-x
xtables-monitor
219.04
KB
-rwxr-xr-x
xtables-nft-multi
219.04
KB
-rwxr-xr-x
zerofree
14.15
KB
-rwxr-xr-x
zic
62.32
KB
-rwxr-xr-x
zramctl
54.52
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : opendkim-genstats
#!/usr/bin/perl # # Copyright (c) 2010-2012, The Trusted Domain Project. All rights reserved. # # Script to generate some HTML-ized statistics for OpenDKIM ### ### Setup ### use strict; use warnings; use DBI; use File::Basename; use Getopt::Long; use IO::Handle; use POSIX; require DBD::mysql; # general my $progname = basename($0); my $version = "2.11.0"; my $verbose = 0; my $helponly = 0; my $showversion = 0; my $out; my $idx; my $dbi_s; my $dbi_h; my $dbi_a; my $thresh; # DB parameters my $def_dbhost = "localhost"; my $def_dbname = "opendkim"; my $def_dbuser = "opendkim"; my $def_dbpasswd = "opendkim"; my $def_dbport = "3306"; my $dbhost; my $dbname; my $dbuser; my $dbpasswd; my $dbport; my $dbscheme = "mysql"; # output location (default) my $reportout; my $tmpout; ### ### NO user-serviceable parts beyond this point ### sub usage { print STDERR "$progname: usage: $progname [options]\n"; print STDERR "\t--dbhost=host database host [$def_dbhost]\n"; print STDERR "\t--dbname=name database name [$def_dbname]\n"; print STDERR "\t--dbpasswd=passwd database password [$def_dbpasswd]\n"; print STDERR "\t--dbport=port database port [$def_dbport]\n"; print STDERR "\t--dbuser=user database user [$def_dbuser]\n"; print STDERR "\t--help print help and exit\n"; print STDERR "\t--output=file output file\n"; print STDERR "\t--verbose verbose output\n"; print STDERR "\t--version print version and exit\n"; } # parse command line arguments my $opt_retval = &Getopt::Long::GetOptions ('dbhost=s' => \$dbhost, 'dbname=s' => \$dbname, 'dbpasswd=s' => \$dbpasswd, 'dbport=s' => \$dbport, 'dbuser=s' => \$dbuser, 'help!' => \$helponly, 'output=s' => \$reportout, 'verbose!' => \$verbose, 'version!' => \$showversion, ); if (!$opt_retval || $helponly) { usage(); if ($helponly) { exit(0); } else { exit(1); } } if ($showversion) { print STDOUT "$progname v$version\n"; exit(0); } # apply defaults if (!defined($dbhost)) { if (defined($ENV{'OPENDKIM_DBHOST'})) { $dbhost = $ENV{'OPENDKIM_DBHOST'}; } else { $dbhost = $def_dbhost; } } if (!defined($dbname)) { if (defined($ENV{'OPENDKIM_DB'})) { $dbname = $ENV{'OPENDKIM_DB'}; } else { $dbname = $def_dbname; } } if (!defined($dbpasswd)) { if (defined($ENV{'OPENDKIM_PASSWORD'})) { $dbpasswd = $ENV{'OPENDKIM_PASSWORD'}; } else { $dbpasswd = $def_dbpasswd; } } if (!defined($dbport)) { if (defined($ENV{'OPENDKIM_PORT'})) { $dbport = $ENV{'OPENDKIM_PORT'}; } else { $dbport = $def_dbport; } } if (!defined($dbuser)) { if (defined($ENV{'OPENDKIM_USER'})) { $dbuser = $ENV{'OPENDKIM_USER'}; } else { $dbuser = $def_dbuser; } } if (!defined($reportout)) { if (defined($ENV{'OPENDKIM_OUTPUT'})) { $reportout = $ENV{'OPENDKIM_OUTPUT'}; } } if ($verbose) { print STDERR "$progname: started at " . localtime() . "\n"; } my $dbi_dsn = "DBI:" . $dbscheme . ":database=" . $dbname . ";host=" . $dbhost . ";port=" . $dbport; $dbi_h = DBI->connect($dbi_dsn, $dbuser, $dbpasswd, { PrintError => 0 }); if (!defined($dbi_h)) { print STDERR "$progname: unable to connect to database: $DBI::errstr\n"; exit(1); } if ($verbose) { print STDERR "$progname: connected to database\n"; } # # start the report # if (!defined($reportout)) { print STDERR "$progname: no output selected\n"; exit(1); } $tmpout = $reportout . "." . $$; open($out, ">", $tmpout) or die "$progname: can't open $tmpout: $!"; if ($verbose) { print STDERR "$progname: report started in $tmpout\n"; } print $out "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\n"; print $out "<html>\n"; print $out " <head>\n"; print $out " <meta http-equiv=\"content-type\" content=\"text/html;charset=us-ascii\">\n"; print $out " <title>\n"; print $out " OpenDKIM Statistics Report\n"; print $out " </title>\n"; print $out " </head>\n"; print $out "\n"; print $out " <body>\n"; print $out "<h1>OpenDKIM Statistics Report</h1>\n"; print $out "Generated " . strftime("%b %e %Y %H:%M:%S", localtime) . "\n"; print $out "<hr>\n"; print $out "<ul>\n"; print $out " <li> <a href=\"#total_records\">Total messages received</a>\n"; print $out " <li> <a href=\"#reporters\">Reporting hosts and record counts</a>\n"; print $out " <li> <a href=\"#signature_counts\">Overall message signature counts</a>\n"; print $out " <li> <a href=\"#dnssec\">DNSSEC results</a>\n"; print $out " <li> <a href=\"#dnssec_trend\">DNSSEC trend</a>\n"; print $out " <li> <a href=\"#passfail\">Overall pass/fail rates for signed mail</a>\n"; print $out " <li> <a href=\"#error_codes\">Top ten error codes</a>\n"; print $out " <li> <a href=\"#third_party\">Author vs. third-party signatures, non-MLM traffic</a>\n"; print $out " <li> <a href=\"#unique_domains\">Count of unique signed From: domains in sample</a>\n"; print $out " <li> <a href=\"#top_signing_domains\">Top 10 signing domains by signature count</a>\n"; print $out " <li> <a href=\"#top_passing_domains\">Top 10 signing domains by passing signature percentage</a>\n"; print $out " <li> <a href=\"#top_failing_domains\">Top 10 signing domains by failed signature percentage</a>\n"; print $out " <li> <a href=\"#use_counts\">Signing domain use counts</a>\n"; print $out " <li> <a href=\"#signing_trend_msg\">Trend in message signing rates</a>\n"; print $out " <li> <a href=\"#signing_trend_domain\">Trend in domain signing rates</a>\n"; print $out " <li> <a href=\"#atps_use\">ATPS use</a>\n"; print $out "</ul>\n"; print $out "<hr>\n"; # # build a temporary table # if ($verbose) { print STDERR "$progname: constructing temporary table\n"; } $dbi_s = $dbi_h->prepare("CREATE TEMPORARY TABLE t1 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, messages_id INT UNSIGNED NOT NULL, messages_date TIMESTAMP NOT NULL, messages_from_domain INT UNSIGNED NOT NULL, messages_atps TINYINT UNSIGNED NOT NULL, messages_sigcount SMALLINT UNSIGNED NOT NULL, signatures_id INT UNSIGNED NOT NULL, signatures_domain INT UNSIGNED NOT NULL, signatures_pass TINYINT UNSIGNED NOT NULL, signatures_fail_body TINYINT UNSIGNED NOT NULL, signatures_sigerror SMALLINT UNSIGNED NOT NULL, signatures_dnssec SMALLINT NOT NULL, reporters_id INT UNSIGNED NOT NULL, reporters_name VARCHAR(255) NOT NULL, reporters_firstseen TIMESTAMP NOT NULL, PRIMARY KEY(id), KEY(messages_from_domain), KEY(messages_sigcount), KEY(messages_atps), KEY(signatures_domain), KEY(signatures_dnssec), KEY(reporters_id) )"); if (!$dbi_s->execute) { print STDERR "$progname: CREATE TEMPORARY TABLE failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } $dbi_s->finish; if ($verbose) { print STDERR "$progname: populating temporary table\n"; } $dbi_s = $dbi_h->prepare("INSERT INTO t1 ( messages_id, messages_date, messages_from_domain, messages_atps, messages_sigcount, signatures_id, signatures_domain, signatures_pass, signatures_fail_body, signatures_sigerror, signatures_dnssec, reporters_id, reporters_name, reporters_firstseen) SELECT messages.id, messages.msgtime, messages.from_domain, messages.atps, messages.sigcount, signatures.id, signatures.domain, signatures.pass, signatures.fail_body, signatures.sigerror, signatures.dnssec, reporters.id, reporters.name, reporters.firstseen FROM messages JOIN reporters ON messages.reporter = reporters.id LEFT OUTER JOIN signatures ON signatures.message = messages.id WHERE reporters.enabled = 1"); if (!$dbi_s->execute) { print STDERR "$progname: INSERT INTO TEMPORARY TABLE failed: " . $dbi_h->errstr . "\n"; $dbi_s->finish; $dbi_h->disconnect; exit(1); } $dbi_s->finish; if ($verbose) { print STDERR "$progname: generating reports\n"; } # # Total record count # print $out "<a name=\"total_records\"></a>\n"; print $out "<p> Total records (messages) received: </p>\n"; print $out "<table border=\"1\" columns=\"2\">\n"; print $out " <tr>\n"; print $out " <td> <b> Messages </b> </td>\n"; print $out " <td> <b> Signed </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT COUNT(DISTINCT messages_id), SUM(SIGN(messages_sigcount)) FROM t1"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Reporting hosts # print $out "<a name=\"reporters\"></a>\n"; print $out "<p> Reporting hosts and record counts: </p>\n"; print $out "<table border=\"1\" columns=\"4\">\n"; print $out " <tr>\n"; print $out " <td> <b> Reporter </b> </td>\n"; print $out " <td> <b> Messages </b> </td>\n"; print $out " <td> <b> Since </b> </td>\n"; print $out " <td> <b> Last </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT reporters_name, COUNT(DISTINCT messages_id), reporters_firstseen, MAX(messages_date) FROM t1 GROUP BY 1 ORDER BY 2"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " <td> " . $dbi_a->[2] . " </td>\n"; print $out " <td> " . $dbi_a->[3] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Overall message signature counts # print $out "<a name=\"signature_counts\"></a>\n"; print $out "<p> Overall message signature counts: </p>\n"; print $out "<table border=\"1\" columns=\"2\">\n"; print $out " <tr>\n"; print $out " <td> <b> Signatures </b> </td>\n"; print $out " <td> <b> Messages </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT messages_sigcount, COUNT(DISTINCT messages_id) FROM t1 GROUP BY 1"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # DNSSEC results # print $out "<a name=\"dnssec\"></a>\n"; print $out "<p> DNSSEC results (see libopendkim/dkim.h): </p>\n"; print $out "<table border=\"1\" columns=\"2\">\n"; print $out " <tr>\n"; print $out " <td> <b> DNSSEC code </b> </td>\n"; print $out " <td> <b> Signature Count </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT signatures_dnssec, COUNT(id) FROM t1 GROUP BY 1 ORDER BY 1"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # DNSSEC trend # print $out "<a name=\"dnssec_trend\"></a>\n"; print $out "<p> DNSSEC trend: </p>\n"; print $out "<table border=\"1\" columns=\"3\">\n"; print $out " <tr>\n"; print $out " <td> <b> Domains </b> </td>\n"; print $out " <td> <b> Year </b> </td>\n"; print $out " <td> <b> Month </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT COUNT(DISTINCT signatures_domain), YEAR(messages_date), MONTHNAME(messages_date) FROM t1 WHERE (signatures_dnssec = 0 OR signatures_dnssec = 2) GROUP BY 2, 3 ORDER BY 2, MONTH(messages_date)"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " <td> " . $dbi_a->[2] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Pass/fail rates # print $out "<a name=\"passfail\"></a>\n"; print $out "<p> Overall pass/fail rate for signed mail: </p>\n"; print $out "<table border=\"1\" columns=\"3\">\n"; print $out " <tr>\n"; print $out " <td> <b> Signatures </b> </td>\n"; print $out " <td> <b> Passed </b> </td>\n"; print $out " <td> <b> Failed (body) </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT COUNT(DISTINCT signatures_id), SUM(signatures_pass), SUM(signatures_fail_body) FROM t1 WHERE signatures_id IS NOT NULL"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " <td> " . $dbi_a->[2] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Top error codes # print $out "<a name=\"error_codes\"></a>\n"; print $out "<p> Top ten error codes (see libopendkim/dkim.h): </p>\n"; print $out "<table border=\"1\" columns=\"2\">\n"; print $out " <tr>\n"; print $out " <td> <b> Error </b> </td>\n"; print $out " <td> <b> Instances </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT sigerrorcodes.name, COUNT(t1.id) FROM t1 JOIN sigerrorcodes ON sigerrorcodes.id = signatures_sigerror WHERE NOT signatures_sigerror IN (0, 28) GROUP BY signatures_sigerror ORDER BY 2 DESC LIMIT 10"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Author vs. third-party, non-MLM # print $out "<a name=\"third_party\"></a>\n"; print $out "<p> Author vs. third-party signatures, non-MLM traffic: </p>\n"; print $out "<table border=\"1\" columns=\"2\">\n"; print $out " <tr>\n"; print $out " <td> <b> Author Signatures </b> </td>\n"; print $out " <td> <b> Passed </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT COUNT(DISTINCT signatures_id), SUM(signatures_pass) FROM t1 WHERE messages_from_domain = signatures_domain"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<table border=\"1\" columns=\"2\">\n"; print $out " <tr>\n"; print $out " <td> <b> Third-Party Signatures </b> </td>\n"; print $out " <td> <b> Passed </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT COUNT(DISTINCT signatures_id), SUM(signatures_pass) FROM t1 WHERE NOT messages_from_domain = signatures_domain"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Unique signed From: domains # print $out "<a name=\"unique_domains\"></a>\n"; print $out "<p> Count of unique signed From: domains in sample: </p>\n"; print $out "<table border=\"1\" columns=\"1\">\n"; print $out " <tr>\n"; print $out " <td> <b> Domains </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT COUNT(DISTINCT messages_from_domain) FROM t1 WHERE messages_sigcount > 0"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Top 10 signing domains by signature count # print $out "<a name=\"top_signing_domains\"></a>\n"; print $out "<p> Top 10 signing domains by signature count: </p>\n"; print $out "<table border=\"1\" columns=\"2\">\n"; print $out " <tr>\n"; print $out " <td> <b> Domain </b> </td>\n"; print $out " <td> <b> Signatures </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT domains.name, SUM(messages_sigcount) FROM t1 JOIN domains ON t1.signatures_domain = domains.id GROUP BY t1.signatures_domain ORDER BY 2 DESC LIMIT 10"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Top 10 passing domains # print $out "<a name=\"top_passing_domains\"></a>\n"; print $out "<p> Top 10 signing domains by passing signature percentage: </p>\n"; print $out "<table border=\"1\" columns=\"3\">\n"; print $out " <tr>\n"; print $out " <td> <b> Domain </b> </td>\n"; print $out " <td> <b> Signatures </b> </td>\n"; print $out " <td> <b> % Passed </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT domains.name, COUNT(t1.id), 100*SUM(t1.signatures_pass)/COUNT(t1.id) FROM t1 JOIN domains ON t1.signatures_domain = domains.id GROUP BY t1.signatures_domain ORDER BY 3 DESC, 2 DESC LIMIT 10"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " <td> " . $dbi_a->[2] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Top 10 failing domains # print $out "<a name=\"top_failing_domains\"></a>\n"; print $out "<p> Top 10 signing domains by failing signature percentage: </p>\n"; print $out "<table border=\"1\" columns=\"3\">\n"; print $out " <tr>\n"; print $out " <td> <b> Domain </b> </td>\n"; print $out " <td> <b> Signatures </b> </td>\n"; print $out " <td> <b> % Failed </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT domains.name, COUNT(t1.id), 100-100*SUM(signatures_pass)/COUNT(t1.id) FROM t1 JOIN domains ON t1.signatures_domain = domains.id GROUP BY t1.signatures_domain ORDER BY 3 DESC, 2 DESC LIMIT 10"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " <td> " . $dbi_a->[2] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Domain use counts # print $out "<a name=\"use_counts\"></a>\n"; print $out "<p> Signing domain use counts: </p>\n"; print $out "<table border=\"1\" columns=\"2\">\n"; print $out " <tr>\n"; print $out " <td> <b> Messages </b> </td>\n"; print $out " <td> <b> Domains </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT msgcount, COUNT(signatures_domain) FROM (SELECT signatures_domain, COUNT(id) AS msgcount FROM t1 GROUP BY 1) a GROUP BY 1 ORDER BY 1 ASC LIMIT 10"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Signing trend (messages) # print $out "<a name=\"signing_trend_msg\"></a>\n"; print $out "<p> Trend in message signing rates: </p>\n"; print $out "<table border=\"1\" columns=\"3\">\n"; print $out " <tr>\n"; print $out " <td> <b> Year </b> </td>\n"; print $out " <td> <b> Month </b> </td>\n"; print $out " <td> <b> % Signed </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT YEAR(messages_date), MONTHNAME(messages_date), (100. * SUM(SIGN(messages_sigcount)) / COUNT(DISTINCT messages_id)) FROM t1 GROUP BY 1, MONTH(messages_date) ORDER BY 1, MONTH(messages_date)"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " <td> " . $dbi_a->[2] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # Signing trend (domains) # print $out "<a name=\"signing_trend_domain\"></a>\n"; print $out "<p> Trend in message signing rates: </p>\n"; print $out "<table border=\"1\" columns=\"3\">\n"; print $out " <tr>\n"; print $out " <td> <b> Year </b> </td>\n"; print $out " <td> <b> Month </b> </td>\n"; print $out " <td> <b> Domains </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT YEAR(messages_date), MONTHNAME(messages_date), COUNT(DISTINCT signatures_domain) FROM t1 GROUP BY 1, MONTH(messages_date) ORDER BY 1, MONTH(messages_date)"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " <td> " . $dbi_a->[1] . " </td>\n"; print $out " <td> " . $dbi_a->[2] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # ATPS use # print $out "<a name=\"atps_use\"></a>\n"; print $out "<p> ATPS use: </p>\n"; print $out "<table border=\"1\" columns=\"1\">\n"; print $out " <tr>\n"; print $out " <td> <b> Domains </b> </td>\n"; print $out " </tr>\n"; $dbi_s = $dbi_h->prepare("SELECT COUNT(DISTINCT messages_from_domain) FROM t1 WHERE messages_atps = 1"); if (!$dbi_s->execute) { print STDERR "$progname: SELECT failed: " . $dbi_h->errstr; $dbi_s->finish; $dbi_h->disconnect; exit(1); } while ($dbi_a = $dbi_s->fetchrow_arrayref()) { print $out " <tr>\n"; print $out " <td> " . $dbi_a->[0] . " </td>\n"; print $out " </tr>\n"; } print $out "</table>\n"; print $out "<br>\n"; $dbi_s->finish; # # all done! if ($verbose) { print STDERR "$progname: terminating at " . localtime() . "\n"; } $dbi_h->disconnect; if (defined($reportout)) { print $out "<hr>\n"; print $out "<font size='-1'>Report completed at " . localtime() . "</font>\n"; print $out "</body>\n"; print $out "</html>\n"; close $out; rename($tmpout, $reportout) or die "$progname: rename to $reportout failed; $!"; } exit(0);
Close
