[jira] Commented: (JAMES-528) Add whitelist support
[ http://issues.apache.org/jira/browse/JAMES-528?page=comments#action_12415823 ] Vincenzo Gianferrari Pini commented on JAMES-528: - The difference between the existing matchers like SenderIsLocal or SenderIsRegex and the new IsInWhiteList matcher consists in the fact that the latter is not "static" (list hardcoded in config.xml) but "dynamic" (list stored in a database), "personal" (per local sender) and optionally grows automatically. The mailet that manages the list in the database is WhiteListManager. The following (that can be found both in javadoc and in config.xml) should explain more: > Add whitelist support > - > > Key: JAMES-528 > URL: http://issues.apache.org/jira/browse/JAMES-528 > Project: James > Type: New Feature > Components: Matchers/Mailets (bundled) > Versions: 2.3.0b1 > Reporter: Vincenzo Gianferrari Pini > Assignee: Vincenzo Gianferrari Pini > Priority: Minor > Fix For: 2.3.0b1 > > Add matcher/mailets providing whitelist support, to reduce false positives in > anti-spam detection. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
[jira] Resolved: (JAMES-527) data-source for default derby maildb is configured with a relative path
[ http://issues.apache.org/jira/browse/JAMES-527?page=all ] Norman Maurer resolved JAMES-527: - Fix Version: 2.4.0 Resolution: Fixed Now we change to $PHOENIX_HOME/bin before start james. This seems to me a better solution then use getProperties() at the moment. Anyway we should maybe change the config for not using a relative path on derby configuration. > data-source for default derby maildb is configured with a relative path > --- > > Key: JAMES-527 > URL: http://issues.apache.org/jira/browse/JAMES-527 > Project: James > Type: Bug > Components: James Core > Versions: 2.3.0, 2.4.0, 2.3.0b1 > Environment: tested on windows, jre 1.5 > Reporter: Joachim Draeger > Assignee: Norman Maurer > Priority: Minor > Fix For: 2.3.0, 2.4.0 > > Data source is configured with a relative path in config.xml: > jdbc:derby:../apps/james/var/derbydb;create=true > The path is relative to the current directory when starting james. Calling > run from the bin folder is allright. Calling it from James root directory > bin\run.bat causes the db to be created in the uplevel directory. > Possible solutions: > - add a "cd PHOENIX_HOME" in start scripts > - evaluate the PHOENIX_HOME enviroment variable in James -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
svn commit: r413590 - /james/server/branches/v2.3/phoenix-bin/bin/phoenix.sh
Author: norman Date: Sun Jun 11 23:47:56 2006 New Revision: 413590 URL: http://svn.apache.org/viewvc?rev=413590&view=rev Log: Change to directory $PHOENIX_HOME/bin before start james to get sure the derbydb directory is created on the right place. Thx to Joachim Draeger for reporting this. See JAMES-527 Modified: james/server/branches/v2.3/phoenix-bin/bin/phoenix.sh Modified: james/server/branches/v2.3/phoenix-bin/bin/phoenix.sh URL: http://svn.apache.org/viewvc/james/server/branches/v2.3/phoenix-bin/bin/phoenix.sh?rev=413590&r1=413589&r2=413590&view=diff == --- james/server/branches/v2.3/phoenix-bin/bin/phoenix.sh (original) +++ james/server/branches/v2.3/phoenix-bin/bin/phoenix.sh Sun Jun 11 23:47:56 2006 @@ -133,6 +133,9 @@ JVM_OPTS="$JVM_OPTS -Djava.security.manager" fi +# change to the bin directory +cd $PHOENIX_HOME/bin + # Get the run cmd RUN_CMD="$JAVA_HOME/bin/java $JVM_OPTS \ $JVM_OPTS \ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
svn commit: r413586 - /james/server/trunk/phoenix-bin/bin/phoenix.sh
Author: norman Date: Sun Jun 11 23:03:23 2006 New Revision: 413586 URL: http://svn.apache.org/viewvc?rev=413586&view=rev Log: Change to directory $PHOENIX_HOME/bin before start james to get sure the derbydb directory is created on the right place. Thx to Joachim Draeger for reporting this. See JAMES-527 Modified: james/server/trunk/phoenix-bin/bin/phoenix.sh Modified: james/server/trunk/phoenix-bin/bin/phoenix.sh URL: http://svn.apache.org/viewvc/james/server/trunk/phoenix-bin/bin/phoenix.sh?rev=413586&r1=413585&r2=413586&view=diff == --- james/server/trunk/phoenix-bin/bin/phoenix.sh (original) +++ james/server/trunk/phoenix-bin/bin/phoenix.sh Sun Jun 11 23:03:23 2006 @@ -133,6 +133,9 @@ JVM_OPTS="$JVM_OPTS -Djava.security.manager" fi +# change to the bin directory +cd $PHOENIX_HOME/bin + # Get the run cmd RUN_CMD="$JAVA_HOME/bin/java $JVM_OPTS \ $JVM_OPTS \ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[jira] Assigned: (JAMES-527) data-source for default derby maildb is configured with a relative path
[ http://issues.apache.org/jira/browse/JAMES-527?page=all ] Norman Maurer reassigned JAMES-527: --- Assign To: Norman Maurer > data-source for default derby maildb is configured with a relative path > --- > > Key: JAMES-527 > URL: http://issues.apache.org/jira/browse/JAMES-527 > Project: James > Type: Bug > Components: James Core > Versions: 2.3.0, 2.4.0, 2.3.0b1 > Environment: tested on windows, jre 1.5 > Reporter: Joachim Draeger > Assignee: Norman Maurer > Priority: Minor > Fix For: 2.3.0 > > Data source is configured with a relative path in config.xml: > jdbc:derby:../apps/james/var/derbydb;create=true > The path is relative to the current directory when starting james. Calling > run from the bin folder is allright. Calling it from James root directory > bin\run.bat causes the db to be created in the uplevel directory. > Possible solutions: > - add a "cd PHOENIX_HOME" in start scripts > - evaluate the PHOENIX_HOME enviroment variable in James -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
[jira] Commented: (JAMES-528) Add whitelist support
[ http://issues.apache.org/jira/browse/JAMES-528?page=comments#action_12415783 ] Steve Brewin commented on JAMES-528: Not sure what this means. Is it a need to be satisfied by code or a documentation? We can already bypass checks in the mailet chain for 'whitelist'ed senders using matchers such as SenderIsLocal and SenderIsRegex. Do we need to update the config and/or the docs. to make this clearer? What more might a new matcher do? > Add whitelist support > - > > Key: JAMES-528 > URL: http://issues.apache.org/jira/browse/JAMES-528 > Project: James > Type: New Feature > Components: Matchers/Mailets (bundled) > Versions: 2.3.0b1 > Reporter: Vincenzo Gianferrari Pini > Assignee: Vincenzo Gianferrari Pini > Priority: Minor > Fix For: 2.3.0b1 > > Add matcher/mailets providing whitelist support, to reduce false positives in > anti-spam detection. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
[jira] Resolved: (JAMES-528) Add whitelist support
[ http://issues.apache.org/jira/browse/JAMES-528?page=all ] Vincenzo Gianferrari Pini resolved JAMES-528: - Resolution: Fixed Added the WhiteListManager mailet and the IsInWhiteList matcher. > Add whitelist support > - > > Key: JAMES-528 > URL: http://issues.apache.org/jira/browse/JAMES-528 > Project: James > Type: New Feature > Components: Matchers/Mailets (bundled) > Versions: 2.3.0b1 > Reporter: Vincenzo Gianferrari Pini > Assignee: Vincenzo Gianferrari Pini > Priority: Minor > Fix For: 2.3.0b1 > > Add matcher/mailets providing whitelist support, to reduce false positives in > anti-spam detection. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
svn commit: r413527 - in /james/server/branches/v2.3/src/java/org/apache/james: transport/mailets/BayesianAnalysis.java transport/mailets/BayesianAnalysisFeeder.java util/BayesianAnalyzer.java util/JD
Author: vincenzo Date: Sun Jun 11 13:28:55 2006 New Revision: 413527 URL: http://svn.apache.org/viewvc?rev=413527&view=rev Log: Fixing @since clause from 3.0 to 2.3.0. Modified: james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java james/server/branches/v2.3/src/java/org/apache/james/util/BayesianAnalyzer.java james/server/branches/v2.3/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java Modified: james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java URL: http://svn.apache.org/viewvc/james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java?rev=413527&r1=413526&r2=413527&view=diff == --- james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java (original) +++ james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java Sun Jun 11 13:28:55 2006 @@ -104,7 +104,7 @@ * @see org.apache.james.util.BayesianAnalyzer * @see org.apache.james.util.JDBCBayesianAnalyzer * @version CVS $Revision: $ $Date: $ - * @since 3.0 + * @since 2.3.0 */ public class BayesianAnalysis Modified: james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java URL: http://svn.apache.org/viewvc/james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java?rev=413527&r1=413526&r2=413527&view=diff == --- james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java (original) +++ james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java Sun Jun 11 13:28:55 2006 @@ -100,7 +100,7 @@ * @see org.apache.james.util.BayesianAnalyzer * @see org.apache.james.util.JDBCBayesianAnalyzer * @version CVS $Revision: $ $Date: $ - * @since 3.0 + * @since 2.3.0 */ public class BayesianAnalysisFeeder Modified: james/server/branches/v2.3/src/java/org/apache/james/util/BayesianAnalyzer.java URL: http://svn.apache.org/viewvc/james/server/branches/v2.3/src/java/org/apache/james/util/BayesianAnalyzer.java?rev=413527&r1=413526&r2=413527&view=diff == --- james/server/branches/v2.3/src/java/org/apache/james/util/BayesianAnalyzer.java (original) +++ james/server/branches/v2.3/src/java/org/apache/james/util/BayesianAnalyzer.java Sun Jun 11 13:28:55 2006 @@ -74,7 +74,7 @@ * before calling computeSpamProbability. * * @version CVS $Revision: $ $Date: $ - * @since 3.0 + * @since 2.3.0 */ public class BayesianAnalyzer { Modified: james/server/branches/v2.3/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java URL: http://svn.apache.org/viewvc/james/server/branches/v2.3/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java?rev=413527&r1=413526&r2=413527&view=diff == --- james/server/branches/v2.3/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java (original) +++ james/server/branches/v2.3/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java Sun Jun 11 13:28:55 2006 @@ -37,7 +37,7 @@ * different parts of the code. * @version CVS $Revision: $ $Date: $ - * @since 3.0 + * @since 2.3.0 */ abstract public class JDBCBayesianAnalyzer - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
svn commit: r413526 - in /james/server/trunk/src/java/org/apache/james: transport/mailets/BayesianAnalysis.java transport/mailets/BayesianAnalysisFeeder.java util/BayesianAnalyzer.java util/JDBCBayesi
Author: vincenzo Date: Sun Jun 11 13:28:17 2006 New Revision: 413526 URL: http://svn.apache.org/viewvc?rev=413526&view=rev Log: Fixing @since clause from 3.0 to 2.3.0. Modified: james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java james/server/trunk/src/java/org/apache/james/util/BayesianAnalyzer.java james/server/trunk/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java Modified: james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java?rev=413526&r1=413525&r2=413526&view=diff == --- james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java (original) +++ james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysis.java Sun Jun 11 13:28:17 2006 @@ -104,7 +104,7 @@ * @see org.apache.james.util.BayesianAnalyzer * @see org.apache.james.util.JDBCBayesianAnalyzer * @version CVS $Revision: $ $Date: $ - * @since 3.0 + * @since 2.3.0 */ public class BayesianAnalysis Modified: james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java?rev=413526&r1=413525&r2=413526&view=diff == --- james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java (original) +++ james/server/trunk/src/java/org/apache/james/transport/mailets/BayesianAnalysisFeeder.java Sun Jun 11 13:28:17 2006 @@ -100,7 +100,7 @@ * @see org.apache.james.util.BayesianAnalyzer * @see org.apache.james.util.JDBCBayesianAnalyzer * @version CVS $Revision: $ $Date: $ - * @since 3.0 + * @since 2.3.0 */ public class BayesianAnalysisFeeder Modified: james/server/trunk/src/java/org/apache/james/util/BayesianAnalyzer.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/java/org/apache/james/util/BayesianAnalyzer.java?rev=413526&r1=413525&r2=413526&view=diff == --- james/server/trunk/src/java/org/apache/james/util/BayesianAnalyzer.java (original) +++ james/server/trunk/src/java/org/apache/james/util/BayesianAnalyzer.java Sun Jun 11 13:28:17 2006 @@ -74,7 +74,7 @@ * before calling computeSpamProbability. * * @version CVS $Revision: $ $Date: $ - * @since 3.0 + * @since 2.3.0 */ public class BayesianAnalyzer { Modified: james/server/trunk/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java?rev=413526&r1=413525&r2=413526&view=diff == --- james/server/trunk/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java (original) +++ james/server/trunk/src/java/org/apache/james/util/JDBCBayesianAnalyzer.java Sun Jun 11 13:28:17 2006 @@ -37,7 +37,7 @@ * different parts of the code. * @version CVS $Revision: $ $Date: $ - * @since 3.0 + * @since 2.3.0 */ abstract public class JDBCBayesianAnalyzer - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
svn commit: r413525 - in /james/server/branches/v2.3/src: conf/james-config.xml conf/sqlResources.xml java/org/apache/james/transport/mailets/WhiteListManager.java java/org/apache/james/transport/matc
Author: vincenzo Date: Sun Jun 11 13:20:10 2006 New Revision: 413525 URL: http://svn.apache.org/viewvc?rev=413525&view=rev Log: Adding whitelist support matcher and mailet (see http://issues.apache.org/jira/browse/JAMES-528). Added: james/server/branches/v2.3/src/java/org/apache/james/transport/mailets/WhiteListManager.java james/server/branches/v2.3/src/java/org/apache/james/transport/matchers/IsInWhiteList.java Modified: james/server/branches/v2.3/src/conf/james-config.xml james/server/branches/v2.3/src/conf/sqlResources.xml Modified: james/server/branches/v2.3/src/conf/james-config.xml URL: http://svn.apache.org/viewvc/james/server/branches/v2.3/src/conf/james-config.xml?rev=413525&r1=413524&r2=413525&view=diff == --- james/server/branches/v2.3/src/conf/james-config.xml (original) +++ james/server/branches/v2.3/src/conf/james-config.xml Sun Jun 11 13:20:10 2006 @@ -214,6 +214,37 @@ --> + + + + + + + + + + + + + + + + + + + + + + + + + + + Modified: james/server/branches/v2.3/src/conf/sqlResources.xml URL: http://svn.apache.org/viewvc/james/server/branches/v2.3/src/conf/sqlResources.xml?rev=413525&r1=413524&r2=413525&view=diff == --- james/server/branches/v2.3/src/conf/sqlResources.xml (original) +++ james/server/branches/v2.3/src/conf/sqlResources.xml Sun Jun 11 13:20:10 2006 @@ -722,5 +722,116 @@ + + + + +whitelist + + +SELECT localUser, localHost FROM whitelist where (localUser=? AND localHost=? AND remoteUser=? AND remoteHost=?) + + +SELECT remoteUser, remoteHost FROM whitelist where (localUser=? AND localHost=?) ORDER BY remoteUser, remoteHost + + +INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost) VALUES (?,?,?,?) + + +DELETE FROM whitelist where (localUser=? AND localHost=? AND remoteUser=? AND remoteHost=?) + + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + +CREATE CACHED TABLE ${table} ( +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) character set latin1 NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) character set latin1 NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) TYPE=InnoDB + + +CREATE TABLE [whitelist] ( +[localUser] [varchar] (64) NOT NULL, +[localHost] [varchar] (255) NOT NULL, +[remoteUser] [varchar] (64) NOT NULL, +[remoteHost] [varchar] (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (
svn commit: r413524 - in /james/server/trunk/src: conf/james-config.xml conf/sqlResources.xml java/org/apache/james/transport/mailets/WhiteListManager.java java/org/apache/james/transport/matchers/IsI
Author: vincenzo Date: Sun Jun 11 13:18:59 2006 New Revision: 413524 URL: http://svn.apache.org/viewvc?rev=413524&view=rev Log: Adding whitelist support matcher and mailet (see http://issues.apache.org/jira/browse/JAMES-528). Added: james/server/trunk/src/java/org/apache/james/transport/mailets/WhiteListManager.java james/server/trunk/src/java/org/apache/james/transport/matchers/IsInWhiteList.java Modified: james/server/trunk/src/conf/james-config.xml james/server/trunk/src/conf/sqlResources.xml Modified: james/server/trunk/src/conf/james-config.xml URL: http://svn.apache.org/viewvc/james/server/trunk/src/conf/james-config.xml?rev=413524&r1=413523&r2=413524&view=diff == --- james/server/trunk/src/conf/james-config.xml (original) +++ james/server/trunk/src/conf/james-config.xml Sun Jun 11 13:18:59 2006 @@ -214,6 +214,37 @@ --> + + + + + + + + + + + + + + + + + + + + + + + + + + + Modified: james/server/trunk/src/conf/sqlResources.xml URL: http://svn.apache.org/viewvc/james/server/trunk/src/conf/sqlResources.xml?rev=413524&r1=413523&r2=413524&view=diff == --- james/server/trunk/src/conf/sqlResources.xml (original) +++ james/server/trunk/src/conf/sqlResources.xml Sun Jun 11 13:18:59 2006 @@ -722,5 +722,116 @@ + + + + +whitelist + + +SELECT localUser, localHost FROM whitelist where (localUser=? AND localHost=? AND remoteUser=? AND remoteHost=?) + + +SELECT remoteUser, remoteHost FROM whitelist where (localUser=? AND localHost=?) ORDER BY remoteUser, remoteHost + + +INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost) VALUES (?,?,?,?) + + +DELETE FROM whitelist where (localUser=? AND localHost=? AND remoteUser=? AND remoteHost=?) + + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + +CREATE CACHED TABLE ${table} ( +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) character set latin1 NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) character set latin1 NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) TYPE=InnoDB + + +CREATE TABLE [whitelist] ( +[localUser] [varchar] (64) NOT NULL, +[localHost] [varchar] (255) NOT NULL, +[remoteUser] [varchar] (64) NOT NULL, +[remoteHost] [varchar] (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64) NOT NULL, +remoteHost varchar (255) NOT NULL, +PRIMARY KEY (localUser, localHost, remoteUser, remoteHost) +) + + +CREATE TABLE whitelist ( +localUser varchar (64) NOT NULL, +localHost varchar (255) NOT NULL, +remoteUser varchar (64)
[jira] Created: (JAMES-528) Add whitelist support
Add whitelist support - Key: JAMES-528 URL: http://issues.apache.org/jira/browse/JAMES-528 Project: James Type: New Feature Components: Matchers/Mailets (bundled) Versions: 2.3.0b1 Reporter: Vincenzo Gianferrari Pini Assigned to: Vincenzo Gianferrari Pini Priority: Minor Fix For: 2.3.0b1 Add matcher/mailets providing whitelist support, to reduce false positives in anti-spam detection. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
[jira] Created: (JAMES-527) data-source for default derby maildb is configured with a relative path
data-source for default derby maildb is configured with a relative path --- Key: JAMES-527 URL: http://issues.apache.org/jira/browse/JAMES-527 Project: James Type: Bug Components: James Core Versions: 2.3.0, 2.4.0, 2.3.0b1 Environment: tested on windows, jre 1.5 Reporter: Joachim Draeger Priority: Minor Fix For: 2.3.0 Data source is configured with a relative path in config.xml: jdbc:derby:../apps/james/var/derbydb;create=true The path is relative to the current directory when starting james. Calling run from the bin folder is allright. Calling it from James root directory bin\run.bat causes the db to be created in the uplevel directory. Possible solutions: - add a "cd PHOENIX_HOME" in start scripts - evaluate the PHOENIX_HOME enviroment variable in James -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
svn commit: r413450 - in /james/server/trunk/src: java/org/apache/james/transport/matchers/RecipientIsRegex.java test/org/apache/james/transport/matchers/RecipientIsRegexTest.java
Author: norman Date: Sun Jun 11 07:23:36 2006 New Revision: 413450 URL: http://svn.apache.org/viewvc?rev=413450&view=rev Log: Throw exception on empty pattern. Add junit test for this Modified: james/server/trunk/src/java/org/apache/james/transport/matchers/RecipientIsRegex.java james/server/trunk/src/test/org/apache/james/transport/matchers/RecipientIsRegexTest.java Modified: james/server/trunk/src/java/org/apache/james/transport/matchers/RecipientIsRegex.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/java/org/apache/james/transport/matchers/RecipientIsRegex.java?rev=413450&r1=413449&r2=413450&view=diff == --- james/server/trunk/src/java/org/apache/james/transport/matchers/RecipientIsRegex.java (original) +++ james/server/trunk/src/java/org/apache/james/transport/matchers/RecipientIsRegex.java Sun Jun 11 07:23:36 2006 @@ -47,7 +47,7 @@ public void init() throws javax.mail.MessagingException { String patternString = getCondition(); -if (patternString == null) { +if ((patternString == null) || (patternString.equals("")) ) { throw new MessagingException("Pattern is missing"); } Modified: james/server/trunk/src/test/org/apache/james/transport/matchers/RecipientIsRegexTest.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/test/org/apache/james/transport/matchers/RecipientIsRegexTest.java?rev=413450&r1=413449&r2=413450&view=diff == --- james/server/trunk/src/test/org/apache/james/transport/matchers/RecipientIsRegexTest.java (original) +++ james/server/trunk/src/test/org/apache/james/transport/matchers/RecipientIsRegexTest.java Sun Jun 11 07:23:36 2006 @@ -98,12 +98,29 @@ setupAll(); matchedRecipients = matcher.match(mockedMail); } catch (MessagingException m) { -m.printStackTrace(); regexException = m.getMessage(); } assertNull(matchedRecipients); assertEquals(regexException, exception); + +} + +// test if an exception was thrown cause the regex was invalid +public void testThrowExceptionWithEmptyPattern() throws MessagingException { +boolean catchException = false; + +setRecipients(new MailAddress[] { +new MailAddress("[EMAIL PROTECTED]"), +new MailAddress("[EMAIL PROTECTED]") }); +setRegex(""); + +try { +setupAll(); +} catch (MessagingException m) { +catchException = true; +} +assertTrue(catchException); } - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
svn commit: r413449 - in /james/server/trunk/src: java/org/apache/james/transport/matchers/SenderIsRegex.java test/org/apache/james/transport/matchers/SenderIsNullTest.java test/org/apache/james/trans
Author: norman Date: Sun Jun 11 07:17:27 2006 New Revision: 413449 URL: http://svn.apache.org/viewvc?rev=413449&view=rev Log: Throw an MessagingException if pattern is empty Add junit test for SenderIsRegex and SenderIsNull matcher Added: james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsNullTest.java james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsRegexTest.java Modified: james/server/trunk/src/java/org/apache/james/transport/matchers/SenderIsRegex.java Modified: james/server/trunk/src/java/org/apache/james/transport/matchers/SenderIsRegex.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/java/org/apache/james/transport/matchers/SenderIsRegex.java?rev=413449&r1=413448&r2=413449&view=diff == --- james/server/trunk/src/java/org/apache/james/transport/matchers/SenderIsRegex.java (original) +++ james/server/trunk/src/java/org/apache/james/transport/matchers/SenderIsRegex.java Sun Jun 11 07:17:27 2006 @@ -56,7 +56,7 @@ public void init() throws MessagingException { String patternString = getCondition(); -if (patternString == null) { +if ((patternString == null) || (patternString.equals(""))) { throw new MessagingException("Pattern is missing"); } Added: james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsNullTest.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsNullTest.java?rev=413449&view=auto == --- james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsNullTest.java (added) +++ james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsNullTest.java Sun Jun 11 07:17:27 2006 @@ -0,0 +1,71 @@ +/*** + * Copyright (c) 2006 The Apache Software Foundation. * + * All rights reserved.* + * --- * + * Licensed under the Apache License, Version 2.0 (the "License"); you * + * may not use this file except in compliance with the License. You* + * may obtain a copy of the License at:* + * * + * http://www.apache.org/licenses/LICENSE-2.0 * + * * + * Unless required by applicable law or agreed to in writing, software * + * distributed under the License is distributed on an "AS IS" BASIS, * + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or * + * implied. See the License for the specific language governing * + * permissions and limitations under the License. * + ***/ + +package org.apache.james.transport.matchers; + +import java.io.UnsupportedEncodingException; +import java.util.Collection; + +import javax.mail.MessagingException; + +import org.apache.mailet.MailAddress; +import org.apache.mailet.Matcher; + +public class SenderIsNullTest extends AbstractSenderIsTest { + +public SenderIsNullTest(String arg0) throws UnsupportedEncodingException { +super(arg0); +} + +// test if matched +public void testSenderIsMatchedAllRecipients() throws MessagingException { +setSender(null); + +setupMockedMail(); +setupMatcher(); + +Collection matchedRecipients = matcher.match(mockedMail); + +assertNotNull(matchedRecipients); +assertEquals(matchedRecipients.size(), mockedMail.getRecipients() +.size()); +} + +// test if not matched +public void testSenderIsNotMatchedAllRecipients() throws MessagingException { +setSender(new MailAddress("[EMAIL PROTECTED]")); + +setupMockedMail(); +setupMatcher(); + +Collection matchedRecipients = matcher.match(mockedMail); + +assertNull(matchedRecipients); +} + +protected Matcher createMatcher() { +return new SenderIsNull(); +} + +protected String getConfigOption() { +return "SenderIsNull"; +} + +protected String getConfigValue() { +return ""; +} +} Added: james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsRegexTest.java URL: http://svn.apache.org/viewvc/james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsRegexTest.java?rev=413449&view=auto == --- james/server/trunk/src/test/org/apache/james/transport/matchers/SenderIsRegexTest.java (added) +++ james/server/trunk/src/test/org/apache/jam
Re: Where to create MailRepository var/mail/inboxes directory?
Am Sonntag, den 11.06.2006, 12:15 +0200 schrieb Joachim Draeger: > Hi! > > Eviroment: Windows, James Trunk/2.3.0b1, JRE 1.5 > > At the moment I use the current directory and add > "apps/james/var/mail/inboxes/user" in JavaMailStoreMailRepository. > I always called bin/run from James root directory. Sometimes I noticed that a > derbydb was created in the uplevel directory. > After further investigations I noticed this derbydb (UserRepository/Spool???) > is > created at ../apps/james/var/derbydb so I conclude run should be called from > the > bin folder and I should use ../apps/james/var/mail/inboxes/user. > Isn't there a cleaner way? Or is there an intent why it works this way? > Everything else seems to be in the right place independent from the current > directory when calling run. > > Joachim I notice exact the same sometimes.. but it happen to me not often. Can you fill a bugreport with all needed infos ? Can you reproduce it ? bye Norman signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
[jira] Updated: (JAMES-461) Javamail Store based MailRepository support (was: Maildir support)
[ http://issues.apache.org/jira/browse/JAMES-461?page=all ] Joachim Draeger updated JAMES-461: -- Attachment: diff_to-javamaildir-0.7-pre1-2.diff patch to javamaildir-0.7-pre1 for javamailstore-mailrepository-4 > Javamail Store based MailRepository support (was: Maildir support) > -- > > Key: JAMES-461 > URL: http://issues.apache.org/jira/browse/JAMES-461 > Project: James > Type: New Feature > Components: MailStore & MailRepository > Reporter: Norman Maurer > Assignee: Stefano Bagnara > Fix For: 2.4.0 > Attachments: JavamailStoreMailRepository.java, > JavamailStoreMailRepository2.zip, MaildirMailRepository.java, > MaildirMailRepository.java, UIDPlusFolderMailRepository1.zip, > diff_to-javamaildir-0.7-pre1-2.diff, javamailstore-mailrepository-3.zip, > javamailstore-mailrepository-4.zip > > Add support for Javamail Stores as MailRepositories -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
Re: [jira] Updated: (JAMES-461) Javamail Store based MailRepository support
Hi Norman! Norman Maurer wrote: What you mean by compatible javamaildir version ? You write your own implementation ? Or is it just a patched version and still under LGPL ? I contribute all needed changes back to original javamaildir. But of course patches have to be reviewed and accepted by the original author. Because I want to share my work quickly JavaMailStoreMailRepository release is one step ahead javamaildir. In fact most things still work with the official 0.7-pre1 release of javamaildir. I don't want to release my patched complete version of javamaildir because I think there should be only one released implementation. What I'll do is attaching the patch to JIRA like I did lasttime and send complete zips by private email for convenience. Writing an own implementation of javamaildir is not an option for me. There is too less demand to justify two different implementations. The vision of an Apache JdbcJavaMailStore will be much more interesting. :-) I will test the javamailstore later ;-) Thanks, I'll send you the latest patched javamaildir. Joachim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Mail interface
Am Samstag, den 10.06.2006, 15:14 -0400 schrieb Serge Knystautas: > On 6/10/06, Norman Maurer <[EMAIL PROTECTED]> wrote: > > i just wonder if there is any reason why the mail interface not provide > > a method to set the sender of an email. Like "setSender(MailAddress > > sender)".. > > > > I ask this cause i notice it while working on junit tests for SenderIs.. > > I guess we could add it, though the theory was that you would not want > to remove the original and/or allow someone to impersonate another > sender. Do you have a (non-test) case for why someone would want to > change the sending email address? > No i only need at at the moment on the tests.. Like you see i use a mocked Mail now.. So if noone see other needs we should not change it. Bye Norman signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: [jira] Updated: (JAMES-461) Javamail Store based MailRepository support (was: Maildir support)
What you mean by compatible javamaildir version ? You write your own implementation ? Or is it just a patched version and still under LGPL ? I will test the javamailstore later ;-) Thx Norman Am Sonntag, den 11.06.2006, 11:11 + schrieb Joachim Draeger (JIRA): > [ http://issues.apache.org/jira/browse/JAMES-461?page=all ] > > Joachim Draeger updated JAMES-461: > -- > > Attachment: javamailstore-mailrepository-4.zip > > javamailstore-mailrepository-4 > > * HashJavamailStoreMailRepository always allows to deliver to a closed > folder. It opens the folder for getMessageCount() only if necessary > * HashJavamailStoreMailRepository was missing capability to update > message when store got called with an existing key > * UIDPlusFolderMailRepository tries first to deliver to a closed folder. > If IllegalStateException was caught it retries on the opened folder. > * Flag.RECENT is set on MimeMessage before passed to JavaMail Store > * when using javamaildir, new messages should stay in the new folder > until list() or retrieve() is called on Repository. > thanks to Norman for reporting this! > * tested with James-2.3.0b1 > > see INSTALL.txt > > A completely compatible javamaildir version (greater than 0.7-pre1) is on the > way, I will announce it here. I provide unofficial prerelease by private > email for the impatient! :-) > > I appreciate any feedback! Success, issues, bad style... :-) > > > > Javamail Store based MailRepository support (was: Maildir support) > > -- > > > > Key: JAMES-461 > > URL: http://issues.apache.org/jira/browse/JAMES-461 > > Project: James > > Type: New Feature > > > Components: MailStore & MailRepository > > Reporter: Norman Maurer > > Assignee: Stefano Bagnara > > Fix For: 2.4.0 > > Attachments: JavamailStoreMailRepository.java, > > JavamailStoreMailRepository2.zip, MaildirMailRepository.java, > > MaildirMailRepository.java, UIDPlusFolderMailRepository1.zip, > > javamailstore-mailrepository-3.zip, javamailstore-mailrepository-4.zip > > > > Add support for Javamail Stores as MailRepositories > signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
[jira] Updated: (JAMES-461) Javamail Store based MailRepository support (was: Maildir support)
[ http://issues.apache.org/jira/browse/JAMES-461?page=all ] Joachim Draeger updated JAMES-461: -- Attachment: javamailstore-mailrepository-4.zip javamailstore-mailrepository-4 * HashJavamailStoreMailRepository always allows to deliver to a closed folder. It opens the folder for getMessageCount() only if necessary * HashJavamailStoreMailRepository was missing capability to update message when store got called with an existing key * UIDPlusFolderMailRepository tries first to deliver to a closed folder. If IllegalStateException was caught it retries on the opened folder. * Flag.RECENT is set on MimeMessage before passed to JavaMail Store * when using javamaildir, new messages should stay in the new folder until list() or retrieve() is called on Repository. thanks to Norman for reporting this! * tested with James-2.3.0b1 see INSTALL.txt A completely compatible javamaildir version (greater than 0.7-pre1) is on the way, I will announce it here. I provide unofficial prerelease by private email for the impatient! :-) I appreciate any feedback! Success, issues, bad style... :-) > Javamail Store based MailRepository support (was: Maildir support) > -- > > Key: JAMES-461 > URL: http://issues.apache.org/jira/browse/JAMES-461 > Project: James > Type: New Feature > Components: MailStore & MailRepository > Reporter: Norman Maurer > Assignee: Stefano Bagnara > Fix For: 2.4.0 > Attachments: JavamailStoreMailRepository.java, > JavamailStoreMailRepository2.zip, MaildirMailRepository.java, > MaildirMailRepository.java, UIDPlusFolderMailRepository1.zip, > javamailstore-mailrepository-3.zip, javamailstore-mailrepository-4.zip > > Add support for Javamail Stores as MailRepositories -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://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]
Where to create MailRepository var/mail/inboxes directory?
Hi! Eviroment: Windows, James Trunk/2.3.0b1, JRE 1.5 At the moment I use the current directory and add "apps/james/var/mail/inboxes/user" in JavaMailStoreMailRepository. I always called bin/run from James root directory. Sometimes I noticed that a derbydb was created in the uplevel directory. After further investigations I noticed this derbydb (UserRepository/Spool???) is created at ../apps/james/var/derbydb so I conclude run should be called from the bin folder and I should use ../apps/james/var/mail/inboxes/user. Isn't there a cleaner way? Or is there an intent why it works this way? Everything else seems to be in the right place independent from the current directory when calling run. Joachim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]