You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Javier Storni <ja...@512konline.com.ar> on 2003/02/17 22:24:26 UTC
"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: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: "JDBC Virtual User Table" Mailet problem
Posted by Javier Storni <ja...@512konline.com.ar>.
After changing the mailet order .... works !
Thanks.
Javier
----- Original Message -----
From: "Noel J. Bergman" <no...@devtech.com>
To: "James Users List" <ja...@jakarta.apache.org>
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:javier@512konline.com.ar]
> Sent: Monday, February 17, 2003 16:24
> To: james-user@jakarta.apache.org
> 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: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: "JDBC Virtual User Table" Mailet problem
Posted by "Noel J. Bergman" <no...@devtech.com>.
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:javier@512konline.com.ar]
Sent: Monday, February 17, 2003 16:24
To: james-user@jakarta.apache.org
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: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org