SQWareProduction:mysql:etc:.profile: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| (3 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 | ||
| Line 19: | Line 19: | ||
################################################################### | ################################################################### | ||
## @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 LANG='en_US.UTF-8' | ||
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