SQWareProduction:generic:etc:sqwgen DbRefVar.cfg

From Wiki_dbSQWare
Revision as of 15:53, 8 March 2017 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_DbRefVar.cfg:
Global var for SQWareRepository connexion
It contains the operating variables of SQWareProduction.

File content:

#!/bin/ksh
###################################################################
# SQWareProduction for Mysql 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	Global var for SQWareRepository connexion
## @Copyright	Copyright 2010-2014, OctopusDBA (www.octopusdba.com)
## @License	GPL v3

if [ "$gvsqw_Debug" != "" ]
then
	echo "sourcing cfg file : .../SQWareProduction/generic/etc/sqwgen_DbRefVar.cfg"
fi
export gvsqw_DbRefPort='3306'
export gvsqw_DbRefHost='SQWareRepositoryHost'
export gvsqw_DbRefDatabase='dbsqware_db'
export gvsqw_DbRefUser='dbsqware_user'
export gvsqw_DbRefPass='OctopusDBA_dbSQWare123'

# ssh connection to bounce server for indicators (for MySQL inserts)
# export gvsqw_BounceServerUserConn='mysql_user@BounceServer'

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

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

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


Variables explanation:


Note:
You can overload variables contain in $gvsqw_GenBin/../etc/sqwgen_DbRefVar.cfg

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