Mailing List Archive: DBMail: users

Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder

Index | Next | Previous | View Threaded

pwadas at jewish

Jul 22, 2009, 11:01 PM

Post #1 of 5 (948 views)
Permalink

Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder

Hello,

When administrator migrates mbox folders to dbmail, in some of them
is a imap message, common pop3/imap ignores it, but when migrated,
this message appears on the list, and frightened users call support, to
ask "what is this and what shall I do with this". And yes, this is no joke.
Any quick sql query to delete from database all messages for all users
(envelopes and bodies) with particular SUBJECT header? or for particular
user? I'd rather to delete the messages, than delete envelope and let
dbmail-util do the rest (it has enough to do with really deleted messages).
Probably Net::POP3 perl script would do the same, but removing from
tables would be much simplier.

Regards,
DT
--
View this message in context: http://www.nabble.com/Annoying-%22DONT-DELETE-THIS-MESSAGE%22-with-previously-used-imap-inbox-folder-tp24619758p24619758.html
Sent from the dbmail users mailing list archive at Nabble.com.

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

jesse at kci

Jul 23, 2009, 7:42 AM

Post #2 of 5 (875 views)
Permalink

Re: Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder [In reply to]

See dbmail-export man page. You want -D and -s with an imap search
matching your subject. See the Exmaples section, and if you need help
with the search string, either run it in your imap client and see what
it uses, or ask back on the list. And you might use -u to restrict your
tests to a specific user until you have it "right".

On Wed, 2009-07-22 at 23:01 -0700, Piotr Wadas wrote:
> Hello,
>
> When administrator migrates mbox folders to dbmail, in some of them
> is a imap message, common pop3/imap ignores it, but when migrated,
> this message appears on the list, and frightened users call support, to
> ask "what is this and what shall I do with this". And yes, this is no joke.
> Any quick sql query to delete from database all messages for all users
> (envelopes and bodies) with particular SUBJECT header? or for particular
> user? I'd rather to delete the messages, than delete envelope and let
> dbmail-util do the rest (it has enough to do with really deleted messages).
> Probably Net::POP3 perl script would do the same, but removing from
> tables would be much simplier.
>
> Regards,
> DT
--
Jesse Norell
Kentec Communications, Inc.
jesse [at] kci
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

michael.monnerie at is

Jul 23, 2009, 8:15 AM

Post #3 of 5 (882 views)
Permalink

Re: Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder [In reply to]

On Donnerstag 23 Juli 2009 Piotr Wadas wrote:
> When administrator migrates mbox folders to dbmail, in some of them
> is a imap message, common pop3/imap ignores it, but when migrated,
> this message appears on the list, and frightened users call support,
> to ask "what is this and what shall I do with this". And yes, this is
> no joke. Any quick sql query to delete from database all messages for
> all users (envelopes and bodies) with particular SUBJECT header? or
> for particular user? I'd rather to delete the messages, than delete
> envelope and let dbmail-util do the rest (it has enough to do with
> really deleted messages). Probably Net::POP3 perl script would do the
> same, but removing from tables would be much simplier.

select * from dbmail_messages where physmessage_id IN (select
physmessage_id from dbmail_subjectfield where subjectfield like
'Annoying%DELETE THIS MESSAGE%');

Instead of "select *" simply write "DELETE" and those messages are gone.

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

vulture at netvulture

Jul 23, 2009, 8:22 AM

Post #4 of 5 (875 views)
Permalink

Re: Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder [In reply to]

Michael Monnerie wrote:
>
> select * from dbmail_messages where physmessage_id IN (select
> physmessage_id from dbmail_subjectfield where subjectfield like
> 'Annoying%DELETE THIS MESSAGE%');
>
> Instead of "select *" simply write "DELETE" and those messages are gone.
>
> mfg zmi
>

I'm glad you responded first. I forgot about those views and was going
to give a very nasty query back to do it. That should work in both 2.2.x
and 2.3.x

-Jon

--
Scanned for viruses and dangerous content by MailScanner

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

michael.monnerie at is

Jul 23, 2009, 9:09 AM

Post #5 of 5 (879 views)
Permalink

Re: Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder [In reply to]

On Donnerstag 23 Juli 2009 Jonathan Feally wrote:
> > select * from dbmail_messages where physmessage_id IN (select
> > physmessage_id from dbmail_subjectfield where subjectfield like
> > 'Annoying%DELETE THIS MESSAGE%');
> >
> > Instead of "select *" simply write "DELETE" and those messages are
> > gone.
> >
> > mfg zmi
> > �
>
> I'm glad you responded first. I forgot about those views and was
> going to give a very nasty query back to do it. That should work in
> both 2.2.x and 2.3.x

:-)

Please anybody doing above query be reminded to change the Subject you
are searching for - otherwise you delete all mails belonging to this
thread ;-) My advise is to make the "select" first to see if it works,
and only afterwards change it to "delete".

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4

Attachments:

signature.asc (0.19 KB)

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads