그럼 mysql 만 바꾸면 되는건가요?
일단 제가 설정한 부분은 문제가 없는건지요?
그리고 mysql 4.1 버젼은 어떤가요? ^^*
관리자 님이 쓴 글입니다.
--------------------------------------------------------------------
:현재 자료실에 올려진 리눅스용 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 이구요
::뭐가 문제일까요? ㅠㅠ
::
::
::
::
: