You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by RanBing <bi...@hotmail.com> on 2010/11/04 19:00:34 UTC
removing messages directly in the database
Hi,
For some reason my client was locked up when receiving a message from the server which use postgres as the backend. Is there a way to quickly empty a user's inbox directly from the database?
Second question: is it possible to configure the server to use file system based inboxes for local users while keep everything else in the database?
Thanks
Bing
Re: removing messages directly in the database
Posted by RanBing <bi...@hotmail.com>.
Cool...
--------------------------------------------------
From: "Eric Charles" <er...@apache.org>
Sent: Friday, November 05, 2010 5:44 PM
To: "James Users List" <se...@james.apache.org>
Subject: Re: removing messages directly in the database
> You can find M2 snapshots via
> http://people.apache.org/builds/james/nightly/.
>
> For your second question, yes, you can use MailDir to store mails on files
> system, and the rest (domain, users, virtualusers) in the database.
> But:
> - MailDir has just been broken and repaired.
> - configuration to achieve what you ask is not rocket-science but really
> needs to be documented.
>
> Take patience untill this Monday and you should have what you need on-line
> :)
>
> Tks,
>
> Eric
>
>
> On 4/11/2010 21:27, Norman Maurer wrote:
>> Hi Bing,
>>
>> sure you can do it via native sql. But the "right" solution is to use
>> jmx. Just login to your james instance via a jmx client (like
>> jconsole), the click on:
>> org.apache.james , mailboxmanagement, operations
>>
>> Here are operations exposed which let you delete a mailbox for a user..
>>
>> Bye,
>> Norman
>>
>> Ps: The JMX stuff is not in M1 only in current trunk or M2-SNAPSHOT
>>
>> 2010/11/4 RanBing<bi...@hotmail.com>:
>>> Hi,
>>>
>>> For some reason my client was locked up when receiving a message from
>>> the server which use postgres as the backend. Is there a way to quickly
>>> empty a user's inbox directly from the database?
>>>
>>> Second question: is it possible to configure the server to use file
>>> system based inboxes for local users while keep everything else in the
>>> database?
>>>
>>> Thanks
>>>
>>> Bing
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: removing messages directly in the database
Posted by Eric Charles <er...@apache.org>.
You can find M2 snapshots via
http://people.apache.org/builds/james/nightly/.
For your second question, yes, you can use MailDir to store mails on
files system, and the rest (domain, users, virtualusers) in the database.
But:
- MailDir has just been broken and repaired.
- configuration to achieve what you ask is not rocket-science but really
needs to be documented.
Take patience untill this Monday and you should have what you need
on-line :)
Tks,
Eric
On 4/11/2010 21:27, Norman Maurer wrote:
> Hi Bing,
>
> sure you can do it via native sql. But the "right" solution is to use
> jmx. Just login to your james instance via a jmx client (like
> jconsole), the click on:
> org.apache.james , mailboxmanagement, operations
>
> Here are operations exposed which let you delete a mailbox for a user..
>
> Bye,
> Norman
>
> Ps: The JMX stuff is not in M1 only in current trunk or M2-SNAPSHOT
>
> 2010/11/4 RanBing<bi...@hotmail.com>:
>> Hi,
>>
>> For some reason my client was locked up when receiving a message from the server which use postgres as the backend. Is there a way to quickly empty a user's inbox directly from the database?
>>
>> Second question: is it possible to configure the server to use file system based inboxes for local users while keep everything else in the database?
>>
>> Thanks
>>
>> Bing
>>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: removing messages directly in the database
Posted by Norman Maurer <no...@apache.org>.
Hi Bing,
sure you can do it via native sql. But the "right" solution is to use
jmx. Just login to your james instance via a jmx client (like
jconsole), the click on:
org.apache.james , mailboxmanagement, operations
Here are operations exposed which let you delete a mailbox for a user..
Bye,
Norman
Ps: The JMX stuff is not in M1 only in current trunk or M2-SNAPSHOT
2010/11/4 RanBing <bi...@hotmail.com>:
> Hi,
>
> For some reason my client was locked up when receiving a message from the server which use postgres as the backend. Is there a way to quickly empty a user's inbox directly from the database?
>
> Second question: is it possible to configure the server to use file system based inboxes for local users while keep everything else in the database?
>
> Thanks
>
> Bing
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org