OpenStaging

VMwareServer2 へ CentOS5.2 を入れたので、 OpenStaging をインストールした。

JDK
1. http://java.sun.com/j2se/1.5.0/ja/download.html
2. chmod 544 jdk-1_5_0_16-linux-i586-rpm.bin
3. ./jdk-1_5_0_16-linux-i586-rpm.bin
4. Do you agree to the above license terms? [yes or no]
5. /usr/java/jdk1.5.0_16/bin/java -version
Tomcat
1. http://tomcat.apache.org/
2. tar zxvf apache-tomcat-5.5.27.tar.gz
3. cp -r apache-tomcat-5.5.27.tar.gz /usr/local/
4. vi /etc/profile
5. source /etc/profile
6. /usr/local/apache-tomcat-5.5.27/bin/startup.sh
7. http://localhost:8080/
8. /usr/local/apache-tomcat-5.5.27/bin/shutdown.sh

/etc/profile

export JAVA_HOME=/usr/java/jdk1.5.0_16
export CATALINA_HOME=/usr/local/apache-tomcat-5.5.27
export CLASSPATH=.:$CATALINA_HOME/common/lib/servlet-api.jar:/common/lib/jsp-api.jar:

MySQL
1. yum -y install mysql-server
2. /etc/init.d/mysqld start
3. mysql -u root
4. mysql> SET PASSWORD FOR root@localhost=PASSWORD('hoge');
5. mysql> exit
6. mysql -u root -p
7. mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| test |

+--------------------+

OpenStaging
1. http://sourceforge.jp/projects/openstaging/
  1. Document.zip
  2. OpenStagingV1.1.2.zip
  3. SampleData.zip
2. unzip Document.zip
3. OpenStaging�C��X�g��[�V��}�j��A��.pdf
  1. vi $CATALINA_HOME/conf/server.xml
    1. useBodyEncodingForURI=”true”を追加
  2. OpenStaging をデプロイ
    1. unzip OpenStagingV1.1.2.zip
    2. mv ./OpenStaging.war /usr/local/apache-tomcat-5.5.27/webapps/
  3. Tomcat を起動
    1. /usr/local/apache-tomcat-5.5.27/bin/startup.sh
  4. settings.properties編集
    1. vi /usr/local/apache-tomcat-5.5.27/webapps/OpenStaging/WEB-INF/classes/settings.properties
      1. OpenStaging.Root=/usr/local/apache-tomcat-5.5.27/webapps/OpenStaging
      2. JobExecuter.javaCommand=/usr/java/jdk1.5.0_16/bin/java
  5. アプリケーションログのファイルパスを設定
    1. vi /usr/local/apache-tomcat-5.5.27/webapps/OpenStaging/WEB-INF/classes/log4j.xml
  6. Tomcat再起動
    1. /usr/local/apache-tomcat-5.5.27/bin/shutdown.sh
    2. /usr/local/apache-tomcat-5.5.27/bin/startup.sh
  7. ログイン画面
    1. http://localhost:8080/OpenStaging/login.jsp
  8. MySQL 用サンプルデータのインポート
    1. mysql -u root -p
    2. mysql> create database openstaging character set sjis;
    3. mysql> grant all privileges on *.* to openstaging@localhost

-> identified by 'openstaging' with grant option;

1. 1. 1. mysql> grant all privileges on openstaging.* to openstaging@'%'

-> identified by 'openstaging' with grant option;

1. 1. 1. 確認用サンプルデータを解凍
      1. unzip SampleData.zip
        
        MySQLSample.zip
        
        OracleSample.zip
        
        PostgreSQLSample.zip
        
        unzip MySQLSample.zip
    2. データ取り込み
      1. mysql -u openstaging -popenstaging -D openstaging < sample_my.dmp
  2. ORDER_VIEWの作成
    1. mysql -uopenstaging -popenstaging -D openstaging
    2. mysql> CREATE VIEW ORDER_VIEW AS

SELECT
ORDER_DETAIL.ITEM_ID
,ORDER_DETAIL.CAMPAIGN_ID
,SUPPORT_CENTER_ID
,DATE(ORDERED_TIME) AS ORDER_DATE
,SELLING_PRICE*(100-DISCOUNT_RATE)/100 AS SALES
,COST_PRICE AS COST
FROM
ORDER_UNIT
,ORDER_DETAIL
,ITEM
,CAMPAIGN
WHERE
ITEM.ITEM_ID=ORDER_DETAIL.ITEM_ID
AND ORDER_DETAIL.CAMPAIGN_ID=CAMPAIGN.CAMPAIGN_ID
AND ORDER_DETAIL.ORDER_UNIT_ID=ORDER_UNIT.ORDER_UNIT_ID;

1. 1. 1. Table 'ORDER_VIEW' already exists
  2. インポートされていることを確認
  3. mysql> show full tables;

1. 1. ユーザー・パスワード設定
  2. cat /usr/local/apache-tomcat-5.5.27/webapps/OpenStaging/WEB-INF/conf/user/user.conf
    1. ユーザ名: openstaging 、パスワード: openstaging
  3. ログイン
    1. http://localhost:8080/OpenStaging/login.jsp