※ 필수입력정보 ※

▷ 제품버젼 : 리눅스용
▷ 사용중인 주소(URL) : http://www.ivworld.net:8080 로컬에서 테스트 중입니다.
▷ 문제발생시 메뉴/주소 : 첫페이지 안떠요
▷ 문제발생시 에러메세지
:
Error: 500
Location: /source/index.jsp
Internal Servlet Error:
Cannot create bean of class user.table.MailUser

2005-08-30 19:06:28 - Ctx( ): Exception in: R( + /source/index.jsp + null) - javax.servlet.Se
rvletException: Cannot create bean of class user.table.MailUser


▷ 질문내용
:
pool.log 를 보니 통신을 못한다고 하는것 같아서 다른분이 올리신 글을 보고
telnet 127.0.0.1 3306 테스트해봤는데 이상없네요..
좀 도와주십시요.

아 그리고 Nconfig.conf 의 Server 와 inc_globalVar.jsp 의 DOMAIN 은
어떻게 써줘야하나요.. ivworld.net 으로 썼다가 하도 안돼서 127.0.0.1 로
변경했습니다.

그리고 왜 nmail 과 nmail.ivworld.net 으로 host 명을 등록하면 왜 안돼는거죠
뭐.. 일단 127.0.0.1 이 됀 담에 다시 물어봐야겠네요.

일단 윗분들에게 빨리 결과를 보여주고 서버를 도입 여부를 확정지어야 하니까요
제발 빨리 좀 부탁드립니다...



##########################################################################################
- 톰켓 디비에러로그 마지막 부분

Tue Aug 30 18:12:06 KST 2005: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Tue Aug 30 18:12:06 KST 2005: Initialized pool mydb
Tue Aug 30 18:12:06 KST 2005: Initialized pool mydb2
Tue Aug 30 18:12:06 KST 2005: Can't create a new connection for jdbc:mysql://127.0.0.1:3306/nmail?useU
nicode=true&characterEncoding=euc-kr
java.sql.SQLException: Communication failure during handshake. Is there a server running on 127.0.0.1:
3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at beans.DBConnectionManager$DBConnectionPool.newConnection(DBConnectionManager.java:423)
at beans.DBConnectionManager$DBConnectionPool.getConnection(DBConnectionManager.java:344)
at beans.DBConnectionManager.getConnection(DBConnectionManager.java:69)
at beans.DBHandler.init(DBHandler.java:33)
at user.table.MailUser.initDBHandler(MailUser.java:603)
at user.table.MailUser.setClassInfo(MailUser.java:1583)
at user.table.MailUser.<init>(MailUser.java:89)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39
)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl
.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at java.beans.Beans.instantiate(Beans.java:204)
at java.beans.Beans.instantiate(Beans.java:48)
at source._0002fsource_0002findex_0002ejspindex_jsp_0._jspService(_0002fsource_0002findex_0002
ejspindex_jsp_0.java:152)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandle
r.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:534)
##########################################################################################

[****@**** root]# telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
C
5.0.11-beta-debug-loxrT.(|[1,$[#94;j($|daConnection closed by foreign host.


mysql> SELECT Host, User, Password FROM user WHERE User='nmail';
+-----------+-------+-------------------------------------------+
| Host | User | Password |
+-----------+-------+-------------------------------------------+
| localhost | nmail | *56E0317CB5E9C614E67598EDE3DA56495544D54B |
| 127.0.0.1 | nmail | *56E0317CB5E9C614E67598EDE3DA56495544D54B |
+-----------+-------+-------------------------------------------+
2 rows in set (0.00 sec)


mysql> SELECT Host, User, Db FROM db WHERE User='nmail';
+-----------+-------+-------+
| Host | User | Db |
+-----------+-------+-------+
| localhost | nmail | nmail |
| 127.0.0.1 | nmail | nmail |
+-----------+-------+-------+
2 rows in set (0.00 sec)


################################################################################
- 톰켓 디비설정 부분
################################################################################
drivers=org.gjt.mm.mysql.Driver
logfile=/usr/local/jakarta-tomcat-3.2.3/logs/pool.log

/ mydb - Nmail DB
mydb.url=jdbc:mysql://127.0.0.1:3306/nmail?useUnicode=true&characterEncoding=euc-kr
mydb.maxconn=0
mydb.user=nmail
mydb.password=nmail

/ mydb2 - External member DB (사용하지 않을경우엔 mydb와 동일한 정보를 넣으십시오.)
mydb2.url=jdbc:mysql://127.0.0.1:3306/nmail?useUnicode=true&characterEncoding=euc-kr
mydb2.maxconn=0
mydb2.user=nmail
mydb2.password=nmail

################################################################################
vi /usr/local/nmail/Nconfig.conf
################################################################################

/----------Mail Server Address Setting
Server=127.0.0.1

/----------DNS Server Address Setting
DNSServer=168.126.63.1

dbDriver=org.gjt.mm.mysql.Driver
dbURL=jdbc:mysql://127.0.0.1:3306/nmail
dbUserid=nmail
dbPassword=nmail
dbMaxConnection=0

################################################################################
vi ./jakarta-tomcat-3.2.3/webapps/ROOT/nmail/include/inc_globalVar.jsp
################################################################################

// 모든 사용자가 수정해야할 내용.
String ADMIN_MAIL = "****@****"; // 관리자이메일.
String[] DOMAIN = {"127.0.0.1"}; // 도메인. ex) {"passkorea.net", "passkorea.net"}