[Jboss-dev-forums] [Design of Mail Services] - Re: Help...

[wobbet <nu...@jb...>]

Okay, that helped a bit...

Some quick notes...

1 - I *am* using Putty as my telnet, not the Win32 telnet. The only time I =
use a CLI telnet is if I'm on the Linux machine hosting the app.

2 - I *tried* to use Outlook to connect to the mailserver but Outlook refus=
es to connect. I'm trying to figure out why. Do I need to reconfigure my do=
mains? What needs to happen?

So when I now go into telnet using the instructions given I am theoreticall=
y able to send email but when I check the mailbox using the LISt command th=
ere is nothing in there. It could be that I'm not sending properly for what=
ever reason. Here's my JBoss log for info on the sending and the receiving =
including a SQLException when trying to check mail that indicates that my m=
ail store hasn't been setup.=20

Do I need to do something to change the mail store? I do *not* have mySQL i=
nstalled on that machine. I *do* have PostgreSQL installed. Is there someth=
ing that I need to do to get the store configured?

Thanks!

rjsjr

2005-05-04 16:16:02,671 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] colonI=
ndex=3D4
  | 2005-05-04 16:16:02,671 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] se=
nder=3D<wo...@lo...>
  | 2005-05-04 16:16:02,672 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] ar=
g=3DFROM
  | 2005-05-04 16:16:02,672 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] Se=
nder=3D <wo...@lo...> **arg =3D FROM
  | 2005-05-04 16:16:02,672 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:16:10,172 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting RCPT TO:<wo...@lo...>^M
  | 2005-05-04 16:16:10,173 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:16:10,173 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D RCPT
  | 2005-05-04 16:16:10,173 DEBUG [org.jboss.mail.smtp.handlers.CmdRCPT] RC=
PT command handler called
  | 2005-05-04 16:16:10,174 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HANDLE AUTH
  | 2005-05-04 16:16:10,175 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:16:33,729 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting RSET^M
  | 2005-05-04 16:16:33,730 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:16:33,730 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D RSET
  | 2005-05-04 16:16:33,730 DEBUG [org.jboss.mail.smtp.handlers.CmdRSET] RS=
ET command handler called
  | 2005-05-04 16:16:33,731 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:16:33,795 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting MAIL FROM:<wo...@lo...>^M
  | 2005-05-04 16:16:33,795 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:16:33,795 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D MAIL
  | 2005-05-04 16:16:33,796 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] MA=
IL command handler called
  | 2005-05-04 16:16:33,796 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] ar=
g =3D FROM:<wo...@lo...>
  | 2005-05-04 16:16:33,796 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] ar=
g wasn't null
  | 2005-05-04 16:16:33,797 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] co=
lonIndex=3D4
  | 2005-05-04 16:16:33,797 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] se=
nder=3D<wo...@lo...>
  | 2005-05-04 16:16:33,797 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] ar=
g=3DFROM
  | 2005-05-04 16:16:33,797 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] Se=
nder=3D <wo...@lo...> **arg =3D FROM
  | 2005-05-04 16:16:33,798 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:16:33,855 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting RCPT TO:<wo...@lo...>^M
  | 2005-05-04 16:16:33,855 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:16:33,855 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D RCPT
  | 2005-05-04 16:16:33,856 DEBUG [org.jboss.mail.smtp.handlers.CmdRCPT] RC=
PT command handler called
  | 2005-05-04 16:16:33,857 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HANDLE AUTH
  | 2005-05-04 16:16:33,857 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:16:33,914 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting DATA^M
  | 2005-05-04 16:16:33,914 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:16:33,915 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D DATA
  | 2005-05-04 16:16:33,730 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D RSET
  | 2005-05-04 16:16:33,730 DEBUG [org.jboss.mail.smtp.handlers.CmdRSET] RS=
ET command handler called
  | 2005-05-04 16:16:33,731 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:16:33,795 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting MAIL FROM:<wo...@lo...>^M
  | 2005-05-04 16:16:33,795 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:16:33,795 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D MAIL
  | 2005-05-04 16:16:33,796 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] MA=
IL command handler called
  | 2005-05-04 16:16:33,796 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] ar=
g =3D FROM:<wo...@lo...>
  | 2005-05-04 16:16:33,796 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] ar=
g wasn't null
  | 2005-05-04 16:16:33,797 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] co=
lonIndex=3D4
  | 2005-05-04 16:16:33,797 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] se=
nder=3D<wo...@lo...>
  | 2005-05-04 16:16:33,797 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] ar=
g=3DFROM
  | 2005-05-04 16:16:33,797 DEBUG [org.jboss.mail.smtp.handlers.CmdMAIL] Se=
nder=3D <wo...@lo...> **arg =3D FROM
  | 2005-05-04 16:16:33,798 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:16:33,855 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting RCPT TO:<wo...@lo...>^M
  | 2005-05-04 16:16:33,855 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:16:33,855 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D RCPT
  | 2005-05-04 16:16:33,856 DEBUG [org.jboss.mail.smtp.handlers.CmdRCPT] RC=
PT command handler called
  | 2005-05-04 16:16:33,857 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HANDLE AUTH
  | 2005-05-04 16:16:33,857 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:16:33,914 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting DATA^M
  | 2005-05-04 16:16:33,914 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:16:33,915 DEBUG [org.jboss.mail.smtp.SMTPProtocolInstance=
] HandleRequest called with command =3D DATA
  | 2005-05-04 16:16:33,915 DEBUG [org.jboss.mail.smtp.handlers.CmdDATA] DA=
TA command handler called
  | 2005-05-04 16:16:33,924 DEBUG [org.jboss.mail.message.Mail] MAIL constr=
uctor called
  | 2005-05-04 16:16:33,978 INFO  [org.jboss.mail.message.Mail] all headers=
 after loading: MailHeadersImpl (5): [hdr(Received =3D 'Received: from wobb=
et-lap-01.nls.nlsholdings.com.localdomain.com (10.10.1.147 10.10.1.147) by =
localhost.localdomain.com/JBossMail 1.0M3 (192.168.69.17)^M
  |         with SMTP id 1115241393962582.6855980296583; Wed, 4 May 2005 16=
:16:33 -0500 (CDT)'), hdr(random noise =3D 'random noise'), hdr(more random=
 noise =3D 'more random noise'), hdr(Content-Type =3D 'Content-Type: text/p=
lain; charset=3Dus-ascii'), hdr(Content-Transfer-Encoding =3D 'Content-Tran=
sfer-Encoding: 8bit')]
  | 2005-05-04 16:17:08,817 INFO  [org.jboss.mail.Server] Got request
  | 2005-05-04 16:17:08,819 INFO  [org.jboss.mail.Server] waiting for reque=
st
  | 2005-05-04 16:17:10,538 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting =C3=AF=C2=BF=C2=BF<fffb>^_=C3=AF=C2=BF=C2=BF<fffb> =C3=AF=
=C2=BF=C2=BF<fffb>^X=C3=AF=C2=BF=C2=BF<fff<fffb>^C=C3=AF=C2=BF=C2=BF=C3=AF=
=C2=BF=C2=BD
  | 2005-05-04 16:17:10,538 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] Got commandString: =C3=AF=C2=BF=C2=BF<fffb>^_=C3=AF=C2=BF=C2=BF<fffb> =C3=
=AF=C2=BF=C2=BF<fffb>^X=C3=AF=C2=BF=C3=AF=C2=BF=C2=BF=C3=AF=C2=BF=C2=BD^A=
=C3=AF=C2=BF=C2=BF<fffb>^C
  | 2005-05-04 16:17:10,539 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:17:10,539 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] HandleRequest called with command =3D =C3=AF=C2=BF=C2=BF<fffb>^_=C3=AF=C2=
=BF=C2=BF<fffb>     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMe=
thodAccessorImpl.java:39)
  | 2005-05-04 16:17:10,545 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:17:18,461 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting HELO localhost.localdomain.com^M
  | 2005-05-04 16:17:18,462 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:17:18,462 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] HandleRequest called with command =3D HELO
  | 2005-05-04 16:17:18,463 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:18:05,879 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting USER wobbet^M
  | 2005-05-04 16:18:05,879 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] Got commandString: USER wobbet^M
  | 2005-05-04 16:18:05,880 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:18:05,880 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] HandleRequest called with command =3D USER
  | 2005-05-04 16:18:05,880 DEBUG [org.jboss.mail.pop3.handlers.CmdUSER] US=
ER command handler called
  | 2005-05-04 16:18:05,882 WARN  [org.jboss.mail.pop3.handlers.CmdUSER] po=
p username set to wobbet
  | 2005-05-04 16:18:05,883 INFO  [STDOUT] socketOverride is null therefore=
 I'm going to return false
  | 2005-05-04 16:18:34,926 DEBUG [org.jboss.mail.AbstractProtocol] ReadCom=
mand outputting PASS testpass^M
  | 2005-05-04 16:18:34,926 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] Got commandString: PASS testpass^M
  | 2005-05-04 16:18:34,927 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] HandleRequest called with request =3D false
  | 2005-05-04 16:18:34,927 DEBUG [org.jboss.mail.pop3.POP3ProtocolInstance=
] HandleRequest called with command =3D PASS
  | 2005-05-04 16:18:34,927 DEBUG [org.jboss.mail.pop3.handlers.CmdPASS] PA=
SS command handler called
  | 2005-05-04 16:18:34,945 WARN  [org.jboss.mail.mailbox.entity.EntityFold=
er] folder requested for Entityfolder=3Dwobbet
  | 2005-05-04 16:18:35,163 DEBUG [org.jboss.mail.mailbox.entity.message.Me=
ssageBean] MessageBean Entity EJB Created.
  | 2005-05-04 16:18:35,189 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQL=
Query.EntityMessage#findByFolderName] Executing SQL: SELECT t0_a.id, t0_a.f=
olderName, t0_a.headers, t0_a.body, t0_a.bodyType, t0_a.storeId FROM ENTITY=
MESSAGE t0_a WHERE (t0_a.folderName =3D ?)
  | 2005-05-04 16:18:35,200 WARN  [org.jboss.resource.security.ConfiguredId=
entityLoginModule] Creating LoginModule with no configured password!
  | 2005-05-04 16:18:35,214 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQL=
Query.EntityMessage#findByFolderName] Find failed
  | java.sql.SQLException: Column not found: T0_A.BODYTYPE in statement [SE=
LECT t0_a.id, t0_a.folderName, t0_a.headers, t0_a.body, t0_a.bodyType, t0_a=
.storeId FROM ENTITYMESSAGE t0_a WHERE (t0_a.folderName =3D ?)]
  |         at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
  |         at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
  |         at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Sour=
ce)
  |         at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection=
.prepareStatement(BaseWrapperManagedConnection.java:355)
  |         at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareSta=
tement(WrappedConnection.java:205)
  |         at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.exec=
ute(JDBCAbstractQueryCommand.java:190)
  |         at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.exec=
ute(JDBCAbstractQueryCommand.java:128)
  |         at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execu=
te(JDBCFindEntitiesCommand.java:40)
  |         at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities=
(JDBCStoreManager.java:598)
  |         at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMP=
PersistenceManager.java:322)
  |         at org.jboss.resource.connectionmanager.CachedConnectionInterce=
ptor.findEntities(CachedConnectionInterceptor.java:321)
  |=20
  |=20
  |=20

View the original post : http://www.jboss.org/index.html?module=3Dbb&op=3Dv=
iewtopic&p=3D3876497#3876497

Reply to the post : http://www.jboss.org/index.html?module=3Dbb&op=3Dpostin=
g&mode=3Dreply&p=3D3876497