Template:SQWareProduction sqwgen GlobalVar.cfg content

From Wiki_dbSQWare
Revision as of 11:04, 20 July 2014 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.


File content: 

#!/bin/ksh
###################################################################
# SQWareProduction Generic module of dbSQWare is developped with GPL License 3.0 :
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
# 
# 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
# GNU General Public License for more details.
# 
# You should have received a copy of the GNU General Public License
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	Generic global var
## @Copyright	Copyright 2010-2014, OctopusDBA (www.octopusdba.com)
## @License	GPL v3

if [ "$gvsqw_Debug" != "" ]
then
	echo "RdbmsName    = $gvsqw_RdbmsName"
	echo "RdbmsType    = $gvsqw_RdbmsType"
	echo "RdbmsTrigram = $gvsqw_RdbmsTrigram"
	echo "RdbmsRoot    = $gvsqw_RdbmsRoot"
	echo "sourcing cfg file : .../SQWareProduction/generic/etc/sqwgen_GlobalVar.cfg"
fi
#global
export gvsqw_SqwVersion=3.0.03
#Force a case for instance name parameter, put UpperCase or LowerCase or NoCase
export gvsqw_InstanceNameForceCase='UpperCase'
export gvsqw_DistPasswdFile="$HOME/.passwd_$gvsqw_RdbmsType"
export gvsqw_GlobalMsgMail="Trt${gvsqw_RdbmsTrigram}Auto${gvsqw_Env}"
export gvsqw_UserExec=`id| cut -d')' -f1| cut -d'(' -f2`
export gvsqw_ConnectDb=Enable
export gvsqw_Hostname=$(hostname|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_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_EgrepIvFs='Filesystem|Disponible'
export gvsqw_SuppLogsHisto=30
export gvsqw_GzipLogsHisto=7
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 |Couldn.t execute |unknown option | doesn.t exist"
export gvsqw_SshOptions="-q -o BatchMode=yes -o StrictHostKeyChecking=no"
export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no"

#Html tags
##<td style="white-space:nowrap; width:237px; vertical-align:top;">
##<div class="example" style="word-wrap: normal;">
export gvsqw_CHtmlH1='<h1 style="font-size:18px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:#0000FF; background-color:white; border-bottom:1px solid #cccc99;">'
export gvsqw_CHtmlH2='<h2 style="font-size:16px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; background-color:white; text-decoration:underline;">'
export gvsqw_CHtmlH3='<h3 style="font-size:14px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; background-color:white; text-decoration:underline;">'
export gvsqw_CHtmlError='<font color="#FF0000">'
export gvsqw_CHtmlOk='<font color="#00FF00">'
export gvsqw_CHtmlInfo='<font color="#0000FF">'
export gvsqw_CHtmlEnd='</font>'
#export gvsqw_THtmlBegin='<table width="100%" cellspacing="3px" cellpadding="3px;" rules="all" style="font-size:12px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; border:solid 1px black;">'
export gvsqw_THtmlBegin='<table cellspacing="3px" cellpadding="3px;" rules="all" style="font-size:12px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; border:solid 1px black;">'
export gvsqw_THtmlEnd='</table>'
export gvsqw_THtmlThBegin='<tr style="font-weight:bold; background-color:#C0C0C0; text-align:left; white-space:nowrap; "><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; ">'
export gvsqw_THtmlTdBegin2='<tr style="background-color:#eee; vertical-align:top;"><td style="white-space:nowrap; ">'
export gvsqw_THtmlTdEnd='</td></tr>'
export gvsqw_THtmlTdInter='</td><td style="white-space:nowrap; ">'
export gvsqw_THtmlTdInterRight='</td><td style="text-align:right; white-space:nowrap; ">'
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:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; background-color:white;">'
export gvsqw_THtmlPreEnd="/pre>"
#export gvsqw_THtmlABegin='<a style="color:black;" onmouseover="this.style.color = '"'red'"'" onmouseout="this.style.color = '"'black'"'"'
export gvsqw_THtmlABegin='<a style="color:black;"'
export gvsqw_HtmlCss='<html><body style="font-size:12px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; background-color:white;">'

##MySQL option for insert indicators
export gvsqw_SizeMinTableIndicators=1
export gvsqw_MySqlInsertOption=''
export gvsqw_MySqlCnfFile='$gvsqw_GenPath/../../generic/etc_cust/.my_SQWareRepository.cnf'
export gvsqw_MySQLExe=''
##Example to prevent "mysql: Unknown OS character set 'ISO8859-15'. mysql: Switching to the default character set 'latin1'."
##export gvsqw_MySqlInsertOption='--default-character-set=latin1'
# ssh connection to bounce server for indicators (for MySQL inserts)
# export gvsqw_BounceServerUserConn='mysql_user@BounceServer'

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

#for webdba
export gvsqw_WebDbaURL="http://webdba"
#export gvsqw_WebDbaUserConn='dbsqware@SQWareWebHost'

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

# 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 "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 "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 "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 "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 "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 "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 "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 "sourcing cfg file : $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg"
		fi
		. $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg
	fi
fi
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwgen_GlobalVar.cfg_content&oldid=5740"