--- DarthVader/docs/install_GL_PARAM.sh	2006/09/06 15:20:21	1.1
+++ DarthVader/docs/install_GL_PARAM.sh	2006/09/07 08:50:38	1.2
@@ -1,10 +1,11 @@
 #!/bin/bash --norc 
 THISDIR=`pwd`
-USERNAME=""
+USERNAME=${PAM_DBUSER}
 HOST=""
 DBNAME=""
-PASSWORD=""
-if [ $# -gt 0 ] && [ $# -le 4 ]; then
+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
+PASSWORD=${PAM_DBPSW}
+if [ $# -gt 0 ]; then
     I=1
     while [ $I -le $# ]; do
 	if [ $I -eq 1 ]; then 
@@ -52,19 +53,27 @@
 	let I=$I+1
     done
 else
-    echo ""
-    echo " Usage: ./install_GL_PARAM.sh [options] "
-    echo ""
-    echo " Options: "
-    echo ""
-    echo " --user=username : MySQL username. "
-    echo ""
-    echo " --host=mysql://localhost/pamelaprod : MySQL host and DB name."
-    echo ""
-    echo " --psw=password :  MySQL password"
-    echo ""    
-    exit 0
+    if [ "$USERNAME" == "" ] || [ "$HOST" == "" ] || [ "$DBNAME" == "" ]; then
+	echo ""
+	echo " Usage: ./install_GL_PARAM.sh [options] "
+	echo ""
+	echo " Options: "
+	echo ""
+	echo " --user=username : MySQL username. "
+	echo ""
+	echo " --host=mysql://localhost/pamelaprod : MySQL host and DB name."
+	echo ""
+	echo " --psw=password :  MySQL password"
+	echo ""    
+	exit 0
+    fi
 fi;
+echo ""
+echo " Updating GL_PARAM table on DB $DBNAME, $HOST with user $USERNAME and password $PASSWORD "
+echo "               (you have 30 seconds to stop me using CTRL+c)       "
+echo ""
+sleep 30;
+echo " Updating GL_PARAM table"
 #
 rm -rf ${THISDIR}/temp.sql
 PAM_CALIB2=$(echo $PAM_CALIB | sed 's/\//\\\//g')
@@ -75,6 +84,7 @@
 cat ${THISDIR}/install_GL_PARAM.sql | sed 's/fullpathgoesere/'${PAM_CALIB2}'/g' >> ${THISDIR}/temp.sql
 mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql 
 #
+echo " done! "
 echo ""
 echo "GL_PARAM TABLE NOW CONTAINS:"
 echo ""