네. 패키지내에 포함되어 있는 JDBC를 사용하려면 버젼맞 낮추시면 됩니다.
설정에는 별다른 문제가 없어보입니다만....
혹시모르니 톰켓, 메일엔진설정에서 MYSQL 주소는 LOCALHOST 대신 127.0.0.1 로 지정하시기 바랍니다.
그리고 4.1 부터 JDBC 드라이버가 달라지는걸로 알고 있습니다.
신현삼 님이 쓴 글입니다.
--------------------------------------------------------------------
:그럼 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 이구요
:::뭐가 문제일까요? ㅠㅠ
:::
:::
:::
:::
::
:
