안녕하세요
MySQL에서 nmail 계정처럼 nbuilder 계정에서도
'localhost, 127.0.0.1' 두 가지 호스트에 대한 권한(user, db table)을 모두 부여하셨나요?
MySQL 의 'mysql' DB 에서 user, db Table 은 아래와 같이 설정되어 있어야 합니다.
사용자명이 'nbuilder'이고 디비명이 'nbuilder'일때의 올바른 설정 예제)
mysql> SELECT Host, User, Password FROM user WHERE User='nbuilder';
+-----------+-------+------------------+
| Host | User | Password |
+-----------+-------+------------------+
| 127.0.0.1 | nbuilder | 0af562342434324d |
| localhost | nbuilder | 0af562342434324d |
+-----------+-------+------------------+
=> User, Password 는 동일하고 Host 명만 두가지여야함.
mysql> SELECT Host, User, Db FROM db WHERE User='nbuilder';
+-----------+-------+-------+
| Host | User | Db |
+-----------+-------+-------+
| 127.0.0.1 | nbuilder | nbuilder |
| localhost | nbuilder | nbuilder |
+-----------+-------+-------+
=> User, Db 는 동일하고 Host 명만 두가지여야함.
이 부분을 점검해보시고 mysql 과 톰켓을 재시작해보시기 바랍니다.
문제가 계속된다면 다음 내용을 올려주시기 바랍니다.
- 톰켓 디비에러로그 마지막 부분
tail -n100 /usr/local/jakarta-tomcat-3.2.3/logs/pool.log
- 톰켓 디비설정 부분
cat /usr/local/jakarta-tomcat-3.2.3/webapps/ROOT/WEB-INF/classes/beans/db.properties
자세한 내용은 [Download]메뉴에 가셔서 엔메일 리눅스용 메뉴얼을 다운받아보시기 바랍니다.
감사합니다.
최현철 님이 쓴 글입니다.
--------------------------------------------------------------------
:앤빌더에서 회원가입후 웹메일 클릭을 하면 회원가입이 되지않아 자동으로 회원가입을 한다며 확인 버튼을 누르라고 합니다..
:확인 버튼 클릭후 이러한 에러 메세지가 나옵니다..
:
:Error: 500
:Location: /source/user/interlocker/link_user_insert.jsp
:Internal Servlet Error:
:
:javax.servlet.ServletException
: at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459)
: 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:744)
: 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)
:
:Root cause:
:java.lang.NullPointerException
: at user.table.CheckUser.getCount(CheckUser.java:141)
: 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:511)
: 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)
:
:
:어떠한 증상인지 확인 부탁합니다.
: