Modify Three: modify resin port
annotate or delete it!

Modify Four: Add virtual host with jsp support
## Add a Virtual Host need four steps: DNS、FTP、RESIN、APACHE

1、Add a CNAME
vi /var/named/yesgo.loc
# add the following line at the end:
www IN CNAME ns.yesgo.loc.
/etc/rc.d/init.d/named restart
nslookup
2、Add a ftp account:
Useradd www –s /dev/null –g ftpchroot
Passwd www
Chmod 701 /home/www
3、Configure resin.conf
vi /usr/local/resin/conf/resin.conf

/home/www

[ Attention! ]:
You set your resin classpath is classes，so you should put your JavaBeans under the directory.
4、configure httpd.conf
vi /usr/local/apache/conf/httpd.conf

# Name the IP address which Virtual Host build on
NameVirtualHost 192.168.1.2

# Add virtual host
www.yesgo.loc>
ServerAdmin [email protected]
DocumentRoot /home/www
ServerName www.yesgo.loc
ErrorLog logs/www.yesgo.loc-error_log
CustomLog logs/www.yesgo.loc -access_log common

##build resin service:
touch /etc/rc.d/init.d/resin
chmod 701 /etc/rc.d/init.d/resin
ln –s /etc/rc.d/init.d/resin /etc/rc.d/rc5.d/S70resin
vi /etc/rc.d/init.d/resin

##the content is:

#!/bin/bash
#Set environment parameter:

JAVA_HOME=/usr/local/jvm

RESIN_HOME=/usr/local/resin

CLASS_HOME=/usr/local/lib/java

CLASSPATH=$CLASSPATH:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/jre/lib:$RESIN_HOME/lib:$CLASS_HOME/drivers/mm.mysql-2.0.4-bin.jar.zip:$CLASS_HOME/jaf/activation.jar: $CLASS_HOME/javamail/mail.jar: $CLASS_HOME/javamail /smtp.jar: $CLASS_HOME/javamail /pop3.jar: $CLASS_HOME/javamail/mailapi.jar: $CLASS_HOME/javamail/imap.jar

PATH=$PATH:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local:/usr/local/bin:/usr/local/jvm/bin:/usr/local/jvm/jre/bin:/usr/local/mysql/bin:/usr/bin/X11:/usr/X11R6/bin

export JAVA_HOME RESIN_HOME CLASS_HOME CLASSPATH PATH

#Start resin web server
exec /usr/local/resin/httpd.sh start

shell>jsp start
shell>apache restart
--------------------------------------------------------------------------------------------
Step 16 PhpMyAdmin install
tar xvzf /home/src/phpMy*
cp /www/phpMyAdmin/* /home/mysql
chown –R mysql /home/mysql
chown –R mysql /home/mysql/*
chmod 701 /home/mysql
chmod 701 /home/mysql/*

##Add authentication
vi config.inc.php3

$cfgServers[1][host] = localhost;
$cfgServers[1][port] = \;
$cfgServers[1][adv_auth] = 1;
$cfgServers[1][stduser] = oot;
$cfgServers[1][stdpass] = your_password;
$cfgServers[1][user] = oot;
$cfgServers[1][password] = your_passwore;
$cfgServers[1][only_db] = \;
$cfgServers[1][verbose] = \;

#Add Virtual Host
vi /usr/local/apache/conf/httpd.conf

ServerAdmin [email protected]
DocumentRoot /www/mysql.yesgo.loc
ServerName mysql.yesgo.loc
ErrorLog logs/mysql.yesgo.loc-error_log
CustomLog logs/mysql.yesgo.loc-access_log common

apache restart
--------------------------------------------------------------------------------------------
Step 17 Server Test
## Why not to use 1+1=<%=1+1%>? The answer is:this sample can test MySQL、Resin、Apache、JDBC、MySQL JDBC Driver、Chinese problem etc.In a word,this test is very all-around.

1、Create Database
## create the sql script as following:
create database servertest
use servertest;

create table prov
(
prov_id tinyint(2) not null primary key,
prov_name char(6) not null
);

insert into prov values (,安徽);
insert into prov values (,北京);
insert into prov values (,重庆);
insert into prov values (,福建);
insert into prov values (,甘肃);
insert into prov values (,广东);
insert into prov values (,广西);
insert into prov values (8,贵州);
insert into prov values (9,海南);
insert into prov values (10,河北);
insert into prov values (11,黑龙江);
insert into prov values (12,河南);
insert into prov values (13,湖北);
insert into prov values (14,湖南);
insert into prov values (15,内蒙古);
insert into prov values (16,江苏);
insert into prov values (17,江西);
insert into prov values (18,吉林);
insert into prov values (19,辽宁);
insert into prov values (20,宁夏);
insert into prov values (21,青海);
insert into prov values (22,山西);
insert into prov values (23,陕西);
insert into prov values (24,山东);
insert into prov values (25,上海);
insert into prov values (26,四川);
insert into prov values (27,天津);
insert into prov values (28,西藏);
insert into prov values (29,新疆);
insert into prov values (30,云南);
insert into prov values (31,浙江);
insert into prov values (32,香港);
insert into prov values (33,澳门);
insert into prov values (34,台湾);

2、Add user for database
mysql –p
mysql> grant all privileges on servertest.* to your_user_name@localhost identified by ‘your_password’ with grant option;
mysql> grant all privileges on servertest.* to your_user_name@’ns.yesgo.loc’ identified by ‘your_password’ with grant option;
mysql> grant all privileges on servertest.* to your_user_name@’192.168.1.2’ identified by ‘your_password’ with grant option;
mysql> grant all privileges on servertest.* to your_user_name@’%’ identified by ‘your_password’ with grant option;
mysql>exit

3、Create index.jsp
touch /home/www/index.jsp
chown –R www /home/www/index.jsp
chgrp –r root /home/www/index.jsp
chmod 771 /home/www/index.jsp
vi test.jsp
## the source code is:

<%@ page language="java" import="java.sql.*"%>

<%
Class.forName ("org.gjt.mm.mysql.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/eidrp","hongze","sinotoy.com");
Statement stmt = conn.createStatement();
String strSql="select * from prov";
ResultSet rs=stmt.executeQuery(strSql);
rs.next();
out.print(rs.getString("prov_id")+" "+rs.getString("prov_name")+"
");
rs.last();
out.print(rs.getString("prov_id")+" "+rs.getString("prov_name")+"
");
stmt.close();
conn.close();
%>
4、browse it
lynx http://www.yesgo.loc (or:lynx http://www.yesgo.loc/index.jsp)
##the correct result should be:

1 安徽
34 台湾

## If the result is the above,congratulation！you succeed.
## Of course,you can also create a php file to test php:
touch /home/www/test.php
chmod 701 /home/www/test.php

vi test.php
## the source code is:
phpinfo();
?>
lynx http://www.yesgo.loc/test.php
--------------------------------------------------------------------------------------------
Step 18 Configuration debug

##After run lynx http://www.yesgo.loc, system perhaps give you some error message.
The proberbly error message is:

Error I:
Forbidden
You don have permission to access / on this server.

Apache/1.3.22 Server at www.yesgo.loc Port 80

Possible Reasons:
1、 You haven’t set right for guest user.
2、 You haven’t set default page.
Solution:
chmod 701 /home/www
chmod 701 /home/www/*

vi /usr/local/apache/conf/httpd.conf
DirectoryIndex index.html index.jsp index.xtp index.php index.php3
Error II:
404 Not Found
/index.jsp was not found on this server.

Resin 2.0.4 (built Thu Nov 15 17:56:24 PST 2001)

Possible Reasons:
1、You haven’t configure the virtual host both resin.conf and httpd.conf
2、you give a error file name to server
Solution:
1、 check your file name,attention uppercase and lowercase;
2、 check both httpd.conf and resin.conf have add the virtual host.

Error III:
500 Servlet Exception
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at com.caucho.util.DynamicClassLoader.loadClass(DynamicClassLoader.java:479)
at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at _cnmysql__jsp._jspService(/cnmysql.jsp:4)
at com.caucho.jsp.JavaPage.service(JavaPage.java:74)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:176)
at com.caucho.server.http.Invocation.service(Invocation.java:278)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:129)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:338)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:270)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)

Resin 2.0.4 (built Thu Nov 15 17:56:24 PST 2001)

Possible Reasons:
1、You haven’t install this driver.
2、you haven’t set classpath in /etc/profile
Solution:
See also Classes Install and edit /etc/profile above.
Error IV:
500 Servlet Exception
java.sql.SQLException: Invalid authorization specification: Access denied
for user: [email protected] (Using password: YES)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at _cnmysql__jsp._jspService(/cnmysql.jsp:5)
at com.caucho.jsp.JavaPage.service(JavaPage.java:74)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:176)
at com.caucho.server.http.Invocation.service(Invocation.java:278)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:129)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:338)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:270)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)

Resin 2.0.4 (built Thu Nov 15 17:56:24 PST 2001)
Possible Reasons:
1、database host、user or password set error
2、you input incorrect host、user or password.
Solution:
1、 see also Modify four in Resin Install;
2、 check your host、user or password in source code.
3、 Attention: don’t forget compare your host in code with in mysql db.

Error IV:
500 Servlet Exception
java.lang.AbstractMethodError
at _cnmysql__jsp._jspService(/cnmysql.jsp:11)
at com.caucho.jsp.JavaPage.service(JavaPage.java:74)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:176)
at com.caucho.server.http.Invocation.service(Invocation.java:278)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:129)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:338)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:270)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)

Resin 2.0.4 (built Thu Nov 15 17:56:24 PST 2001)

Possible Reasons:
1、the version of your jvm is to low,jdbc version is 1.0;
2、mysql jdbc Driver doesn’t support jdbc 2.0;
Solution:
1、 upgrade your jvm,my suggestion is j2sdk-1_3_1_01-linux-i386.bin;
2、 replace mysql_comp.jar with mm.mysql-2.0.4-bin.jar.zip

Appendix
Appendix I : Thanks
Friends:
Many knowledge and experience is learned from my friends,please permit me express my pure-hearted thinksgiving for them.Mr.Jim Zhao is my torchbearer on unix and linux,it’s he lead me to touch unix and linux,he gave me many help on my study way.I also get many help from my net friends,such as Mr.axman 、 Mr.popeye and others,thinks for them too.

Sites:
I also have gotten many resource and knowledge from technic web site,such as :
http://www.cnjsp.net
http://www.linuxaid.com.cn
http://www.linuxbyte.net
http://www.linuxforum.net
thinks for them too.

Appendix II : Todo List
1、 Give a verbose description;
2、 Distrabute simplified chinese release;
3、 Cstom package,don’t install everything.install only necessary packages;
4、 Don’t install X,use init 3 not init 5
5、 Enhance system security.

Appendix III: Revision log
12/20/01 distrabute the first release: language:English,version 0.0.1;

发布人:叶三耿来自:

站点导航

赞助商链接