Wordpressの自動設定（失敗版）

wp_setup.sh

#!/bin/bash

WP_ROOT=/var/www
WP_SITE=http://wp-local/
MYSQL_LOGIN='-u root -ptest '
MYSQL='mysql '$MYSQL_LOGIN
MYSQLDUMP='mysqldump '$MYSQL_LOGIN
WP_DB=wp_db

MYSQL_WP_USER=wp_user
MYSQL_WP_PASS=password

USER=$(who am i | sed 's/^\(\S\+\).\+/\1/g')

sudo rm -f /var/www/index.html

sudo sed -i '2a 127.0.0.1 wp-local' /etc/hosts

${MYSQL} <<MYSQL
create database ${WP_DB};
GRANT ALL ON ${WP_DB}.* TO ${MYSQL_WP_USER}@"localhost" IDENTIFIED BY '${MYSQL_WP_PASS}';
FLUSH PRIVILEGES;
MYSQL

MYSQL=${MYSQL}${WP_DB}
MYSQLDUMP=${MYSQLDUMP}${WP_DB}

sudo chown ${USER}.  $WP_ROOT

wget http://ja.wordpress.org/wordpress-3.5.1-ja.tar.gz
tar xvf wordpress-3.5.1-ja.tar.gz
cp -r wordpress/* $WP_ROOT

cat $WP_ROOT/wp-config-sample.php | \
 sed -e 's/database_name_here/'${WP_DB}'/' | \
 sed -e 's/username_here/'${MYSQL_WP_USER}'/' | \
 sed -e 's/password_here/'${MYSQL_WP_PASS}'/' > $WP_ROOT/wp-config.php

echo '
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
' > $WP_ROOT/.htaccess
 
curl -c cookie.txt ${WP_SITE}wp-admin/install.php > /dev/null

curl -b cookie.txt ${WP_SITE}wp-admin/install.php?step=2  -e ${WP_SITE}wp-admin/install.php -X  POST \
 -d "weblog_title=WordpressBlog" \
 -d "user_name=admin" \
 -d "admin_password=test" \
 -d "admin_password2=test" \
 -d "[email protected]" \
 -d "Submit=WordPress をインストール"  > /dev/null

wget http://downloads.wordpress.org/plugin/quick-cache.111203.zip
unzip quick-cache.111203.zip
cp -r quick-cache ${WP_ROOT}/wp-content/plugins/
mkdir ${WP_ROOT}/wp-content/cache/

sudo chown -R www-data.  $WP_ROOT

${MYSQLDUMP} --skip-extended-insert > wordpress_begins.sql

sudo sed -i "1a define('WP_CACHE', true);" ${WP_ROOT}/wp-config.php

${MYSQL} <<MYSQL
UPDATE wp_options set option_value = '/%year%/%monthnum%/%day%/%postname%/' WHERE option_name = 'permalink_structure';
UPDATE wp_options set option_value = 'a:1:{i:0;s:27:\"quick-cache/quick-cache.php\";}' WHERE option_name = 'active_plugins';
INSERT INTO wp_options(option_name, option_value, autoload) VALUES
 ('ws_plugin__qcache_configured','1','yes'),
 ('ws_plugin__qcache_notices','a:0:{}','yes'),
 ('ws_plugin__qcache_options','a:20:{s:16:\"options_checksum\";s:32:\"e1d4aec5b27d62a02abe7e6038d4cdc9\";s:15:\"options_version\";s:5:\"1.001\";s:25:\"run_deactivation_routines\";s:1:\"1\";s:7:\"enabled\";s:1:\"1\";s:16:\"enable_debugging\";s:1:\"0\";s:25:\"dont_cache_when_logged_in\";s:1:\"1\";s:32:\"dont_cache_query_string_requests\";s:1:\"1\";s:19:\"allow_browser_cache\";s:1:\"0\";s:10:\"expiration\";s:4:\"3600\";s:15:\"clear_on_update\";s:6:\"single\";s:21:\"dont_cache_these_uris\";s:71:\"wp-app\r\nwp-signup\r\nwp-register\r\nwp-activate\r\nwp-login\r\nwp-admin\r\nxmlrpc\";s:21:\"dont_cache_these_refs\";s:0:\"\";s:23:\"dont_cache_these_agents\";s:13:\"w3c_validator\";s:16:\"use_flock_or_sem\";s:3:\"sem\";s:12:\"version_salt\";s:0:\"\";s:18:\"auto_cache_enabled\";s:1:\"0\";s:16:\"auto_cache_agent\";s:88:\"Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3\";s:22:\"auto_cache_sitemap_url\";s:0:\"\";s:26:\"auto_cache_additional_urls\";s:0:\"\";s:24:\"auto_cache_max_processes\";s:1:\"5\";}','yes'),
 ('ws_plugin__qcache_activated_version','111203','yes');
MYSQL