Changeset 23552
- Timestamp:
- 2014/06/13 23:52:08 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/eccube_install.sh
r23551 r23552 73 73 # Functions 74 74 75 create_ config_php()75 create_sequence_tables() 76 76 { 77 cat > "./${CONFIG_PHP}" <<__EOF__ 78 <?php 79 define('ECCUBE_INSTALL', 'ON'); 80 define('HTTP_URL', '${HTTP_URL}'); 81 define('HTTPS_URL', '${HTTPS_URL}'); 82 define('ROOT_URLPATH', '${ROOT_URLPATH}'); 83 define('DOMAIN_NAME', '${DOMAIN_NAME}'); 84 define('DB_TYPE', '${DBTYPE}'); 85 define('DB_USER', '${DBUSER}'); 86 define('DB_PASSWORD', '${CONFIGPASS:-$DBPASS}'); 87 define('DB_SERVER', '${DBSERVER}'); 88 define('DB_NAME', '${DBNAME}'); 89 define('DB_PORT', '${DBPORT}'); 90 define('ADMIN_DIR', '${ADMIN_DIR}'); 91 define('ADMIN_FORCE_SSL', FALSE); 92 define('ADMIN_ALLOW_HOSTS', 'a:0:{}'); 93 define('AUTH_MAGIC', '${AUTH_MAGIC}'); 94 define('PASSWORD_HASH_ALGOS', 'sha256'); 95 define('MAIL_BACKEND', 'mail'); 96 define('SMTP_HOST', ''); 97 define('SMTP_PORT', ''); 98 define('SMTP_USER', ''); 99 define('SMTP_PASSWORD', ''); 100 101 __EOF__ 102 } 103 104 105 ####################################################################### 106 # Install 107 108 #-- Update Permissions 109 echo "update permissions..." 110 chmod -R go+w "./html" 111 chmod go+w "./data" 112 chmod -R go+w "./data/Smarty" 113 chmod -R go+w "./data/cache" 114 chmod -R go+w "./data/class" 115 chmod -R go+w "./data/class_extends" 116 chmod go+w "./data/config" 117 chmod -R go+w "./data/download" 118 chmod -R go+w "./data/downloads" 119 chmod go+w "./data/fonts" 120 chmod go+w "./data/include" 121 chmod go+w "./data/logs" 122 chmod -R go+w "./data/module" 123 chmod go+w "./data/smarty_extends" 124 chmod go+w "./data/upload" 125 chmod go+w "./data/upload/csv" 126 127 #-- Setup Database 128 SQL_DIR="./html/install/sql" 129 OPTIONAL_SQL_FILE=optional.sql 130 if [ -f ${OPTIONAL_SQL_FILE} ] 131 then 132 echo "remove optional SQL" 133 rm ${OPTIONAL_SQL_FILE} 134 fi 135 136 SEQUENCES=" 77 SEQUENCES=" 137 78 dtb_best_products_best_id_seq 138 79 dtb_bloc_bloc_id_seq … … 168 109 " 169 110 111 comb_sql=""; 112 for S in $SEQUENCES; do 113 case ${DBTYPE} in 114 pgsql) 115 sql=$(echo "CREATE SEQUENCE ${S} START 10000;") 116 ;; 117 mysql) 118 sql=$(echo "CREATE TABLE ${S} ( 119 sequence int(11) NOT NULL AUTO_INCREMENT, 120 PRIMARY KEY (sequence) 121 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 122 LOCK TABLES ${S} WRITE; 123 INSERT INTO ${S} VALUES (10000); 124 UNLOCK TABLES;") 125 ;; 126 esac 127 128 comb_sql=${comb_sql}${sql} 129 done; 130 131 case ${DBTYPE} in 132 pgsql) 133 echo ${comb_sql} | sudo -u ${PGUSER} ${PSQL} -U ${DBUSER} ${DBNAME} 134 ;; 135 mysql) 136 echo ${comb_sql} | ${MYSQL} -u ${DBUSER} ${PASSOPT} ${DBNAME} 137 ;; 138 esac 139 } 140 141 create_config_php() 142 { 143 cat > "./${CONFIG_PHP}" <<__EOF__ 144 <?php 145 define('ECCUBE_INSTALL', 'ON'); 146 define('HTTP_URL', '${HTTP_URL}'); 147 define('HTTPS_URL', '${HTTPS_URL}'); 148 define('ROOT_URLPATH', '${ROOT_URLPATH}'); 149 define('DOMAIN_NAME', '${DOMAIN_NAME}'); 150 define('DB_TYPE', '${DBTYPE}'); 151 define('DB_USER', '${DBUSER}'); 152 define('DB_PASSWORD', '${CONFIGPASS:-$DBPASS}'); 153 define('DB_SERVER', '${DBSERVER}'); 154 define('DB_NAME', '${DBNAME}'); 155 define('DB_PORT', '${DBPORT}'); 156 define('ADMIN_DIR', '${ADMIN_DIR}'); 157 define('ADMIN_FORCE_SSL', FALSE); 158 define('ADMIN_ALLOW_HOSTS', 'a:0:{}'); 159 define('AUTH_MAGIC', '${AUTH_MAGIC}'); 160 define('PASSWORD_HASH_ALGOS', 'sha256'); 161 define('MAIL_BACKEND', 'mail'); 162 define('SMTP_HOST', ''); 163 define('SMTP_PORT', ''); 164 define('SMTP_USER', ''); 165 define('SMTP_PASSWORD', ''); 166 167 __EOF__ 168 } 169 170 171 ####################################################################### 172 # Install 173 174 #-- Update Permissions 175 echo "update permissions..." 176 chmod -R go+w "./html" 177 chmod go+w "./data" 178 chmod -R go+w "./data/Smarty" 179 chmod -R go+w "./data/cache" 180 chmod -R go+w "./data/class" 181 chmod -R go+w "./data/class_extends" 182 chmod go+w "./data/config" 183 chmod -R go+w "./data/download" 184 chmod -R go+w "./data/downloads" 185 chmod go+w "./data/fonts" 186 chmod go+w "./data/include" 187 chmod go+w "./data/logs" 188 chmod -R go+w "./data/module" 189 chmod go+w "./data/smarty_extends" 190 chmod go+w "./data/upload" 191 chmod go+w "./data/upload/csv" 192 193 #-- Setup Database 194 SQL_DIR="./html/install/sql" 195 OPTIONAL_SQL_FILE=optional.sql 196 if [ -f ${OPTIONAL_SQL_FILE} ] 197 then 198 echo "remove optional SQL" 199 rm ${OPTIONAL_SQL_FILE} 200 fi 201 170 202 echo "create optional SQL..." 171 203 echo "INSERT INTO dtb_member (member_id, login_id, password, salt, work, del_flg, authority, creator_id, rank, update_date) VALUES (2, 'admin', '${ADMINPASS}', '${AUTH_MAGIC}', '1', '0', '0', '0', '1', current_timestamp);" >> ${OPTIONAL_SQL_FILE} … … 183 215 echo "insert data..." 184 216 sudo -u ${PGUSER} ${PSQL} -U ${DBUSER} -f ${SQL_DIR}/insert_data.sql ${DBNAME} 185 for S in $SEQUENCES 186 do 187 echo "CREATE SEQUENCE $S START 10000;" >> ${OPTIONAL_SQL_FILE} 188 done 217 echo "create sequence table..." 218 create_sequence_tables 189 219 echo "execute optional SQL..." 190 220 sudo -u ${PGUSER} ${PSQL} -U ${DBUSER} -f ${OPTIONAL_SQL_FILE} ${DBNAME} … … 209 239 echo "insert data..." 210 240 ${MYSQL} -u ${DBUSER} ${PASSOPT} ${DBNAME} < ${SQL_DIR}/insert_data.sql 211 for S in $SEQUENCES 212 do 213 echo "CREATE TABLE $S ( sequence int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence)) ENGINE=InnoDB DEFAULT CHARSET=utf8; LOCK TABLES $S WRITE; INSERT INTO $S VALUES (10000); UNLOCK TABLES;" >> ${OPTIONAL_SQL_FILE} 214 done 241 echo "create sequence table..." 242 create_sequence_tables 215 243 echo "execute optional SQL..." 216 244 ${MYSQL} -u ${DBUSER} ${PASSOPT} ${DBNAME} < ${OPTIONAL_SQL_FILE}
Note: See TracChangeset
for help on using the changeset viewer.