SQWareProduction:generic:etc:sqwgen DbRefVar.cfg

From Wiki_dbSQWare
Jump to: navigation, search

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:


Nuvola apps information.png
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.