james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rouaz...@apache.org
Subject [09/13] james-project git commit: JAMES-1858: Move current run guice to run guice with cassandra
Date Wed, 07 Dec 2016 08:53:37 GMT
http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/cassandra/destination/conf/quota.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/cassandra/destination/conf/quota.xml b/dockerfiles/run/guice/cassandra/destination/conf/quota.xml
new file mode 100644
index 0000000..70162e0
--- /dev/null
+++ b/dockerfiles/run/guice/cassandra/destination/conf/quota.xml
@@ -0,0 +1,53 @@
+<?xml version="1.0"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you 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.
+ -->
+
+<!--
+   This template file can be used as example for James Server configuration
+   DO NOT USE IT AS SUCH AND ADAPT IT TO YOUR NEEDS
+-->
+
+<!-- See http://james.apache.org/server/3/config.html for usage -->
+
+<!--
+        This configuration file allows you to customize the way quota are handled on this server.
+        You need to rename it in quota.xml so that it gets interpreted by James on startup.
+
+        The different configuration options are detailed here.
+
+        Read RFC-2087 for full details.
+-->
+
+<quota>
+    <quotaRootResolver>
+        <provider>default</provider>
+    </quotaRootResolver>
+    <currentQuotaManager>
+        <provider>cassandra</provider>
+    </currentQuotaManager>
+    <maxQuotaManager>
+        <provider>cassandra</provider>
+    </maxQuotaManager>
+    <quotaManager>
+        <provider>store</provider>
+    </quotaManager>
+    <updates>
+        <provider>event</provider>
+    </updates>
+</quota>

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/cassandra/destination/conf/recipientrewritetable.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/cassandra/destination/conf/recipientrewritetable.xml b/dockerfiles/run/guice/cassandra/destination/conf/recipientrewritetable.xml
new file mode 100644
index 0000000..fde339b
--- /dev/null
+++ b/dockerfiles/run/guice/cassandra/destination/conf/recipientrewritetable.xml
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one   
+  or more contributor license agreements.  See the NOTICE file 
+  distributed with this work for additional information        
+  regarding copyright ownership.  The ASF licenses this file   
+  to you 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.                                           
+ -->
+
+<!-- The default table for storing James' RecipientRewriteTable mappings. -->
+<recipientrewritetable class="org.apache.james.rrt.jpa.JPARecipientRewriteTable">
+  <recursiveMapping>true</recursiveMapping>
+  <mappingLimit>10</mappingLimit>
+</recipientrewritetable>
+

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/cassandra/destination/conf/smtpserver.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/cassandra/destination/conf/smtpserver.xml b/dockerfiles/run/guice/cassandra/destination/conf/smtpserver.xml
new file mode 100644
index 0000000..bc609be
--- /dev/null
+++ b/dockerfiles/run/guice/cassandra/destination/conf/smtpserver.xml
@@ -0,0 +1,105 @@
+<?xml version="1.0"?>
+
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one
+  or more contributor license agreements.  See the NOTICE file
+  distributed with this work for additional information
+  regarding copyright ownership.  The ASF licenses this file
+  to you 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.
+ -->
+
+<smtpservers>
+    <smtpserver enabled="true">
+        <jmxName>smtpserver-global</jmxName>
+        <bind>0.0.0.0:25</bind>
+        <connectionBacklog>200</connectionBacklog>
+        <tls socketTLS="false" startTLS="false">
+            <keystore>file://conf/keystore</keystore>
+            <secret>james72laBalle</secret>
+            <provider>org.bouncycastle.jce.provider.BouncyCastleProvider</provider>
+            <algorithm>SunX509</algorithm>
+        </tls>
+        <connectiontimeout>360</connectiontimeout>
+        <connectionLimit>0</connectionLimit>
+        <connectionLimitPerIP>0</connectionLimitPerIP>
+        <authRequired>false</authRequired>
+        <authorizedAddresses>0.0.0.0/0</authorizedAddresses>
+        <verifyIdentity>true</verifyIdentity>
+        <maxmessagesize>0</maxmessagesize>
+        <addressBracketsEnforcement>true</addressBracketsEnforcement>
+        <smtpGreeting>JAMES Linagora's SMTP awesome Server</smtpGreeting>
+        <handlerchain>
+            <handler class="org.apache.james.smtpserver.fastfail.ValidRcptHandler"/>
+            <handler class="org.apache.james.smtpserver.CoreCmdHandlerLoader"/>
+        </handlerchain>
+    </smtpserver>
+    <smtpserver enabled="true">
+        <jmxName>smtpserver-TLS</jmxName>
+        <bind>0.0.0.0:465</bind>
+        <connectionBacklog>200</connectionBacklog>
+        <tls socketTLS="true" startTLS="false">
+            <keystore>file://conf/keystore</keystore>
+            <secret>james72laBalle</secret>
+            <provider>org.bouncycastle.jce.provider.BouncyCastleProvider</provider>
+            <algorithm>SunX509</algorithm>
+        </tls>
+        <connectiontimeout>360</connectiontimeout>
+        <connectionLimit>0</connectionLimit>
+        <connectionLimitPerIP>0</connectionLimitPerIP>
+        <!--
+           Authorize only local users
+        -->
+        <authRequired>true</authRequired>
+        <authorizedAddresses>0.0.0.0/0</authorizedAddresses>
+        <!-- Trust authenticated users -->
+        <verifyIdentity>false</verifyIdentity>
+        <maxmessagesize>0</maxmessagesize>
+        <addressBracketsEnforcement>true</addressBracketsEnforcement>
+        <smtpGreeting>JAMES Linagora's SMTP awesome Server</smtpGreeting>
+        <handlerchain>
+            <handler class="org.apache.james.smtpserver.fastfail.ValidRcptHandler"/>
+            <handler class="org.apache.james.smtpserver.CoreCmdHandlerLoader"/>
+        </handlerchain>
+    </smtpserver>
+    <smtpserver enabled="true">
+        <jmxName>smtpserver-authenticated</jmxName>
+        <bind>0.0.0.0:587</bind>
+        <connectionBacklog>200</connectionBacklog>
+        <tls socketTLS="false" startTLS="true">
+            <keystore>file://conf/keystore</keystore>
+            <secret>james72laBalle</secret>
+            <provider>org.bouncycastle.jce.provider.BouncyCastleProvider</provider>
+            <algorithm>SunX509</algorithm>
+        </tls>
+        <connectiontimeout>360</connectiontimeout>
+        <connectionLimit>0</connectionLimit>
+        <connectionLimitPerIP>0</connectionLimitPerIP>
+        <!--
+           Authorize only local users
+        -->
+        <authRequired>true</authRequired>
+        <authorizedAddresses>0.0.0.0/0</authorizedAddresses>
+        <!-- Trust authenticated users -->
+        <verifyIdentity>false</verifyIdentity>
+        <maxmessagesize>0</maxmessagesize>
+        <addressBracketsEnforcement>true</addressBracketsEnforcement>
+        <smtpGreeting>JAMES Linagora's SMTP awesome Server</smtpGreeting>
+        <handlerchain>
+            <handler class="org.apache.james.smtpserver.fastfail.ValidRcptHandler"/>
+            <handler class="org.apache.james.smtpserver.CoreCmdHandlerLoader"/>
+        </handlerchain>
+    </smtpserver>
+</smtpservers>
+
+

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/cassandra/destination/conf/sqlResources.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/cassandra/destination/conf/sqlResources.xml b/dockerfiles/run/guice/cassandra/destination/conf/sqlResources.xml
new file mode 100644
index 0000000..82cfa26
--- /dev/null
+++ b/dockerfiles/run/guice/cassandra/destination/conf/sqlResources.xml
@@ -0,0 +1,931 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one   
+  or more contributor license agreements.  See the NOTICE file 
+  distributed with this work for additional information        
+  regarding copyright ownership.  The ASF licenses this file   
+  to you 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.                                           
+ -->
+
+<sqlResources>
+
+    <dbMatchers>
+        <dbMatcher db="mssql" databaseProductName="microsoft sql server"/>
+        <dbMatcher db="oracle" databaseProductName="oracle.*"/>
+        <dbMatcher db="mysql" databaseProductName="my.*"/>
+        <dbMatcher db="derby" databaseProductName="derby.*"/>
+        <dbMatcher db="postgresql" databaseProductName="postgres.*"/>
+        <dbMatcher db="hsqldb" databaseProductName="hsql.*"/>
+        <dbMatcher db="sapdb" databaseProductName="sap.*"/>
+        <dbMatcher db="hypersonic" databaseProductName="HypersonicSQL"/>
+        <dbMatcher db="db2" databaseProductName="db2.*"/>
+        <dbMatcher db="ingres" databaseProductName="ingres.*"/>
+    </dbMatchers>
+
+    <dbOptions>
+        <dbOption name="getBody" value="useBytes"/>
+        <dbOption name="getAttributes" value="useBytes"/>
+        <dbOption db="mssql" name="getBody" value="useBytes"/>
+        <dbOption db="mssql" name="getAttributes" value="useBytes"/>
+        <dbOption db="oracle" name="getBody" value="useBlob"/>
+        <dbOption db="oracle" name="getAttributes" value="useBlob"/>
+        <dbOption db="mysql" name="getBody" value="useBytes"/>
+        <dbOption db="mysql" name="getAttributes" value="useBytes"/>
+        <dbOption db="derby" name="getBody" value="useBytes"/>
+        <dbOption db="derby" name="getAttributes" value="useBytes"/>
+        <dbOption db="postgresql" name="getBody" value="useBytes"/>
+        <dbOption db="postgresql" name="getAttributes" value="useBytes"/>
+        <dbOption db="sapdb" name="getBody" value="useBytes"/>
+        <dbOption db="sapdb" name="getAttributes" value="useBytes"/>
+        <dbOption db="hypersonic" name="getBody" value="useBytes"/>
+        <dbOption db="hypersonic" name="getAttributes" value="useBytes"/>
+        <dbOption db="hsqldb" name="getBody" value="useBytes"/>
+        <dbOption db="hsqldb" name="getAttributes" value="useBytes"/>
+        <dbOption db="db2" name="getBody" value="useBlob"/>
+        <dbOption db="db2" name="getAttributes" value="useBlob"/>
+        <dbOption db="ingres" name="getBody" value="useBytes"/>
+        <dbOption db="ingres" name="getAttributes" value="useBytes"/>
+    </dbOptions>
+
+    <sqlDefs name="org.apache.james.user.jdbc.JamesUsersJdbcRepository">
+        <sql name="tableName">${table}</sql>
+
+        <!-- Statements used to retrieve all user information for a user from this repository. -->
+        <sql name="select">SELECT username, pwdHash, pwdAlgorithm, useForwarding,
+            forwardDestination, useAlias, alias
+            FROM ${table}
+            ORDER BY username
+        </sql>
+
+        <!-- Statements used to get all user information for a user with a particular user name in a -->
+        <!-- case-insensitive fashion from this repository. -->
+        <sql name="selectByLowercaseName">
+            SELECT username, pwdHash, pwdAlgorithm, useForwarding,
+            forwardDestination, useAlias, alias
+            FROM ${table}
+            WHERE lower(username) = ?
+        </sql>
+
+        <sql name="selectByLowercaseName" db="mysql">
+            SELECT username, pwdHash, pwdAlgorithm, useForwarding,
+            forwardDestination, useAlias, alias
+            FROM ${table}
+            WHERE username = ?
+        </sql>
+
+        <!-- Statements used to insert a user into this repository. -->
+        <sql name="insert">INSERT INTO ${table}
+            (username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias)
+            VALUES (?,?,?,?,?,?,?)
+        </sql>
+
+        <!-- Statements used to update information for a user from this repository. -->
+        <sql name="update">UPDATE ${table} SET
+            pwdHash = ?, pwdAlgorithm = ?, useForwarding = ?, forwardDestination = ?, useAlias = ?, alias = ?
+            WHERE username = ?
+        </sql>
+
+        <!-- Statements used to delete a user from this repository. -->
+        <sql name="delete">DELETE FROM ${table} WHERE username = ?</sql>
+
+        <!-- Statements used to create the table associated with this class. -->
+        <sql name="createTable" db="hypersonic">CREATE CACHED TABLE ${table} (username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20), useForwarding INTEGER, forwardDestination VARCHAR(255), useAlias INTEGER, alias VARCHAR(255), PRIMARY KEY(username))</sql>
+        <sql name="createTable">CREATE TABLE ${table} (username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20), useForwarding SMALLINT, forwardDestination VARCHAR(255), useAlias SMALLINT, alias VARCHAR(255), PRIMARY KEY(username))</sql>
+        <!-- An example of a database-specific sql statement
+        <sql name="createTable" db="mssql">CREATE TABLE ${table} (uniqueId UNIQUEIDENTIFIER, username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20), useForwarding SMALLINT, forwardDestination VARCHAR(255), useAlias SMALLINT, alias VARCHAR(255), PRIMARY KEY(username))</sql>
+        -->
+    </sqlDefs>
+
+    <sqlDefs name="org.apache.james.user.jdbc.DefaultUsersJdbcRepository">
+        <sql name="tableName">${table}</sql>
+
+        <!-- Statements used to retrieve all user information for a user from this repository. -->
+        <sql name="select">SELECT username, pwdHash, pwdAlgorithm
+            FROM ${table}
+        </sql>
+
+        <!-- Statements used to insert a user into this repository. -->
+        <sql name="insert">INSERT INTO ${table}
+            (username, pwdHash, pwdAlgorithm)
+            VALUES (?,?,?)
+        </sql>
+
+        <!-- Statements used to update information for a user from this repository. -->
+        <sql name="update">UPDATE ${table} SET
+            pwdHash = ?, pwdAlgorithm = ?
+            WHERE username = ?
+        </sql>
+
+        <!-- Statements used to delete a user from this repository. -->
+        <sql name="delete">DELETE FROM ${table} WHERE username = ?</sql>
+
+        <!-- Statements used to create the table associated with this class. -->
+        <sql name="createTable" db="hypersonic">CREATE CACHED TABLE ${table} (username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20), PRIMARY KEY(username))</sql>
+        <sql name="createTable">CREATE TABLE ${table} (username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20), PRIMARY KEY(username))</sql>
+    </sqlDefs>
+
+    <sqlDefs name="org.apache.james.user.jdbc.ListUsersJdbcRepository">
+        <!-- An example of defining "default" parameters within the definition file.
+             This is used if no key parameter is specified in config. -->
+        <parameters key="unknownList"/>
+
+        <sql name="tableName">${table}</sql>
+
+        <!-- Statements used to retrieve all users on a particular list from this repository. -->
+        <sql name="select">SELECT listSubscriber
+            FROM ${table}
+            WHERE listName = '${key}'
+        </sql>
+
+        <!-- Statements used to insert a user/list mapping into this repository. -->
+        <sql name="insert">INSERT INTO ${table}
+            (listSubscriber, listName)
+            VALUES (?, '${key}')
+        </sql>
+
+        <!-- Statements used to update a user/list mapping in this repository. -->
+        <sql name="update">UPDATE ${table} SET
+            listSubscriber = ?
+            WHERE listSubscriber = ? AND listName = '${key}'
+        </sql>
+
+        <!-- Statements used to delete a user/list mapping from this repository. -->
+        <sql name="delete">DELETE FROM ${table}
+            WHERE listSubscriber = ? AND listName = '${key}'
+        </sql>
+
+        <!-- Statements used to create the table associated with this class. -->
+        <sql name="createTable" db="hypersonic">CREATE CACHED TABLE ${table} (listName VARCHAR(64) NOT NULL, listSubscriber VARCHAR(255) NOT NULL, PRIMARY KEY(listName, listSubscriber))</sql>
+        <sql name="createTable">CREATE TABLE ${table} (listName VARCHAR(64) NOT NULL, listSubscriber VARCHAR(255) NOT NULL, PRIMARY KEY(listName, listSubscriber))</sql>
+    </sqlDefs>
+
+    <sqlDefs name="org.apache.james.mailrepository.jdbc.JDBCMailRepository">
+
+        <!-- Statements used to check whether a particular message exists in this repository. -->
+        <sql name="checkMessageExistsSQL">SELECT count(*) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to update a message stored in this repository. -->
+        <sql name="updateMessageSQL">UPDATE ${table} SET message_state = ?, error_message = ?, sender = ?, recipients = ?, remote_host = ?, remote_addr = ?, last_updated = ? WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to update the body of a message stored in this repository. -->
+        <sql name="updateMessageBodySQL">UPDATE ${table} SET message_body = ? WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to update the attributes of a message stored in this repository. -->
+        <sql name="updateMessageAttributesSQL">UPDATE ${table} SET message_attributes = ? WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to insert a message into this repository. -->
+        <sql name="insertMessageSQL">INSERT INTO ${table} (message_name,
+            repository_name, message_state, error_message, sender, recipients,
+            remote_host, remote_addr, last_updated, message_body,
+            message_attributes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</sql>
+
+        <!-- Statements used to retrieve a message stored in this repository. -->
+        <sql name="retrieveMessageSQL">SELECT message_state, error_message, sender, recipients, remote_host, remote_addr, last_updated FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to retrieve the body of a message stored in this repository. -->
+        <sql name="retrieveMessageBodySQL">SELECT message_body FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to retrieve the attributes of a message stored in this repository. -->
+        <sql name="retrieveMessageAttributesSQL">SELECT message_attributes FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to retrieve the size of the body of a message stored in this repository. -->
+        <!-- NOTE: This statement is optional and need not be implemented for a particular database to be supported. -->
+        <sql name="retrieveMessageBodySizeSQL" db="mssql">SELECT datalength(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+        <sql name="retrieveMessageBodySizeSQL" db="mysql">SELECT length(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+        <sql name="retrieveMessageBodySizeSQL" db="hypersonic">SELECT length(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+        <sql name="retrieveMessageBodySizeSQL" db="hsqldb">SELECT length(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+        <sql name="retrieveMessageBodySizeSQL" db="postgresql">SELECT length(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+        <sql name="retrieveMessageBodySizeSQL" db="oracle">SELECT dbms_lob.getlength(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+        <sql name="retrieveMessageBodySizeSQL" db="db2">SELECT length(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+        <sql name="retrieveMessageBodySizeSQL" db="ingres">SELECT length(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+        <sql name="retrieveMessageBodySizeSQL" db="derby">SELECT length(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to delete a message stored in this repository. -->
+        <sql name="removeMessageSQL">DELETE FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
+
+        <!-- Statements used to list all messages stored in this repository. -->
+        <sql name="listMessagesSQL">SELECT message_name, message_state, last_updated FROM ${table} WHERE repository_name = ? ORDER BY last_updated ASC</sql>
+
+        <!-- Statements used to create the table associated with this class. -->
+        <sql name="createTable" db="mysql">
+            CREATE TABLE ${table} (
+            message_name varchar (200) NOT NULL,
+            repository_name varchar (100) NOT NULL,
+            message_state varchar (30) NOT NULL ,
+            error_message varchar (200) NULL ,
+            sender varchar (255) NULL ,
+            recipients text NOT NULL ,
+            remote_host varchar (255) NOT NULL ,
+            remote_addr varchar (20) NOT NULL ,
+            message_body longblob NOT NULL ,
+            message_attributes longblob NULL ,
+            last_updated datetime NOT NULL,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+        <sql name="createTable" db="hypersonic">
+            CREATE CACHED TABLE ${table} (
+            message_name varchar (200) NOT NULL,
+            repository_name varchar (255) NOT NULL,
+            message_state varchar (30) NOT NULL ,
+            error_message varchar (200) NULL ,
+            sender varchar (255) NULL ,
+            recipients varchar NOT NULL ,
+            remote_host varchar (255) NOT NULL ,
+            remote_addr varchar (20) NOT NULL ,
+            message_body varchar NOT NULL ,
+            message_attributes varchar NULL ,
+            last_updated timestamp NOT NULL,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+        <sql name="createTable" db="hsqldb">
+            CREATE CACHED TABLE ${table} (
+            message_name varchar (200) NOT NULL,
+            repository_name varchar (255) NOT NULL,
+            message_state varchar (30) NOT NULL ,
+            error_message varchar (200) NULL ,
+            sender varchar (255) NULL ,
+            recipients varchar NOT NULL ,
+            remote_host varchar (255) NOT NULL ,
+            remote_addr varchar (20) NOT NULL ,
+            message_body varchar NOT NULL ,
+            message_attributes varchar NULL ,
+            last_updated timestamp NOT NULL,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+        <sql name="createTable" db="mssql">
+            CREATE TABLE [${table}] (
+            [message_name] [varchar] (200) NOT NULL,
+            [repository_name] [varchar] (255) NOT NULL,
+            [message_state] [varchar] (30) NOT NULL ,
+            [error_message] [varchar] (1000) NULL ,
+            [sender] [varchar] (255) NULL ,
+            [recipients] [text] NOT NULL ,
+            [remote_host] [varchar] (255) NOT NULL ,
+            [remote_addr] [varchar] (20) NOT NULL ,
+            [message_body] [image] NOT NULL ,
+            [message_attributes] [image] NULL ,
+            [last_updated] [datetime] NOT NULL,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+        <sql name="createTable" db="oracle">
+            CREATE TABLE ${table} (
+            message_name varchar2(200) NOT NULL ,
+            repository_name varchar2(255) NOT NULL ,
+            message_state varchar2(30) NOT NULL ,
+            error_message varchar2(200) NULL ,
+            sender varchar2(255) ,
+            recipients varchar2(1000) NOT NULL ,
+            remote_host varchar2(100) NOT NULL ,
+            remote_addr varchar2(20) NOT NULL ,
+            message_body blob NOT NULL ,
+            message_attributes blob NULL ,
+            last_updated date NOT NULL ,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+        <sql name="createTable" db="postgresql">
+            CREATE TABLE ${table} (
+            message_name varchar (200) NOT NULL,
+            repository_name varchar (255) NOT NULL,
+            message_state varchar (30) NOT NULL ,
+            error_message varchar (200) NULL ,
+            sender varchar (255) NULL ,
+            recipients text NOT NULL ,
+            remote_host varchar (255) NOT NULL ,
+            remote_addr varchar (20) NOT NULL ,
+            message_body bytea NOT NULL ,
+            message_attributes bytea NULL ,
+            last_updated timestamp NOT NULL,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+        <sql name="createTable" db="sapdb">
+            CREATE TABLE ${table} (
+            message_name varchar (200) NOT NULL,
+            repository_name varchar (200) NOT NULL,
+            message_state varchar (30) NOT NULL ,
+            error_message varchar (200) NULL ,
+            sender varchar (200) NULL ,
+            recipients long NOT NULL ,
+            remote_host varchar (100) NOT NULL ,
+            remote_addr varchar (20) NOT NULL ,
+            message_body long byte NOT NULL ,
+            message_attributes long byte NULL ,
+            last_updated date NOT NULL,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+        <sql name="createTable" db="db2">
+            CREATE TABLE ${table} (
+            message_name varchar(200) NOT NULL ,
+            repository_name varchar(255) NOT NULL ,
+            message_state varchar(30) NOT NULL ,
+            error_message varchar(200) ,
+            sender varchar(255) ,
+            recipients varchar(1000) NOT NULL ,
+            remote_host varchar(100) NOT NULL ,
+            remote_addr varchar(20) NOT NULL ,
+            message_body blob NOT NULL ,
+            message_attributes blob ,
+            last_updated timestamp NOT NULL ,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+        <sql name="createTable" db="ingres">
+            CREATE TABLE ${table} (
+            message_name varchar (200) NOT NULL,
+            repository_name varchar (255) NOT NULL,
+            message_state varchar (30) NOT NULL ,
+            error_message varchar (200) ,
+            sender varchar (255) ,
+            recipients LONG VARCHAR NOT NULL ,
+            remote_host varchar (255) NOT NULL ,
+            remote_addr varchar (20) NOT NULL ,
+            message_body LONG BYTE NOT NULL ,
+            message_attributes LONG BYTE ,
+            last_updated DATE NOT NULL
+            )
+        </sql>
+        <sql name="createTable" db="derby">
+            CREATE TABLE ${table} (
+            message_name varchar (200) NOT NULL,
+            repository_name varchar (255) NOT NULL,
+            message_state varchar (30) NOT NULL ,
+            error_message varchar (200) ,
+            sender varchar (255) ,
+            recipients long varchar NOT NULL ,
+            remote_host varchar (255) NOT NULL ,
+            remote_addr varchar (20) NOT NULL ,
+            message_body blob NOT NULL ,
+            message_attributes blob ,
+            last_updated timestamp NOT NULL,
+            PRIMARY KEY (repository_name, message_name)
+            )
+        </sql>
+    </sqlDefs>
+
+    <sqlDefs name="org.apache.james.util.bayesian.JDBCBayesianAnalyzer">
+
+        <sql name="hamTableName">bayesiananalysis_ham</sql>
+        <sql name="spamTableName">bayesiananalysis_spam</sql>
+        <sql name="messageCountsTableName">bayesiananalysis_messagecounts</sql>
+
+        <!-- Statements used to retrieve the message counts. -->
+        <sql name="selectMessageCounts">SELECT HAMCOUNT, SPAMCOUNT FROM bayesiananalysis_messagecounts</sql>
+
+        <!-- Statements used to initialize the message counts. -->
+        <sql name="initializeMessageCounts">INSERT INTO bayesiananalysis_messagecounts (HAMCOUNT, SPAMCOUNT) VALUES (0,0)</sql>
+
+        <!-- Statements used to update the ham message counts. -->
+        <sql name="updateHamMessageCounts">UPDATE bayesiananalysis_messagecounts SET HAMCOUNT=(HAMCOUNT + ?)</sql>
+
+        <!-- Statements used to update the spam message counts. -->
+        <sql name="updateSpamMessageCounts">UPDATE bayesiananalysis_messagecounts SET SPAMCOUNT=(SPAMCOUNT + ?)</sql>
+
+        <!-- Statements used to retrieve the ham token counts. -->
+        <sql name="selectHamTokens">SELECT TOKEN, OCCURRENCES FROM bayesiananalysis_ham</sql>
+
+        <!-- Statements used to retrieve the spam token counts. -->
+        <sql name="selectSpamTokens">SELECT TOKEN, OCCURRENCES FROM bayesiananalysis_spam</sql>
+
+        <!-- Statements used to insert the ham token counts. -->
+        <sql name="insertHamToken">INSERT INTO bayesiananalysis_ham (TOKEN, OCCURRENCES) VALUES (?,?)</sql>
+
+        <!-- Statements used to insert the spam token counts. -->
+        <sql name="insertSpamToken">INSERT INTO bayesiananalysis_spam (TOKEN, OCCURRENCES) VALUES (?,?)</sql>
+
+        <!-- Statements used to update the ham token counts. -->
+        <sql name="updateHamToken">UPDATE bayesiananalysis_ham SET OCCURRENCES=(OCCURRENCES + ?) WHERE (TOKEN=?)</sql>
+
+        <!-- Statements used to update the spam token counts. -->
+        <sql name="updateSpamToken">UPDATE bayesiananalysis_spam SET OCCURRENCES=(OCCURRENCES + ?) WHERE (TOKEN=?)</sql>
+
+        <!-- Statements used to delete ham tokens. -->
+        <sql name="deleteHamTokens">DELETE FROM bayesiananalysis_ham</sql>
+
+        <!-- Statements used to delete spam tokens. -->
+        <sql name="deleteSpamTokens">DELETE FROM bayesiananalysis_spam</sql>
+
+        <!-- Statements used to delete message counts. -->
+        <sql name="deleteMessageCounts">DELETE FROM bayesiananalysis_messagecounts</sql>
+
+
+        <!-- Statements used to create the "ham" table (the 'token' field must be case sensitive). -->
+        <sql name="createHamTable" db="mysql">
+            CREATE TABLE bayesiananalysis_ham (
+            token varchar(128) binary NOT NULL default '',
+            occurrences int(11) NOT NULL default '0',
+            PRIMARY KEY (token)
+            ) TYPE=InnoDB
+        </sql>
+        <sql name="createHamTable" db="mssql">
+            CREATE TABLE [bayesiananalysis_ham] (
+            [token] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL,
+            [occurrences] [int] NOT NULL default (0),
+            PRIMARY KEY (token)
+            )
+        </sql>
+        <sql name="createHamTable" db="derby">
+            CREATE TABLE bayesiananalysis_ham (
+            token varchar(128) NOT NULL,
+            occurrences INTEGER NOT NULL default 0,
+            PRIMARY KEY (token)
+            )
+        </sql>
+        <sql name="createHamTable" db="postgresql">
+            CREATE TABLE bayesiananalysis_ham (
+            token varchar(128) NOT NULL,
+            occurrences int NOT NULL default 0,
+            PRIMARY KEY (token)
+            )
+        </sql>
+
+        <!-- Statements used to create the "spam" table (the 'token' field must be case sensitive). -->
+        <sql name="createSpamTable" db="mysql">
+            CREATE TABLE bayesiananalysis_spam (
+            token varchar(128) binary NOT NULL default '',
+            occurrences int(11) NOT NULL default '0',
+            PRIMARY KEY (token)
+            ) TYPE=InnoDB
+        </sql>
+        <sql name="createSpamTable" db="mssql">
+            CREATE TABLE [bayesiananalysis_spam] (
+            [token] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL,
+            [occurrences] [int] NOT NULL default (0),
+            PRIMARY KEY (token)
+            )
+        </sql>
+        <sql name="createSpamTable" db="derby">
+            CREATE TABLE bayesiananalysis_spam (
+            token varchar (128) NOT NULL,
+            occurrences INTEGER  NOT NULL default 0,
+            PRIMARY KEY (token)
+            )
+        </sql>
+        <sql name="createSpamTable" db="postgresql">
+            CREATE TABLE bayesiananalysis_spam (
+            token varchar (128) NOT NULL,
+            occurrences int  NOT NULL default 0,
+            PRIMARY KEY (token)
+            )
+        </sql>
+
+        <!-- Statements used to create the "message counts" table. -->
+        <sql name="createMessageCountsTable" db="mysql">
+            CREATE TABLE bayesiananalysis_messagecounts (
+            hamcount int(11) NOT NULL default '0',
+            spamcount int(11) NOT NULL default '0'
+            ) TYPE=InnoDB
+        </sql>
+        <sql name="createMessageCountsTable" db="mssql">
+            CREATE TABLE [bayesiananalysis_messagecounts] (
+            [hamcount] [int] NOT NULL default (0),
+            [spamcount] [int] NOT NULL default (0)
+            )
+        </sql>
+        <sql name="createMessageCountsTable" db="derby">
+            CREATE TABLE bayesiananalysis_messagecounts (
+            hamcount INTEGER NOT NULL default 0,
+            spamcount INTEGER  NOT NULL default 0
+            )
+        </sql>
+        <sql name="createMessageCountsTable" db="postgresql">
+            CREATE TABLE bayesiananalysis_messagecounts (
+            hamcount int NOT NULL default 0,
+            spamcount int  NOT NULL default 0
+            )
+        </sql>
+    </sqlDefs>
+
+    <sqlDefs name="WhiteList">
+
+        <sql name="whiteListTableName">whitelist</sql>
+
+        <!-- Statements used to retrieve a single entry. -->
+        <sql name="selectByPK">SELECT localUser, localHost FROM whitelist where (localUser=? AND localHost=? AND remoteUser=? AND remoteHost=?)</sql>
+
+        <!-- Statements used to all entries by sender address. -->
+        <sql name="selectBySender">SELECT remoteUser, remoteHost FROM whitelist where (localUser=? AND localHost=?) ORDER BY remoteUser, remoteHost</sql>
+
+        <!-- Statements used to insert an entry. -->
+        <sql name="insert">INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost) VALUES (?,?,?,?)</sql>
+
+        <!-- Statements used to delete an entry. -->
+        <sql name="deleteByPK">DELETE FROM whitelist where (localUser=? AND localHost=? AND remoteUser=? AND remoteHost=?)</sql>
+
+        <!-- Statements used to create the "whitelist" table. -->
+        <sql name="createWhiteListTable" db="hypersonic">
+            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)
+            )    </sql>
+        <sql name="createWhiteListTable" db="hsqldb">
+            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)
+            )    </sql>
+        <sql name="createWhiteListTable" db="mysql">
+            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
+        </sql>
+        <sql name="createWhiteListTable" db="mssql">
+            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)
+            )
+        </sql>
+        <sql name="createWhiteListTable" db="oracle">
+            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)
+            )
+        </sql>
+        <sql name="createWhiteListTable" db="postgresql">
+            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)
+            )
+        </sql>
+        <sql name="createWhiteListTable" db="sapdb">
+            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)
+            )
+        </sql>
+        <sql name="createWhiteListTable" db="db2">
+            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)
+            )
+        </sql>
+        <sql name="createWhiteListTable" db="ingres">
+            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)
+            )
+        </sql>
+        <sql name="createWhiteListTable" db="derby">
+            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)
+            )
+        </sql>
+
+    </sqlDefs>
+
+    <sqlDefs name="NetworkWhiteList">
+
+        <sql name="networkWhiteListTableName">networkWhitelist</sql>
+
+        <!-- Statements used to retrieve a single entry. -->
+        <sql name="selectNetwork">SELECT network FROM networkWhitelist where (localUser=? AND localHost=?)</sql>
+
+        <!-- Statements used to create the "whitelist" table. -->
+        <sql name="createNetworkWhiteListTable" db="hypersonic">
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) NOT NULL,
+            network varchar (255) NOT NULL,
+            PRIMARY KEY (localUser, localHost)
+            )    </sql>
+        <sql name="createNetworkWhiteListTable" db="hsqldb">
+            CREATE CACHED TABLE ${table} (
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) NOT NULL,
+            network varchar (255) NOT NULL
+            )    </sql>
+        <sql name="createNetworkWhiteListTable" db="mysql">
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) character set latin1 NOT NULL,
+            network varchar (255) NOT NULL
+            ) TYPE=InnoDB
+        </sql>
+        <sql name="createNetworkWhiteListTable" db="mssql">
+            CREATE TABLE [networkWhitelist] (
+            [localUser] [varchar] (64) NOT NULL,
+            [localHost] [varchar] (255) NOT NULL,
+            [network] [varchar] (255) NOT NULL
+            )
+        </sql>
+        <sql name="createNetworkWhiteListTable" db="oracle">
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) NOT NULL,
+            network varchar (255) NOT NULL
+            )
+        </sql>
+        <sql name="createNetworkWhiteListTable" db="postgresql">
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) NOT NULL,
+            network varchar (255) NOT NULL
+            )
+        </sql>
+        <sql name="createNetworkWhiteListTable" db="sapdb">
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) NOT NULL,
+            network varchar (255) NOT NULL
+            )
+        </sql>
+        <sql name="createNetworkWhiteListTable" db="db2">
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) NOT NULL,
+            network varchar (255) NOT NULL
+            )
+        </sql>
+        <sql name="createNetworkWhiteListTable" db="ingres">
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) NOT NULL,
+            network varchar (255) NOT NULL
+            )
+        </sql>
+        <sql name="createNetworkWhiteListTable" db="derby">
+            CREATE TABLE networkWhitelist (
+            localUser varchar (64) NOT NULL,
+            localHost varchar (255) NOT NULL,
+            network varchar (255) NOT NULL
+            )
+        </sql>
+
+    </sqlDefs>
+
+    <sqlDefs name="GreyList">
+
+        <sql name="greyListTableName">greylist</sql>
+
+        <!-- Statements used to retrieve a single entry. -->
+        <sql name="selectQuery">SELECT create_time,count FROM greylist WHERE ipaddress = ? AND sender = ? AND recip = ?</sql>
+
+        <!-- Statements used to insert an entry. -->
+        <sql name="insertQuery">INSERT INTO greylist (ipaddress,sender,recip,count,create_time) values (?,?,?,?,?)</sql>
+
+        <!-- Statements used to delete an entry. -->
+        <sql name="deleteQuery">DELETE FROM greylist WHERE create_time &lt; ? AND count = 0</sql>
+
+        <!-- Statements used to delete an entry. -->
+        <sql name="deleteAutoWhitelistQuery">DELETE FROM greylist WHERE create_time &lt; ?</sql>
+
+        <!-- Statements used to delete an entry. -->
+        <sql name="updateQuery">UPDATE greylist SET create_time = ? , count = ? WHERE ipaddress = ? AND sender = ? AND recip = ?</sql>
+
+        <!-- Statements used to create the "whitelist" table. -->
+        <sql name="createGreyListTable" db="hypersonic">
+            CREATE TABLE greylist (
+            ipaddress varchar (20) NOT NULL,
+            sender varchar (255) NOT NULL,
+            recip varchar (255) NOT NULL,
+            count int NOT NULL,
+            create_time datetime NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )    </sql>
+
+        <sql name="createGreyListTable" db="hsqldb">
+            CREATE CACHED TABLE ${table} (
+            CREATE TABLE greylist (
+            ipaddress varchar (20) NOT NULL,
+            sender varchar (255) NOT NULL,
+            recip varchar (255) NOT NULL,
+            count int NOT NULL,
+            create_time timestamo NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )    </sql>
+        <sql name="createGreyListTable" db="mysql">
+            CREATE TABLE greylist (
+            ipaddress varchar (20) NOT NULL,
+            sender varchar (255) NOT NULL,
+            recip varchar (255) NOT NULL,
+            count int NOT NULL,
+            create_time datetime NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            ) TYPE=InnoDB
+        </sql>
+        <sql name="createGreyListTable" db="mssql">
+            CREATE TABLE [greylist] (
+            [ipaddress] [varchar] (20) NOT NULL,
+            [sender] [varchar] (255) NOT NULL,
+            [recip] [varchar] (255) NOT NULL,
+            [count] [int] NOT NULL,
+            [create_time] [datetime] NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )
+        </sql>
+        <sql name="createGreyListTable" db="oracle">
+            CREATE TABLE greylist (
+            ipaddress varchar2(20) NOT NULL,
+            sender varchar2(255) NOT NULL,
+            recip varchar2(255) NOT NULL,
+            count int NOT NULL,
+            create_time datetime NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )
+        </sql>
+        <sql name="createGreyListTable" db="postgresql">
+            CREATE TABLE greylist (
+            ipaddress varchar (20) NOT NULL,
+            sender varchar (255) NOT NULL,
+            recip varchar (255) NOT NULL,
+            count int NOT NULL,
+            create_time timestamp NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )
+        </sql>
+        <sql name="createGreyListTable" db="sapdb">
+            CREATE TABLE greylist (
+            ipaddress varchar (20) NOT NULL,
+            sender varchar (255) NOT NULL,
+            recip varchar (255) NOT NULL,
+            count int NOT NULL,
+            create_time date NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )
+        </sql>
+        <sql name="createGreyListTable" db="db2">
+            CREATE TABLE greylist (
+            ipaddress varchar (20) NOT NULL,
+            sender varchar (255) NOT NULL,
+            recip varchar (255) NOT NULL,
+            count int NOT NULL,
+            create_time timestamp NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )
+        </sql>
+        <sql name="createGreyListTable" db="ingres">
+            CREATE TABLE greylist (
+            ipaddress varchar (20) NOT NULL,
+            sender varchar (255) NOT NULL,
+            recip varchar (255) NOT NULL,
+            count int NOT NULL,
+            create_time date NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )
+        </sql>
+        <sql name="createGreyListTable" db="derby">
+            CREATE TABLE greylist (
+            ipaddress varchar (20) NOT NULL,
+            sender varchar (255) NOT NULL,
+            recip varchar (255) NOT NULL,
+            count int NOT NULL,
+            create_time timestamp NOT NULL,
+            PRIMARY KEY (ipaddress,sender,recip)
+            )
+        </sql>
+    </sqlDefs>
+
+    <sqlDefs name="org.apache.james.rrt.jdbc.JDBCRecipientRewriteTable">
+
+        <!-- Statements used to check whether a particular message exists in this repository. -->
+        <sql name="selectMappings" db="derby">select RecipientRewriteTable.target_address,(RecipientRewriteTable."user" || '@' ||RecipientRewriteTable.domain) from RecipientRewriteTable, RecipientRewriteTable as VUTDomains where ((RecipientRewriteTable."user") like ? or (RecipientRewriteTable."user") = '*') and (RecipientRewriteTable.domain like ? or (RecipientRewriteTable.domain = '*')) order by 2 desc</sql>
+        <sql name="selectMappings">select RecipientRewriteTable.target_address from RecipientRewriteTable, RecipientRewriteTable as VUTDomains where (RecipientRewriteTable.user like ? or RecipientRewriteTable.user = '*') and (RecipientRewriteTable.domain like ? or (RecipientRewriteTable.domain = '*')) order by concat(RecipientRewriteTable.user,'@',RecipientRewriteTable.domain) desc limit 1</sql>
+        <sql name="selectMappings" db="postgresql">select RecipientRewriteTable.target_address from RecipientRewriteTable, RecipientRewriteTable as VUTDomains where (RecipientRewriteTable.user like ? or RecipientRewriteTable.user = '*') and (RecipientRewriteTable.domain like ? or (RecipientRewriteTable.domain = '*')) order by (RecipientRewriteTable.user || '@' || RecipientRewriteTable.domain) desc limit 1</sql>
+
+        <sql name="selectUserDomainMapping" db="derby">select RecipientRewriteTable.target_address from RecipientRewriteTable where RecipientRewriteTable."user" = ? and RecipientRewriteTable.domain = ? </sql>
+        <sql name="selectUserDomainMapping">select RecipientRewriteTable.target_address from RecipientRewriteTable where RecipientRewriteTable.user = ? and RecipientRewriteTable.domain = ? </sql>
+
+        <sql name="deleteMapping">delete from RecipientRewriteTable where RecipientRewriteTable."user" = ? and RecipientRewriteTable.domain = ? and RecipientRewriteTable.target_address = ?</sql>
+
+        <sql name="updateMapping">update RecipientRewriteTable set RecipientRewriteTable.target_address = ? where RecipientRewriteTable."user" = ? and RecipientRewriteTable.domain = ? </sql>
+
+        <sql name="addMapping">insert into RecipientRewriteTable values(?,?,?) </sql>
+
+        <sql name="selectAllMappings">select * from RecipientRewriteTable </sql>
+
+        <!-- Statements used to create the table associated with this class. -->
+        <sql name="createTable" db="mysql">
+            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)
+            )
+        </sql>
+        <!-- TEMPORARY DISABLED -->
+        <!--
+        <sql name="createTable" db="hypersonic">
+            CREATE CACHED 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)
+            )
+        </sql>
+        <sql name="createTable" db="hsqldb">
+            CREATE CACHED 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)
+            )
+        </sql>
+        <sql name="createTable" db="mssql">
+            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)
+            )
+        </sql>
+        <sql name="createTable" db="oracle">
+            CREATE TABLE RecipientRewriteTable (
+                user varchar2(64) NOT NULL default '',
+                domain varchar2(255) NOT NULL default '',
+                target_address varchar2(255) NOT NULL default '',
+                PRIMARY KEY (user,domain)
+            )
+        </sql>
+        <sql name="createTable" db="sapdb">
+            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)
+            )
+        </sql>
+        <sql name="createTable" db="db2">
+            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)
+            )
+        </sql>
+        <sql name="createTable" db="ingres">
+            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)
+            )
+        </sql>
+        -->
+        <sql name="createTable" db="postgresql">
+            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)
+            )
+        </sql>
+        <sql name="createTable" db="derby">
+            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)
+            )
+        </sql>
+    </sqlDefs>
+
+</sqlResources>
+

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/cassandra/destination/conf/usersrepository.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/cassandra/destination/conf/usersrepository.xml b/dockerfiles/run/guice/cassandra/destination/conf/usersrepository.xml
new file mode 100644
index 0000000..c745677
--- /dev/null
+++ b/dockerfiles/run/guice/cassandra/destination/conf/usersrepository.xml
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one   
+  or more contributor license agreements.  See the NOTICE file 
+  distributed with this work for additional information        
+  regarding copyright ownership.  The ASF licenses this file   
+  to you 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.                                           
+ -->
+
+<usersrepository name="LocalUsers">
+    <algorithm>MD5</algorithm>
+    <enableVirtualHosting>true</enableVirtualHosting>    
+    <enableForwarding>true</enableForwarding>
+</usersrepository>
+

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/cassandra/destination/conf/webadmin.properties
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/cassandra/destination/conf/webadmin.properties b/dockerfiles/run/guice/cassandra/destination/conf/webadmin.properties
new file mode 100644
index 0000000..70a6cb9
--- /dev/null
+++ b/dockerfiles/run/guice/cassandra/destination/conf/webadmin.properties
@@ -0,0 +1,22 @@
+#  Licensed to the Apache Software Foundation (ASF) under one
+#  or more contributor license agreements.  See the NOTICE file
+#  distributed with this work for additional information
+#  regarding copyright ownership.  The ASF licenses this file
+#  to you 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.
+
+#  This template file can be used as example for James Server configuration
+#  DO NOT USE IT AS SUCH AND ADAPT IT TO YOUR NEEDS
+
+enabled=true
+port=8000
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/destination/conf/META-INF/jpa-mappings-template.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/destination/conf/META-INF/jpa-mappings-template.xml b/dockerfiles/run/guice/destination/conf/META-INF/jpa-mappings-template.xml
deleted file mode 100644
index fe76d25..0000000
--- a/dockerfiles/run/guice/destination/conf/META-INF/jpa-mappings-template.xml
+++ /dev/null
@@ -1,40 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<!--
-  Licensed to the Apache Software Foundation (ASF) under one
-  or more contributor license agreements.  See the NOTICE file
-  distributed with this work for additional information
-  regarding copyright ownership.  The ASF licenses this file
-  to you 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.    
--->
-
-<!-- Use this file to overwriting the annotations defined in the JPA domain classes -->
-
-<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
-                 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
-                 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_2_0.xsd"
-                 version="2.0">
-
-    <entity class="org.apache.james.mailbox.jpa.mail.model.JPAHeader">
-
-        <table name="JAMES_MAIL_HEADER"/>
-
-        <attributes>
-            <basic name="value">
-                <column name="HEADER_VALUE" length="8000" />
-            </basic>
-        </attributes>
-
-    </entity>
-
-</entity-mappings>

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/destination/conf/META-INF/persistence-template.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/destination/conf/META-INF/persistence-template.xml b/dockerfiles/run/guice/destination/conf/META-INF/persistence-template.xml
deleted file mode 100644
index cca9545..0000000
--- a/dockerfiles/run/guice/destination/conf/META-INF/persistence-template.xml
+++ /dev/null
@@ -1,80 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
-  Licensed to the Apache Software Foundation (ASF) under one
-  or more contributor license agreements.  See the NOTICE file
-  distributed with this work for additional information
-  regarding copyright ownership.  The ASF licenses this file
-  to you 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.    
--->
-
-<persistence xmlns="http://java.sun.com/xml/ns/persistence"
-             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
-             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
-             version="2.0">
-
-    <persistence-unit name="James" transaction-type="RESOURCE_LOCAL">
-
-        <!-- Use the mappings to overwriting the annotations defined in the JPA domain classes -->
-        <mapping-file>META-INF/jpa-mappings-template.xml</mapping-file>
-
-        <!-- Mailbox stuff-->
-        <class>org.apache.james.mailbox.jpa.mail.model.JPAMailbox</class>
-        <class>org.apache.james.mailbox.jpa.mail.model.JPAUserFlag</class>
-        <class>org.apache.james.mailbox.jpa.mail.model.openjpa.AbstractJPAMailboxMessage</class>
-        <!--
-                <class>org.apache.james.mailbox.jpa.mail.model.openjpa.JPAEncryptedMailboxMessage</class>
-        -->
-
-        <!-- This needs to get used when you want to use streaming. Remember to comment the following classes
-             org.apache.james.mailbox.jpa.mail.model.JPAMessage
-             If you don't do this the EntityManager will get confused!
-        <class>org.apache.james.mailbox.jpa.mail.model.openjpa.JPAStreamingMailboxMessage</class>
-        -->
-        <!-- Comment if you want to use streaming -->
-        <class>org.apache.james.mailbox.jpa.mail.model.openjpa.JPAMailboxMessage</class>
-
-        <class>org.apache.james.mailbox.jpa.mail.model.JPAProperty</class>
-        <class>org.apache.james.mailbox.jpa.user.model.JPASubscription</class>
-
-        <!-- DomainList -->
-        <class>org.apache.james.domainlist.jpa.model.JPADomain</class>
-
-        <!-- User-->
-        <class>org.apache.james.user.jpa.model.JPAUser</class>
-
-        <!-- RecipientRewrite -->
-        <class>org.apache.james.rrt.jpa.model.JPARecipientRewrite</class>
-
-        <properties>
-            <!--  Create tables on startup -->
-            <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>
-            <!--  Create foreign keys on startup -->
-            <property name="openjpa.jdbc.MappingDefaults" value="ForeignKeyDeleteAction=cascade, JoinForeignKeyDeleteAction=cascade"/>
-            <!--  Reorder SQL statements to satisfy database foreign key constraints -->
-            <property name="openjpa.jdbc.SchemaFactory" value="native(ForeignKeys=true)"/>
-            <!--  Disable query cache for now. It seems to be buggy. -->
-            <!--  See http://www.mail-archive.com/server-dev@james.apache.org/msg28802.html -->
-            <!--  See https://issues.apache.org/jira/browse/OPENJPA-1827 -->
-            <property name="openjpa.jdbc.QuerySQLCache" value="false"/>
-            <!--  Uncomment this if you want to see the generated SQL in the console.
-            <property name="openjpa.Log" value="SQL=TRACE"/>
-            -->
-            <!--  Uncomment this if you want to get verbose OpenJPA log the console.
-            <property name="openjpa.Log" value="DefaultLevel=TRACE"/>
-            -->
-        </properties>
-
-    </persistence-unit>
-
-</persistence>

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/destination/conf/META-INF/persistence.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/destination/conf/META-INF/persistence.xml b/dockerfiles/run/guice/destination/conf/META-INF/persistence.xml
deleted file mode 100644
index 18ff105..0000000
--- a/dockerfiles/run/guice/destination/conf/META-INF/persistence.xml
+++ /dev/null
@@ -1,47 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
-  Licensed to the Apache Software Foundation (ASF) under one
-  or more contributor license agreements.  See the NOTICE file
-  distributed with this work for additional information
-  regarding copyright ownership.  The ASF licenses this file
-  to you 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.    
--->
-
-<persistence xmlns="http://java.sun.com/xml/ns/persistence"
-             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
-             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
-             version="2.0">
-
-    <persistence-unit name="James" transaction-type="RESOURCE_LOCAL">
-        <!-- Mailbox stuff-->
-        <class>org.apache.james.mailbox.jpa.mail.model.JPAMailbox</class>
-        <class>org.apache.james.mailbox.jpa.mail.model.JPAUserFlag</class>
-        <class>org.apache.james.mailbox.jpa.mail.model.openjpa.AbstractJPAMailboxMessage</class>
-        <class>org.apache.james.mailbox.jpa.mail.model.openjpa.JPAMailboxMessage</class>
-        <class>org.apache.james.mailbox.jpa.mail.model.JPAProperty</class>
-        <class>org.apache.james.mailbox.jpa.user.model.JPASubscription</class>
-        <class>org.apache.james.domainlist.jpa.model.JPADomain</class>
-        <class>org.apache.james.user.jpa.model.JPAUser</class>
-        <class>org.apache.james.rrt.jpa.model.JPARecipientRewrite</class>
-
-        <properties>
-            <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>
-            <property name="openjpa.jdbc.MappingDefaults" value="ForeignKeyDeleteAction=cascade, JoinForeignKeyDeleteAction=cascade"/>
-            <property name="openjpa.jdbc.SchemaFactory" value="native(ForeignKeys=true)"/>
-            <property name="openjpa.jdbc.QuerySQLCache" value="false"/>
-        </properties>
-
-    </persistence-unit>
-
-</persistence>

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/destination/conf/cassandra.properties
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/destination/conf/cassandra.properties b/dockerfiles/run/guice/destination/conf/cassandra.properties
deleted file mode 100644
index c9a94bb..0000000
--- a/dockerfiles/run/guice/destination/conf/cassandra.properties
+++ /dev/null
@@ -1,8 +0,0 @@
-# Configuration file for cassandra mailbox
-
-cassandra.ip=cassandra
-cassandra.port=9042
-cassandra.keyspace=apache_james
-cassandra.replication.factor=1
-cassandra.retryConnection.maxRetries=10
-cassandra.retryConnection.minDelay=5000
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/destination/conf/dnsservice.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/destination/conf/dnsservice.xml b/dockerfiles/run/guice/destination/conf/dnsservice.xml
deleted file mode 100644
index 0978a00..0000000
--- a/dockerfiles/run/guice/destination/conf/dnsservice.xml
+++ /dev/null
@@ -1,29 +0,0 @@
-<?xml version="1.0"?>
-<!--
-  Licensed to the Apache Software Foundation (ASF) under one   
-  or more contributor license agreements.  See the NOTICE file 
-  distributed with this work for additional information        
-  regarding copyright ownership.  The ASF licenses this file   
-  to you 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.                                           
- -->
-
-<dnsservice>
-  <servers>
-    <server>8.8.8.8</server>
-    <server>62.210.16.6</server>
-  </servers>
-  <autodiscover>false</autodiscover>
-  <authoritative>false</authoritative>
-  <maxcachesize>50000</maxcachesize>
-</dnsservice>

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/destination/conf/domainlist.xml
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/destination/conf/domainlist.xml b/dockerfiles/run/guice/destination/conf/domainlist.xml
deleted file mode 100644
index fc64fd2..0000000
--- a/dockerfiles/run/guice/destination/conf/domainlist.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<?xml version="1.0"?>
-<!--
-  Licensed to the Apache Software Foundation (ASF) under one   
-  or more contributor license agreements.  See the NOTICE file 
-  distributed with this work for additional information        
-  regarding copyright ownership.  The ASF licenses this file   
-  to you 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.                                           
- -->
-
-<domainlist class="org.apache.james.domainlist.jpa.JPADomainList">
-    <domainnames>
-        <domainname>james.linagora.com</domainname>
-    </domainnames>
-    <autodetect>true</autodetect>
-    <autodetectIP>true</autodetectIP>
-    <defaultDomain>localhost</defaultDomain>
-</domainlist>

http://git-wip-us.apache.org/repos/asf/james-project/blob/d40723b6/dockerfiles/run/guice/destination/conf/elasticsearch.properties
----------------------------------------------------------------------
diff --git a/dockerfiles/run/guice/destination/conf/elasticsearch.properties b/dockerfiles/run/guice/destination/conf/elasticsearch.properties
deleted file mode 100644
index a10cd3f..0000000
--- a/dockerfiles/run/guice/destination/conf/elasticsearch.properties
+++ /dev/null
@@ -1,30 +0,0 @@
-#  Licensed to the Apache Software Foundation (ASF) under one
-#  or more contributor license agreements.  See the NOTICE file
-#  distributed with this work for additional information
-#  regarding copyright ownership.  The ASF licenses this file
-#  to you 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.
-
-#  This template file can be used as example for James Server configuration
-#  DO NOT USE IT AS SUCH AND ADAPT IT TO YOUR NEEDS
-
-# Configuration file for ElasticSearch
-
-elasticsearch.masterHost=elasticsearch
-elasticsearch.port=9300
-elasticsearch.nb.shards=1
-elasticsearch.nb.replica=0
-elasticsearch.retryConnection.maxRetries=7
-elasticsearch.retryConnection.minDelay=3000
-# Index or not attachments (default value: true)
-elasticsearch.indexAttachments=true


---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message