[Syscheck-users] SF.net SVN: syscheck:[7864] trunk/syscheck

[<ki...@us...>]

Revision: 7864
          http://syscheck.svn.sourceforge.net/syscheck/?rev=7864&view=rev
Author:   kinneh
Date:     2009-10-31 20:57:12 +0000 (Sat, 31 Oct 2009)

Log Message:
-----------
#15 new script to create db user at localhost only

Added Paths:
-----------
    trunk/syscheck/config/815.conf
    trunk/syscheck/config/815.english
    trunk/syscheck/database-replication/815-create-mysql-ejbca-user-db-user-localhost-only.sh

Added: trunk/syscheck/config/815.english
===================================================================
--- trunk/syscheck/config/815.english	                        (rev 0)
+++ trunk/syscheck/config/815.english	2009-10-31 20:57:12 UTC (rev 7864)
@@ -0,0 +1,10 @@
+HELP="grants access to the ejbca user from localhost only"
+
+LEVEL_1=$INFO
+DESCR_1="access rules inserted into mysql db ok"
+HELP_1="no action is needed"
+
+LEVEL_2=$INFO
+DESCR_2="failed to insert access rules into mysql db"
+HELP_2="run the script with sh -x $0 -s to find out more info"
+

Added: trunk/syscheck/database-replication/815-create-mysql-ejbca-user-db-user-localhost-only.sh
===================================================================
--- trunk/syscheck/database-replication/815-create-mysql-ejbca-user-db-user-localhost-only.sh	                        (rev 0)
+++ trunk/syscheck/database-replication/815-create-mysql-ejbca-user-db-user-localhost-only.sh	2009-10-31 20:57:12 UTC (rev 7864)
@@ -0,0 +1,52 @@
+#!/bin/sh
+
+#Scripts that creates replication privilegdes for the slave db to the master.
+
+# Set default home if not already set.
+SYSCHECK_HOME=${SYSCHECK_HOME:-"/usr/local/syscheck"}
+
+## Import common definitions ##
+. $SYSCHECK_HOME/resources.sh
+
+SCRIPTID=815
+getlangfiles $SCRIPTID || exit 1;
+getconfig $SCRIPTID || exit 1;
+
+ERRNO_1="${SCRIPTID}1"
+ERRNO_2="${SCRIPTID}2"
+
+schelp () {
+        echo "$HELP"
+        echo "$ERRNO_1/$DESCR_1 - $HELP_1"
+        echo "$ERRNO_2/$DESCR_2 - $HELP_2"
+        echo "${SCREEN_HELP}"
+        exit
+}
+
+
+PRINTTOSCREEN=1
+
+if [ "x$1" = "x-h" -o "x$1" = "x--help" ] ; then
+        schelp
+elif [ "x$1" = "x-s" -o  "x$1" = "x--screen" -o \
+    "x$2" = "x-s" -o  "x$2" = "x--screen"   ] ; then
+        PRINTTOSCREEN=1
+fi
+
+
+OUTFILE="$CLUSTERSCRIPT_HOME/tmp_create-ejbca-mysql-user.sql"
+
+echo "GRANT ALL ON ejbca.* to '$DB_USER'@'localhost' IDENTIFIED BY '${DB_PASSWORD}';" > $OUTFILE
+echo "select * from user where user like '%${DB_USER}%'" >> $OUTFILE
+
+echo "Will now insert these sql:"
+cat $OUTFILE
+
+$MYSQL_BIN mysql -u root --password="$MYSQLROOT_PASSWORD" <  $OUTFILE
+if [ $? -eq 0 ] ; then
+        printlogmess $LEVEL_1 $ERRNO_1 "$DESCR_1"
+else
+        printlogmess $LEVEL_2 $ERRNO_2 "$DESCR_2"
+fi
+
+rm $OUTFILE


Property changes on: trunk/syscheck/database-replication/815-create-mysql-ejbca-user-db-user-localhost-only.sh
___________________________________________________________________
Added: svn:executable
   + *


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.