You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by Kev Jackson <fo...@gmail.com> on 2007/12/13 08:59:08 UTC

Strange spam repository problem with svn trunk

Hi all,

Another strange one ;p

In mailstore-....log, I see :
13/12/07 02:35:58 INFO  mailstore: JdbcMailRepository 'null, table 
'spams': JDBC Mail Attributes support ready.
13/12/07 02:35:58 INFO  mailstore: added repository: 
db://maildb/spams/MAIL->org.apache.james.mailrepository.JDBCMailRepository

But when I send an email I see :
13/12/07 02:35:58 INFO  mailstore: added repository: 
file://var/mail/relay-denied/MAIL->org.apache.james.mailrepository.AvalonMailRepository
13/12/07 02:37:41 INFO  mailstore: JdbcMailRepository 'sylvain, table 
'inboxes': JDBC Mail Attributes support ready.
13/12/07 02:37:41 INFO  mailstore: added repository: 
db://maildb/inboxes/sylvain/MAIL->org.apache.james.mailrepository.JDBCMailRepository
13/12/07 02:57:38 INFO  mailstore: JdbcMailRepository 'sylvain, table 
'inboxes': JDBC Mail Attributes support ready.
13/12/07 02:57:38 INFO  mailstore: added repository: 
db://maildb/inboxes/sylvain/MAIL->org.apache.james.mailrepository.JDBCMailRepository
13/12/07 03:07:41 INFO  mailstore: JdbcMailRepository 'sylvain, table 
'inboxes': JDBC Mail Attributes support ready.
13/12/07 03:07:41 INFO  mailstore: added repository: 
db://maildb/inboxes/sylvain/MAIL->org.apache.james.mailrepository.JDBCMailRepository
13/12/07 03:15:28 ERROR mailstore: Exception caught while storing mail 
Mail1197533708499-0
java.io.IOException: ERROR: null value in column "repository_name" 
violates not-null constraint
         at 
org.apache.james.mailrepository.JDBCMailRepository.internalStore(JDBCMailRepository.java:667)
         at 
org.apache.james.mailrepository.AbstractMailRepository.store(AbstractMailRepository.java:145)
         at 
org.apache.james.transport.mailets.ToRepository.service(ToRepository.java:100)
         at 
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:451)
         at 
org.apache.james.transport.StateAwareProcessorList.service(StateAwareProcessorList.java:167)
         at 
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:206)
         at java.lang.Thread.run(Thread.java:595)


This looks like there's a configuration problem.  The destinationURL is 
used to determine where to store normal mails (db://maildb/inboxes), and 
in our spam processor config we have a ToRepository mailet setup like so:
<mailet match="All" class="ToRepository">
   <repositoryPath> db://maildb/spams/ </repositoryPath>
</mailet>

When we send an email, James parses the destinationURL and successfully 
determines that we want to store the mail in a table (inboxes) with a 
repository_name of sylvain.  But when the mail is spam (which this mail 
is), it cannot determine the correct repository_name (it thinks it's 
null as you can see from the first part of mailstore log above).

I've just updated the servers with the latest code, and this didn't 
happen previously, so it's either a bug in the code, or a problem with 
my config which I also had to update.

Looking at JDBCMailRepository, I cannot see where it would determine the 
repository_name when sending an email, but I guess that it adds the spam 
repository at startup, when it should be adding it dynamically (when a 
user receives a mail that's spam).

Thanks,
Kev



---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org