This:
Checking Mail1045516122530-5 with HostIsLocal
Servicing Mail1045516122530-5 by ToProcessor Mailet
Processed Mail1045516122530-5 through transport
Result was error
comes from:
<mailet match="HostIsLocal" class="ToProcessor">
<processor>error</processor>
</mailet>
HostIsLocal is matching the message(s) and sending through ToProcessor to
the error processor.
What are you trying to accomplish by providing the <sqlquery> configuration
item, and what do you presume that:
<param1>user</param1>
<param2>host</param2>
<param3>host</param3>
does? Generally speaking, all you need is:
<mailet match="All" class="JDBCVirtualUserTable">
<table>db://maildb/VirtualUserTable</table>
</mailet>
Unless you are using something other than MySQL. IIRC, Alan Gerhard posted
the query string for MSSQL a while back. For debugging most mailets, add
<debug>true</debug>
to the mailet configuration.
--- Noel
-----Original Message-----
From: Javier Storni [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 16:24
To: [EMAIL PROTECTED]
Subject: "JDBC Virtual User Table" Mailet problem
Hi.
I have this configuration for processor
******************************************************************
<processor name="transport">
<mailet match="RecipientIsLocal" class="LocalDelivery"/>
<mailet match="All" class="JDBCVirtualUserTable">
<table>db://maildb/VirtualUserTable</table>
<sqlquery>
SELECT VirtualUserTable.target_address
FROM VirtualUserTable, VirtualUserTable AS VUTDomains
WHERE (VirtualUserTable.user like ? OR VirtualUserTable.user like '\\%')
AND (VirtualUserTable.domain like ? OR (VirtualUserTable.domain like
'\\%'
AND VUTDomains.domain like ?))
ORDER BY concat(VirtualUserTable.user,'@',VirtualUserTable.domain) DESC
</sqlquery>
<param1>user</param1>
<param2>host</param2>
<param3>host</param3>
</mailet>
<mailet match="HostIsLocal" class="ToProcessor">
<processor>error</processor>
</mailet>
<mailet match="All" class="RemoteDelivery">
<outgoing> db://maildb/spool/outgoing </outgoing>
<delayTime> 21600000 </delayTime>
<maxRetries> 5 </maxRetries>
<deliveryThreads> 1 </deliveryThreads>
<!--
<gateway> otherserver.mydomain.com </gateway>
<gatewayPort>25</gatewayPort>
-->
</mailet>
</processor>
******************************************************************
Every time I send a message to an alias ( wich is defined in table
virtualusertable ), I don't get any error message on the postmaster box, and
the only error message in logs is
**************************************************************
17/02/03 18:08:42 DEBUG spoolmanager: ==== Begin processing mail
Mail1045516122530-5====
17/02/03 18:08:42 DEBUG spoolmanager: Processing Mail1045516122530-5 through
transport
17/02/03 18:08:42 DEBUG spoolmanager.transport: Servicing mail:
Mail1045516122530-5
17/02/03 18:08:42 DEBUG spoolmanager.transport: Checking Mail1045516122530-5
with org.apache.james.transport.matchers.RecipientIsLocal@402af3
17/02/03 18:08:42 DEBUG spoolmanager.transport: Checking Mail1045516122530-5
with org.apache.james.transport.matchers.All@11f23e5
17/02/03 18:08:42 DEBUG spoolmanager.transport: Servicing
Mail1045516122530-5 by JDBC Virtual User Table mailet
17/02/03 18:08:42 DEBUG spoolmanager.transport: Checking Mail1045516122530-5
with org.apache.james.transport.matchers.HostIsLocal@16dc861
17/02/03 18:08:42 DEBUG spoolmanager.transport: Servicing
Mail1045516122530-5 by ToProcessor Mailet
17/02/03 18:08:43 DEBUG spoolmanager: Processed Mail1045516122530-5 through
transport
17/02/03 18:08:43 DEBUG spoolmanager: Result was error
**************************************************************
"I'am completely lost "
Thanks in advance.
Javier Storni
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
