SQWareProduction:mysql:etc:.profile

From Wiki_dbSQWare
Revision as of 19:04, 30 January 2022 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.

Sample file for .profile $gvsqw_MysBin/../etc/.profile:
Sample of lines to add to .profile of mysql users.

File content:

#!/bin/ksh
###################################################################
# SQWareProduction for Mysql 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	template .profile for unix users Mysql
## @Copyright	Copyright 2010-2022, dbSQWare (www.dbsqware.com)

export LANG='en_US.UTF-8'

export MYSQL_SID=MYS_XXXX_YYY

#dbSQWare
export gvsqw_Env='PRD'
export gvsqw_MysBin=$HOME/SQWareProduction/mysql/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MysBin/../etc/.profile_confort ]
then
	. $gvsqw_MysBin/../etc/.profile_confort
fi

###################################################################
###################################################################
## Multi instance

export PATH='/cygdrive/d/Program Files/MariaDB 10.3/bin':$PATH
export LD_LIBRARY_PATH='/cygdrive/d/Program Files/MariaDB 10.3/lib':$LD_LIBRARY_PATH
export LANG='en_US.UTF-8'

lvsqw_Instance=$1
case $lvsqw_Instance in
MAR_W103_PRD)
	export MYSQL_SID=$lvsqw_Instance
    export PATH='/cygdrive/d/Program Files/MariaDB 10.3/bin':$PATH
    export LD_LIBRARY_PATH='/cygdrive/d/Program Files/MariaDB 10.3/lib':$LD_LIBRARY_PATH
    export MYSQL_PORT=3306
    ;;
MAR_W104_PRD)
	export MYSQL_SID=$lvsqw_Instance
    export PATH='/cygdrive/d/Program Files/MariaDB 10.4/bin':$PATH
    export LD_LIBRARY_PATH='/cygdrive/d/Program Files/MariaDB 10.4/lib':$LD_LIBRARY_PATH
    export MYSQL_PORT=3307
    ;;
*)
    export MYSQL_SID="NoSID"
    export MYSQL_PORT=3300
    ;;
esac

#dbSQWare
export gvsqw_Env='PRD'
export gvsqw_MysBin=$HOME/SQWareProduction/mysql/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MysBin/../etc/.profile_confort ]
then
	. $gvsqw_MysBin/../etc/.profile_confort
fi