OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
bin
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
02/03/2023 08:25:32 AM
rwxr-xr-x
📄
auditreport.sh
1.15 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
clripcs
44.5 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
comparedb.sh
487 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
convertToexcel.pl
3.69 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
convertToexcel_my.rd.pl
3.06 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
crlf.sh
67 bytes
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
cron.sh
173 bytes
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubadmserv
1.94 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubalert
1.3 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubetlserv
1.97 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubgphserv
2.55 MB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
cubmenuserv
2.51 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubnotify
2.79 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubot.properties
1.93 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
cubregenxy
947.66 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubregenxy.gz
341.15 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubrouter
378.71 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubrxgate
440.74 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
cubrxlogin
529.18 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubsearch
1.58 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubsearchrouter
520.15 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
doZip.sh
669 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
esalesforce
57 bytes
02/03/2023 07:34:09 AM
rwxr-xr-x
📁
etl
-
02/03/2023 07:34:08 AM
rwxr-xr-x
📁
etl_odbc
-
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
finyr.so
25.82 KB
02/03/2023 07:34:11 AM
rwxr-xr-x
📄
finyr.so_16May
26.11 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
fmtxml2ooffice.sh
1013 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
forecast.R
3.13 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
gep_days.so
10.03 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
html2csv.sh
2.97 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
html2ps
129.14 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
httpd
565.41 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
httpd_2.2
2.9 MB
02/03/2023 07:34:15 AM
rwxr-xr-x
📁
jars
-
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
jgraphserver.sh
841 bytes
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
libAdaptikTokenServiceProvider.so
631.87 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libTokenServiceProvider.so
146.98 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libcrypto.so.0.9.8
38.29 KB
05/03/2022 10:19:39 AM
rw-r--r--
📄
libcubotsvc.so
112.92 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
libdbdriver.so
113.32 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libldap-2.3.so.0
319.36 KB
05/12/2022 01:52:38 PM
rw-r--r--
📄
libmysqlclient.so
1.52 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libmysqlclient.so.15
3.78 MB
04/23/2023 02:08:47 PM
rw-r--r--
📄
libmysqlclient.so.16
3.78 MB
04/23/2023 02:08:47 PM
rw-r--r--
📄
libodbc.so.1
421.49 KB
03/26/2018 02:37:19 PM
rw-r--r--
📄
libpcre.so.1
449.93 KB
05/17/2022 07:42:45 AM
rw-r--r--
📄
librxauth.so
98.6 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxetl.so
29.8 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxfusionchart.so
60.25 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
librxgphserv.so
125.78 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxmetadata.so
227.2 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
librxmysql.so
80.75 KB
02/03/2023 07:34:10 AM
rwxr-xr-x
📄
librxolap.so
823.31 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
libssl.so.0.9.8
563.78 KB
05/24/2023 05:14:51 PM
rw-r--r--
📄
libtdsodbc.so
929.6 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
makeXtab2NormalExcel.pl
5.33 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
mod_axis2.so
226.12 KB
02/03/2023 08:01:00 AM
rwxr-xr-x
📄
mod_jk.so
384.77 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
mod_rx.so
50.69 KB
02/03/2023 08:01:00 AM
rw-r--r--
📄
multiSheet.pl
5.74 KB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
preCheck.js
1.03 KB
02/03/2023 07:34:13 AM
rw-r--r--
📄
priority_regen.sh
4.41 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
procscript.sh
321 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxdummydb.so
108.43 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxmssql.so
112.95 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxmysql.so
108.4 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
rxodbc.so
113.24 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxolite.so
108.45 KB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
rxora.so
113.03 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
rxsalesforce.so
108 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxsybase.so
123.61 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
services.xml
6.64 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
setvars.sh
556 bytes
02/03/2023 07:34:15 AM
rwxr-xr-x
📁
utils
-
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
ws.core.js
40.18 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
wsAll.js
142.94 KB
02/03/2023 07:34:09 AM
rw-r--r--
Editing: priority_regen.sh
Close
#!/bin/sh # -- /* Priority Based Data Regeneration # -- * We could use unix_timestamp to make it little more techie, however, I felt good if user can simply understand it ... # -- */ #PRIORITY=(10 20 30 40 50 60 70 80 90) DB=$1 export DATESTR=`date +%Y%m%d` SCRIPTLOG=/home/cubot/logs/regen_priorty_${DATESTR}.log > ${SCRIPTLOG} exec 2>>${SCRIPTLOG} exec >>${SCRIPTLOG} #Step 1: Clear IPCS export IPCS_DATE=`date '+%Y_%m_%d_%H_%M_%S'` ###### SET variables for CUBOT ######## . /home/cubot/bin/setvars.sh ###### Clear IPCS and O/P in a file ###### /home/cubot/bin/clripcs -1 >> /home/cubot/logs/IPCS_${IPCS_DATE}.log #Step 2: Clear Cache mysql $DB -vvv << ! drop table if exists tmp_series_stat; update data_series, ds_stat set dt_status='D' where ds_src_id is NOT NULL and dt_status='V' and ds_series_id=dt_series_id; create table tmp_series_stat select distinct dt_series_id from ds_stat where dt_status != 'V'; alter table tmp_series_stat add primary key (dt_series_id); truncate table data_xy; optimize table ds_stat; optimize table data_xy; optimize table data_series; optimize table data_seriesids; optimize table data_seriesvals; ! mysql $DB -vvv << ! drop table if exists regen_series; CREATE TABLE regen_series ( rs_series_id int(11) NOT NULL DEFAULT '0', rs_priority tinyint(4) DEFAULT '100', rs_trn_table char(64) DEFAULT NULL, rs_menu_id int(11) DEFAULT NULL, rs_gen_mstime double DEFAULT NULL, rs_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (rs_series_id) ) ENGINE=MyISAM; update data_series, ds_stat set dt_status='D' where ds_src_id is NOT NULL and dt_status='V' and ds_series_id=dt_series_id; insert ignore into regen_series(rs_series_id, rs_priority) select distinct gs_series_id,10 from graph_series where gs_id in (select ni_message_info from notify_info where ni_active = 1 and ni_status = 0); insert ignore into regen_series(rs_series_id, rs_priority) select distinct gs_series_id,20 from graph_series where gs_id in (select distinct fp_id from folder_properties where date(from_unixtime(fp_laccessdt)) > date(date_sub(now(), INTERVAL 2 DAY))); insert ignore into regen_series(rs_series_id, rs_priority) select distinct gs_series_id,30 from graph_series where gs_id in (select distinct fp_id from folder_properties where date(from_unixtime(fp_laccessdt)) > date(date_sub(now(), INTERVAL 8 DAY))); insert ignore into regen_series(rs_series_id, rs_priority) select distinct gs_series_id,40 from graph_series where gs_id in (select distinct fp_id from folder_properties where date(from_unixtime(fp_laccessdt)) between date(date_sub(now(), INTERVAL 16 DAY)) and date(date_sub(now(), INTERVAL 7 DAY))); insert ignore into regen_series(rs_series_id, rs_priority) select distinct gs_series_id,50 from graph_series where gs_id in (select distinct fp_id from folder_properties where date(from_unixtime(fp_laccessdt)) between date(date_sub(now(), INTERVAL 30 DAY)) and date(date_sub(now(), INTERVAL 15 DAY))); #insert ignore into regen_series(rs_series_id, rs_priority) select distinct gs_series_id,60 from graph_series where gs_id in (select distinct fp_id from folder_properties where date(from_unixtime(fp_laccessdt)) between date(date_sub(now(), INTERVAL 51 DAY)) and date(date_sub(now(), INTERVAL 29 DAY))); #insert ignore into regen_series(rs_series_id, rs_priority) select distinct gs_series_id,70 from graph_series where gs_id in (select distinct fp_id from folder_properties where date(from_unixtime(fp_laccessdt)) between date(date_sub(now(), INTERVAL 90 DAY)) and date(date_sub(now(), INTERVAL 50 DAY))); #insert ignore into regen_series(rs_series_id, rs_priority) select distinct gs_series_id,80 from graph_series where gs_id > 100000; #insert ignore into regen_series(rs_series_id, rs_priority) select distinct dt_series_id,90 from ds_stat where dt_status = 'V'; update regen_series , data_series, ds_stat set rs_menu_id = ds_yid, rs_gen_mstime = dt_query_time where rs_series_id = ds_series_id and ds_series_id = dt_series_id and dt_status = 'V' and ds_src_id is NULL; delete from regen_series where rs_menu_id is NULL; update regen_series, menu_dtls set rs_trn_table = md_table where md_id = rs_menu_id; ! mysql -N $DB -e "select concat(rs_series_id, ',', rs_priority) from regen_series where rs_priority<>90 order by rs_priority ;" | awk -f /etl/scripts/priority_regen_split.awk -F',' &> /tmp/regen_exe_${DATESTR}.sql echo `date` "STARTING Priority Regen" sh /tmp/regen_exe_${DATESTR}.sql echo `date` "COMPLETED Priority Regen"