-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy patheccube_install.sh
160 lines (132 loc) · 5.58 KB
/
eccube_install.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
#!/bin/sh
######################################################################
#
# EC-CUBE の再インストールを行う shell スクリプト
#
# ※ PostgreSQL 専用
#
# 1. 既存の EC-CUBE サイトを移動(PREFIX.YYYYMMDD)
# 2. SVNリポジトリより checkout(tags/EC_CUBE_VERSION)
# 3. パーミッション変更
# 4. html/install/sql 配下の SQL を実行
# 5. 管理者権限をアップデート
# 6. data/install.php を生成
#
# 使い方
#
# # ./ec_cube_install.sh /install/path/to/eccube eccube-2.4.1
#
# この場合の DocumentRoot は, /install/path/to/eccube/html になります.
#
# 開発コミュニティの関連スレッド
# http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=4918&forum=14&post_id=23090#forumpost23090
#
#######################################################################
PREFIX=${PREFIX:-"$1"}
EC_CUBE_VERSION=${EC_CUBE_VERSION:-"$2"}
ADMIN_MAIL=${ADMIN_MAIL:-"[email protected]"}
SHOP_NAME=${SHOP_NAME:-"ロックオンのふとんやさん"}
INSTALL_PHP="data/install.php"
SITE_URL=${SITE_URL:-"http://demo2.ec-cube.net/"}
SSL_URL=${SSL_URL:-"http://demo2.ec-cube.net/"}
DOMAIN_NAME=${DOMAIN_NAME:-""}
TODAY=`date "+%Y%m%d"`
SVN=svn
SVN_USER=guest
SVN_PASSWD=lh1jNhUn
REPOSITORY="https://svn.ec-cube.net/open/tags/"
PGUSER=postgres
DROPDB=dropdb
CREATEDB=createdb
PSQL=psql
DBSERVER="127.0.0.1"
DBNAME=demo2_db
DBUSER=demo2_db_user
DBPASS=password
DBPORT=5432
OPTIONAL_SQL_FILE=optional.sql
echo "PREFIX=${PREFIX}"
echo "EC_CUBE_VERSION=${EC_CUBE_VERSION}"
if [ -d ${PREFIX} ]
then
echo "backup old version..."
mv ${PREFIX} "${PREFIX}.${TODAY}"
fi
if [ -f ${OPTIONAL_SQL_FILE} ]
then
echo "remove optional SQL"
rm ${OPTIONAL_SQL_FILE}
fi
echo "checkout sources from svn.ec-cube.net..."
${SVN} checkout --username ${SVN_USER} --password ${SVN_PASSWD} \
"${REPOSITORY}/${EC_CUBE_VERSION}" ${PREFIX}
echo "update permissions..."
chmod -R 777 "${PREFIX}/data/cache"
chmod -R 777 "${PREFIX}/data/class"
chmod -R 777 "${PREFIX}/data/Smarty"
chmod -R 777 "${PREFIX}/data/logs"
chmod -R 777 "${PREFIX}/data/downloads"
chmod -R 777 "${PREFIX}/html/install/temp"
chmod -R 777 "${PREFIX}/html/user_data"
chmod -R 777 "${PREFIX}/html/cp"
chmod -R 777 "${PREFIX}/html/upload"
#echo "dropdb..."
#su ${PGUSER} -c "${DROPDB} ${DBNAME}"
#echo "createdb..."
#su ${PGUSER} -c "${CREATEDB} -U ${DBUSER} ${DBNAME}"
SQL_DIR="${PREFIX}/html/install/sql"
echo "drop view..."
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/drop_view.sql ${DBNAME}"
echo "drop tables..."
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/drop_table.sql ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -c 'DROP TABLE dtb_session;' ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -c 'DROP TABLE dtb_module;' ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -c 'DROP TABLE dtb_campaign_order;' ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -c 'DROP TABLE dtb_mobile_kara_mail;' ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -c 'DROP TABLE dtb_mobile_ext_session_id;' ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -c 'DROP TABLE dtb_site_control;' ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -c 'DROP TABLE dtb_trackback;' ${DBNAME}"
echo "create table..."
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/create_table_pgsql.sql ${DBNAME}"
echo "create_view..."
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/create_view.sql ${DBNAME}"
echo "adding tables..."
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/add/dtb_campaign_order_pgsql.sql ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/add/dtb_mobile_ext_session_id_pgsql.sql ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/add/dtb_mobile_kara_mail_pgsql.sql ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/add/dtb_module_pgsql.sql ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/add/dtb_session_pgsql.sql ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/add/dtb_site_control_pgsql.sql ${DBNAME}"
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/add/dtb_trackback_pgsql.sql ${DBNAME}"
echo "insert data..."
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${SQL_DIR}/insert_data.sql ${DBNAME}"
echo "create optional SQL..."
echo "INSERT INTO dtb_member (member_id, login_id, password, authority, creator_id) VALUES ('1', 'admin', '2c19f4a742398150cecc80b3e76b673a35b8c19c', '0', '0');" >> ${OPTIONAL_SQL_FILE}
echo "INSERT INTO dtb_baseinfo (shop_name, email01, email02, email03, email04, email05, top_tpl, product_tpl, detail_tpl, mypage_tpl) VALUES ('${SHOP_NAME}', '${ADMIN_MAIL}', '${ADMIN_MAIL}', '${ADMIN_MAIL}', '${ADMIN_MAIL}', '${ADMIN_MAIL}', 'default1', 'default1', 'default1', 'default1');" >> ${OPTIONAL_SQL_FILE}
echo "execute optional SQL..."
su ${PGUSER} -c "${PSQL} -U ${DBUSER} -f ${OPTIONAL_SQL_FILE} ${DBNAME}"
echo "copy images..."
cp -rv "${PREFIX}/html/install/save_image" "${PREFIX}/html/upload/"
echo "creating ${INSTALL_PHP}..."
cat > "${PREFIX}/${INSTALL_PHP}" <<EOF
<?php
define ('ECCUBE_INSTALL', 'ON');
define ('HTML_PATH', '${PREFIX}/html/');
define ('SITE_URL', '${SITE_URL}');
define ('SSL_URL', '${SSL_URL}');
define ('URL_DIR', '/');
define ('DOMAIN_NAME', '${DOMAIN_NAME}');
define ('DB_TYPE', 'pgsql');
define ('DB_USER', '${DBUSER}');
define ('DB_PASSWORD', '${DBPASS}');
define ('DB_SERVER', '${DBSERVER}');
define ('DB_NAME', '${DBNAME}');
define ('DB_PORT', '${DBPORT}');
define ('DATA_PATH', '${PREFIX}/data/');
define ('MOBILE_HTML_PATH', HTML_PATH . 'mobile/');
define ('MOBILE_SITE_URL', SITE_URL . 'mobile/');
define ('MOBILE_SSL_URL', SSL_URL . 'mobile/');
define ('MOBILE_URL_DIR', URL_DIR . 'mobile/');
?>
EOF
echo "Finished Successful!"