SQWareProduction:mysql:etc:.profile: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
File content: | File content: | ||
<pre> | <pre> | ||
#!/bin/ | #!/bin/bash | ||
################################################################### | ################################################################### | ||
# SQWareProduction for Mysql module of dbSQWare | # SQWareProduction for Mysql module of dbSQWare | ||
# | # | ||
# 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 | ||
# | # CGU/CGA for more details. | ||
# | # | ||
# You should have received a copy of the | # You should have received a copy of the CGU/CGA | ||
# along with this program. If not, see <http://www. | # 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 | ## @Copyright Copyright 2007-2025, 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 | 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 ] | |||
export | then | ||
export 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 | |||
fi | fi | ||
</pre> | </pre> | ||
<br> | <br> | ||
Latest revision as of 16:02, 23 February 2025
Sample file for .profile $gvsqw_MysBin/../etc/.profile:
Sample of lines to add to .profile of mysql users.
File content:
#!/bin/bash
###################################################################
# 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 2007-2025, 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