It would be cool if forwarding to multiple addresses were also included in the data model.
Usually several recipients are needed for email addresses like support, info, alerts etc. ----- Original Message ----- From: "Noel J. Bergman" <[EMAIL PROTECTED]> To: "James-Dev Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, August 14, 2002 9:44 AM Subject: [PROPOSAL] JDBCAlias+ > Attach is a SQL proof of concept. I propose to incorporate this into > JDBCAlias. The idea is that JDBCAlias will be able to do the following: > > 1. Map from source-user@source-domain to dest-user@dest-domain. > We use this to map from domain-user@domain to local-user@localhost. > This maintains the existing functionality of JDBCAlias. > > 2. Map from any-user@source-domain to specific-user@dest-domain. > This can be used to implement a catchall address for a domain. > This is NEW functionality. > > 3. Map from specific-user@any-local-domain to specific-user@dest-domain. > The meaning of "any-local-domain" is that although there is a wildcard, > the > match succeeds IFF the requested domain exists somewhere in the domain > column. > This is important because otherwise the wildcard user map could trap > e-mail > intended for relay. > This is NEW functionality. > > If you are using JDBCAlias to support a virtual user table, this change > provides the ability to create a catch-all address for a given domain, and > to easily map a username across all local domains, without having to edit > config.xml for each case. > > The SQL file can be tested by typing mysql < maptest.sql. It uses the test > database, so you have no authentication requirement for this demo. The SQL > file shows the table, a comment showing the prototype query (which will be > used with JDBC), sample data, test results, and a set of test queries. > > The results are the test queries are the comments between the insert > statements and the select statements. > > A few notes about how it works. Part of the key is the ORDER BY clause. I > believe that '%' is always going to be less than a legitimate user or domain > name. This means that user@domain > user@% > %@domain. I believe that to > be the desireable precedence, however, I plan to add a <sqlquery></sqlquery> > child to the mailet config, so that the query can be user replaced. > Replacing the query replaces the mapping policy. But you have to be able to > code the policy in one query. > > The query demonstrated is for MySQL. I don't intend to provide queries for > other SQL servers, but other users can feel free to submit the equivalents. > > Comments are solicited. > > --- Noel > ---------------------------------------------------------------------------- ---- > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
