org.apache.james.transport.mailets

Class JDBCRecipientRewriteTable

java.lang.Object

org.apache.mailet.base.GenericMailet

org.apache.james.transport.mailets.AbstractRecipientRewriteTable

org.apache.james.transport.mailets.JDBCRecipientRewriteTable

All Implemented Interfaces:

org.apache.mailet.Mailet, org.apache.mailet.MailetConfig

Deprecated.

use the definitions in virtualusertable-store.xml instead

@Deprecated
public class JDBCRecipientRewriteTable
extends AbstractRecipientRewriteTable

Implements a Virtual User Table for JAMES. Derived from the JDBCAlias mailet, but whereas that mailet uses a simple map from a source address to a destination address, this handles simple wildcard selection, verifies that a catchall address is for a domain in the Virtual User Table, and handles forwarding.

JDBCRecipientRewriteTable does not provide any administation tools. You'll have to create the RecipientRewriteTable yourself. The standard configuration is as follows:

 CREATE TABLE RecipientRewriteTable
 (
  user varchar(64) NOT NULL default '',
  domain varchar(255) NOT NULL default '',
  target_address varchar(255) NOT NULL default '',
  PRIMARY KEY (user,domain)
 );
 

The user column specifies the username of the virtual recipient, the domain column the domain of the virtual recipient, and the target_address column the email address of the real recipient. The target_address column can contain just the username in the case of a local user, and multiple recipients can be specified in a list separated by commas, semi-colons or colons.

The standard query used with RecipientRewriteTable is:

 select RecipientRewriteTable.target_address from RecipientRewriteTable, RecipientRewriteTable as VUTDomains
 where (RecipientRewriteTable.user like ? or RecipientRewriteTable.user like "\%")
 and (RecipientRewriteTable.domain like ?
 or (RecipientRewriteTable.domain like "\%" and VUTDomains.domain like ?))
 order by concat(RecipientRewriteTable.user,'@',RecipientRewriteTable.domain) desc limit 1
 

For a given [user, domain, domain] used with the query, this will match as follows (in precedence order):

1. user@domain - explicit mapping for user@domain
2. user@% - catchall mapping for user anywhere
3. %@domain - catchall mapping for anyone at domain
4. null - no valid mapping

You need to set the connection. At the moment, there is a limit to what you can change regarding the SQL Query, because there isn't a means to specify where in the query to replace parameters. [TODO]

 <mailet match="All" class="JDBCRecipientRewriteTable">
   <table>db://maildb/RecipientRewriteTable</table>
   <sqlquery>sqlquery</sqlquery>
 </mailet>
 

Field Summary

Fields

Modifier and Type	Field and Description
protected DataSource	datasource Deprecated.
protected String	query Deprecated. The query used by the mailet to get the alias mapping

Constructor Summary

Constructors

Constructor and Description
JDBCRecipientRewriteTable() Deprecated.

Method Summary

Methods

Modifier and Type	Method and Description
String	getMailetInfo() Deprecated.
void	init() Deprecated. Initialize the mailet
protected void	mapRecipients(Map<org.apache.mailet.MailAddress,String> recipientsMap) Deprecated. Map any virtual recipients to real recipients using the configured JDBC connection, table and query.
void	setDataSourceSelector(DataSource datasource) Deprecated.

Methods inherited from class org.apache.james.transport.mailets.AbstractRecipientRewriteTable

service, setDNSService, setDomainList

Methods inherited from class org.apache.mailet.base.GenericMailet

arrayToString, checkInitParameters, destroy, getInitParameter, getInitParameter, getInitParameter, getInitParameterNames, getMailetConfig, getMailetContext, getMailetName, init, log, log

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

datasource

protected DataSource datasource

Deprecated.

query

protected String query

Deprecated.

The query used by the mailet to get the alias mapping

Constructor Detail

JDBCRecipientRewriteTable

public JDBCRecipientRewriteTable()

Deprecated.

Method Detail

setDataSourceSelector

public void setDataSourceSelector(DataSource datasource)

Deprecated.

init

public void init()
          throws javax.mail.MessagingException

Deprecated.

Initialize the mailet

Overrides:

init in class org.apache.mailet.base.GenericMailet

Throws:

javax.mail.MessagingException

mapRecipients

protected void mapRecipients(Map<org.apache.mailet.MailAddress,String> recipientsMap)
                      throws javax.mail.MessagingException

Deprecated.

Map any virtual recipients to real recipients using the configured JDBC connection, table and query.

Specified by:

mapRecipients in class AbstractRecipientRewriteTable

Parameters:

recipientsMap - the mapping of virtual to real recipients

Throws:

javax.mail.MessagingException

getMailetInfo

public String getMailetInfo()

Deprecated.

Specified by:

getMailetInfo in interface org.apache.mailet.Mailet

Overrides:

getMailetInfo in class org.apache.mailet.base.GenericMailet