Linux 下 Resin + JSP + MySQL 整合安裝配置全記錄

Linux 環境構建 Resin + JSP + MySQL 開發平台完整步驟

軟體版本

• J2SDK 1.5.0
• Apache 2.0.53
• Resin 3.0.13
• MySQL 4.1.12 (Server + Client RPM)
• MySQL-JDBC Connector 3.1.10

安裝流程

1. J2SDK

chmod +x jdk-1_5_0-linux-i586-rpm.bin
./jdk-1_5_0-linux-i586-rpm.bin
rpm -ivh jdk-1_5_0-linux-i586.rpm
# 安裝至 /usr/java/jdk1.5.0

# 環境變量 (/home/jun/.bashrc 或 /etc/profile)
export JAVA_HOME=/usr/java/jdk1.5.0
export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib:$CLASSPATH
export PATH=$PATH:$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$HOME/bin

驗證：javac 顯示參數即正常。

2. Apache 2

tar zxvf httpd-2.0.53.tar.gz
cd httpd-2.0.53
./configure --prefix=/usr/local/apache2
make && make install

# 啟動測試
/usr/local/apache2/bin/httpd -k start
# 瀏覽器訪問 https://localhost

# 修改 DocumentRoot 至 /var/www
vi /usr/local/apache2/conf/httpd.conf
# DocumentRoot "/var/www"

# 設定開機自啟
cp /usr/local/apache2/apachectl /etc/rc.d/init.d/httpd
cd /etc/rc.d/rc3.d
ln -s /etc/rc.d/init.d/httpd S80httpd

3. MySQL (RPM)

rpm -ivh MySQL-server-4.1.12-1.i386.rpm  # 自動啟動
rpm -ivh MySQL-client-4.1.12-1.i386.rpm
mysqlshow  # 顯示 mysql、test 兩庫即成功

4. Resin

cd /usr/local
tar zxvf /down/resin-3.0.13.tar.gz
cd resin-3.0.13
./configure --with-java-home=/usr/java/jdk1.5.0 --with-apxs=/usr/local/apache2/bin/apxs
make && make install

# 啟動測試
/usr/local/resin-3.0.13/bin/httpd.sh -verbose
# 瀏覽器 https://localhost:8080 見 Resin 首頁

# 整合 Apache + Resin
# 1. 確認 mod_caucho.so 存在
# 2. 編輯 httpd.conf
LoadModule caucho_module /usr/local/apache2/modules/mod_caucho.so
ResinConfigServer 192.168.1.109 6802  # 改為實際 IP
CauchoStatus yes

# 3. 編輯 resin.conf，host 改實際 IP，web-app 根目錄指向 /var/www
# 4. 重啟兩服務
/usr/local/apache2/bin/httpd -k restart
/usr/local/resin-3.0.13/bin/httpd.sh start

# 5. 測試 JSP
# /var/www/test.jsp:  2+2=<%=2+2%>
# 訪問 https://localhost/test.jsp 顯示 4 即成功

5. MySQL JDBC 驅動配置

cd /usr/local
tar zxvf /down/mysql-connector-java-3.1.10.tar.gz

# 編輯 /etc/rc.d/rc.local 設定 Resin 自啟動與 JDBC 路徑
export JAVA_HOME=/usr/java/jdk1.5.0
export JDBC=/usr/local/mysql-connector-java-3.1.10
export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/lib/dt.jar:$JDBC/mysql-connector-java-3.1.10-bin.jar:$CLASSPATH
echo "Starting Resin 3.0.13..."
/usr/local/resin-3.0.13/bin/httpd.sh start
sleep 15

6. JSP 測試 MySQL 連接

<%@ page import="java.sql.*,java.io.*" contentType="text/html; charset=gb2312" %>
<%
  Class.forName("com.mysql.jdbc.Driver");
  Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
  out.println("驅動程序加載成功!
已經建立到MySQL數據庫連接.");
%>

訪問 https://localhost/testMySQL.jsp 顯示成功訊息即平台就緒。