/[PAMELA software]/YodaProfiler/docs/install_DB.sh
ViewVC logotype

Diff of /YodaProfiler/docs/install_DB.sh

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by mocchiut, Tue Oct 17 15:19:50 2006 UTC revision 1.6 by mocchiut, Thu Sep 6 07:39:13 2007 UTC
# Line 3  THISDIR=`pwd` Line 3  THISDIR=`pwd`
3  USERNAME=${PAM_DBUSER}  USERNAME=${PAM_DBUSER}
4  HOST=""  HOST=""
5  DBNAME=""  DBNAME=""
6  COUNT=0;for word in `echo ${PAM_DBHOST} | tr [\/] [" "] |sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done  FORCE="no"
7    GPAMELA="no"
8    COUNT=0;for word in `echo ${PAM_DBHOST} | tr [\/] [" "] |tr [?] [" "] |sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done
9  PASSWORD=${PAM_DBPSW}  PASSWORD=${PAM_DBPSW}
10  if [ $# -gt 0 ]; then  if [ $# -gt 0 ]; then
11      for INPUT in $*; do      for INPUT in $*; do
# Line 19  if [ $# -gt 0 ]; then Line 21  if [ $# -gt 0 ]; then
21              echo ""              echo ""
22              echo " --psw=password :  MySQL password"              echo " --psw=password :  MySQL password"
23              echo ""              echo ""
24                echo " --force :  do not wait [default: wait]"
25                echo ""
26              exit 0              exit 0
27          fi          fi
28          TEST=`echo $INPUT | sed 's/--user=//g'`          TEST=`echo $INPUT | sed 's/--user=//g'`
# Line 28  if [ $# -gt 0 ]; then Line 32  if [ $# -gt 0 ]; then
32          fi          fi
33          TEST=`echo $INPUT | sed 's/--host=//g'`          TEST=`echo $INPUT | sed 's/--host=//g'`
34          if [ $TEST != $INPUT  ]; then          if [ $TEST != $INPUT  ]; then
35              COUNT=0;for word in `echo $TEST | tr [\/] [" "] |sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done              COUNT=0;for word in `echo $TEST | tr [\/] [" "] | tr [?] [" "] | sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done
36              export DBNAME;              export DBNAME;
37              export HOST;              export HOST;
38          fi          fi
# Line 37  if [ $# -gt 0 ]; then Line 41  if [ $# -gt 0 ]; then
41              PASSWORD=`echo $TEST`              PASSWORD=`echo $TEST`
42              export PASSWORD;              export PASSWORD;
43          fi          fi
44            if [ "$INPUT" == "--force" ]; then
45                FORCE="yes";
46                export FORCE;
47            fi
48            if [ "$INPUT" == "--gpamela" ]; then
49                GPAMELA="yes";
50                export GPAMELA;
51            fi
52      done      done
53  else  else
54      if [ "$USERNAME" == "" ] || [ "$HOST" == "" ] || [ "$DBNAME" == "" ]; then      if [ "$USERNAME" == "" ] || [ "$HOST" == "" ] || [ "$DBNAME" == "" ]; then
55          echo ""          echo ""
56          echo " Usage: ./install_GL_PARAM.sh [options] "          echo " Usage: ./install_DB.sh [options] "
57          echo ""          echo ""
58          echo " Options: "          echo " Options: "
59          echo ""          echo ""
# Line 57  fi; Line 69  fi;
69  echo ""  echo ""
70  echo " Installing DB $DBNAME on $HOST with user $USERNAME and password $PASSWORD  "  echo " Installing DB $DBNAME on $HOST with user $USERNAME and password $PASSWORD  "
71  echo ""  echo ""
72  echo " WARNING: if already existing the DB will be RECREATED and you will LOSE all data! "  if [ "$FORCE" == "no" ]; then
73  echo ""      echo " WARNING: if already existing the DB will be RECREATED and you will LOSE all data! "
74  echo "    =======>   You have 30 seconds to stop me using CTRL+c  <=======    "      echo ""
75  echo ""      echo "    =======>   You have 30 seconds to stop me using CTRL+c  <=======    "
76  sleep 30;      echo ""
77        sleep 30;
78    fi;
79  #  #
80  rm -rf ${THISDIR}/temp.sql  rm -rf ${THISDIR}/temp.sql
81  #  #
82  cat ${THISDIR}/PAMELAProductionDB.sql | sed 's/dbname/'${DBNAME}'/g' >> ${THISDIR}/temp.sql  cat ${THISDIR}/PAMELAProductionDB.sql | sed 's/dbname/'${DBNAME}'/g' >> ${THISDIR}/temp.sql
83  mysql --user=$USERNAME --password=$PASSWORD --host=$HOST < ${THISDIR}/temp.sql  mysql --user=$USERNAME --password=$PASSWORD --host=$HOST < ${THISDIR}/temp.sql
84  echo " done! "  echo " done! "
85    #
86    #
87    #
88    if [ "$GPAMELA" == "yes" ]; then
89        echo ""
90        echo " Adapting GL_PARAM table to be used with simulated data "
91        echo ""
92    #
93        rm -rf ${THISDIR}/temp.sql
94    #
95        cat ${THISDIR}/GP_PARAM.sql | sed 's/dbname/'${DBNAME}'/g' >> ${THISDIR}/temp.sql
96        mysql --user=$USERNAME --password=$PASSWORD --host=$HOST < ${THISDIR}/temp.sql
97    #
98        echo " done! "
99    fi;
100    #
101  echo ""  echo ""
102  rm -rf ${THISDIR}/temp.sql  rm -rf ${THISDIR}/temp.sql
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.6
  ViewVC Help
Powered by ViewVC 1.1.23