"JDBC Virtual User Table" Mailet problem

[Javier Storni]

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]