OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	02/03/2023 08:06:37 AM	rwxr-xr-x
📄 config.pl	6.53 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 dataextract.sh	2.51 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 etl.pl	5.46 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 etlproc	11.81 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 func.pl	4.01 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 globvar.sh	330 bytes	02/03/2023 07:34:08 AM	rw-r--r--
📄 initetl.pl	1.88 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 libawk.awk	3.07 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 makeXtab2NormalExcel.pl	5.25 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 process.pl	6.92 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 process_changed.pl	5.69 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 readwrite.pl	4.16 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 rxcsv.pl	7.94 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 rxdb.pl	8.84 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 rxfile.pl	4.72 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 rxsalesforce.pl	3.33 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 rxsalesforce.pl.bak	3.33 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 rxxml.pl	12.66 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 rxxml2.pl	4.18 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 s.log	8.86 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 sendmail.pl	1.06 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 sourcequery.pl	4.17 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 sql.pl	13.89 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 sql_mssql.pl	13.89 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 store.pl	7.6 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 task.pl	30.55 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 task_mssql.pl	30.8 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 tmpxml.pl	1.49 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 userfunc.pl	5.5 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 valid.pl	3.9 KB	02/03/2023 07:34:08 AM	rw-r--r--
📄 workflow.pl	3.72 KB	02/03/2023 07:34:08 AM	rwxr-xr-x
📄 xform.pl	2.62 KB	02/03/2023 07:34:08 AM	rw-r--r--

Editing: dataextract.sh

#!/bin/bash

###########################################################################################################################
#Company		: Robust Designs (Ind) Pvt Ltd
#Product		: Cubot 7.2.1
#Author			: Arun,Shailesh
#Last Updated 	: 10 July 2008
#Version		: 1.0

#sh /home/cubot/bin/etl/dataextract.sh mysql sampledb cubot NA localhost /tmp/result.csv "select * from menu_trees limit 100;"

#****************************************************NOTE******************************************************************
#DO NOT ALIGN THIS SCRIPT. BY DOING LIKE BELOW ALIGN IT MAY FAIL IN SOME CASES. PROBLEM MAY COME DUE TO [ ! ].

#if [ "$USER" != "NA" ] ;then #4
#	mysql -u $USER -t  $DBNAME<<! >$REDIRECT_FILE 2>$REDIRECT_FILE
#	$QERY;
#	!
#fi
###########################################################################################################################
HOMEDIR="/home/cubot"
LOG_FILE="$HOMEDIR/logs/ora.log"

if [ -f "$LOG_FILE" ]; then
	exec >>$LOG_FILE
	exec 2>>$LOG_FILE
fi

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$HOMEDIR/sqlplus/;

if [ "$#" != "7" ]; then
	echo "We are expecting 7 arguments in shell script $0. Arguments Passed:$@";
	echo "USSAGE: [ $0 DBTYPE(oracle/mysql) DBNAME USER PASSWD HOST REDIRECT_FILE QERY ]. Use NA if USER/HOST/PASSWD not needed.";
	exit 1;
fi

DBTYPE=$1;
DBNAME=$2;
USER=$3;
PASSWD=$4;
HOST=$5;
REDIRECT_FILE=$6;
QERY=$7;

if [ "$DBNAME" == "NA" -o "$QERY" == "NA" ]; then
	echo "Got Problem DBNAME=$DBNAME and Query=$QERY in $0";
	exit 1;
fi

if [ "$REDIRECT_FILE" == "NA" ]; then
	echo "Got Problem REDIRECT_FILE = NA in $0";
	exit 1;
fi

if [ "$DBTYPE" == "oracle" ]; then #1
/home/cubot/sqlplus/sqlplus -s  $USER/$PASSWD@'(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = '$HOST')(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = '$DBNAME')))'<<! >$REDIRECT_FILE

set termout off serverout off feedback off sqlblanklines off MARKUP HTML ON  
set arraysize 5000
set linesize 9999
set pagesize 1000
ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';
$QERY;
!
else

if [ "$HOST" != "NA" -a "$PASSWD" != "NA" -a "$USER" != "NA" ]; then #2
mysql -h $HOST -u $USER -p $PASSWD -t  $DBNAME -H<<! >$REDIRECT_FILE 2>$REDIRECT_FILE 
$QERY;
!
else

if [ "$HOST" != "NA" -a "$USER" != "NA" ] ;then #3
mysql -h $HOST -u $USER -t  $DBNAME -H<<! >$REDIRECT_FILE 2>$REDIRECT_FILE 
$QERY;
!
else
if [ "$USER" != "NA" ] ;then #4
mysql -u $USER -t  $DBNAME -H<<! >$REDIRECT_FILE 2>$REDIRECT_FILE 
$QERY;
!
else
mysql -t  $DBNAME -H<<! >$REDIRECT_FILE 2>$REDIRECT_FILE 
$QERY;
!
fi #/4

fi #/3

fi #/2

fi #/1

exit 0;