You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Steve <sb...@sebscape.com> on 2002/08/14 08:36:18 UTC
Is this an error? Trying to create a hypersonic db store
Hello all.
I am trying to setup James using HypersonicSQL as my db stores. I just downloaded james-2.1a1 in an attempt to start with the latest version (short of CVS).
I have
- modified my SAR-INF/config.xml so that all (I hope) mailets and stores use the db option.
- I have added hypersonic connection parameters to the <database-connections> section.
- I have updated the sqlResources.xml
added dbMatcher for Hypersonic
added sql's for hypersonic
James now starts up without reporting any errors.
I can use the telnet client to add and list users.
I can send emails to James, from james, and within james.
Once, when I was sending an email to myself, I noted the following in the run window:
C:\james-2.1a1\bin>run
Using PHOENIX_HOME: C:\james-2.1a1
Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
Using JAVA_HOME: c:\jdk1.3
Phoenix 4.0a4
James 2.1a1
Started POP3 Server plain:110
Started SMTP Server plain:25
Started NNTP Server plain:119
java.lang.RuntimeException: Did not find a record Mail1029306580132-2 in spool
at org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
epository.java:454)
at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
va:205)
at org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
at org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)
java.lang.RuntimeException: Exception while retrieving mail: Did not find a reco
rd Mail1029306580132-2 in spool
at org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
epository.java:494)
at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
va:205)
at org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
at org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)
However, I did receive the email. Is this a problem? In general, I want to test the setup. What tests would you suggest, and what logs should I look for?
Thanks!
Steve B.
PS - the JDBC How-To makes it sound like you have only to add info to the database-connections section. This may be a bit misleading as there are many places in the config.xml that need to be commented and uncommented. It may be worth listing them as when I eventually realized there were additional changes to be made, it took me a couple tries to find them all...just a suggestion.
RE: Is this an error? Trying to create a hypersonic db store
Posted by Danny Angus <da...@apache.org>.
its is a "known issue", but james runs just fine despite throwing this
exception.
> -----Original Message-----
> From: Steve [mailto:sbelt@sebscape.com]
> Sent: 14 August 2002 07:36
> To: James Users List
> Subject: Is this an error? Trying to create a hypersonic db store
>
>
> Hello all.
>
> I am trying to setup James using HypersonicSQL as my db stores. I
> just downloaded james-2.1a1 in an attempt to start with the
> latest version (short of CVS).
>
> I have
> - modified my SAR-INF/config.xml so that all (I hope) mailets and
> stores use the db option.
> - I have added hypersonic connection parameters to the
> <database-connections> section.
> - I have updated the sqlResources.xml
> added dbMatcher for Hypersonic
> added sql's for hypersonic
>
> James now starts up without reporting any errors.
> I can use the telnet client to add and list users.
> I can send emails to James, from james, and within james.
>
> Once, when I was sending an email to myself, I noted the
> following in the run window:
>
> C:\james-2.1a1\bin>run
> Using PHOENIX_HOME: C:\james-2.1a1
> Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
> Using JAVA_HOME: c:\jdk1.3
>
> Phoenix 4.0a4
>
> James 2.1a1
> Started POP3 Server plain:110
> Started SMTP Server plain:25
> Started NNTP Server plain:119
> java.lang.RuntimeException: Did not find a record
> Mail1029306580132-2 in spool
> at
> org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> epository.java:454)
> at
> org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> va:205)
> at
> org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> ecutableRunnable.java:47)
> at
> org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> .java:80)
> java.lang.RuntimeException: Exception while retrieving mail: Did
> not find a reco
> rd Mail1029306580132-2 in spool
> at
> org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> epository.java:494)
> at
> org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> va:205)
> at
> org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> ecutableRunnable.java:47)
> at
> org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> .java:80)
>
> However, I did receive the email. Is this a problem? In general,
> I want to test the setup. What tests would you suggest, and what
> logs should I look for?
>
> Thanks!
>
> Steve B.
>
> PS - the JDBC How-To makes it sound like you have only to add
> info to the database-connections section. This may be a bit
> misleading as there are many places in the config.xml that need
> to be commented and uncommented. It may be worth listing them as
> when I eventually realized there were additional changes to be
> made, it took me a couple tries to find them all...just a suggestion.
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: (Followup) Is this an error? Trying to create a hypersonic db store
Posted by Steve <sb...@velos.com>.
Actually, there is no special changes made to the config.xml to support
the hypersonicSQL database. The step-3 I added for all the commented-
out sections are the same items which need to be changed for ANY
database. In the JDBC-HowTo, this step is omitted. Since it took so
much of my time, I added it to help others who might need it.
I would suggest, as you say, I send a patch for the sqlResources.xml. The
hypersonic <database-connection> could be added as a commented-out
section of the config.xml just as mysql and oracle examples are included.
Pardon my speaking out of school, but...
In earlier posts by others, it was suggested that database repositories were
suggested over file-system repositories. If hypersonic proves to be solid,
perhaps it should be the default configuration. (This is what the jetspeed
folks do).
Anyway, I will post patches for the committers to consider.
WRT testing, what are the suggested tests?
* so far I have tested (with and without attachments):
* james-account -- mailto --> james-account
* james-account -- mailto --> external-account
* external-account -- mailto --> james-account
* passed all tests at http://www.abuse.net/relay.html
* telnet adduser, listusers, countusers, addforwarding
** Note that although the addforwarding command worked in the
telnet session (as I see the users table updated apparently properly),
the mail does not actually get forwarded. I do not know yet if this is a
bug in my implementation or another unrelated issue.
Steve B.
----- Original Message -----
From: "Danny Angus" <da...@apache.org>
To: "James Users List" <ja...@jakarta.apache.org>
Sent: Wednesday, August 14, 2002 3:14 PM
Subject: RE: (Followup) Is this an error? Trying to create a hypersonic db
store
> A better idea might be to subit a patch for sqlResources and simply a
> paragraph or two of config docs pointing up any specific Hypersonic
heads-up
> to add to http://jakarta.apache.org/james/usingJDBC_v2.0.html
>
> Rather than clutter up an already confusing config file with another
> alternative scheme.
>
> d.
>
>
> > -----Original Message-----
> > From: Noel J. Bergman [mailto:noel@devtech.com]
> > Sent: 14 August 2002 20:26
> > To: James Users List
> > Subject: RE: (Followup) Is this an error? Trying to create a hypersonic
> > db store
> >
> >
> > Steve,
> >
> > Are you going to continue testing, and contribute a diff against
> > sqlResources.xml and james-config.xml so that it can be included
> > in the CVS?
> >
> > Please see: http://jakarta.apache.org/james/contribute.html
> >
> > --- Noel
> >
> > -----Original Message-----
> > From: Steve [mailto:sbelt@velos.com]
> > Sent: Wednesday, August 14, 2002 14:58
> > To: James Users List
> > Subject: Re: (Followup) Is this an error? Trying to create a hypersonic
> > db store
> >
> >
> > I just downloaded the CVS version and verified that the HypersonicSQL
> > "works" on this version. (No heavy testing done, just looped message
> > to myself) Please let me kow if you try this configuration including
> > what worked and what failed.
> >
> > I am also thankful that with this CVS version I now pass the tests on
> > http://www.abuse.net/relay.html!
> >
> > Steve B.
> >
> > ----- Original Message -----
> > From: "Steve" <sb...@velos.com>
> > To: "James Users List" <ja...@jakarta.apache.org>
> > Sent: Wednesday, August 14, 2002 9:41 AM
> > Subject: Re: Is this an error? Trying to create a hypersonic db store
> >
> >
> > > (I am running james-2.1a1 binary dist, jdk1.3, WindowsXP running
> > > james as a service)
> > >
> > > Kudos to the developers! The sqlResources and config.xml
implementation
> > > mad things as simple as they could be.
> > >
> > > I hope it is ok to send attachments to this mail list. Here is the
> > > sqlResources.xml I created for 2.1a1. The following instructions will
> > > setup James to use HypersonicSQL in "stand-alone" mode.
> > >
> > > 1) replace the sqlResources.xml in the /conf directory with the one
> > > attached to this email.
> > > 2) Add the following to the <database-connections> nest. (Note that
the
> > > url will need to be modified to an existing pathname for your
> > installation.):
> > >
> > > <data-source name="maildb"
> > > class="org.apache.james.util.mordred.JdbcDataSource">
> > > <driver>org.hsql.jdbcDriver</driver>
> > >
> >
<dburl>jdbc:HypersonicSQL:<path-to-james>/apps/james/var/james.db</dburl>
> > > <user>sa</user>
> > > <password />
> > > <max>10</max>
> > > </data-source>
> > >
> > > 3) There are many areas in the config.xml which have values for the
file
> > > repository, but also have commented-out equivalents for the database
> > > repository; comment-out the file xml, and uncomment out the db
> > xml. (Hint:
> > > do a text search for "file:". Careful, some of these are the path to
the
> > > sqlResources.xml which should not be changed.)
> > >
> > > 4) Put the HypersonicSQL jar file (hsql.jar) into the <james-home>/lib
> > > folder. You can download it from SourceForge (although IMHO it would
be
> > > nice to distribute with James).
> > >
> > > Start-up James and test it out. You will see that the first
> > time you run,
> > > the database files will automatically be created by HypersonicSQL in
the
> > > directory you indicated in the <dburl>. Note that this is in
stand-alone
> > > mode, so if you would like to interact with the db directly,
> > you will need
> > > to stop james to un-lock the data files.
> > >
> > > HypersonicSQL includes its own interface. chdir to the james/lib
folder
> > > ant type:
> > > java -cp hsql.jar org.hsql.util.DatabaseManager
> > >
> > > I just set this up last night. I sent and received a couple test
> > > messages - in other words, this is not well tested. If you have any
> > problems
> > > related to this setup, let me know. If I can recreate the problem, I
can
> > try
> > > to fix it.
> > >
> > > Steve B.
> > >
> > > PS - If I get a chance, I will try to download the latest CVS today
and
> > > apply the changes there as well.
> > >
> > > ----- Original Message -----
> > > From: "Noel J. Bergman" <no...@devtech.com>
> > > To: "James Users List" <ja...@jakarta.apache.org>
> > > Sent: Wednesday, August 14, 2002 1:41 AM
> > > Subject: RE: Is this an error? Trying to create a hypersonic db store
> > >
> > >
> > > > Steve,
> > > >
> > > > Please submit that information. A lot of users have asked about
using
> > > > HypersonicSQL with James.
> > > >
> > > > Please update to the CVS version. We've made a number of changes
> > > > specifically in the area you were exercising.
> > > >
> > > > If I recall correctly, there is a race condition in the
> > spooler scheme.
> > > > A message is acquired from the spool by a worker thread. The worker
> > > > thread then asks if it can own the message. If another thread has
the
> > > > message locked (in a map), then the worker can't have it, and it
goes
> > > > back to the spool for another. However, if a thread actively
working
> > > > on the message should happen finish, delete and unlock the message
> > between
> > > > the time when the new worker thread tentatively acquires the message
> > from
> > > > the spool to work on and when it sees if someone else has locked it,
> > then
> > > > you'll see that exception.
> > > >
> > > > We've recently done a lot of work in that part of the code, and have
> > > > significantly reduced the possibility of that exception. When it
does
> > > > happen, it is harmless. It simply means that a message was in the
> > > > queue, was pulled from the queue, but was already in use by another
> > thread
> > > > that finished with it and deleted it because there is nothing left
to
> > do.
> > > >
> > > > --- Noel
> > > >
> > > > -----Original Message-----
> > > > From: Steve [mailto:sbelt@sebscape.com]
> > > > Sent: Wednesday, August 14, 2002 2:36
> > > > To: James Users List
> > > > Subject: Is this an error? Trying to create a hypersonic db store
> > > >
> > > >
> > > > Hello all.
> > > >
> > > > I am trying to setup James using HypersonicSQL as my db stores. I
just
> > > > downloaded james-2.1a1 in an attempt to start with the latest
version
> > > > (short of CVS).
> > > >
> > > > I have
> > > > - modified my SAR-INF/config.xml so that all (I hope) mailets
> > and stores
> > > > use the db option.
> > > > - I have added hypersonic connection parameters to the
> > > > <database-connections> section.
> > > > - I have updated the sqlResources.xml
> > > > added dbMatcher for Hypersonic
> > > > added sql's for hypersonic
> > > >
> > > > James now starts up without reporting any errors.
> > > > I can use the telnet client to add and list users.
> > > > I can send emails to James, from james, and within james.
> > > >
> > > > Once, when I was sending an email to myself, I noted the following
in
> > > > the run window:
> > > >
> > > > C:\james-2.1a1\bin>run
> > > > Using PHOENIX_HOME: C:\james-2.1a1
> > > > Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
> > > > Using JAVA_HOME: c:\jdk1.3
> > > >
> > > > Phoenix 4.0a4
> > > >
> > > > James 2.1a1
> > > > Started POP3 Server plain:110
> > > > Started SMTP Server plain:25
> > > > Started NNTP Server plain:119
> > > > java.lang.RuntimeException: Did not find a record
> > Mail1029306580132-2 in
> > > > spool
> > > > at
> > > >
org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> > > > epository.java:454)
> > > > at
> > > >
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> > > > va:205)
> > > > at
> > > >
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> > > > ecutableRunnable.java:47)
> > > > at
> > > >
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> > > > .java:80)
> > > > java.lang.RuntimeException: Exception while retrieving mail: Did not
> > > > find a record Mail1029306580132-2 in spool
> > > > at
> > > >
org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> > > > epository.java:494)
> > > > at
> > > >
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> > > > va:205)
> > > > at
> > > >
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> > > > ecutableRunnable.java:47)
> > > > at
> > > >
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> > > > .java:80)
> > > >
> > > > However, I did receive the email. Is this a problem? In
> > general, I want
> > > > to test the setup. What tests would you suggest, and what
> > logs should I
> > > > look for?
> > > >
> > > > Thanks!
> > > >
> > > > Steve B.
> > > >
> > > > PS - the JDBC How-To makes it sound like you have only to add info
to
> > > > the database-connections section. This may be a bit
> > misleading as there
> > are
> > > > many places in the config.xml that need to be commented and
> > uncommented.
> > It
> > > > may be worth listing them as when I eventually realized there were
> > > > additional changes to be made, it took me a couple tries to find
them
> > all...
> > > > just a suggestion.
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: (Followup) Is this an error? Trying to create a hypersonic db store
Posted by Danny Angus <da...@apache.org>.
A better idea might be to subit a patch for sqlResources and simply a
paragraph or two of config docs pointing up any specific Hypersonic heads-up
to add to http://jakarta.apache.org/james/usingJDBC_v2.0.html
Rather than clutter up an already confusing config file with another
alternative scheme.
d.
> -----Original Message-----
> From: Noel J. Bergman [mailto:noel@devtech.com]
> Sent: 14 August 2002 20:26
> To: James Users List
> Subject: RE: (Followup) Is this an error? Trying to create a hypersonic
> db store
>
>
> Steve,
>
> Are you going to continue testing, and contribute a diff against
> sqlResources.xml and james-config.xml so that it can be included
> in the CVS?
>
> Please see: http://jakarta.apache.org/james/contribute.html
>
> --- Noel
>
> -----Original Message-----
> From: Steve [mailto:sbelt@velos.com]
> Sent: Wednesday, August 14, 2002 14:58
> To: James Users List
> Subject: Re: (Followup) Is this an error? Trying to create a hypersonic
> db store
>
>
> I just downloaded the CVS version and verified that the HypersonicSQL
> "works" on this version. (No heavy testing done, just looped message
> to myself) Please let me kow if you try this configuration including
> what worked and what failed.
>
> I am also thankful that with this CVS version I now pass the tests on
> http://www.abuse.net/relay.html!
>
> Steve B.
>
> ----- Original Message -----
> From: "Steve" <sb...@velos.com>
> To: "James Users List" <ja...@jakarta.apache.org>
> Sent: Wednesday, August 14, 2002 9:41 AM
> Subject: Re: Is this an error? Trying to create a hypersonic db store
>
>
> > (I am running james-2.1a1 binary dist, jdk1.3, WindowsXP running
> > james as a service)
> >
> > Kudos to the developers! The sqlResources and config.xml implementation
> > mad things as simple as they could be.
> >
> > I hope it is ok to send attachments to this mail list. Here is the
> > sqlResources.xml I created for 2.1a1. The following instructions will
> > setup James to use HypersonicSQL in "stand-alone" mode.
> >
> > 1) replace the sqlResources.xml in the /conf directory with the one
> > attached to this email.
> > 2) Add the following to the <database-connections> nest. (Note that the
> > url will need to be modified to an existing pathname for your
> installation.):
> >
> > <data-source name="maildb"
> > class="org.apache.james.util.mordred.JdbcDataSource">
> > <driver>org.hsql.jdbcDriver</driver>
> >
> <dburl>jdbc:HypersonicSQL:<path-to-james>/apps/james/var/james.db</dburl>
> > <user>sa</user>
> > <password />
> > <max>10</max>
> > </data-source>
> >
> > 3) There are many areas in the config.xml which have values for the file
> > repository, but also have commented-out equivalents for the database
> > repository; comment-out the file xml, and uncomment out the db
> xml. (Hint:
> > do a text search for "file:". Careful, some of these are the path to the
> > sqlResources.xml which should not be changed.)
> >
> > 4) Put the HypersonicSQL jar file (hsql.jar) into the <james-home>/lib
> > folder. You can download it from SourceForge (although IMHO it would be
> > nice to distribute with James).
> >
> > Start-up James and test it out. You will see that the first
> time you run,
> > the database files will automatically be created by HypersonicSQL in the
> > directory you indicated in the <dburl>. Note that this is in stand-alone
> > mode, so if you would like to interact with the db directly,
> you will need
> > to stop james to un-lock the data files.
> >
> > HypersonicSQL includes its own interface. chdir to the james/lib folder
> > ant type:
> > java -cp hsql.jar org.hsql.util.DatabaseManager
> >
> > I just set this up last night. I sent and received a couple test
> > messages - in other words, this is not well tested. If you have any
> problems
> > related to this setup, let me know. If I can recreate the problem, I can
> try
> > to fix it.
> >
> > Steve B.
> >
> > PS - If I get a chance, I will try to download the latest CVS today and
> > apply the changes there as well.
> >
> > ----- Original Message -----
> > From: "Noel J. Bergman" <no...@devtech.com>
> > To: "James Users List" <ja...@jakarta.apache.org>
> > Sent: Wednesday, August 14, 2002 1:41 AM
> > Subject: RE: Is this an error? Trying to create a hypersonic db store
> >
> >
> > > Steve,
> > >
> > > Please submit that information. A lot of users have asked about using
> > > HypersonicSQL with James.
> > >
> > > Please update to the CVS version. We've made a number of changes
> > > specifically in the area you were exercising.
> > >
> > > If I recall correctly, there is a race condition in the
> spooler scheme.
> > > A message is acquired from the spool by a worker thread. The worker
> > > thread then asks if it can own the message. If another thread has the
> > > message locked (in a map), then the worker can't have it, and it goes
> > > back to the spool for another. However, if a thread actively working
> > > on the message should happen finish, delete and unlock the message
> between
> > > the time when the new worker thread tentatively acquires the message
> from
> > > the spool to work on and when it sees if someone else has locked it,
> then
> > > you'll see that exception.
> > >
> > > We've recently done a lot of work in that part of the code, and have
> > > significantly reduced the possibility of that exception. When it does
> > > happen, it is harmless. It simply means that a message was in the
> > > queue, was pulled from the queue, but was already in use by another
> thread
> > > that finished with it and deleted it because there is nothing left to
> do.
> > >
> > > --- Noel
> > >
> > > -----Original Message-----
> > > From: Steve [mailto:sbelt@sebscape.com]
> > > Sent: Wednesday, August 14, 2002 2:36
> > > To: James Users List
> > > Subject: Is this an error? Trying to create a hypersonic db store
> > >
> > >
> > > Hello all.
> > >
> > > I am trying to setup James using HypersonicSQL as my db stores. I just
> > > downloaded james-2.1a1 in an attempt to start with the latest version
> > > (short of CVS).
> > >
> > > I have
> > > - modified my SAR-INF/config.xml so that all (I hope) mailets
> and stores
> > > use the db option.
> > > - I have added hypersonic connection parameters to the
> > > <database-connections> section.
> > > - I have updated the sqlResources.xml
> > > added dbMatcher for Hypersonic
> > > added sql's for hypersonic
> > >
> > > James now starts up without reporting any errors.
> > > I can use the telnet client to add and list users.
> > > I can send emails to James, from james, and within james.
> > >
> > > Once, when I was sending an email to myself, I noted the following in
> > > the run window:
> > >
> > > C:\james-2.1a1\bin>run
> > > Using PHOENIX_HOME: C:\james-2.1a1
> > > Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
> > > Using JAVA_HOME: c:\jdk1.3
> > >
> > > Phoenix 4.0a4
> > >
> > > James 2.1a1
> > > Started POP3 Server plain:110
> > > Started SMTP Server plain:25
> > > Started NNTP Server plain:119
> > > java.lang.RuntimeException: Did not find a record
> Mail1029306580132-2 in
> > > spool
> > > at
> > > org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> > > epository.java:454)
> > > at
> > > org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> > > va:205)
> > > at
> > > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> > > ecutableRunnable.java:47)
> > > at
> > > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> > > .java:80)
> > > java.lang.RuntimeException: Exception while retrieving mail: Did not
> > > find a record Mail1029306580132-2 in spool
> > > at
> > > org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> > > epository.java:494)
> > > at
> > > org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> > > va:205)
> > > at
> > > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> > > ecutableRunnable.java:47)
> > > at
> > > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> > > .java:80)
> > >
> > > However, I did receive the email. Is this a problem? In
> general, I want
> > > to test the setup. What tests would you suggest, and what
> logs should I
> > > look for?
> > >
> > > Thanks!
> > >
> > > Steve B.
> > >
> > > PS - the JDBC How-To makes it sound like you have only to add info to
> > > the database-connections section. This may be a bit
> misleading as there
> are
> > > many places in the config.xml that need to be commented and
> uncommented.
> It
> > > may be worth listing them as when I eventually realized there were
> > > additional changes to be made, it took me a couple tries to find them
> all...
> > > just a suggestion.
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: (Followup) Is this an error? Trying to create a hypersonic db store
Posted by "Noel J. Bergman" <no...@devtech.com>.
Steve,
Are you going to continue testing, and contribute a diff against
sqlResources.xml and james-config.xml so that it can be included in the CVS?
Please see: http://jakarta.apache.org/james/contribute.html
--- Noel
-----Original Message-----
From: Steve [mailto:sbelt@velos.com]
Sent: Wednesday, August 14, 2002 14:58
To: James Users List
Subject: Re: (Followup) Is this an error? Trying to create a hypersonic
db store
I just downloaded the CVS version and verified that the HypersonicSQL
"works" on this version. (No heavy testing done, just looped message
to myself) Please let me kow if you try this configuration including
what worked and what failed.
I am also thankful that with this CVS version I now pass the tests on
http://www.abuse.net/relay.html!
Steve B.
----- Original Message -----
From: "Steve" <sb...@velos.com>
To: "James Users List" <ja...@jakarta.apache.org>
Sent: Wednesday, August 14, 2002 9:41 AM
Subject: Re: Is this an error? Trying to create a hypersonic db store
> (I am running james-2.1a1 binary dist, jdk1.3, WindowsXP running
> james as a service)
>
> Kudos to the developers! The sqlResources and config.xml implementation
> mad things as simple as they could be.
>
> I hope it is ok to send attachments to this mail list. Here is the
> sqlResources.xml I created for 2.1a1. The following instructions will
> setup James to use HypersonicSQL in "stand-alone" mode.
>
> 1) replace the sqlResources.xml in the /conf directory with the one
> attached to this email.
> 2) Add the following to the <database-connections> nest. (Note that the
> url will need to be modified to an existing pathname for your
installation.):
>
> <data-source name="maildb"
> class="org.apache.james.util.mordred.JdbcDataSource">
> <driver>org.hsql.jdbcDriver</driver>
>
<dburl>jdbc:HypersonicSQL:<path-to-james>/apps/james/var/james.db</dburl>
> <user>sa</user>
> <password />
> <max>10</max>
> </data-source>
>
> 3) There are many areas in the config.xml which have values for the file
> repository, but also have commented-out equivalents for the database
> repository; comment-out the file xml, and uncomment out the db xml. (Hint:
> do a text search for "file:". Careful, some of these are the path to the
> sqlResources.xml which should not be changed.)
>
> 4) Put the HypersonicSQL jar file (hsql.jar) into the <james-home>/lib
> folder. You can download it from SourceForge (although IMHO it would be
> nice to distribute with James).
>
> Start-up James and test it out. You will see that the first time you run,
> the database files will automatically be created by HypersonicSQL in the
> directory you indicated in the <dburl>. Note that this is in stand-alone
> mode, so if you would like to interact with the db directly, you will need
> to stop james to un-lock the data files.
>
> HypersonicSQL includes its own interface. chdir to the james/lib folder
> ant type:
> java -cp hsql.jar org.hsql.util.DatabaseManager
>
> I just set this up last night. I sent and received a couple test
> messages - in other words, this is not well tested. If you have any
problems
> related to this setup, let me know. If I can recreate the problem, I can
try
> to fix it.
>
> Steve B.
>
> PS - If I get a chance, I will try to download the latest CVS today and
> apply the changes there as well.
>
> ----- Original Message -----
> From: "Noel J. Bergman" <no...@devtech.com>
> To: "James Users List" <ja...@jakarta.apache.org>
> Sent: Wednesday, August 14, 2002 1:41 AM
> Subject: RE: Is this an error? Trying to create a hypersonic db store
>
>
> > Steve,
> >
> > Please submit that information. A lot of users have asked about using
> > HypersonicSQL with James.
> >
> > Please update to the CVS version. We've made a number of changes
> > specifically in the area you were exercising.
> >
> > If I recall correctly, there is a race condition in the spooler scheme.
> > A message is acquired from the spool by a worker thread. The worker
> > thread then asks if it can own the message. If another thread has the
> > message locked (in a map), then the worker can't have it, and it goes
> > back to the spool for another. However, if a thread actively working
> > on the message should happen finish, delete and unlock the message
between
> > the time when the new worker thread tentatively acquires the message
from
> > the spool to work on and when it sees if someone else has locked it,
then
> > you'll see that exception.
> >
> > We've recently done a lot of work in that part of the code, and have
> > significantly reduced the possibility of that exception. When it does
> > happen, it is harmless. It simply means that a message was in the
> > queue, was pulled from the queue, but was already in use by another
thread
> > that finished with it and deleted it because there is nothing left to
do.
> >
> > --- Noel
> >
> > -----Original Message-----
> > From: Steve [mailto:sbelt@sebscape.com]
> > Sent: Wednesday, August 14, 2002 2:36
> > To: James Users List
> > Subject: Is this an error? Trying to create a hypersonic db store
> >
> >
> > Hello all.
> >
> > I am trying to setup James using HypersonicSQL as my db stores. I just
> > downloaded james-2.1a1 in an attempt to start with the latest version
> > (short of CVS).
> >
> > I have
> > - modified my SAR-INF/config.xml so that all (I hope) mailets and stores
> > use the db option.
> > - I have added hypersonic connection parameters to the
> > <database-connections> section.
> > - I have updated the sqlResources.xml
> > added dbMatcher for Hypersonic
> > added sql's for hypersonic
> >
> > James now starts up without reporting any errors.
> > I can use the telnet client to add and list users.
> > I can send emails to James, from james, and within james.
> >
> > Once, when I was sending an email to myself, I noted the following in
> > the run window:
> >
> > C:\james-2.1a1\bin>run
> > Using PHOENIX_HOME: C:\james-2.1a1
> > Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
> > Using JAVA_HOME: c:\jdk1.3
> >
> > Phoenix 4.0a4
> >
> > James 2.1a1
> > Started POP3 Server plain:110
> > Started SMTP Server plain:25
> > Started NNTP Server plain:119
> > java.lang.RuntimeException: Did not find a record Mail1029306580132-2 in
> > spool
> > at
> > org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> > epository.java:454)
> > at
> > org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> > va:205)
> > at
> > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> > ecutableRunnable.java:47)
> > at
> > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> > .java:80)
> > java.lang.RuntimeException: Exception while retrieving mail: Did not
> > find a record Mail1029306580132-2 in spool
> > at
> > org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> > epository.java:494)
> > at
> > org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> > va:205)
> > at
> > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> > ecutableRunnable.java:47)
> > at
> > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> > .java:80)
> >
> > However, I did receive the email. Is this a problem? In general, I want
> > to test the setup. What tests would you suggest, and what logs should I
> > look for?
> >
> > Thanks!
> >
> > Steve B.
> >
> > PS - the JDBC How-To makes it sound like you have only to add info to
> > the database-connections section. This may be a bit misleading as there
are
> > many places in the config.xml that need to be commented and uncommented.
It
> > may be worth listing them as when I eventually realized there were
> > additional changes to be made, it took me a couple tries to find them
all...
> > just a suggestion.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: (Followup) Is this an error? Trying to create a hypersonic db store
Posted by Steve <sb...@velos.com>.
I just downloaded the CVS version and verified that the HypersonicSQL
"works"
on this version. (No heavy testing done, just looped message to myself)
Please
let me kow if you try this configuration including what worked and what
failed.
I am also thankful that with this CVS version I now pass the tests on
http://www.abuse.net/relay.html!
Steve B.
----- Original Message -----
From: "Steve" <sb...@velos.com>
To: "James Users List" <ja...@jakarta.apache.org>
Sent: Wednesday, August 14, 2002 9:41 AM
Subject: Re: Is this an error? Trying to create a hypersonic db store
> (I am running james-2.1a1 binary dist, jdk1.3, WindowsXP running james as
a
> service)
>
> Kudos to the developers! The sqlResources and config.xml implementation
mad
> things as simple as they could be.
>
> I hope it is ok to send attachments to this mail list. Here is the
> sqlResources.xml I created for 2.1a1. The following instructions will
setup
> James to use HypersonicSQL in "stand-alone" mode.
>
> 1) replace the sqlResources.xml in the /conf directory with the one
attached
> to this email.
> 2) Add the following to the <database-connections> nest. (Note that the
url
> will need to be modified to an existing pathname for your installation.):
>
> <data-source name="maildb"
> class="org.apache.james.util.mordred.JdbcDataSource">
> <driver>org.hsql.jdbcDriver</driver>
>
<dburl>jdbc:HypersonicSQL:<path-to-james>/apps/james/var/james.db</dburl>
> <user>sa</user>
> <password />
> <max>10</max>
> </data-source>
>
> 3) There are many areas in the config.xml which have values for the file
> repository, but also have commented-out equivalents for the database
> repository; comment-out the file xml, and uncomment out the db xml. (Hint:
> do a text search for "file:". Careful, some of these are the path to the
> sqlResources.xml which should not be changed.)
>
> 4) Put the HypersonicSQL jar file (hsql.jar) into the <james-home>/lib
> folder. You can download it from SourceForge (although IMHO it would be
nice
> to distribute with James).
>
> Start-up James and test it out. You will see that the first time you run,
> the database files will automatically be created by HypersonicSQL in the
> directory you indicated in the <dburl>. Note that this is in stand-alone
> mode, so if you would like to interact with the db directly, you will need
> to stop james to un-lock the data files.
>
> HypersonicSQL includes its own interface. chdir to the james/lib folder
ant
> type:
> java -cp hsql.jar org.hsql.util.DatabaseManager
>
> I just set this up last night. I sent and received a couple test
messages -
> in other words, this is not well tested. If you have any problems related
to
> this setup, let me know. If I can recreate the problem, I can try to fix
it.
>
> Steve B.
>
> PS - If I get a chance, I will try to download the latest CVS today and
> apply the changes there as well.
>
> ----- Original Message -----
> From: "Noel J. Bergman" <no...@devtech.com>
> To: "James Users List" <ja...@jakarta.apache.org>
> Sent: Wednesday, August 14, 2002 1:41 AM
> Subject: RE: Is this an error? Trying to create a hypersonic db store
>
>
> > Steve,
> >
> > Please submit that information. A lot of users have asked about using
> > HypersonicSQL with James.
> >
> > Please update to the CVS version. We've made a number of changes
> > specifically in the area you were exercising.
> >
> > If I recall correctly, there is a race condition in the spooler scheme.
A
> > message is acquired from the spool by a worker thread. The worker
thread
> > then asks if it can own the message. If another thread has the message
> > locked (in a map), then the worker can't have it, and it goes back to
the
> > spool for another. However, if a thread actively working on the message
> > should happen finish, delete and unlock the message between the time
when
> > the new worker thread tentatively acquires the message from the spool to
> > work on and when it sees if someone else has locked it, then you'll see
> that
> > exception.
> >
> > We've recently done a lot of work in that part of the code, and have
> > significantly reduced the possibility of that exception. When it does
> > happen, it is harmless. It simply means that a message was in the
queue,
> > was pulled from the queue, but was already in use by another thread that
> > finished with it and deleted it because there is nothing left to do.
> >
> > --- Noel
> >
> > -----Original Message-----
> > From: Steve [mailto:sbelt@sebscape.com]
> > Sent: Wednesday, August 14, 2002 2:36
> > To: James Users List
> > Subject: Is this an error? Trying to create a hypersonic db store
> >
> >
> > Hello all.
> >
> > I am trying to setup James using HypersonicSQL as my db stores. I just
> > downloaded james-2.1a1 in an attempt to start with the latest version
> (short
> > of CVS).
> >
> > I have
> > - modified my SAR-INF/config.xml so that all (I hope) mailets and stores
> use
> > the db option.
> > - I have added hypersonic connection parameters to the
> > <database-connections> section.
> > - I have updated the sqlResources.xml
> > added dbMatcher for Hypersonic
> > added sql's for hypersonic
> >
> > James now starts up without reporting any errors.
> > I can use the telnet client to add and list users.
> > I can send emails to James, from james, and within james.
> >
> > Once, when I was sending an email to myself, I noted the following in
the
> > run window:
> >
> > C:\james-2.1a1\bin>run
> > Using PHOENIX_HOME: C:\james-2.1a1
> > Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
> > Using JAVA_HOME: c:\jdk1.3
> >
> > Phoenix 4.0a4
> >
> > James 2.1a1
> > Started POP3 Server plain:110
> > Started SMTP Server plain:25
> > Started NNTP Server plain:119
> > java.lang.RuntimeException: Did not find a record Mail1029306580132-2 in
> > spool
> > at
> > org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> > epository.java:454)
> > at
> > org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> > va:205)
> > at
> > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> > ecutableRunnable.java:47)
> > at
> > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> > .java:80)
> > java.lang.RuntimeException: Exception while retrieving mail: Did not
find
> a
> > reco
> > rd Mail1029306580132-2 in spool
> > at
> > org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> > epository.java:494)
> > at
> > org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> > va:205)
> > at
> > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> > ecutableRunnable.java:47)
> > at
> > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> > .java:80)
> >
> > However, I did receive the email. Is this a problem? In general, I want
to
> > test the setup. What tests would you suggest, and what logs should I
look
> > for?
> >
> > Thanks!
> >
> > Steve B.
> >
> > PS - the JDBC How-To makes it sound like you have only to add info to
the
> > database-connections section. This may be a bit misleading as there are
> many
> > places in the config.xml that need to be commented and uncommented. It
may
> > be worth listing them as when I eventually realized there were
additional
> > changes to be made, it took me a couple tries to find them all...just a
> > suggestion.
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
----------------------------------------------------------------------------
----
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Is this an error? Trying to create a hypersonic db store
Posted by Steve <sb...@velos.com>.
(I am running james-2.1a1 binary dist, jdk1.3, WindowsXP running james as a
service)
Kudos to the developers! The sqlResources and config.xml implementation mad
things as simple as they could be.
I hope it is ok to send attachments to this mail list. Here is the
sqlResources.xml I created for 2.1a1. The following instructions will setup
James to use HypersonicSQL in "stand-alone" mode.
1) replace the sqlResources.xml in the /conf directory with the one attached
to this email.
2) Add the following to the <database-connections> nest. (Note that the url
will need to be modified to an existing pathname for your installation.):
<data-source name="maildb"
class="org.apache.james.util.mordred.JdbcDataSource">
<driver>org.hsql.jdbcDriver</driver>
<dburl>jdbc:HypersonicSQL:<path-to-james>/apps/james/var/james.db</dburl>
<user>sa</user>
<password />
<max>10</max>
</data-source>
3) There are many areas in the config.xml which have values for the file
repository, but also have commented-out equivalents for the database
repository; comment-out the file xml, and uncomment out the db xml. (Hint:
do a text search for "file:". Careful, some of these are the path to the
sqlResources.xml which should not be changed.)
4) Put the HypersonicSQL jar file (hsql.jar) into the <james-home>/lib
folder. You can download it from SourceForge (although IMHO it would be nice
to distribute with James).
Start-up James and test it out. You will see that the first time you run,
the database files will automatically be created by HypersonicSQL in the
directory you indicated in the <dburl>. Note that this is in stand-alone
mode, so if you would like to interact with the db directly, you will need
to stop james to un-lock the data files.
HypersonicSQL includes its own interface. chdir to the james/lib folder ant
type:
java -cp hsql.jar org.hsql.util.DatabaseManager
I just set this up last night. I sent and received a couple test messages -
in other words, this is not well tested. If you have any problems related to
this setup, let me know. If I can recreate the problem, I can try to fix it.
Steve B.
PS - If I get a chance, I will try to download the latest CVS today and
apply the changes there as well.
----- Original Message -----
From: "Noel J. Bergman" <no...@devtech.com>
To: "James Users List" <ja...@jakarta.apache.org>
Sent: Wednesday, August 14, 2002 1:41 AM
Subject: RE: Is this an error? Trying to create a hypersonic db store
> Steve,
>
> Please submit that information. A lot of users have asked about using
> HypersonicSQL with James.
>
> Please update to the CVS version. We've made a number of changes
> specifically in the area you were exercising.
>
> If I recall correctly, there is a race condition in the spooler scheme. A
> message is acquired from the spool by a worker thread. The worker thread
> then asks if it can own the message. If another thread has the message
> locked (in a map), then the worker can't have it, and it goes back to the
> spool for another. However, if a thread actively working on the message
> should happen finish, delete and unlock the message between the time when
> the new worker thread tentatively acquires the message from the spool to
> work on and when it sees if someone else has locked it, then you'll see
that
> exception.
>
> We've recently done a lot of work in that part of the code, and have
> significantly reduced the possibility of that exception. When it does
> happen, it is harmless. It simply means that a message was in the queue,
> was pulled from the queue, but was already in use by another thread that
> finished with it and deleted it because there is nothing left to do.
>
> --- Noel
>
> -----Original Message-----
> From: Steve [mailto:sbelt@sebscape.com]
> Sent: Wednesday, August 14, 2002 2:36
> To: James Users List
> Subject: Is this an error? Trying to create a hypersonic db store
>
>
> Hello all.
>
> I am trying to setup James using HypersonicSQL as my db stores. I just
> downloaded james-2.1a1 in an attempt to start with the latest version
(short
> of CVS).
>
> I have
> - modified my SAR-INF/config.xml so that all (I hope) mailets and stores
use
> the db option.
> - I have added hypersonic connection parameters to the
> <database-connections> section.
> - I have updated the sqlResources.xml
> added dbMatcher for Hypersonic
> added sql's for hypersonic
>
> James now starts up without reporting any errors.
> I can use the telnet client to add and list users.
> I can send emails to James, from james, and within james.
>
> Once, when I was sending an email to myself, I noted the following in the
> run window:
>
> C:\james-2.1a1\bin>run
> Using PHOENIX_HOME: C:\james-2.1a1
> Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
> Using JAVA_HOME: c:\jdk1.3
>
> Phoenix 4.0a4
>
> James 2.1a1
> Started POP3 Server plain:110
> Started SMTP Server plain:25
> Started NNTP Server plain:119
> java.lang.RuntimeException: Did not find a record Mail1029306580132-2 in
> spool
> at
> org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> epository.java:454)
> at
> org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> va:205)
> at
> org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> ecutableRunnable.java:47)
> at
> org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> .java:80)
> java.lang.RuntimeException: Exception while retrieving mail: Did not find
a
> reco
> rd Mail1029306580132-2 in spool
> at
> org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
> epository.java:494)
> at
> org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
> va:205)
> at
> org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
> ecutableRunnable.java:47)
> at
> org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
> .java:80)
>
> However, I did receive the email. Is this a problem? In general, I want to
> test the setup. What tests would you suggest, and what logs should I look
> for?
>
> Thanks!
>
> Steve B.
>
> PS - the JDBC How-To makes it sound like you have only to add info to the
> database-connections section. This may be a bit misleading as there are
many
> places in the config.xml that need to be commented and uncommented. It may
> be worth listing them as when I eventually realized there were additional
> changes to be made, it took me a couple tries to find them all...just a
> suggestion.
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
RE: Is this an error? Trying to create a hypersonic db store
Posted by "Noel J. Bergman" <no...@devtech.com>.
Steve,
Please submit that information. A lot of users have asked about using
HypersonicSQL with James.
Please update to the CVS version. We've made a number of changes
specifically in the area you were exercising.
If I recall correctly, there is a race condition in the spooler scheme. A
message is acquired from the spool by a worker thread. The worker thread
then asks if it can own the message. If another thread has the message
locked (in a map), then the worker can't have it, and it goes back to the
spool for another. However, if a thread actively working on the message
should happen finish, delete and unlock the message between the time when
the new worker thread tentatively acquires the message from the spool to
work on and when it sees if someone else has locked it, then you'll see that
exception.
We've recently done a lot of work in that part of the code, and have
significantly reduced the possibility of that exception. When it does
happen, it is harmless. It simply means that a message was in the queue,
was pulled from the queue, but was already in use by another thread that
finished with it and deleted it because there is nothing left to do.
--- Noel
-----Original Message-----
From: Steve [mailto:sbelt@sebscape.com]
Sent: Wednesday, August 14, 2002 2:36
To: James Users List
Subject: Is this an error? Trying to create a hypersonic db store
Hello all.
I am trying to setup James using HypersonicSQL as my db stores. I just
downloaded james-2.1a1 in an attempt to start with the latest version (short
of CVS).
I have
- modified my SAR-INF/config.xml so that all (I hope) mailets and stores use
the db option.
- I have added hypersonic connection parameters to the
<database-connections> section.
- I have updated the sqlResources.xml
added dbMatcher for Hypersonic
added sql's for hypersonic
James now starts up without reporting any errors.
I can use the telnet client to add and list users.
I can send emails to James, from james, and within james.
Once, when I was sending an email to myself, I noted the following in the
run window:
C:\james-2.1a1\bin>run
Using PHOENIX_HOME: C:\james-2.1a1
Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
Using JAVA_HOME: c:\jdk1.3
Phoenix 4.0a4
James 2.1a1
Started POP3 Server plain:110
Started SMTP Server plain:25
Started NNTP Server plain:119
java.lang.RuntimeException: Did not find a record Mail1029306580132-2 in
spool
at
org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
epository.java:454)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
va:205)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)
java.lang.RuntimeException: Exception while retrieving mail: Did not find a
reco
rd Mail1029306580132-2 in spool
at
org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
epository.java:494)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
va:205)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)
However, I did receive the email. Is this a problem? In general, I want to
test the setup. What tests would you suggest, and what logs should I look
for?
Thanks!
Steve B.
PS - the JDBC How-To makes it sound like you have only to add info to the
database-connections section. This may be a bit misleading as there are many
places in the config.xml that need to be commented and uncommented. It may
be worth listing them as when I eventually realized there were additional
changes to be made, it took me a couple tries to find them all...just a
suggestion.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>