After changing the mailet order .... works ! Thanks.
Javier ----- Original Message ----- From: "Noel J. Bergman" <[EMAIL PROTECTED]> To: "James Users List" <[EMAIL PROTECTED]> Sent: Monday, February 17, 2003 7:48 PM Subject: RE: "JDBC Virtual User Table" Mailet problem > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
