NEW Nmail PHP 3 업그레이드 할인
자세히 보기

리눅스에서 오류가 나서 질문드립니다.

신*삼 2006.03.30 16:21 조회 9997

※ 필수입력정보 ※

▷ 제품버젼 : nwmail 1.1p7
▷ 사용중인 주소(URL) : http://3mac.co.kr:8080
▷ 문제발생시 메뉴/주소 :
▷ 문제발생시 에러메세지
:

pool.log

Thu Mar 30 16:12:42 KST 2006: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Thu Mar 30 16:12:42 KST 2006: Initialized pool mydb
Thu Mar 30 16:12:42 KST 2006: Initialized pool mydb2
Thu Mar 30 16:12:42 KST 2006: Can't create a new connection for jdbc:mysql://localhost:3306/nmail?useUnicode=true&characterEncoding=euc-kr
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost: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:525)
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:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
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_0002ejspindex_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(HttpConnectionHandler.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:595)


▷ 질문내용
:

디비연결 문제인거 같긴 한데...
설정 확인해봐도 어디가 잘못된건지 모르겠네요...

mysql user테이블에

| localhost | nmail | 패스워드 | Y .....
| 127.0.0.1 | nmail | 패스워드 | Y .....
이렇게 들어가있구요

mysql db테이블에

localhost | nmail | nmail | Y.....
127.0.0.1 | nmail | nmail | Y.....

들어가있구요...

[ db.properties ]
drivers=org.gjt.mm.mysql.Driver
logfile=/usr/local/jakarta-tomcat-3.2.3/logs/pool.log

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

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


[NConfig]

/----------DB Driver Setting
/dbDriver=sun.jdbc.odbc.JdbcOdbcDriver
/dbURL=jdbc:odbc:nmail
/dbUserid=nmail
/dbPassword=nmail
/dbMaxConnection=0

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


이렇게 되어있습니다...

MySQL 5.1 이구요
뭐가 문제일까요? ㅠㅠ



댓글 3
이전 글 메일 용량에 대해서... 3 김*성 2006.04.03
다음 글 메일패스워드 분실 1 김*성 2006.03.30