Re: Multiple Databases?

2018-05-08 Thread Benoit Tellier
Hi Jerry,

There is currently no solution to do what you describe. There is no
"custom storage treatment" for archived mails.

I did not address nor faced this problem, thus can not really help you.

Cheers,

Benoit Tellier

Le 09/05/2018 à 02:08, Jerry Malcolm a écrit :
> I realize this is a completely off-the-wall question... but has there
> been any discussion about breaking the JAMES db into multiple
> databases?  I have a bunch of clients, each with a bunch of accounts. 
> And they all want to archive all of their mail and be able to access it
> through the same mail client.  As the years go by, the db just keeps
> growing and growing.  This became acutely obvious when I was recently
> forced by my server provider to migrate to newer hardware, and I
> realized I had to have mail down for a long time while I transferred a
> 60gB+ file across a slow connection to the new server.  The db size is
> also making daily backups a problem.
> 
> The reality is that 90% of the mail is archived into 'year' folders for
> each of the accounts which are basically "read-only" now.  Only a
> relatively small amount of mail is truly in dynamically updated
> folders.  If there was a way to store "/archives/2002" folders through
> "/archives/2017" folders in one db and all of the other folders in
> another db, it would make backup and migration a much simpler task.
> 
> Ok, I'm pretty sure that isn't in the immediate plan.  But just let me
> put my vote in.  Alternatively, is there any alternative to having one
> ever-growing mail db?  Is there some trick with the db server that can
> present one logical db from multiple db files?  (I know a lot about
> databases... but there's still a bunch I don't know).  Has anyone else
> faced/addressed this problem?  Or is the answer to just live with it?
> 
> Thanks.
> 
> Jerry
> 
> 
> -
> To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
> For additional commands, e-mail: server-user-h...@james.apache.org
> 

-
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org



Multiple Databases?

2018-05-08 Thread Jerry Malcolm
I realize this is a completely off-the-wall question... but has there 
been any discussion about breaking the JAMES db into multiple 
databases?  I have a bunch of clients, each with a bunch of accounts.  
And they all want to archive all of their mail and be able to access it 
through the same mail client.  As the years go by, the db just keeps 
growing and growing.  This became acutely obvious when I was recently 
forced by my server provider to migrate to newer hardware, and I 
realized I had to have mail down for a long time while I transferred a 
60gB+ file across a slow connection to the new server.  The db size is 
also making daily backups a problem.


The reality is that 90% of the mail is archived into 'year' folders for 
each of the accounts which are basically "read-only" now.  Only a 
relatively small amount of mail is truly in dynamically updated 
folders.  If there was a way to store "/archives/2002" folders through 
"/archives/2017" folders in one db and all of the other folders in 
another db, it would make backup and migration a much simpler task.


Ok, I'm pretty sure that isn't in the immediate plan.  But just let me 
put my vote in.  Alternatively, is there any alternative to having one 
ever-growing mail db?  Is there some trick with the db server that can 
present one logical db from multiple db files?  (I know a lot about 
databases... but there's still a bunch I don't know).  Has anyone else 
faced/addressed this problem?  Or is the answer to just live with it?


Thanks.

Jerry


-
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org



Re: Redact IP addresses from Received field

2018-05-08 Thread Rich P
Hi Benoit --

Thanks for your reply.  I will take a look at the code and consider 
contributing this feature.

Best,

Rich


On 5/7/2018 10:53 PM, Benoit Tellier wrote:
> Hi Rich,
>
> Very unfortunately such a functionality do not exist today...
>
> However a new mailet can be contributed for this. I would propose:
>
> ```
> 
> host1.secret.com,host2.secret.com,145.12.15.168,145.12.15.169
> 
> ```
>
> This can be implemented in mailet/standard project of this repository:
> https://github.com/apache/james-project . An issue should also be
> created in the Apache JIRA https://issues.apache.org/jira/browse/JAMES
>
> Such a functionality seems quite generic and would allow to hide
> internal mail infrastructure, thus it seems interesting. Such a
> contribution will be highly appreciated. We can, of course, help you,
> and provide guidance to implement such a mailet.
>
> Best regards,
>
> Benoit Tellier
>
> Le 07/05/2018 à 21:40, Rich P a écrit :
>> In order to hide IP addresses for outbound mail, I configured James to 
>> remove the Received field using this in mailetcontainer.xml:
>>
>>
>> 
>>  Received
>> 
>>
>> This works but I think it's triggering SPAM filters for downstream 
>> recipients.  Is there a simple way to leave the field intact but redact the 
>> IP addresses?
>>
>>
>> Thanks.
>>
>>
> -
> To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
> For additional commands, e-mail: server-user-h...@james.apache.org
>
> .
>


-
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org