현재 자료실에 올려진 리눅스용 Java버젼의 경우...
mysql 3.23, mysql 4.0 에서 동작하도록 패키징되어 있습니다.
mysql 5.1에서 사용하려면 패키지내에 포함된 jdbc와 디비설정을 모두 변경해야하는
까다로운 작업이어서 별도의 패키지를 제작할 예정입니다.
현재로선 가능하다면 mysql 4.0 이하버젼을 설치해서 테스트해보시는 방법밖엔 없을 듯 합니다.
신현삼 님이 쓴 글입니다.
--------------------------------------------------------------------
:※ 필수입력정보 ※
:
:▷ 제품버젼 : 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 이구요
:뭐가 문제일까요? ㅠㅠ
:
:
:
:
