NEW Nmail PHP 3 업그레이드 할인
자세히 보기

Nmail ASP 서비스 종료 안내(EOS)

Nmail ASP (nWmail, Nmail Server) 제품은 유상 유지보수를 포함한 모든 서비스가 종료되었습니다.

nmail 접속시 에러 문제

궁* 2004.09.24 12:04 조회 810

※ 필수입력정보 ※

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

▷ 질문내용
: nbuilder에서 nmail 접속시 에러가 나네요..
여기 저기 q&a를 보아도 문제를 알수가 없네요..
확인 부탁 드릴게요...


에러Error: 500
Location: /source/user/interlocker/link_user_insert.jsp
Internal Servlet Error:

javax.servlet.ServletException: Cannot create bean of class user.table.MailUser
at source.user.i_00025terlocker._0002fsource_0002fuser_0002finterlocker_0002flink_0005fuser_0005finsert_0002ejsplink_0005fuser_0005finsert_jsp_0._jspService(_0002fsource_0002fuser_0002finterlocker_0002flink_0005fuser_0005finsert_0002ejsplink_0005fuser_0005finsert_jsp_0.java:238)
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)



디비 내용 입니다...
mysql> select host,user,password from user where user='nmail1';
+-----------------------+--------+------------------+
| host | user | password |
+-----------------------+--------+------------------+
| localhost | nmail1 | 7f9e49e***-****-**** |
| localhost.localdomain | nmail1 | 7f9e49e***-****-**** |
+-----------------------+--------+------------------+
2 rows in set (0.00 sec)

mysql> select host,user,db from db where user='nmail1';
+-----------------------+--------+-------+
| host | user | db |
+-----------------------+--------+-------+
| localhost | nmail1 | nmail |
| localhost.localdomain | nmail1 | nmail |
+-----------------------+--------+-------+
2 rows in set (0.00 sec)


톰켓 디비에러로그 마지막 부분

****@**** local]# tail -n100 /usr/local/jakarta-tomcat-3.2.3/logs/pool.log
at java.beans.Beans.instantiate(Beans.java:207)
at java.beans.Beans.instantiate(Beans.java:51)
at source.user.i_00025terlocker._0002fsource_0002fuser_0002finterlocker_0002flink_0005fuser_0005finsert_0002ejsplink_0005fuser_0005finsert_jsp_0._jspService(_0002fsource_0002fuser_0002finterlocker_0002flink_0005fuser_0005finsert_0002ejsplink_0005fuser_0005finsert_jsp_0.java:236)
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)
Fri Sep 24 00:04:18 KST 2004: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Fri Sep 24 00:04:18 KST 2004: Initialized pool mydb
Fri Sep 24 00:04:18 KST 2004: Initialized pool mydb2
Fri Sep 24 00:04:18 KST 2004: Can't create a new connection for jdbc:mysql://211.223.49.235: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.user.i_00025terlocker._0002fsource_0002fuser_0002finterlocker_0002flink_0005fuser_0005finsert_0002ejsplink_0005fuser_0005finsert_jsp_0._jspService(_0002fsource_0002fuser_0002finterlocker_0002flink_0005fuser_0005finsert_0002ejsplink_0005fuser_0005finsert_jsp_0.java:236)
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)
Fri Sep 24 00:11:21 KST 2004: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Fri Sep 24 00:11:21 KST 2004: Initialized pool mydb
Fri Sep 24 00:11:21 KST 2004: Initialized pool mydb2
Fri Sep 24 00:11:21 KST 2004: Can't create a new connection for jdbc:mysql://211.223.49.235: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.user.i_00025terlocker._0002fsource_0002fuser_0002finterlocker_0002flink_0005fuser_0005finsert_0002ejsplink_0005fuser_0005finsert_jsp_0._jspService(_0002fsource_0002fuser_0002finterlocker_0002flink_0005fuser_0005finsert_0002ejsplink_0005fuser_0005finsert_jsp_0.java:236)
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)

톰캐 설정내용..
****@**** bin]# cat /usr/local/jakarta-tomcat-3.2.3/webapps/ROOT/WEB-INF/classes/beans/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://127.0.0.1:3306/nmail?useUnicode=true&characterEncoding=euc-kr
mydb.maxconn=0
mydb.user=nmail1
mydb.password=nmail1

/ mydb2 - External member DB (사용하지 않을경우엔 mydb와 동일한 정보를 넣으십시오.)
mydb2.url=jdbc:mysql://127.0.0.1:3306/nmail?useUnicode=true&characterEncoding=euc-kr
mydb2.maxconn=0
mydb2.user=nmail
mydb2.password=nmail1
[****@**** bin]#

답변부탁드릴게요>>>

댓글 0
이전 글 급한 질문있습니다. 1 박*환 2004.09.23
다음 글 리눅스용 nmail에서 일본어 지원할려면 ? 1 이*효 2004.09.23