localmoffycreate



#!/bin/bash

set -e

user="moffy"
passwd="oscerciv"
db="moffy"

mysqladmin -uroot -p create $db
echo "GRANT ALL ON $db.* TO '$user@localhost' IDENTIFIED BY '$passwd' WITH GRANT OPTION;" | mysql -uroot -p

#mysql -u$user -p$passwd $db < $basedir/sql/publish.sql
dbstring="INSERT INTO eZUser_User VALUES (1,'$user',password('$passwd'),'$user@$domain','admin','user','false','',0,0);"
cat $basedir/sql/publish.sql | sed "s/^INSERT INTO eZUser_User VALUES.*\$/$dbstring/" | mysql -u$user -p$passwd $db
su $user -c "zcat $basedir/data.tar.gz | tar -xv -C $basedir"
mysql -u$user -p$passwd $db < $basedir/sql/data.sql

#su $user -c "cd $basedir && ./modfix.sh"
#su $user -c "cd $basedir && ./secure_clearcache.sh"
#su $user -c "echo \"
#RewriteEngine On
#RewriteRule ^/stats/store/(.*).gif\\\$ $basedir/ezstats/user/storestats.php [S=2]
#RewriteRule ^/filemanager/filedownload/([^/]+)/(.*)\\\$ $basedir/ezfilemanager/files/\\\$1 [T=\\\"application/oct-stream\\\",S=1]
#RewriteRule \!\.(gif|css|jpg|png)\\\$ $basedir/index.php
#\" > $basedir/.htaccess"

#su $user -c "echo \"
#RewriteEngine On
#RewriteRule \!\.(gif|css|jpg|png)\\\$ $basedir/index_admin.php
#\" > $adminbasedir/.htaccess"

su $user -c "
    cd $basedir
    ./modfix.sh
    ./secure_modfix.sh $user $group
    ./clearcache.sh
    ./secure_clearcache.sh
    cat site.ini | sed 's/^SiteURL=publish.ez.no\$/SiteURL=$host/' > site.ini.tmp && mv site.ini.tmp site.ini
    cat site.ini | sed 's/^Database=publish\$/Database=$db/' > site.ini.tmp && mv site.ini.tmp site.ini
    cat site.ini | sed 's/^User=publish\$/User=$user/' > site.ini.tmp && mv site.ini.tmp site.ini
    cat site.ini | sed 's/^Password=publish\$/Password=$passwd/' > site.ini.tmp && mv site.ini.tmp site.ini
    cat site.ini | sed 's/^Database=publish\$/Database=$db/' > site.ini.tmp && mv site.ini.tmp site.ini
"

echo "
<VirtualHost *>
    ServerName  $host
    ServerAdmin $user@$domain
    DocumentRoot    $basedir
    user        $user
    group       $group
    php_flag    magic_quotes_gpc off
    RewriteEngine   On
    RewriteRule ^/stats/store/(.*).gif\$ $basedir/ezstats/user/storestats.php [S=2]
    RewriteRule ^/filemanager/filedownload/([^/]+)/(.*)\$ $basedir/ezfilemanager/files/\$1 [T="application/oct-stream",S=1]
    RewriteRule !\.(gif|css|jpg|png)\$ $basedir/index.php
</VirtualHost>
<VirtualHost *>
    ServerName  $adminhost
    ServerAdmin $user@$domain
    DocumentRoot    $basedir
    user        $user
    group       $group
    php_flag    magic_quotes_gpc off
    RewriteEngine   On
    RewriteRule !\.(gif|css|jpg|png)\$ $basedir/index_admin.php
</VirtualHost>
" > $webcfg

echo "Remember to reload Apache..."