※ 필수입력정보 ※

▷ 제품버젼 :
▷ 사용중인 주소(URL) : http://
▷ 문제발생시 메뉴/주소 :
▷ 문제발생시 에러메세지
:

▷ 질문내용
:
기차니 님이 쓴 글입니다.
:--------------------------------------------------------------------
java version "1.3.1_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_01)
Java HotSpot(TM) Client VM (build 1.3.1_01, mixed mode)

입니다
pool.log내용입니다
127.0.0.1 하면 안되나여?아님 nmail로 로그인이 안되서 그런가여?
db-
mysql> select * from user;
+-----------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| kwon | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| localhost | | | Y | N | N | N | N | N | N | N | N | N | N | N | N | N |
| kwon | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| 127,0,0,1 | nmail | 0af56ab35464301d | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| localhost | nmail | 0af56ab35464301d | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
+-----------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
mysql> select * from db;
+-----------+---------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+---------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| % | test | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y |
| % | test\_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y |
| localhost | nmail | nmail | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 127.0.0.1 | nmail | nmail | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
+-----------+---------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+


톰켓 디비설정 부분

db.url=jdbc:mysql://220.126.127.210:3306/nmail?useUnicode=true&characterEncoding=euc-kr
mydb.maxconn=0
mydb.user=nmail
mydb.password=nmail
쨉쩔쳉쳉 쳇ㅒ봔맞맞?쨀쳉쨍쩍쳇시쩔?)
mydb2.url=jdbc:mysql://127.0.0.1:3306/nmail?useUnicode=true&characterEncoding=euc-kr
mydb2.maxconn=0
mydb2.user=nmail
mydb2.password=nmail
~
[****@**** logs]# tail -n100 pool.log
at java.lang.Class.newInstance(Class.java:237)
at java.beans.Beans.instantiate(Beans.java:207)
at java.beans.Beans.instantiate(Beans.java:51)
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:484)
Tue Dec 28 01:57:47 KST 2004: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Tue Dec 28 01:57:47 KST 2004: Initialized pool mydb
Tue Dec 28 01:57:47 KST 2004: Initialized pool mydb2
Tue Dec 28 01:57:47 KST 2004: Can't create a new connection for jdbc:mysql://220.126.127.210:3306/nmail?useUnicode=true&characterEncoding=euc
-kr
java.sql.SQLException: Server configuration denies access to data source
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:193)
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:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
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 java.lang.Class.newInstance0(Native Method)
at java.lang.Class.newInstance(Class.java:237)
at java.beans.Beans.instantiate(Beans.java:207)
at java.beans.Beans.instantiate(Beans.java:51)
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:484)

Tue Dec 28 02:04:56 KST 2004: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Tue Dec 28 02:04:56 KST 2004: Initialized pool mydb
Tue Dec 28 02:04:56 KST 2004: Can't create a new connection for jdbc:mysql://127.0.0.1:3306/nmail?useUnicode=true&characterEncoding=euc-kr
java.sql.SQLException: Invalid authorization specification: Access denied for user: '****@****' (Using password: YES)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330)
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:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
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 java.lang.Class.newInstance0(Native Method)
at java.lang.Class.newInstance(Class.java:237)
at java.beans.Beans.instantiate(Beans.java:207)
at java.beans.Beans.instantiate(Beans.java:51)
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:484)

관리자 님이 쓴 글입니다.
--------------------------------------------------------------------
:안녕하세요
:
:자바관련 라이브러리가 없어서 발생한 에러로 보입니다.
:
:http://passkorea.net/pubs/_jar_webmail.tar.gz
:
:위 파일을 다운받으신뒤 JDK lib 디렉토리에 압축을 풀어서 넣어주시면 됩니다.
:ex) tar zxvf _jar_webmail.tar.gz -C /usr/local/java/lib
:
:위와같이 처리후 톰캣을 재시작해도 안된다면 사용중인 자바버젼을 알려주시기 바랍니다.
:ex) /usr/local/java/bin/java -version
:
:감사합니다.
:
: