jboss-dev-forums

[Jboss-dev-forums] [Design of JBoss Collaboration Server] - Re: POP --> isDeleted

[<go...@ic...>]

so as to not reinvent the wheel, does anyone have the sql code to fully delete emails from dbase

i.e., when a user or mailbox is deleted, all their associated email should be deleted,  was wondering if anyone already has the SQL code that could accomplish this...will keep searching forums though, would look in code, but last time I spoke with Andrew, he stated mails were never fully expunged, and that we needed a routine to do this periodically


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3953847#3953847

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3953847

[Jboss-dev-forums] [Design of JBoss Collaboration Server] - Re: POP --> isDeleted

[<go...@ic...>]

actually, found the email blob cleanup code, which looks as if it deletes orpahned emails that dont exist in messagedata, I imagine I can just delete a mailboxes messagedata entries, and the run the sql code for the "cleanup", thus the "cleanup" sql code, would actually have something to cleanup.

Just trying to delete a users data, alias, and mailbox, all in one "swooop"


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3955125#3955125

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3955125

[Jboss-dev-forums] [Design of JBoss Collaboration Server] - Re: POP --> isDeleted

[<aco...@jb...>]

Guys, when such descriptions get so verbose I think one thing...PATCHES PLEASE!!!  If it takes me a lot of time to understand it and it isn't IMAP efficiency, API or admin (my primary concerns ATM) then it will possibly get lost AND IT SHOULDN'T, and I KNOW that the other JBMS guys (as opposed to JBCS on the whole) are the same way!  This sounds like a simpler fix with less lines of code than the actual thread!  

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3956019#3956019

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3956019

[Jboss-dev-forums] [Design of JBoss Collaboration Server] - Re: POP --> isDeleted

[<go...@ic...>]

Welcome back from vacation, hope you got to enjoy it, how was the weather in SanFran?

I would like to help with "patching", but ATM am busy with normal work.  I will try and make an effort though...

I did this in mySQL....see anything wrong with it, other than  maybe inefficiency,  i.e. to delete all of a users email related data...

DELETE FROM messagedata WHERE folder_id = lngUserInBoxID;	
  | /* Now clean orphaned emails in other tables */
  | DELETE FROM paged_mail_store WHERE id not in (select m.bodyid from messagedata m);
  | DELETE FROM paged_mail_store_pages WHERE blobid not in (select b.id from paged_mail_store b);
  | DELETE FROM storeitemmetadata WHERE pid not in (select b.id from paged_mail_store b);

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3956025#3956025

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3956025