diff options
author | M.Gergo | 2019-03-08 20:50:48 +0100 |
---|---|---|
committer | M.Gergo | 2019-03-08 20:50:48 +0100 |
commit | 3dab26c6797b32926287f22a041380080551060b (patch) | |
tree | bb4ba41398083a054e956e25f2d8c72bcdd0a7a0 /mayor-installer-mod/install.d/35createdatabases.sh | |
parent | f70027ffbedce10f412868a7bf9b0b67b113f1b1 (diff) | |
download | mayor-3dab26c6797b32926287f22a041380080551060b.tar.gz mayor-3dab26c6797b32926287f22a041380080551060b.zip |
pici rendrakás
Diffstat (limited to 'mayor-installer-mod/install.d/35createdatabases.sh')
-rwxr-xr-x | mayor-installer-mod/install.d/35createdatabases.sh | 132 |
1 files changed, 0 insertions, 132 deletions
diff --git a/mayor-installer-mod/install.d/35createdatabases.sh b/mayor-installer-mod/install.d/35createdatabases.sh deleted file mode 100755 index 718ca3c2..00000000 --- a/mayor-installer-mod/install.d/35createdatabases.sh +++ /dev/null @@ -1,132 +0,0 @@ -#!/bin/bash -# - -cat <<EOF -Adatbázisok létrehozása - -A felhasználói azonosítók és csoportok adatainak tárolásához, a -munkamenetek adminisztrálásához és a napló modul adatainak tárolásához -szükséges adatbázisok létrehozása következik. - -Ez a lépés csak a szükséges konfigurációs állományok megléte -esetén fut le helyesen! - -A telepítő először elkészíti a betöltendő SQL utasításokat tartalmazó -állományokat a $TMPDIR/mysql alá, majd - amennyiben engedélyezzük - -be is tölti az állományokat. - -EOF - -read -n 1 -p "A konfigurációs állományok alapján létrehozhatom az adatbázisokat? (i/N)" -s DO -if [ "$DO" != "i" ]; then echo -e "\nAz adatbázisok létrehozását kihagyjuk.\n"; exit 1; fi - -if [ "$MAYORDIR" = "" ]; then echo "MAYORDIR változó üres. Kilépek!"; exit 1; fi - -echo -n -e "\n Config fileok ellenőrzése..." - -if [ ! -e "$MAYORDIR/log" ]; then mkdir $MAYORDIR/log; fi -if [ ! -e /var/log/mayor ]; then ln -s $MAYORDIR/log /var/log/mayor; fi -if [ ! -e /etc/mayor ]; then ln -s $MAYORDIR/config /etc/mayor; fi -chmod +x $MAYORDIR/bin/mayor - -FILES="$MAYORDIR/config/parent-conf.php $MAYORDIR/config/private-conf.php $MAYORDIR/config/main-config.php $MAYORDIR/config/module-naplo/config.php $MAYORDIR/install/base/mysql/mayor-login.sql $MAYORDIR/install/base/mysql/mayor-auth.sql $MAYORDIR/install/base/mysql/private-users.sql $MAYORDIR/install/module-naplo/mysql/naplo-users.sql" -for f in $FILES -do - if [ ! -e $f ]; then echo -e "\n\r Nincs meg a szükséges ${f} config file!"; exit 1; else echo -n '.'; fi -done; -echo " kész."; - -if [ ! -e $MAYORDIR/log/mayor-base.rev ]; then - echo " Hiányzó mayor-base.rev file"; - if [ -e $MAYORDIR/log/revision ]; - then - IREV=$(cat $MAYORDIR/log/revision) - else - IREV=""; - fi -else - cp $MAYORDIR/log/mayor-base.rev $MAYORDIR/log/revision - IREV=$(cat $MAYORDIR/log/revision) -fi - -echo " Az aktuális revision: ${IREV}" - -if [ "$IREV" = "" ] -then - echo " Nincs revision file és helyreállítani sem tudom. Kilépek!" - exit 1; -fi - -echo " SQL fileok létrehozása... " -mkdir -p $TMPDIR/mysql -cd $TMPDIR/mysql -DB=$(grep db $MAYORDIR/config/main-config.php | sed -e "s/$.*=\ *['|\"]//g" -e "s/['|\"];//g") -USER=$(grep user $MAYORDIR/config/main-config.php | sed -e "s/$.*=\ *['|\"]//g" -e "s/['|\"];//g") -PW=$(grep pw $MAYORDIR/config/main-config.php | sed -e "s/$.*=\ *['|\"]//g" -e "s/['|\"];//g") -cat $MAYORDIR/install/base/mysql/mayor-login.sql | sed -e "s/%MYSQL_LOGIN_DB%/$DB/g" -e "s/%MYSQL_LOGIN_USER%/$USER/g" \ - -e "s/%MYSQL_LOGIN_PW%/$PW/g" > mayor-login.sql -DB=$(grep db $MAYORDIR/config/parent-conf.php | sed -e "s/^.*>\ *['|\"]//g" -e "s/['|\"],//g") -USER=$(grep user $MAYORDIR/config/parent-conf.php | sed -e "s/^.*>\ *['|\"]//g" -e "s/['|\"],//g") -PW=$(grep pw $MAYORDIR/config/parent-conf.php | sed -e "s/^.*>\ *['|\"]//g" -e "s/['|\"],//g") -cat $MAYORDIR/install/base/mysql/mayor-auth.sql | sed -e "s/%MYSQL_AUTH_DB%/$DB/g" -e "s/%MYSQL_AUTH_USER%/$USER/g" \ - -e "s/%MYSQL_AUTH_PW%/$PW/g" > mayor-parent.sql -DB=$(grep db $MAYORDIR/config/private-conf.php | sed -e "s/^.*>\ *['|\"]//g" -e "s/['|\"],//g") -USER=$(grep 'mysql user' $MAYORDIR/config/private-conf.php | sed -e "s/^.*>\ *['|\"]//g" -e "s/['|\"],//g") -PW=$(grep pw $MAYORDIR/config/private-conf.php | sed -e "s/^.*>\ *['|\"]//g" -e "s/['|\"],//g") -cat $MAYORDIR/install/base/mysql/mayor-auth.sql | sed -e "s/%MYSQL_AUTH_DB%/$DB/g" -e "s/%MYSQL_AUTH_USER%/$USER/g" \ - -e "s/%MYSQL_AUTH_PW%/$PW/g" > mayor-private.sql -DB=$(grep db $MAYORDIR/config/module-naplo/config.php | grep naplo_base | sed -e "s/^.*=\ *['|\"]//g" -e "s/['|\"];//g") -USER=$(egrep 'userWrite.*=' $MAYORDIR/config/module-naplo/config.php | sed -e "s/^.*=\ *['|\"]//g" -e "s/['|\"];//g") -USERREAD=$(egrep 'userRead.*=' $MAYORDIR/config/module-naplo/config.php | sed -e "s/^.*=\ *['|\"]//g" -e "s/['|\"];//g") -PW=$(egrep 'pwWrite.*=' $MAYORDIR/config/module-naplo/config.php | sed -e "s/^.*=\ *['|\"]//g" -e "s/['|\"];//g") -PWREAD=$(egrep 'pwRead.*=' $MAYORDIR/config/module-naplo/config.php | sed -e "s/^.*=\ *['|\"]//g" -e "s/['|\"];//g") -cat $MAYORDIR/install/module-naplo/mysql/base.sql | sed -e "s/%MYSQL_NAPLO_DB%/$DB/g" -e "s/%MYSQL_NAPLO_USER%/$USER/g" \ - -e "s/%MYSQL_NAPLO_PW%/$PW/g" -e "s/%MYSQL_NAPLO_USER_READ%/$USERREAD/g" \ - -e "s/%MYSQL_NAPLO_PW_READ%/$PWREAD/g" > base.sql -DB=$(grep db $MAYORDIR/config/private-conf.php | sed -e "s/^.*>\ *['|\"]//g" -e "s/['|\"],//g") - -cat $MAYORDIR/install/base/mysql/private-users.sql | sed -e "s/%MYSQL_PRIVATE_DB%/$DB/g" > private-users.sql -cat $MAYORDIR/install/module-naplo/mysql/naplo-users.sql | sed -e "s/%MYSQL_PRIVATE_DB%/$DB/g" > naplo-users.sql - -echo " A létrejött sql fileok:" -FILES=$(ls *.sql) -for f in $FILES -do - echo " * ${f}"; -done; -read -n 1 -p "Telepíthetem? (i/N)" -s DO -if [ "$DO" != "i" ]; then echo " ok, kiléptem..."; exit 1; fi -echo -e "\n" - -read -p " A mysql root jelszó (a begépelt szöveg nem látszik!): " -s MYSQLROOTPW - - -if [ ! -e $MAYORDIR/config/main.conf ]; then - cat $MAYORDIR/config/main.conf.example | sed s/%SQLPW%/$MYSQLROOTPW/ > $MAYORDIR/config/main.conf -# BDIR=$(echo $MAYORDIR | sed -e 's:\/:\\\/:g') -# sed -e "s/BASEDIR=\"\/var\/mayor\"/BASEDIR=\"$BDIR\"/g" -i $MAYORDIR/config/main.conf - chmod 600 $MAYORDIR/config/main.conf -fi - -if [ "$MYSQLROOTPW" = "" ]; -then - MYSQLROOTPWSTR=""; -else - MYSQLROOTPWSTR="-p$MYSQLROOTPW --user=root" -fi - -cat /tmp/mysql/mayor-login.sql | mysql $MYSQLROOTPWSTR --default-character-set=utf8 -cat /tmp/mysql/mayor-parent.sql | mysql $MYSQLROOTPWSTR --default-character-set=utf8 -cat /tmp/mysql/mayor-private.sql | mysql $MYSQLROOTPWSTR --default-character-set=utf8 -cat /tmp/mysql/base.sql | mysql $MYSQLROOTPWSTR --default-character-set=utf8 -cat /tmp/mysql/private-users.sql | mysql $MYSQLROOTPWSTR --default-character-set=utf8 -cat /tmp/mysql/naplo-users.sql | mysql $MYSQLROOTPWSTR --default-character-set=utf8 - -echo -e "\n" -echo "A telepítés végeztével beléphetsz a webes felületen! -========================================================= - user: mayoradmin -========================================================= - jelszó: jelszo -========================================================= -" |