
Hello, first a thank you to Florian Gattung for the suggestion as to how to close all the viramails we have recieved. Now I have another question. We have heaps of mails in the OTRS-system that really is spam and mails that we dont need in there, simply junk that fills up the database. Does anyone know a script (perhaps in php) that can delete all those mails, so they wont be in the system at all anymore? (having around 120000 sobig related mails and lots of other spam). Thanks in advance. Med venlig hilsen / Best regards Anders Hinding

Hi Anders,
you do not need a php-script, otrs can do it for you:
edit $OTRS_HOME/Kernel/Config/GenericAgent.pm
you must define a new job:
'delete' => {
Queue => '
Hello,
first a thank you to Florian Gattung for the suggestion as to how to close all the viramails we have recieved.
Now I have another question.
We have heaps of mails in the OTRS-system that really is spam and mails that we dont need in there, simply junk that fills up the database.
Does anyone know a script (perhaps in php) that can delete all those mails, so they wont be in the system at all anymore? (having around 120000 sobig related mails and lots of other spam).
Thanks in advance.
Med venlig hilsen / Best regards
Anders Hinding
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Subject: Re: [otrs] Deleting trashmail from OTRS
Hi Anders,
you do not need a php-script, otrs can do it for you:
edit $OTRS_HOME/Kernel/Config/GenericAgent.pm
you must define a new job:
'delete' => { Queue => '
', State => ['new','open'], #mails state new + open Locks => ['lock','unlock'], New => { Delete => 1, }, }, GenericAgent will now delete all you mails located in
. You can also choose your spam-queue as . Guenther
but isnt it neccessary in this way to move the spam mails into the "spam"-queue by hand (1 click per mail)? Flo
Anders Hinding schrieb:
Hello,
first a thank you to Florian Gattung for the suggestion as to how to close all the viramails we have recieved.
Now I have another question.
We have heaps of mails in the OTRS-system that really is spam and mails that we dont need in there, simply junk that fills up the database.
Does anyone know a script (perhaps in php) that can delete all those mails, so they wont be in the system at all anymore? (having around 120000 sobig related mails and lots of other spam).
Thanks in advance.
Med venlig hilsen / Best regards
Anders Hinding
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Hi Florian, Florian Gattung schrieb:
Subject: Re: [otrs] Deleting trashmail from OTRS
but isnt it neccessary in this way to move the spam mails into the "spam"-queue by hand (1 click per mail)?
no, it should be possible to move it via perl-scripts. Greetings Guenther
Flo
Anders Hinding schrieb:
Hello,
first a thank you to Florian Gattung for the suggestion as to how to
close
all the viramails we have recieved.
Now I have another question.
We have heaps of mails in the OTRS-system that really is spam and mails
that
we dont need in there, simply junk that fills up the database.
Does anyone know a script (perhaps in php) that can delete all those
mails,
so they wont be in the system at all anymore? (having around 120000
sobig
related mails and lots of other spam).
Thanks in advance.
Med venlig hilsen / Best regards
Anders Hinding
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

and this...
Med venlig hilsen / Best regards
Anders Hinding
Eurotrust Secure Hosting Tech
EuroTrust Secure Hosting A/S
Part of the VeriSign Trust Network
Phone: + 45 3954 0102 - Fax: + 45 3954 0163
Mail: ahi@securehosting.dk - website http://www.securehosting.dk
Poppelgårdvej 11-13, DK 2860 Søborg, Denmark
CONFIDENTIALITY. This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please
notify the sender immediately and do not disclose the contents to
another person, use it for any purpose, or store or copy the
information on any medium.
P.S. Ved svar, send venligst resten af denne mail med.
----- Original Message -----
From: "Guenther Rasch"
Hi Florian,
Florian Gattung schrieb:
Subject: Re: [otrs] Deleting trashmail from OTRS
but isnt it neccessary in this way to move the spam mails into the "spam"-queue by hand (1 click per mail)?
no, it should be possible to move it via perl-scripts.
Greetings Guenther
Flo
Anders Hinding schrieb:
Hello,
first a thank you to Florian Gattung for the suggestion as to how to
close
all the viramails we have recieved.
Now I have another question.
We have heaps of mails in the OTRS-system that really is spam and mails
that
we dont need in there, simply junk that fills up the database.
Does anyone know a script (perhaps in php) that can delete all those
mails,
so they wont be in the system at all anymore? (having around 120000
sobig
related mails and lots of other spam).
Thanks in advance.
Med venlig hilsen / Best regards
Anders Hinding
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Thanks for the answer.
How do I define which mails I need to delete?
For example if it's all mails that contain a certain subject og a certain
sender?
(basically, I'm not that much into perl, which is why aI wanted to do it
though a php-script directly in the database)
Med venlig hilsen / Best regards
Anders Hinding
----- Original Message -----
From: "Guenther Rasch"
Hi Anders,
you do not need a php-script, otrs can do it for you:
edit $OTRS_HOME/Kernel/Config/GenericAgent.pm
you must define a new job:
'delete' => { Queue => '
', State => ['new','open'], #mails state new + open Locks => ['lock','unlock'], New => { Delete => 1, }, }, GenericAgent will now delete all you mails located in
. You can also choose your spam-queue as . Guenther
Anders Hinding schrieb:
Hello,
first a thank you to Florian Gattung for the suggestion as to how to close all the viramails we have recieved.
Now I have another question.
We have heaps of mails in the OTRS-system that really is spam and mails that we dont need in there, simply junk that fills up the database.
Does anyone know a script (perhaps in php) that can delete all those mails, so they wont be in the system at all anymore? (having around 120000 sobig related mails and lots of other spam).
Thanks in advance.
Med venlig hilsen / Best regards
Anders Hinding
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Hi Anders, On Wed, Aug 27, 2003 at 10:41:51AM +0200, Anders Hinding wrote:
How do I define which mails I need to delete?
For example if it's all mails that contain a certain subject og a certain sender?
The easiest way is to defined a 'delete' queue and move spam ticket in it. The GenericAgent will do the reset. If you want to dispatch incoming emails by some subject to the 'delete' queue then you should use procmail. See also: "Queue dispatching with procmail (for more complex dispatching)" http://doc.otrs.org/1.1/html/receiving-email-cmd.html#RECEIVING-EMAIL-CMD-DI...
Anders Hinding
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972

If you want to dispatch incoming emails by some subject to the 'delete' queue then you should use procmail.
See also: "Queue dispatching with procmail (for more complex dispatching)"
http://doc.otrs.org/1.1/html/receiving-email-cmd.html#RECEIVING-EMAIL->C MD-DISPATCHING-WITH-PROC
Martin
But how do you get the PostMasterPOP3.pl to recognize the .procmail? I have set the pop accounts to trusted and it still doesn't work. Ray

On Wed, Aug 27, 2003 at 03:11:15PM -0400, Raymond Keckler wrote:
If you want to dispatch incoming emails by some subject to the 'delete' queue then you should use procmail.
See also: "Queue dispatching with procmail (for more complex dispatching)"
http://doc.otrs.org/1.1/html/receiving-email-cmd.html#RECEIVING-EMAIL->C MD-DISPATCHING-WITH-PROC [...] But how do you get the PostMasterPOP3.pl to recognize the .procmail?
I have set the pop accounts to trusted and it still doesn't work.
Yes, because PostMasterPOP3.pl can't work with Procmail. Procmail is just working with PostMaster.pl and local mail deliver via MTA (http://doc.otrs.org/1.1/html/receiving-email-cmd.html).
Ray
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ --
participants (5)
-
Anders Hinding
-
Florian Gattung
-
Guenther Rasch
-
Martin Edenhofer
-
Raymond Keckler