How to delete all the emails in Quarantine

[cocconi]

Hi
I need to delete all the emails in the quarantine.
I know it should be done by the RCPT, but in this case (bad) SENDERS are in my network.
I can't wait the end of quarantine delay, I need to empty all before it.
I already try
'rm /var/spool/pmg/spam /*/*'
but it only delete the files, not the rcpt list in the web interface.
I've try some pmgsh commands without success too (it's need to delete email ID per email ID for each user)
If someone has the answer it 'll be great !

Thanks

 

[thiagotgc]

I opened a post here for this

https://bugzilla.proxmox.com/show_bug.cgi?id=2600

But I still have no return ...

 

[hata_ph]

You can delete mail queue from Administration -> Queues -> Deferred Mail.

 

[thiagotgc]

You can delete mail queue from Administration -> Queues -> Deferred Mail.

I think he wants it just like me.

You want to be able to delete messages that are in the Spam, Virus and Attachments quarantine.

 

[cocconi]

[

I think he wants it just like me.

You want to be able to delete messages that are in the Spam, Virus and Attachments quarantine.

Yes it is exactly the same problem !
And I need same solution

 

[cocconi]

Do you know where is stored the spam sender list ? I've not found it in postgresql db.

 

[thiagotgc]

I've tried several commands using pmgsh to delete all spam and Virus quarantine emails at once ...

 

[cocconi]

and do you find a pmgsh command usefull for this ?
May be I'll do a python script to get all quaruser and delete mails if regex compliant.

 

[cocconi]

I've made a perl script finaly (as PMG is perl it was easier).
If any is interest to use it .
syntax :
delete_quarantine.pl -f <from> -r <rcpt> -u <subject> -a <action>
action is mandatory : count/list/remove
it needs at least one : sender, rcpt or subject ; you can mix several

You can search for a sender, a recipient or some text in the subject, or a mixed of all of this.
And you must say which action you want to do.
It works for me, on PMG : pmg-api/6.1-5/e367e6d1

You have to rename it to *.pl, it's forbidden to upload pl files.

 

[thiagotgc]

very very good !!
I renamed it "pmgdq" and put it in / usr / bin / next to "pmgsh"
I think the team could evaluate putting this tool in an official way, and even implement it in the GUI ....


Could you add two functions?

1 - Send emails (currently only have to remove)
2 - Send / Remove EVERYTHING in quarantine

 

[cocconi]

I've made some changes & corrections :
- new delivery action
- action to all emails in quarantine if the from or the rcpt is named 'allemails'
- the from check is done vs the 'from' and no more the 'enveloppe_sender'
- the output is now printed 'From' & 'Rcpt'
- the script is named 'pmgdq ', thanks to 'thiagotgc'

Hope it can be usefull

 

[thiagotgc]

Great! Great job! It will help a lot!

Is it possible to carry the code for virus quarantine messages?

 

[cocconi]

I don't know, I'll check next days

 

[thiagotgc]

I don't know, I'll check next days

I have used this Script a lot.

But I see that it would be excellent if it could also be used with Quarantine Virus.

 

[hata_ph]

The script is a godsend.It allow me to remove/deliver bulk mail from quarantine.
It is a good idea to implement this on PMG GUI.

 

[hata_ph]

Btw, how to search subject using the script?
I try pmgdq -u Anthony -a count but not working...

 

[rojoblandino]

Btw, how to search subject using the script?
I try pmgdq -u Anthony -a count but not working...

There is a mistake is not -u is -s.

Try as:

pmgdq -s Anthony -a count

 

[rojoblandino]

I've made some changes & corrections :
- new delivery action
- action to all emails in quarantine if the from or the rcpt is named 'allemails'
- the from check is done vs the 'from' and no more the 'enveloppe_sender'
- the output is now printed 'From' & 'Rcpt'
- the script is named 'pmgdq ', thanks to 'thiagotgc'

Hope it can be usefull

What i am getting as response is this output:
delete_quarantine.pl -f MAILER-DAEMON@mydomain.local.in -a count 400 Parameter verification failed. pmail: value does not match the regex pattern get quarantine/spam [OPTIONS] malformed JSON string, neither array, object, number, string or atom, at character offset 0 (before "(end of string)") at bin/delete_quarantine.pl line 110.

On line 110 is:

... my $jspam= qx(/usr/bin/pmgsh get /quarantine/spam --starttime $starttime --endtime $endtime -pmail $u->{'mail'} 2>/dev/null); -> my $emails = decode_json($jspam); foreach my $em (@$emails){ ...

 

[rojoblandino]

What i am getting as response is this output:
delete_quarantine.pl -f MAILER-DAEMON@mydomain.local.in -a count 400 Parameter verification failed. pmail: value does not match the regex pattern get quarantine/spam [OPTIONS] malformed JSON string, neither array, object, number, string or atom, at character offset 0 (before "(end of string)") at bin/delete_quarantine.pl line 110.

On line 110 is:

... my $jspam= qx(/usr/bin/pmgsh get /quarantine/spam --starttime $starttime --endtime $endtime -pmail $u->{'mail'} 2>/dev/null); -> my $emails = decode_json($jspam); foreach my $em (@$emails){ ...

it must be add >'< between $u->{'mail'}

my $jspam= qx(/usr/bin/pmgsh get /quarantine/spam --starttime $starttime --endtime $endtime -pmail '$u->{'mail'}' 2>/dev/null);

Greetings.

More fixes should be welcome.

Errores show up with mails like following one:

a/h8uvt0aseoxwpvjbwe1fq==_1109382361974_khyiyoo8eemu3dsuuple3q==@in.constantcontact.com

 

[rojoblandino]

it must be add >'< between $u->{'mail'}

my $jspam= qx(/usr/bin/pmgsh get /quarantine/spam --starttime $starttime --endtime $endtime -pmail '$u->{'mail'}' 2>/dev/null);

Greetings.

More fixes should be welcome.

Errores show up with mails like following one:

a/h8uvt0aseoxwpvjbwe1fq==_1109382361974_khyiyoo8eemu3dsuuple3q==@in.constantcontact.com

I have update my proxmox and this kind of problem has been solved.

Greetings.