I am trying to configure and set up a new Apache James 3.2.0 email
server and running into troubles getting it to work, though I think I am
close. I am not sure what all info I need to provide so feel free to ask
for more... The server is coming up and running but when I try to send
an email through it, the client seems to think all goes well but the
james.server.log file is showing bad things... And nothing is being
received through the IMAP side... So can a kind guru decipher this stack
walkback and give me a clue on how to fix and make James a happy camper?
I won't show the entire stack walkback just what I think are the
highlights, but if anyone wants the whole thing I certainly can provide
it. Thanks in advance... Marc
INFO 20:02:43,990 |
org.apache.james.metrics.logger.DefaultMetricFactory | Time spent in
IMAP-NOOP: 0 ms.
INFO 20:02:44,008 |
org.apache.james.metrics.logger.DefaultMetricFactory | Time spent in
IMAP-GETQUOTAROOT: 1 ms.
INFO 20:02:44,048 |
org.apache.james.metrics.logger.DefaultMetricFactory | Time spent in
IMAP-IDLE: 1 ms.
INFO 20:03:39,582 |
org.apache.james.protocols.netty.BasicChannelUpstreamHandler |
Connection established from 10.10.10.1
INFO 20:03:39,963 | org.apache.james.smtpserver.SendMailHandler |
Successfully spooled mail
Mail1548389019876-bafd9328-095e-4b22-8a2e-d4c18fb74522 from
MaybeSender{mailAddress=Optional[myn...@mydomain.com]} on
10.10.10.1/10.10.10.1 for [myn...@mydomain.com]
INFO 20:03:39,978 |
org.apache.james.protocols.netty.BasicChannelUpstreamHandler |
Connection closed for 10.10.10.1
WARN 20:03:39,996 |
org.apache.james.transport.mailets.RecipientRewriteTableProcessor |
Could not rewrite recipient myn...@mydomain.com
org.apache.james.rrt.api.RecipientRewriteTableException: Error while
retrieve mappings
at
org.apache.james.rrt.jpa.JPARecipientRewriteTable.getMapping(JPARecipientRewriteTable.java:107)
at
org.apache.james.rrt.jpa.JPARecipientRewriteTable.mapAddress(JPARecipientRewriteTable.java:79)
at
org.apache.james.rrt.lib.AbstractRecipientRewriteTable.getMappings(AbstractRecipientRewriteTable.java:110)
at
org.apache.james.rrt.lib.AbstractRecipientRewriteTable.getMappings(AbstractRecipientRewriteTable.java:99)
at
org.apache.james.transport.mailets.RecipientRewriteTableProcessor.executeRrtForRecipient(RecipientRewriteTableProcessor.java:164)
at
org.apache.james.transport.mailets.RecipientRewriteTableProcessor.lambda$executeRrtFor$1(RecipientRewriteTableProcessor.java:153)
at
java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
at java.util.Collections$2.tryAdvance(Collections.java:4717)
at java.util.Collections$2.forEachRemaining(Collections.java:4725)
at
java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
at
java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
at
java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
at
java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at
java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:474)
at
org.apache.james.transport.mailets.RecipientRewriteTableProcessor.executeRrtFor(RecipientRewriteTableProcessor.java:159)
at
org.apache.james.transport.mailets.RecipientRewriteTableProcessor.processMail(RecipientRewriteTableProcessor.java:129)
at
org.apache.james.transport.mailets.RecipientRewriteTable.service(RecipientRewriteTable.java:88)
at
org.apache.james.mailetcontainer.impl.camel.CamelProcessor.process(CamelProcessor.java:81)
at
org.apache.james.mailetcontainer.impl.camel.CamelMailetProcessor$MailetContainerRouteBuilder.handleMailet(CamelMailetProcessor.java:178)
at
org.apache.james.mailetcontainer.impl.camel.CamelMailetProcessor$MailetContainerRouteBuilder.lambda$configure$0(CamelMailetProcessor.java:155)
yada yada yada - some walkback messages deleted here....
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: <openjpa-3.0.0-r422266:1833209 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Could not set
parameter at position 2 (values was 'mydomain.com')
Query - conn:47(M) - "SELECT t0.DOMAIN_NAME, t0.USER_NAME,
t0.TARGET_ADDRESS FROM JAMES_RECIPIENT_REWRITE t0 WHERE (t0.USER_NAME
LIKE ? ESCAPE '\\' AND t0.DOMAIN_NAME LIKE ? ESCAPE '\\') ORDER BY
t0.DOMAIN_NAME DESC"
FailedObject: SELECT rrt FROM JamesRecipientRewrite rrt WHERE (rrt.user
LIKE :user) and (rrt.domain like :domain) ORDER BY rrt.domain DESC
[java.lang.String]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5038)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4998)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
yada yada yada - some walkback messages deleted here....
at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:290)
at
org.apache.james.rrt.jpa.JPARecipientRewriteTable.getMapping(JPARecipientRewriteTable.java:96)
... 81 more
Caused by: java.sql.SQLException: Could not set parameter at position 2
(values was 'mydomain.com')
Query - conn:47(M) - "SELECT t0.DOMAIN_NAME, t0.USER_NAME,
t0.TARGET_ADDRESS FROM JAMES_RECIPIENT_REWRITE t0 WHERE (t0.USER_NAME
LIKE ? ESCAPE '\\' AND t0.DOMAIN_NAME LIKE ? ESCAPE '\\') ORDER BY
t0.DOMAIN_NAME DESC"
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getSqlException(ExceptionMapper.java:271)
at
org.mariadb.jdbc.MariaDbPreparedStatementClient.setParameter(MariaDbPreparedStatementClient.java:480)
at
org.mariadb.jdbc.BasePrepareStatement.setString(BasePrepareStatement.java:1533)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
--
Linux Counter
