SQWareProduction:generic:etc:sqwgen GlobalVar.cfg

From Wiki_dbSQWare
Revision as of 18:03, 6 November 2023 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Configuration file $gvsqw_GenBin/../etc/sqwgen_GlobalVar.cfg:
Generic global var
It contains the operating variables of SQWareProduction.

File content: 

#!/bin/bash
###################################################################
# SQWareProduction Generic module of dbSQWare
# 
# dbSQWare is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# CGU/CGA for more details.
# 
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	Generic global var
## @Copyright	Copyright 2007-2025, dbSQWare (www.dbsqware.com)

if [ "$gvsqw_Debug" != "" ]
then
	echo $gvsqw_EchoOpt "RdbmsName    = $gvsqw_RdbmsName"
	echo $gvsqw_EchoOpt "RdbmsType    = $gvsqw_RdbmsType"
	echo $gvsqw_EchoOpt "RdbmsTrigram = $gvsqw_RdbmsTrigram"
	echo $gvsqw_EchoOpt "RdbmsRoot    = $gvsqw_RdbmsRoot"
	echo $gvsqw_EchoOpt "sourcing cfg file : ../SQWareProduction/generic/etc/sqwgen_GlobalVar.cfg"
fi

lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ "$gvsqw_dbSQWareScript" != "True" ]
then
	# ColorMultiLinesShort (p_cms)
	# ColorMultiLinesLong (p_cml)
	# Color2LinesShort (p_c2s)
	# Color2LinesLong (p_c2l)
	# ColorOneLineShort (p_cos)
	# ColorOneLineLong (p_col)
	# BlackWhiteMultiLinesShort (p_bms)
	# BlackWhiteMultiLinesLong (p_bml)
	# BlackWhite2LinesShort (p_b2s)
	# BlackWhite2LinesLong (p_b2l)
	# BlackWhiteOneLineShort (p_bos)
	# BlackWhiteOneLineLong (p_bol)
	if [ "$SHELLOPTS" != "" ]
	then
		export gvsqw_PromptStyle="ColorOneLineShort"
	else
		export gvsqw_PromptStyle="BlackWhiteOneLineLong"
	fi

	#For prompt color !
	blanc_noir="\033[37;40m"
	if [ "$gvsqw_Env" = "PRD" ]
	then
		#rouge_noir
		export color_noir="\033[31;40m"
	elif [ "$gvsqw_Env" = "INT" ]
	then
		#jaune_noir
		export color_noir="\033[33;40m"
	elif [ "$gvsqw_Env" = "VA" ]
	then
		#bleu_noir
		export color_noir="\033[34;40m"
	else
		#vert_noir
		export color_noir="\033[32;40m"
	fi
fi

#global
export gvsqw_SqwVersion=2025.07
if [ -w /var/tmp ]
then
	export gvsqw_GlobalTmpDir='/var/tmp'
else
	export gvsqw_GlobalTmpDir='/tmp'
fi

#export LANG='en_US.UTF-8'
#Force a case for instance name parameter, put UpperCase or LowerCase or NoCase
export gvsqw_InstanceNameForceCase='UpperCase'
#export gvsqw_Locale='en' change default Locale (en,fr)
export gvsqw_DistPasswdFile="$HOME/.passwd_$gvsqw_RdbmsType"
export gvsqw_SslCipher="-aes-256-cbc"
export gvsqw_SslPassFile="$HOME/sqwConfig/.ssl"
export gvsqw_GlobalMsgMail="Trt${gvsqw_RdbmsTrigram}Auto${gvsqw_Env}"
#To force mail sender, ex : gvsqw_MailSender='toto@mydomain.com' or gvsqw_MailSender=`id| cut -d')' -f1| cut -d'(' -f2`'@'`uname -n`
export gvsqw_MailSender=''
#Force a case for mail subject, put UpperCase or LowerCase or NoCase, to avoid quarantine (like rule ODD_CASE of spamassassin)
export gvsqw_MailSubjetForceCase='NoCase'
export gvsqw_UserExec=`id| cut -d')' -f1| cut -d'(' -f2`
export gvsqw_ConnectDb=Enable
export gvsqw_Hostname=$(uname -n|cut -d '.' -f1)
#Put NoNail in gvsqw_GlobalMail if you don't want to send mail on error
export gvsqw_GlobalMail='default@dbsqware.com'
#Put disable in gvsqw_SendmailHtmlFormat if you don't want to send mail in html format
export gvsqw_SendmailHtmlFormat=enable
export gvsqw_PreFormatHtlml=enable
#Put disable in gvsqw_Colors if you don't want to print in color
export gvsqw_Colors=enable
#Put disable in gvsqw_TraceJobDb if you don't want to trace job execution in SQWareRepository
#export gvsqw_TraceJobDb=enable
#Put disable in gvsqw_TraceSqlDb if you don't want to trace job execution in SQWareRepository
#export gvsqw_TraceSqlDb=enable
#Put disable in gvsqw_UpLoadLogFile if you don't want to upLoad log of job execution in SQWareRepository
export gvsqw_UpLoadLogFile=enable
#Put disable in gvsqw_TraceBackup if you don't want to backup execution in SQWareRepository
export gvsqw_TraceBackup=enable
export gvsqw_UpLoadLogFileMaxLine=200
export gvsqw_UpLoadMailFileMaxLine=400
export gvsqw_SendMailFileMaxLine=2000
export gvsqw_EgrepIvFs='Filesystem|Disponible'
export gvsqw_SuppLogsHisto=30
export gvsqw_GzipLogsHisto=3
export gvsqw_SuppBckCfg=30
export gvsqw_SuppArchAlert=30
export gvsqw_SuppTapeFilesLists=5
export gvsqw_InitInstanceSourceCommand='. ~/.profile'
export gvsqw_NbThread=2
export gvsqw_MysqlErrorMsg="ERROR |FAILED |ERREUR |ECHEC | ERROR:| FAILED:| ERREUR:| ECHEC:|Couldn.t execute |unknown option | doesn.t exist"
export gvsqw_DisplayNumberBlank="  0"
export gvsqw_LockFileWaitTimeOut=3600
#Put enable for full display log in sqw*_RunJob.ksh scripts
export gvsqw_RunJobFullOutput=disable

#manage ssh
export gvsqw_SshConnectTimeout=20
export gvsqw_SshOptions='-q -o BatchMode=yes -o StrictHostKeyChecking=no -o ConnectTimeout=$gvsqw_SshConnectTimeout'
export gvsqw_SshOptionsNoQuiet='-o BatchMode=yes -o StrictHostKeyChecking=no -o ConnectTimeout=$gvsqw_SshConnectTimeout'
export gvsqw_SshOptionsInteractive='-o StrictHostKeyChecking=no -o ServerAliveInterval=60 -o ServerAliveCountMax=10 -o ConnectTimeout=$gvsqw_SshConnectTimeout'
export gvsqw_ScpOptions='-o BatchMode=yes -o StrictHostKeyChecking=no -o ConnectTimeout=$gvsqw_SshConnectTimeout'
export gvsqw_RsyncOptions='ssh -o BatchMode=yes -o StrictHostKeyChecking=no -o ConnectTimeout=$gvsqw_SshConnectTimeout'

#Html tags
export gvsqw_CHtmlH1='<br/><h1 style="font-size:18px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:#f6761f; background-color:white; border-bottom:1px solid #fec060;">'
export gvsqw_CHtmlH2='<br/><h2 style="font-size:16px; font-family:Comic Sans MS,Cursive,Helvetica,Sans-Serif,Arial; color:#424666; background-color:white; text-decoration:underline; margin-left: 10px;">'
export gvsqw_CHtmlH3='<h3 style="font-size:14px; font-family:Courier,Helvetica,Sans-Serif,Arial; color:#424666; background-color:white; text-decoration:underline; margin-left: 20px;">'
export gvsqw_CHtmlError='<font color="#FF0000">'
export gvsqw_CHtmlOk='<font color="#27d827">'
export gvsqw_CHtmlInfo='<font color="#0000FF">'
export gvsqw_CHtmlNotFound='<font color="#9d00ff">'
export gvsqw_CHtmlWarning='<font color="#ff9100">'
export gvsqw_CHtmlEnd='</font>'
#export gvsqw_THtmlBegin='<table cellpadding="5px;" rules="all" style="font-size:12px; font-family:Verdana,Helvetica,Sans-Serif,Arial; color:#424666; margin-left: 50px; border:solid 1px #424666;">'
export gvsqw_THtmlBegin='<table cellpadding="5px;" rules="all" style="font-size:12px; font-family:Verdana,Helvetica,Sans-Serif,Arial; color:#424666; margin-left: 50px;">'
export gvsqw_THtmlEnd='</table>'
export gvsqw_THtmlThBegin='<tr style="font-weight:normal; font-style:italic; background-color:#afafaf; text-align:left; white-space:nowrap; color:#fff;"><th>'
export gvsqw_THtmlThEnd='</th></tr>'
export gvsqw_THtmlThInter='</th><th>'
export gvsqw_THtmlTdBegin1='<tr style="background-color:white; vertical-align:top;"><td style="white-space:nowrap; border-color: #424666;">'
export gvsqw_THtmlTdBegin2='<tr style="background-color:#f5f5f5; vertical-align:top;"><td style="white-space:nowrap; border-color: #424666;">'
export gvsqw_THtmlTdEnd='</td></tr>'
export gvsqw_THtmlTdInter='</td><td style="white-space:nowrap; border-color: #424666;">'
export gvsqw_THtmlTdInterRight='</td><td style="text-align:right; white-space:nowrap; border-color: #424666;">'
export gvsqw_THtmlUl='<ul style="font-size:14px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; background-color:white;">'
export gvsqw_THtmlUlEnd="</ul>"
export gvsqw_THtmlPre='pre style="font-size:12px; font-family:Consolas,Sans-Serif,Arial; background-color:white; color:#424666;">'
export gvsqw_THtmlPreFooter='pre style="font-size:10px; font-family:Helvetica,Sans-Serif,Arial; color:#f6761f; background-color:white;">'
export gvsqw_THtmlPreEnd="/pre>"
export gvsqw_THtmlABegin='<a style="color:#424666;"'
export gvsqw_THtmlABeginFooter='<a style="color:#979797;"'
export gvsqw_HtmlCss='<html><body style="font-size:12px; font-family:Verdana, Helvetica,Sans-Serif,Arial; color:#424666; background-color:white;">'

#####################################################
##For indicators
export gvsqw_SizeMinTableIndicators=10
export gvsqw_CommandPathVersionList="bash;--version ksh;--version rsync;--version openssl;version"
export gvsqw_CommandPathVersionListExtra=""
export gvsqw_AlwaysListFS="/;/var;/var/tmp;/var/log"

#For NetBackup script
export gvsqw_NetBackupPath='/usr/openv/netbackup'

#For RunJob script
export gvsqw_SendMailOnError=Disable #Put Enable to activate sendmail on error

#For Rsync script
export gvsqw_RsyncDefaultSourceDir='ToBeDefine'
export gvsqw_RsyncDefaultTargetDir='ToBeDefine'
export gvsqw_RsyncDefaultUser='$gvsqw_UserExec@RsyncHost'
export gvsqw_RsyncWaitTimeOut=3600

##Globaly forcing return code for scripts
#export gvsqw_ForcedReturnCodeScript_sqwmys_DumpDatabase=0

#for webdba
export gvsqw_WebDbaURL="https://webdba"
export gvsqw_WebDbaUser='dbsqware@SQWareWebHost'
#export gvsqw_WebDbaDirSlowQuery='Directory to store SlowQuery files'
#export gvsqw_WebDbaDirAwr='Directory to store AWR reports'

###################################################################################################
###################################################################################################

# Source generic custom
eval lvsqw_Tmp="\$gvsqw_${gvsqw_RdbmsTrigram}Bin"
if [ -r $gvsqw_GenPath/../../generic/etc_cust/sqwgen_GlobalVar.cfg ]
then
	if [ "$gvsqw_Debug" != "" ]
	then
		echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../generic/etc_cust/sqwgen_GlobalVar.cfg"
	fi
	. $gvsqw_GenPath/../../generic/etc_cust/sqwgen_GlobalVar.cfg
elif  [ -r $lvsqw_Tmp/../../generic/etc_cust/sqwgen_GlobalVar.cfg ]
then
	if [ "$gvsqw_Debug" != "" ]
	then
		echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../generic/etc_cust/sqwgen_GlobalVar.cfg"
	fi
	. $lvsqw_Tmp/../../generic/etc_cust/sqwgen_GlobalVar.cfg
fi

# For not normed environnement
if [ -r $HOME/sqwConfig/sqwgen_GlobalVar.cfg ]
then
	if [ "$gvsqw_Debug" != "" ]
	then
		echo $gvsqw_EchoOpt "sourcing cfg file : $HOME/sqwConfig/sqwgen_GlobalVar.cfg"
	fi
	. $HOME/sqwConfig/sqwgen_GlobalVar.cfg
fi

if [ "$gvsqw_RdbmsType" != "generic" ]
then
	# Source rdbms global
	if [ -r $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg"
		fi
		. $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg
	elif  [ -r $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg"
		fi
		. $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg
	fi
	# Source rdbms custom
	if [ -r $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg"
		fi
		. $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg
	elif  [ -r $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg"
		fi
		. $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg
	fi
	# For not normed environnement
	if [ -r $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg"
		fi
		. $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg
	fi
fi


Variables explanation: 

#General variables
gvsqw_InstanceNameForceCase => Force a case for instance name parameter, put UpperCase or LowerCase or NoCase
gvsqw_SqwVersion => SQWare Production version
gvsqw_ConnectDb => if connection to db evalable then Enable else Disable
gvsqw_Hostname => Hostname for prompt and trace
gvsqw_GlobalMsgMail => Begining of email subject
gvsqw_GlobalMail => email adress, put NoNail in gvsqw_GlobalMail if you don't want to send mail on error
gvsqw_SendmailHtmlFormat => Html format for email, put disable in gvsqw_SendmailHtmlFormat if you don't want to send mail in html format
gvsqw_PreFormatHtlml => enable if file is already formated
gvsqw_Colors => enable, put disable in gvsqw_Colors if you don't want to print in color
gvsqw_TraceJobDb => enable, put disable in gvsqw_TraceJobDb if you don't want to trace job execution in SQWareRepository
gvsqw_EgrepIvFs => for 'egrep -v' on 'df' command
gvsqw_SuppLogsHisto => number of days to delete log files
gvsqw_GzipLogsHisto => number of days to compress log files
gvsqw_SuppArchAlert => number of days to delete archives of alert files
gvsqw_SuppBckCfg => number of days to delete archives of init and control files
gvsqw_RootAdmin => admin directory
gvsqw_RootCfg => configuration directory
gvsqw_RootDbf => datafiles directory
gvsqw_NbThread => default number of thread for parallelism
gvsqw_SshOptions => ssh default options
gvsqw_ScpOptions => scp default options
gvsqw_MailSender => to force the sender of the mail
gvsqw_MailSubjetForceCase => Force a case for mail subject, put UpperCase or LowerCase or NoCase, to avoid quarantine (like rule ODD_CASE of spamassassin)
gvsqw_RunJobFullOutput => for full display log in sqw*_RunJob.ksh scripts

#Html tags
gvsqw_CHtmlError => font tag for error
gvsqw_CHtmlOk => font tag for OK
gvsqw_CHtmlInfo => font tag for info
gvsqw_CHtmlEnd => end font tag
gvsqw_THtmlBegin => table tag
gvsqw_THtmlEnd => end table tag
gvsqw_THtmlThBegin => th tag
gvsqw_THtmlThEnd => end th tag
gvsqw_THtmlThInter => inter th tag
gvsqw_THtmlTdBegin1 => td tag sqwnc
gvsqw_THtmlTdBegin2 => td tag sqwc_
gvsqw_THtmlTdEnd => end td tag
gvsqw_THtmlTdInter => inter td tag
gvsqw_THtmlPre => tag for pre formated text
gvsqw_THtmlPreEnd => end tag for pre formated text
gvsqw_HtmlCss => CSS style

#for SQWare Web
gvsqw_WebDbaURL => SQWareWeb URL
gvsqw_WebDbaUser => Connection string ssh user@hostname to SQWareWeb
gvsqw_WebDbaDirAwr => Directory to store AWR reports on SQWareWeb
Note:
You can overload variables contain in $gvsqw_GenBin/../etc/sqwgen_GlobalVar.cfg

by the same variables in $gvsqw_GenBin/../etc_cust/sqwgen_GlobalVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwgen_GlobalVar.cfg specifically for this user.


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:generic:etc:sqwgen_GlobalVar.cfg&oldid=25533"