From 7efc3525cf22580de3207e5faf910c501f69c2e6 Mon Sep 17 00:00:00 2001
From: prabatuty <prabatuty>
Date: Sat, 10 Oct 2009 14:22:51 +0000
Subject: [PATCH] adding start/stop scripts

---
 csqlinstall.ksh     |  4 ++++
 csqlinstallmmdb.ksh |  3 +++
 scripts/shutdown.sh | 60 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 scripts/startup.sh  | 15 ++++++++++++++
 4 files changed, 82 insertions(+)
 create mode 100755 scripts/shutdown.sh
 create mode 100755 scripts/startup.sh

diff --git a/csqlinstall.ksh b/csqlinstall.ksh
index e62ed008..148ca8d4 100755
--- a/csqlinstall.ksh
+++ b/csqlinstall.ksh
@@ -42,5 +42,9 @@ find ${install_dir}/demo -name "CVS" -exec rm -rf {} \; 2>/dev/null
 
 cp -R ${root_dir}/docs ${install_dir}
 find ${install_dir}/docs -name "CVS" -exec rm -rf {} \; 2>/dev/null
+
+cp -R ${root_dir}/scripts ${install_dir}
+find ${install_dir}/scripts -name "CVS" -exec rm -rf {} \; 2>/dev/null
+
 cd ${root_dir}
 echo "Build completed Successfully"
diff --git a/csqlinstallmmdb.ksh b/csqlinstallmmdb.ksh
index 6127e1a1..654d6819 100755
--- a/csqlinstallmmdb.ksh
+++ b/csqlinstallmmdb.ksh
@@ -41,5 +41,8 @@ rm -rf ${install_dir}/demo
 mkdir ${install_dir}/demo
 cp -R ${root_dir}/demo/wisc ${install_dir}/demo
 find ${install_dir}/demo -name "CVS" -exec rm -rf {} \; 2>/dev/null
+cp -R ${root_dir}/scripts ${install_dir}
+find ${install_dir}/scripts -name "CVS" -exec rm -rf {} \; 2>/dev/null
+
 cd ${root_dir}
 echo "Build completed Successfully"
diff --git a/scripts/shutdown.sh b/scripts/shutdown.sh
new file mode 100755
index 00000000..f9827c68
--- /dev/null
+++ b/scripts/shutdown.sh
@@ -0,0 +1,60 @@
+#!/bin/sh
+# Stop CSQL Server
+AWK=awk
+FORCE=$1
+LOGFILE=`grep LOG_FILE $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
+LOGDIR=`dirname $LOGFILE`
+
+echo "CSQL Server Stopped: " + `date` >>$LOGDIR/csqlserver.log
+while true
+do
+   SQLPID=`ps -e | grep csqlsqlserver |tail -1| awk -F" " '{ print $1 }'`
+   if [ "$SQLPID" != "" ]
+   then
+       kill -2 $SQLPID
+       sleep 1
+   else break;
+   fi
+done
+REPLPID=`ps -e | grep csqlreplserver |tail -1| awk -F" " '{ print $1 }'`
+if [ "$REPLPID" != "" ]
+then
+    kill -2 $REPLPID
+fi
+CACHEPID=`ps -e | grep csqlcacheserver |tail -1| awk -F" " '{ print $1 }'`
+if [ "$CACHEPID" != "" ]
+then
+    kill -2 $CACHEPID
+fi
+CSQLPID=`ps -e | grep csqlserver |tail -1| awk -F" " '{ print $1 }'`
+if [ "$CSQLPID" == "" ]
+then
+    echo "returning early"
+    return;
+fi
+kill -2 $CSQLPID
+CSQLPID=`ps -e | grep csqlserver |tail -1| awk -F" " '{ print $1 }'`
+if [ "$CSQLPID" == "" ]
+then
+    FORCE=
+fi
+
+if [ -z "$FORCE" ]
+then
+   echo "stop server without force"
+else
+   echo "stop server with force"
+   kill -9 $CSQLPID
+   KEY=`grep SYS_DB_KEY $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
+   echo removing key $KEY
+   ipcrm -M $KEY
+   KEY=`grep USER_DB_KEY $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
+   echo removing key $KEY
+   ipcrm -M $KEY
+   KEY=`grep ID_SHM_KEY $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
+   echo removing key $KEY
+   ipcrm -M $KEY
+   KEY=`grep MSG_KEY $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
+   echo removing message queue key $KEY
+   ipcrm -Q $KEY
+fi
diff --git a/scripts/startup.sh b/scripts/startup.sh
new file mode 100755
index 00000000..01243227
--- /dev/null
+++ b/scripts/startup.sh
@@ -0,0 +1,15 @@
+#!/bin/sh
+# Start CSQL Server
+VERBOSE=$1
+LOGDIR=/tmp
+echo "CSQL Server Start: " + `date` >>$LOGDIR/csqlserver.log
+if [ -z "$VERBOSE" ]
+then
+echo "Starting csqlserver without verbose"
+nohup $CSQL_INSTALL_ROOT/bin/csqlserver >>$LOGDIR/csqlserver.log 2>>$LOGDIR/csqlserver.log &
+sleep 2
+else
+echo "Start csqlserver with verbose"
+$CSQL_INSTALL_ROOT/bin/csqlserver
+fi
+
-- 
2.11.4.GIT