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

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

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

주말에도 답글주시는 관리자님 감사 합니다 안되서 다시함더 부탁 드립니다..

정*수 2003.09.28 17:11 조회 728

지금저의 디비유저 환경입니다..
관리자님깨서 주신정보대로 따라 했습니다..
mysql> SELECT Host, User, Password FROM user WHERE User='nmail';
+-----------------------+-------+------------------+
| Host | User | Password |
+-----------------------+-------+------------------+
| localhost | nmail | 0af56ab35464301d |
| localhost.localdomain | nmail | 0af56ab35464301d |
| 127.0.0.1 | nmail | 0af56ab35464301d |
+-----------------------+-------+------------------+
3 rows in set (0.00 sec)

mysql> SELECT Host, User, Db FROM db WHERE User='nmail';
+-----------------------+-------+-------+
| Host | User | Db |
+-----------------------+-------+-------+
| localhost | nmail | nmail |
| localhost.localdomain | nmail | nmail |
| localhost.127.0.0.1 | nmail | nmail |
| 127.0.0.1 | nmail | nmail |
+-----------------------+-------+-------+
4 rows in set (0.00 sec)

mysql>


여기는 로그 환경입니다..

[****@**** bin]# tail -n100 /usr/local/jakarta-tomcat-3.2.3/logs/pool.log
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:232)
at java.beans.Beans.instantiate(Beans.java:202)
at java.beans.Beans.instantiate(Beans.java:46)
at source._0002fsource_0002findex_0002ejspindex_jsp_0._jspService(_0002fsource_0002findex_0002ej
spindex_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:479)
Tue Sep 23 05:56:21 KST 2003: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Tue Sep 23 05:56:21 KST 2003: Initialized pool mydb
Tue Sep 23 05:56:21 KST 2003: Initialized pool mydb2
Tue Sep 23 05:56:21 KST 2003: Can't create a new connection for jdbc:mysql://152.149.66.228:3306/nmail?u
seUnicode=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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:172)
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:232)
at java.beans.Beans.instantiate(Beans.java:202)
at java.beans.Beans.instantiate(Beans.java:46)
at source._0002fsource_0002findex_0002ejspindex_jsp_0._jspService(_0002fsource_0002findex_0002ej
spindex_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:479)
Tue Sep 23 11:31:30 KST 2003: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Tue Sep 23 11:31:30 KST 2003: Initialized pool mydb
Tue Sep 23 11:31:30 KST 2003: Initialized pool mydb2
Tue Sep 23 11:31:30 KST 2003: Created a new connection in pool mydb
Tue Sep 23 11:32:37 KST 2003: Created a new connection in pool mydb
Tue Sep 23 11:55:32 KST 2003: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Tue Sep 23 11:55:32 KST 2003: Initialized pool mydb
Tue Sep 23 11:55:32 KST 2003: Initialized pool mydb2
Tue Sep 23 11:55:32 KST 2003: Created a new connection in pool mydb
Tue Sep 23 11:55:39 KST 2003: Created a new connection in pool mydb
Wed Sep 24 23:38:42 KST 2003: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Wed Sep 24 23:38:42 KST 2003: Initialized pool mydb
Wed Sep 24 23:38:42 KST 2003: Initialized pool mydb2
Wed Sep 24 23:38:42 KST 2003: Created a new connection in pool mydb
Wed Sep 24 23:38:48 KST 2003: Created a new connection in pool mydb
Thu Sep 25 14:54:23 KST 2003: Removed bad connection from mydb
Thu Sep 25 14:54:24 KST 2003: Removed bad connection from mydb
Thu Sep 25 14:54:24 KST 2003: Created a new connection in pool mydb
Thu Sep 25 14:54:30 KST 2003: Created a new connection in pool mydb
Thu Sep 25 15:54:00 KST 2003: Created a new connection in pool mydb2
Sun Sep 28 09:46:51 KST 2003: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Sun Sep 28 09:46:51 KST 2003: Initialized pool mydb
Sun Sep 28 09:46:51 KST 2003: Initialized pool mydb2
Sun Sep 28 09:46:51 KST 2003: Created a new connection in pool mydb
Sun Sep 28 09:47:08 KST 2003: Created a new connection in pool mydb
Sun Sep 28 10:50:02 KST 2003: Created a new connection in pool mydb
Sun Sep 28 16:54:44 KST 2003: JDBC driver 등록 :org.gjt.mm.mysql.Driver
Sun Sep 28 16:54:44 KST 2003: Initialized pool mydb
Sun Sep 28 16:54:44 KST 2003: Initialized pool mydb2
Sun Sep 28 16:54:44 KST 2003: Created a new connection in pool mydb
Sun Sep 28 16:54:50 KST 2003: Created a new connection in pool mydb
Sun Sep 28 16:55:43 KST 2003: Created a new connection in pool mydb
[****@**** bin]#


그리고 로그 환경과 탐켓 디비 환경입니다...


[****@**** 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://localhost:3306/nmail?useUnicode=true&characterEncoding=euc-kr
mydb.maxconn=0
mydb.user=nmail
mydb.password=nmail

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

메일보내는 사이트는뜨는데 메일 발송했을때 메일발송실폐 라고 뜨고
여전히 메일은 나가지는 않네요.. 그리고 외부에서 메일을 받어 보면 들어 오기는 오는데
"제목없음" 그리고 받을 매일을 확인하면 아무것도 없어요 보낸 사람 메일주소도 없고.
아무정보도 볼수가없습니다..

killall java 해보기도 했고
지금 데몬을 실행 하기 전에 제 서버는
[****@**** local]# telnet localhost 110
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
[****@**** local]# telnet localhost 25
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
[****@**** local]#

이렇습니다

댓글 1
이전 글 nWmail 보안계정 로그인 1 차*성 2003.09.28
다음 글 이것도 이상한!!! 1 정*수 2003.09.28