Initial import

1 files changed, 40 insertions, 0 deletions

diff --git a/setdb.sh b/setdb.sh
new file mode 100755
index 000000000000..69eaaa38b6b1
--- /dev/null
+++ b/setdb.sh
@@ -0,0 +1,40 @@
+
+setup() {
+  #ln -s /usr/share/webapps/esniper /srv/http/
+
+  # enable extension=pdo_mysql.so in file /etc/php/php.ini
+  # systemctl restart php-fpm
+
+  DBNAME=root
+  DBUSER=root
+  DBPASS=root
+
+  printf "Input Database(MySQL) Username:"
+  read tmp
+  if test -n "$tmp"; then
+    DBUSER="$tmp"
+  fi
+  printf "Input Database(MySQL) Password:"
+  read tmp
+  if test -n "$tmp"; then
+    DBPASS="$tmp"
+  fi
+  DBNAME="${DBUSER}"
+
+  sed -i "s/\"EZSQL_DB_NAME\", \"snyp\"/\"EZSQL_DB_NAME\", \"$DBNAME\"/g" /usr/share/webapps/esniper/config.inc.php
+  sed -i "s/\"EZSQL_DB_USER\", \"snyp\"/\"EZSQL_DB_USER\", \"$DBUSER\"/g" /usr/share/webapps/esniper/config.inc.php
+  sed -i "s/\"EZSQL_DB_PASSWORD\", \"snyp\"/\"EZSQL_DB_PASSWORD\", \"$DBPASS\"/g" /usr/share/webapps/esniper/config.inc.php
+
+  chmod 700 /usr/share/webapps/esniper/config.inc.php
+  chown http:http /usr/share/webapps/esniper/config.inc.php
+
+
+  cp /usr/share/webapps/esniper/install/esniper.sql /tmp/tmp-esniper-db.sql
+  sed -e "s|# phpMyAdmin SQL Dump|CREATE DATABASE IF NOT EXISTS ${DBNAME};\nuse ${DBNAME};\n|g" \
+      -i /tmp/tmp-esniper-db.sql
+
+  mysql -h localhost -u$DBUSER -p$DBPASS < /tmp/tmp-esniper-db.sql
+}
+
+setup
+