OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
bin
/
utils
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
02/03/2023 08:06:37 AM
rwxr-xr-x
📄
.auditreport.sh.swp
12 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
CollectReportData.sh
2.17 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
ComapreCubotTableData.sh
1.06 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
VBox.sh
1.59 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
auditreport.sh
1.35 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cleanSRCid.sql
386 bytes
02/03/2023 07:34:08 AM
rw-r--r--
📄
cleancache.sh
8.89 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
compare_database.sh
148 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
compressCSS.sh
262 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
compressJS.sh
251 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubbackup.sh
1.43 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubbackup_sync.sh
314 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubmonitor.sh
3.77 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubotmail
29.64 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
esalesforce.pl
1.87 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
etl_xform_template.sh
543 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
killrunaway.sh
609 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
migrateSharedreports.sh
1.14 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
mysql2pgsql.perl
40.98 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
removenewlinechar.awk
292 bytes
02/03/2023 07:34:08 AM
rw-r--r--
📄
removenewlinechar.pl
534 bytes
02/03/2023 07:34:08 AM
rw-r--r--
📄
removenewlinechar2.awk
82 bytes
02/03/2023 07:34:08 AM
rw-r--r--
📄
renameCubUser.sh
2.38 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
sendmail.pl
2.13 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
updatealldb.sh
1.08 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
yuicompressor-2.4.6.jar
832.85 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
zap
1.86 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
Editing: killrunaway.sh
Close
#!/bin/bash # Change threshold seconds to which queries you want to kill THRESHOLD_SECS=3600 MYSQL_USER=root #mysql -u $MYSQL_USER -e "show full processlist" | grep Query | grep -v processlist | awk -F"\t" '{if($prcs_time > $THRESHOLD_SECS) printf("\n%s -Query on %s db from %s@%s is running from %s seconds\nQuery is : %s\n\n", $1, $4, $2, $3, $6, $8);}' mysqladmin -u $MYSQL_USER processlist | grep [QuerySleep] | cut -d'|' -f2,7 | while read prcs_id sep prcs_time do if [ $prcs_time -gt $THRESHOLD_SECS ] then echo $prcs_id running for $prcs_time mysqladmin -u $MYSQL_USER kill $prcs_id fi done