Difference between revisions of "SQWareProduction:mysql:etc:.profile"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(8 intermediate revisions by the same user not shown)
Line 6: Line 6:
 
#!/bin/ksh
 
#!/bin/ksh
 
###################################################################
 
###################################################################
−
# SQWareProduction for Mysql module of dbSQWare is developped with GPL License 3.0 :
+
# SQWareProduction for Mysql module of dbSQWare
−
#
 
−
# 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,
 
# dbSQWare is distributed in the hope that it will be useful,
 
# but WITHOUT ANY WARRANTY; without even the implied warranty of
 
# but WITHOUT ANY WARRANTY; without even the implied warranty of
 
# MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE.  See the
 
# MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE.  See the
−
# GNU General Public License for more details.
+
# CGU/CGA for more details.
 
#  
 
#  
−
# You should have received a copy of the GNU General Public License
+
# You should have received a copy of the CGU/CGA
−
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
 
#  
 
#  
 
# For information : contact@dbsqware.com or www.dbsqware.com
 
# For information : contact@dbsqware.com or www.dbsqware.com
 
###################################################################
 
###################################################################
 
## @Synopsis template .profile for unix users Mysql
 
## @Synopsis template .profile for unix users Mysql
−
## @Copyright Copyright 2010-2016, OctopusDBA (www.octopusdba.com)
+
## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com)
−
## @License GPL v3
 
−
## @Contributor : Pierre-Jean Catez
 
  
 +
export LANG='en_US.UTF-8'
 +
 +
export MYSQL_SID=MYS_XXXX_YYY
 +
 +
#dbSQWare
 +
export gvsqw_Env='PRD'
 
export gvsqw_MysBin=$HOME/SQWareProduction/mysql/bin
 
export gvsqw_MysBin=$HOME/SQWareProduction/mysql/bin
−
export MYSQL_SID=MYS_XXXX_YYY
+
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
−
export MYSQL_HOME=$HOME/uct/5.1.40
+
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MysBin/../etc/.profile_confort ]
−
export MEM_HOME=$HOME/uct/mysqlmonitoragent-2.1.0.1093
+
then
−
export PATH=$MYSQL_HOME/bin:/usr/sbin:$PATH
+
. $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
 
#dbSQWare
−
export gvsqw_Env=''
+
export gvsqw_Env='PRD'
 +
export gvsqw_MysBin=$HOME/SQWareProduction/mysql/bin
 
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
 
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
 
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MysBin/../etc/.profile_confort ]
 
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MysBin/../etc/.profile_confort ]
 
then
 
then
−
  . $gvsqw_MysBin/../etc/.profile_confort
+
. $gvsqw_MysBin/../etc/.profile_confort
 
fi
 
fi
 
</pre>
 
</pre>
 
<br>
 
<br>

Latest revision as of 21:19, 25 February 2024

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-2024, 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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mysql:etc:.profile&oldid=26098"