[
https://issues.apache.org/jira/browse/JAMES-745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12462194
]
Norman Maurer commented on JAMES-745:
-------------------------------------
Any news one this ? I whould like to fix this issue ... I whould use 1)
> XMLVirtualUserTable and JDBCVirtualUserTable not work symetric
> --------------------------------------------------------------
>
> Key: JAMES-745
> URL: https://issues.apache.org/jira/browse/JAMES-745
> Project: James
> Issue Type: Bug
> Affects Versions: 2.2.0, 2.3.0
> Reporter: Norman Maurer
> Fix For: Next Major
>
>
> from ml:
> Looking at the virtualusertable query I see that if I only add the rule
> user=bago
> domain=%
> [EMAIL PROTECTED]
> It will never alias any recipient: neither [EMAIL PROTECTED] nor [EMAIL
> PROTECTED]
> If I instead add another generic mapping referring to the domain like:
> user=nonexistinguser
> domain=somedomain
> [EMAIL PROTECTED]
> (yes, this does not change anything, but I need to add it to make the
> previous work)
> Then a message to [EMAIL PROTECTED] will be rewritten to [EMAIL PROTECTED]
> This is the query:
> --
> 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
> LIMIT 1
> ---
> And the key/guilty part is the self-join and the "AND VUTDomains.domain like
> ?"
> This mean that domain=% will match any domain already used in another rule.
> This is not documented anywhere and I also think this is not an intended
> behaviour.
> Was this hack used to try to alias only local domains?
> Should we change it to consider % valid for any local domain (specified in
> servernames) even if not used in other mapping rules and document it this way?
> Do we need to introduce a new wildcard to specify ANY domain (even the non
> local)?
> On the other side the XMLVirtualUserTable seems to have not such behaviour
> and to always rewrite any domain, even remote one or domains not used in
> other mapping rules.
> So what is the intended behaviour? I think that is really bad that XML and
> JDBC behave differently wrt this issue.
> My preference is:
> 1) use the XML behaviour by default when using %
> 2) optionally introduce later a new wildcart to match only local domains
> (this can be already achieved by using HostIsLocal matcher for the virtual
> users table.
> This means: remove the self join and the where condition on VUTDomains from
> JDBCVirtualUserTable.
> WDYT?
> Stefano
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
