NEW Nmail PHP 3.4.0 업데이트 - 보안 강화(2단계 인증 등), 중요 메일, 대표 계정, 스팸 자동 업데이트
자세히 보기

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

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

nmail 접속시 에러 문제

궁* 2004.09.24 12:04 조회 1782

※ 필수입력정보 ※

▷ 제품버젼 :
▷ 사용중인 주소(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