안녕하세요
Can't create a new connection for jdbc:mysql://127.0.0.1:3306/nmail?useUnicode=true&characterEncoding=euc-kr
java.sql.SQLException: Communication failure during handshake. Is there a server running on 127.0.0.1:3306?
=>
에러메세지를 보니 톰켓을 실행하는 로컬서버(127.0.0.1)에서 mysql 이 동작중이지 않았다는 뜻으로 보입니다.
해당 서버에 접속해서 다음처럼 3306 포트가 응답을 하는지 테스트해보시기 바랍니다.
telnet 127.0.0.1 3306
감사합니다.
정의진 님이 쓴 글입니다.
--------------------------------------------------------------------
:※ 필수입력정보 ※
:
:▷ 제품버젼 : 테스트용 웹메일 (리눅스)
:▷ 사용중인 주소(URL) : 아직 사용을 못하고 있고요
:▷ 문제발생시 메뉴/주소 :
:▷ 문제발생시 에러메세지
: : Error: 500
:
:▷ 질문내용
: :
:회사에서 웹메일을 좀 알아보라 해서, 리눅스용 웹메일 설치해서 테스트좀 해보려구 하는데요
:웹에서 500 에러가 자꾸 나서 게시판에 비슷한 글들이 많아..수정도 해봤는데..잘안되네요
:도와 주세요
:
:
:db에서 유저는 다음과 같이 되었구요
:
:mysql > select user,host,password from user where user='nmail';
:+-------+-----------+-------------------------------------------+
:| user | host | password |
:+-------+-----------+-------------------------------------------+
:| nmail | 127.0.0.1 | *56E0317CB5E9C614E67598EDE3DA56495544D54B |
:| nmail | localhost | *56E0317CB5E9C614E67598EDE3DA56495544D54B |
:+-------+-----------+-------------------------------------------+
:2 rows in set (0.00 sec)
:
:톰켓 db세팅은
:
: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=10
: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=10
:mydb2.user=nmail
:mydb2.password=nmail
:
:글구, 로그 마지막 부분은.
:
:Wed Mar 09 19:00:08 KST 2005: JDBC driver 등록 :org.gjt.mm.mysql.Driver
:Wed Mar 09 19:00:08 KST 2005: Initialized pool mydb
:Wed Mar 09 19:00:08 KST 2005: Initialized pool mydb2
:Wed Mar 09 19:00:08 KST 2005: Can't create a new connection for jdbc:mysql://127.0.0.1:3306/nmail?useUnicode=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_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:534)
:
:
:위와 같습니다...
:몇일째 삽질만 하고 있는데요...제가 실력이 없어설...
:도와주세요
:
