MONITOR/alistoragemanager/setupStorageDatabase.sh

   1 #!/bin/bash
   2 HOST="localhost"   # IP of machine on which mysql database is located
   3 PORT="123"
   4 DATABASE="database"
   5 USER="user"
   6 PASS="pass123"
   7 TABLE="table"
   8 STORAGE_PATH="/some/path/"
   9 MAX_SIZE="300000000"
  10 MAX_OCCUPATION="100"
  11 REMOVE_PERCENT="50"
  12 EVENTS_IN_FILE="20"
  13 EVENT_SERVER="localhost"   # IP of machine running alieventserver
  14 EVENT_SERVER_USER="user"
  15 EVENT_SERVER_PORT="124"
  16 STORAGE_SERVER="localhost"      # IP of machine running alistorage
  17 STORAGE_SERVER_USER="user"
  18 STORAGE_SERVER_PORT="125"      # server thread communication port
  19 STORAGE_CLIENT_PORT="126"      # client thread communication port
  20 XML_SERVER_PORT="127"          # server of xml files
  21 mysql -u root -ppassword -e "create database if not exists $DATABASE;"
  22 mysql -u root -ppassword -e "grant ALL PRIVILEGES on $DATABASE.* to '$USER'@'$HOST' identified by '$PASS';"
  23 mysql -u root -ppassword -e "use $DATABASE;"
  24 mysql -u root -ppassword -e "CREATE TABLE IF NOT EXISTS $DATABASE.$TABLE(\
  25 run_number int(6) NOT NULL,\
  26 event_number int(6) NOT NULL,\
  27 system text(7) DEFAULT NULL,\
  28 multiplicity int(5) DEFAULT NULL,\
  29 permanent tinyint(1) DEFAULT NULL,\
  30 file_path text(100) DEFAULT NULL,\
  31 PRIMARY KEY(run_number,event_number));"
  32
  33 echo "-----------------------------"
  34 echo "Databases successfuly created"
  35 echo "-----------------------------"