Nmail PHP
제품소개
데모
다운로드
구입안내
FAQ (21)
Q&A (6124)
사용후기 (20)
Home    Contact us    Sitemap
기술지원안내
FAQ
Q&A 게시판
사용자 팁


Home > Support > Q&A > Nmail PHP
Nmail PHP Q&A


제 목 40 - 리눅스에서 오류가 나서 질문드립니다.
글쓴이 신현삼

※ 필수입력정보 ※

▷ 제품버젼 : 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 이구요
뭐가 문제일까요? ㅠㅠ




       
관련 게시물
번호   제목 글쓴이 등록일 조회수
40  
신현삼
06-03-30 9315
   
관리자
06-03-31 9323

리스트
번호   제목 글쓴이 등록일 조회수
   
관리자
06-04-04 7451
41  
김무성
06-04-03 8385
   
관리자
06-04-04 6983
   
김무성
06-04-05 6729
   
관리자
06-04-05 7941
40  
신현삼
06-03-30 9315
   
관리자
06-03-31 9323
   
신현삼
06-03-31 7784
   
관리자
06-03-31 7697
39  
김무성
06-03-30 8222
   
관리자
06-03-31 7546
38  
인홍진
06-03-22 7367
   
관리자
06-03-22 7131
   
인홍진
06-03-23 6459
   
관리자
06-03-23 6209
37  
인홍진
06-03-18 8617
   
관리자
06-03-20 7458
36  
신병욱
06-03-17 8076
   
관리자
06-03-17 7594
35  
박형명
06-03-15 7286
◀◀ 301 | 302 | 303 | 304 | 305 | 306 | 307 | 308 | 309 | 310 | ▶▶
패스코리아넷   경남 창원시 마산회원구 내서읍 중리상곡로 129, 한성빌딩 701호
메일 문의 : nmail@passkorea.net   I   전화 : 1544-1608   I   팩스 : 055-231-2069
사업자 등록번호 : 608-25-32288   I   대표자 : 빈경윤